GoogleApi.Dataform.V1beta1.Model.IncrementalTableConfig (google_api_dataform v0.8.0)
View SourceContains settings for relations of type INCREMENTAL_TABLE.
Attributes
-
incrementalPostOperations(type:list(String.t), default:nil) - SQL statements to be executed after inserting new rows into the relation. -
incrementalPreOperations(type:list(String.t), default:nil) - SQL statements to be executed before inserting new rows into the relation. -
incrementalSelectQuery(type:String.t, default:nil) - The SELECT query which returns rows which should be inserted into the relation if it already exists and is not being refreshed. -
refreshDisabled(type:boolean(), default:nil) - Whether this table should be protected from being refreshed. -
uniqueKeyParts(type:list(String.t), default:nil) - A set of columns or SQL expressions used to define row uniqueness. If any duplicates are discovered (as defined byunique_key_parts), only the newly selected rows (as defined byincremental_select_query) will be included in the relation. -
updatePartitionFilter(type:String.t, default:nil) - A SQL expression conditional used to limit the set of existing rows considered for a merge operation (seeunique_key_partsfor more information).
Summary
Functions
Unwrap a decoded JSON object into its complex fields.
Types
@type t() :: %GoogleApi.Dataform.V1beta1.Model.IncrementalTableConfig{ incrementalPostOperations: [String.t()] | nil, incrementalPreOperations: [String.t()] | nil, incrementalSelectQuery: String.t() | nil, refreshDisabled: boolean() | nil, uniqueKeyParts: [String.t()] | nil, updatePartitionFilter: String.t() | nil }