Google Cloud Dataform V1beta1 Client - Class IncrementalTableConfig (0.3.0)

Reference documentation and code samples for the Google Cloud Dataform V1beta1 Client class IncrementalTableConfig.

Contains settings for relations of type INCREMENTAL_TABLE.

Generated from protobuf message google.cloud.dataform.v1beta1.CompilationResultAction.Relation.IncrementalTableConfig

Namespace

Google \ Cloud \ Dataform \ V1beta1 \ CompilationResultAction \ Relation

Methods

__construct

Constructor.

Parameters
Name	Description
`data`	`array` Optional. Data for populating the Message object.
`↳ incremental_select_query`	`string` 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`	`array` 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`	`string` 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`	`array` SQL statements to be executed before inserting new rows into the relation.
`↳ incremental_post_operations`	`array` SQL statements to be executed after inserting new rows into the relation.

getIncrementalSelectQuery

The SELECT query which returns rows which should be inserted into the relation if it already exists and is not being refreshed.

Returns
Type	Description
`string`

setIncrementalSelectQuery

The SELECT query which returns rows which should be inserted into the relation if it already exists and is not being refreshed.

Parameter
Name	Description
`var`	`string`

Returns
Type	Description
`$this`

getRefreshDisabled

Whether this table should be protected from being refreshed.

Returns
Type	Description
`bool`

setRefreshDisabled

Whether this table should be protected from being refreshed.

Parameter
Name	Description
`var`	`bool`

Returns
Type	Description
`$this`

getUniqueKeyParts

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.

Returns
Type	Description
`Google\Protobuf\Internal\RepeatedField`

setUniqueKeyParts

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.

Parameter
Name	Description
`var`	`string[]`

Returns
Type	Description
`$this`

getUpdatePartitionFilter

A SQL expression conditional used to limit the set of existing rows considered for a merge operation (see unique_key_parts for more information).

Returns
Type	Description
`string`

setUpdatePartitionFilter

A SQL expression conditional used to limit the set of existing rows considered for a merge operation (see unique_key_parts for more information).

Parameter
Name	Description
`var`	`string`

Returns
Type	Description
`$this`

getIncrementalPreOperations

SQL statements to be executed before inserting new rows into the relation.

Returns
Type	Description
`Google\Protobuf\Internal\RepeatedField`

setIncrementalPreOperations

SQL statements to be executed before inserting new rows into the relation.

Parameter
Name	Description
`var`	`string[]`

Returns
Type	Description
`$this`

getIncrementalPostOperations

SQL statements to be executed after inserting new rows into the relation.

Returns
Type	Description
`Google\Protobuf\Internal\RepeatedField`

setIncrementalPostOperations

SQL statements to be executed after inserting new rows into the relation.

Parameter
Name	Description
`var`	`string[]`

Returns
Type	Description
`$this`