Google Cloud Dataform V1beta1 Client - Class IncrementalTableConfig (0.10.1)

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 string[]

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 string[]

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

↳ incremental_post_operations string[]

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\RepeatedField<string>

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\RepeatedField<string>

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\RepeatedField<string>

setIncrementalPostOperations

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

Parameter
Name Description
var string[]
Returns
Type Description
$this