Sélectionner vos préférences de cookies

Nous utilisons des cookies essentiels et des outils similaires qui sont nécessaires au fonctionnement de notre site et à la fourniture de nos services. Nous utilisons des cookies de performance pour collecter des statistiques anonymes afin de comprendre comment les clients utilisent notre site et d’apporter des améliorations. Les cookies essentiels ne peuvent pas être désactivés, mais vous pouvez cliquer sur « Personnaliser » ou « Refuser » pour refuser les cookies de performance.

Si vous êtes d’accord, AWS et les tiers approuvés utiliseront également des cookies pour fournir des fonctionnalités utiles au site, mémoriser vos préférences et afficher du contenu pertinent, y compris des publicités pertinentes. Pour accepter ou refuser tous les cookies non essentiels, cliquez sur « Accepter » ou « Refuser ». Pour effectuer des choix plus détaillés, cliquez sur « Personnaliser ».

SnowflakeNodeData - AWS Glue
Cette page n'a pas été traduite dans votre langue. Demande de traduction

SnowflakeNodeData

Specifies configuration for Snowflake nodes in AWS Glue Studio.

Contents

Action

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

Type: String

Required: No

AdditionalOptions

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

Type: String to string map

Key Pattern: ([\u0009\u000B\u000C\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF])*

Value Pattern: ([\u0009\u000B\u000C\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF])*

Required: No

AutoPushdown

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.

Type: Boolean

Required: No

Connection

Specifies a AWS Glue Data Catalog Connection to a Snowflake endpoint.

Type: Option object

Required: No

Database

Specifies a Snowflake database for your node to use.

Type: String

Required: No

IamRole

Not currently used.

Type: Option object

Required: No

MergeAction

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

Type: String

Pattern: [A-Za-z0-9_-]*

Required: No

MergeClause

A SQL statement that specifies a custom merge behavior.

Type: String

Required: No

MergeWhenMatched

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

Type: String

Pattern: [A-Za-z0-9_-]*

Required: No

MergeWhenNotMatched

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

Type: String

Pattern: [A-Za-z0-9_-]*

Required: No

PostAction

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

Type: String

Required: No

PreAction

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

Type: String

Required: No

SampleQuery

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

Type: String

Required: No

Schema

Specifies a Snowflake database schema for your node to use.

Type: String

Required: No

SelectedColumns

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.

Type: Array of Option objects

Required: No

SourceType

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

Type: String

Pattern: [A-Za-z0-9_-]*

Required: No

StagingTable

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.

Type: String

Required: No

Table

Specifies a Snowflake table for your node to use.

Type: String

Required: No

TableSchema

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

Type: Array of Option objects

Required: No

TempDir

Not currently used.

Type: String

Pattern: ([\u0009\u000B\u000C\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF])*

Required: No

Upsert

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.

Type: Boolean

Required: No

See Also

For more information about using this API in one of the language-specific AWS SDKs, see the following:

Rubrique suivante :

SnowflakeSource

Rubrique précédente :

SkewedInfo
ConfidentialitéConditions d'utilisation du sitePréférences de cookies
© 2025, Amazon Web Services, Inc. ou ses affiliés. Tous droits réservés.