SnowflakeNodeData

Specifies what action to take when writing to a table with preexisting data. Valid values: append, merge, truncate, drop.

Specifies additional options passed to the Snowflake connector. If options are specified elsewhere in this node, this will take precedence.

Specifies whether automatic query pushdown is enabled. If pushdown is enabled, then when a query is run on Spark, if part of the query can be "pushed down" to the Snowflake server, it is pushed down. This improves performance of some queries.

Specifies a Glue Data Catalog Connection to a Snowflake endpoint.

Specifies a Snowflake database for your node to use.

Not currently used.

Specifies a merge action. Valid values: simple, custom. If simple, merge behavior is defined by MergeWhenMatched and MergeWhenNotMatched. If custom, defined by MergeClause.

A SQL statement that specifies a custom merge behavior.

Specifies how to resolve records that match preexisting data when merging. Valid values: update, delete.

Specifies how to process records that do not match preexisting data when merging. Valid values: insert, none.

A SQL string run after the Snowflake connector performs its standard actions.

A SQL string run before the Snowflake connector performs its standard actions.

A SQL string used to retrieve data with the query sourcetype.

Specifies a Snowflake database schema for your node to use.

Specifies the columns combined to identify a record when detecting matches for merges and upserts. A list of structures with value, label and description keys. Each structure describes a column.

Specifies how retrieved data is specified. Valid values: "table", "query".

The name of a staging table used when performing merge or upsert append actions. Data is written to this table, then moved to table by a generated postaction.

Specifies a Snowflake table for your node to use.

Manually defines the target schema for the node. A list of structures with value , label and description keys. Each structure defines a column.

Not currently used.

Used when Action is append. Specifies the resolution behavior when a row already exists. If true, preexisting rows will be updated. If false, those rows will be inserted.