# 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](API_AmazonRedshiftAdvancedOption.md) objects Required: No ** CatalogDatabase ** The name of the AWS Glue Data Catalog database when working with a data catalog. Type: [Option](API_Option.md) 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](API_Option.md) object Required: No ** Connection ** The AWS Glue connection to the Redshift cluster. Type: [Option](API_Option.md) 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](API_Option.md) 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](API_Option.md) 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](API_Option.md) 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](API_Option.md) 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](API_Option.md) 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: + [AWS SDK for C\$1\$1](https://docs.aws.amazon.com/goto/SdkForCpp/glue-2017-03-31/AmazonRedshiftNodeData) + [AWS SDK for Java V2](https://docs.aws.amazon.com/goto/SdkForJavaV2/glue-2017-03-31/AmazonRedshiftNodeData) + [AWS SDK for Ruby V3](https://docs.aws.amazon.com/goto/SdkForRubyV3/glue-2017-03-31/AmazonRedshiftNodeData)