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:
([\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF]|[^\S\r\n"'])*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:
