Class IncrementalTableConfig
Contains settings for relations of type INCREMENTAL_TABLE
.
Implements
Inherited Members
Namespace: Google.Apis.Dataform.v1beta1.Data
Assembly: Google.Apis.Dataform.v1beta1.dll
Syntax
public class IncrementalTableConfig : IDirectResponseSchema
Properties
ETag
The ETag of the item.
Declaration
public virtual string ETag { get; set; }
Property Value
Type | Description |
---|---|
string |
IncrementalPostOperations
SQL statements to be executed after inserting new rows into the relation.
Declaration
[JsonProperty("incrementalPostOperations")]
public virtual IList<string> IncrementalPostOperations { get; set; }
Property Value
Type | Description |
---|---|
IList<string> |
IncrementalPreOperations
SQL statements to be executed before inserting new rows into the relation.
Declaration
[JsonProperty("incrementalPreOperations")]
public virtual IList<string> IncrementalPreOperations { get; set; }
Property Value
Type | Description |
---|---|
IList<string> |
IncrementalSelectQuery
The SELECT query which returns rows which should be inserted into the relation if it already exists and is not being refreshed.
Declaration
[JsonProperty("incrementalSelectQuery")]
public virtual string IncrementalSelectQuery { get; set; }
Property Value
Type | Description |
---|---|
string |
RefreshDisabled
Whether this table should be protected from being refreshed.
Declaration
[JsonProperty("refreshDisabled")]
public virtual bool? RefreshDisabled { get; set; }
Property Value
Type | Description |
---|---|
bool? |
UniqueKeyParts
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.
Declaration
[JsonProperty("uniqueKeyParts")]
public virtual IList<string> UniqueKeyParts { get; set; }
Property Value
Type | Description |
---|---|
IList<string> |
UpdatePartitionFilter
A SQL expression conditional used to limit the set of existing rows considered for a merge operation (see
unique_key_parts
for more information).
Declaration
[JsonProperty("updatePartitionFilter")]
public virtual string UpdatePartitionFilter { get; set; }
Property Value
Type | Description |
---|---|
string |