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 ».

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

AmazonRedshiftNodeData

Specifies an Amazon Redshift node.

Contents

AccessType

The access type for the Redshift connection. Can be a direct connection or catalog connections.

Type: String

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

Required: No

Action

Specifies how writing to a Redshift cluser will occur.

Type: String

Required: No

AdvancedOptions

Optional values when connecting to the Redshift cluster.

Type: Array of AmazonRedshiftAdvancedOption objects

Required: No

CatalogDatabase

The name of the AWS Glue Data Catalog database when working with a data catalog.

Type: Option object

Required: No

CatalogRedshiftSchema

The Redshift schema name when working with a data catalog.

Type: String

Required: No

CatalogRedshiftTable

The database table to read from.

Type: String

Required: No

CatalogTable

The AWS Glue Data Catalog table name when working with a data catalog.

Type: Option object

Required: No

Connection

The AWS Glue connection to the Redshift cluster.

Type: Option object

Required: No

CrawlerConnection

Specifies the name of the connection that is associated with the catalog table used.

Type: String

Required: No

IamRole

Optional. The role name use when connection to S3. The IAM role ill default to the role on the job when left blank.

Type: Option object

Required: No

MergeAction

The action used when to detemine how a MERGE in a Redshift sink will be handled.

Type: String

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

Required: No

MergeClause

The SQL used in a custom merge to deal with matching records.

Type: String

Required: No

MergeWhenMatched

The action used when to detemine how a MERGE in a Redshift sink will be handled when an existing record matches a new record.

Type: String

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

Required: No

MergeWhenNotMatched

The action used when to detemine how a MERGE in a Redshift sink will be handled when an existing record doesn't match a new record.

Type: String

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

Required: No

PostAction

The SQL used before a MERGE or APPEND with upsert is run.

Type: String

Required: No

PreAction

The SQL used before a MERGE or APPEND with upsert is run.

Type: String

Required: No

SampleQuery

The SQL used to fetch the data from a Redshift sources when the SourceType is 'query'.

Type: String

Required: No

Schema

The Redshift schema name when working with a direct connection.

Type: Option object

Required: No

SelectedColumns

The list of column names used to determine a matching record when doing a MERGE or APPEND with upsert.

Type: Array of Option objects

Required: No

SourceType

The source type to specify whether a specific table is the source or a custom query.

Type: String

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

Required: No

StagingTable

The name of the temporary staging table that is used when doing a MERGE or APPEND with upsert.

Type: String

Required: No

Table

The Redshift table name when working with a direct connection.

Type: Option object

Required: No

TablePrefix

Specifies the prefix to a table.

Type: String

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

Required: No

TableSchema

The array of schema output for a given node.

Type: Array of Option objects

Required: No

TempDir

The Amazon S3 path where temporary data can be staged when copying out of the database.

Type: String

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

Required: No

Upsert

The action used on Redshift sinks when doing an APPEND.

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 :

AmazonRedshiftSource

Rubrique précédente :

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