IncrementalTableConfig

import type { IncrementalTableConfig } from "https://googleapis.deno.dev/v1/dataform:v1beta1.ts";

Contains settings for relations of type INCREMENTAL_TABLE.

interface IncrementalTableConfig {

incrementalPostOperations?: string[];

incrementalPreOperations?: string[];

incrementalSelectQuery?: string;

refreshDisabled?: boolean;

uniqueKeyParts?: string[];

updatePartitionFilter?: string;

}

§Properties

incrementalPostOperations?: string[]

[src]

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

incrementalPreOperations?: string[]

[src]

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

incrementalSelectQuery?: string

[src]

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

refreshDisabled?: boolean

[src]

Whether this table should be protected from being refreshed.

uniqueKeyParts?: string[]

[src]

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.

updatePartitionFilter?: string

[src]

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