IncrementalTableConfig(mapping=None, *, ignore_unknown_fields=False, **kwargs)Contains settings for relations of type INCREMENTAL_TABLE.
Attributes | |
|---|---|
| Name | Description |
incremental_select_query |
str
The SELECT query which returns rows which should be inserted into the relation if it already exists and is not being refreshed. |
refresh_disabled |
bool
Whether this table should be protected from being refreshed. |
unique_key_parts |
MutableSequence[str]
A set of columns or SQL expressions used to define row uniqueness. If any duplicates are discovered (as defined by unique_key_parts), only the newly selected rows (as
defined by incremental_select_query) will be included in
the relation.
|
update_partition_filter |
str
A SQL expression conditional used to limit the set of existing rows considered for a merge operation (see unique_key_parts for more information).
|
incremental_pre_operations |
MutableSequence[str]
SQL statements to be executed before inserting new rows into the relation. |
incremental_post_operations |
MutableSequence[str]
SQL statements to be executed after inserting new rows into the relation. |