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 \ RelationMethods
__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 |
↳ update_partition_filter |
string
A SQL expression conditional used to limit the set of existing rows considered for a merge operation (see |
↳ 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 |
|