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 |
Sequence[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 |
Sequence[str]
SQL statements to be executed before inserting new rows into the relation. |
incremental_post_operations |
Sequence[str]
SQL statements to be executed after inserting new rows into the relation. |