Google Cloud Dataform V1beta1 Client - Class IncrementalTableConfig (0.1.6)

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

Methods

__construct

Constructor.

Parameters
NameDescription
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
TypeDescription
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
NameDescription
var string
Returns
TypeDescription
$this

getRefreshDisabled

Whether this table should be protected from being refreshed.

Returns
TypeDescription
bool

setRefreshDisabled

Whether this table should be protected from being refreshed.

Parameter
NameDescription
var bool
Returns
TypeDescription
$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
TypeDescription
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
NameDescription
var string[]
Returns
TypeDescription
$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
TypeDescription
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
NameDescription
var string
Returns
TypeDescription
$this

getIncrementalPreOperations

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

Returns
TypeDescription
Google\Protobuf\Internal\RepeatedField

setIncrementalPreOperations

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

Parameter
NameDescription
var string[]
Returns
TypeDescription
$this

getIncrementalPostOperations

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

Returns
TypeDescription
Google\Protobuf\Internal\RepeatedField

setIncrementalPostOperations

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

Parameter
NameDescription
var string[]
Returns
TypeDescription
$this