View Source GoogleApi.Dataform.V1beta1.Model.IncrementalTableConfig (google_api_dataform v0.7.0)
Contains 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_parts
for 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 }