选择您的 Cookie 首选项

我们使用必要 Cookie 和类似工具提供我们的网站和服务。我们使用性能 Cookie 收集匿名统计数据,以便我们可以了解客户如何使用我们的网站并进行改进。必要 Cookie 无法停用,但您可以单击“自定义”或“拒绝”来拒绝性能 Cookie。

如果您同意,AWS 和经批准的第三方还将使用 Cookie 提供有用的网站功能、记住您的首选项并显示相关内容,包括相关广告。要接受或拒绝所有非必要 Cookie,请单击“接受”或“拒绝”。要做出更详细的选择,请单击“自定义”。

SnowflakeNodeData - AWS Glue
此页面尚未翻译为您的语言。 请求翻译

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:

下一主题:

SnowflakeSource

上一主题:

SkewedInfo
隐私网站条款Cookie 首选项
© 2025, Amazon Web Services, Inc. 或其附属公司。保留所有权利。