Class: Aws::Glue::Types::AmazonRedshiftNodeData
- Inherits:
-
Struct
- Object
- Struct
- Aws::Glue::Types::AmazonRedshiftNodeData
- Includes:
- Structure
- Defined in:
- lib/aws-sdk-glue/types.rb
Overview
Specifies an Amazon Redshift node.
Constant Summary collapse
- SENSITIVE =
[]
Instance Attribute Summary collapse
-
#access_type ⇒ String
The access type for the Redshift connection.
-
#action ⇒ String
Specifies how writing to a Redshift cluser will occur.
-
#advanced_options ⇒ Array<Types::AmazonRedshiftAdvancedOption>
Optional values when connecting to the Redshift cluster.
-
#catalog_database ⇒ Types::Option
The name of the Glue Data Catalog database when working with a data catalog.
-
#catalog_redshift_schema ⇒ String
The Redshift schema name when working with a data catalog.
-
#catalog_redshift_table ⇒ String
The database table to read from.
-
#catalog_table ⇒ Types::Option
The Glue Data Catalog table name when working with a data catalog.
-
#connection ⇒ Types::Option
The Glue connection to the Redshift cluster.
-
#crawler_connection ⇒ String
Specifies the name of the connection that is associated with the catalog table used.
-
#iam_role ⇒ Types::Option
Optional.
-
#merge_action ⇒ String
The action used when to detemine how a MERGE in a Redshift sink will be handled.
-
#merge_clause ⇒ String
The SQL used in a custom merge to deal with matching records.
-
#merge_when_matched ⇒ String
The action used when to detemine how a MERGE in a Redshift sink will be handled when an existing record matches a new record.
-
#merge_when_not_matched ⇒ String
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.
-
#post_action ⇒ String
The SQL used before a MERGE or APPEND with upsert is run.
-
#pre_action ⇒ String
The SQL used before a MERGE or APPEND with upsert is run.
-
#sample_query ⇒ String
The SQL used to fetch the data from a Redshift sources when the SourceType is ‘query’.
-
#schema ⇒ Types::Option
The Redshift schema name when working with a direct connection.
-
#selected_columns ⇒ Array<Types::Option>
The list of column names used to determine a matching record when doing a MERGE or APPEND with upsert.
-
#source_type ⇒ String
The source type to specify whether a specific table is the source or a custom query.
-
#staging_table ⇒ String
The name of the temporary staging table that is used when doing a MERGE or APPEND with upsert.
-
#table ⇒ Types::Option
The Redshift table name when working with a direct connection.
-
#table_prefix ⇒ String
Specifies the prefix to a table.
-
#table_schema ⇒ Array<Types::Option>
The array of schema output for a given node.
-
#temp_dir ⇒ String
The Amazon S3 path where temporary data can be staged when copying out of the database.
-
#upsert ⇒ Boolean
The action used on Redshift sinks when doing an APPEND.
Instance Attribute Details
#access_type ⇒ String
The access type for the Redshift connection. Can be a direct connection or catalog connections.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#action ⇒ String
Specifies how writing to a Redshift cluser will occur.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#advanced_options ⇒ Array<Types::AmazonRedshiftAdvancedOption>
Optional values when connecting to the Redshift cluster.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#catalog_database ⇒ Types::Option
The name of the Glue Data Catalog database when working with a data catalog.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#catalog_redshift_schema ⇒ String
The Redshift schema name when working with a data catalog.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#catalog_redshift_table ⇒ String
The database table to read from.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#catalog_table ⇒ Types::Option
The Glue Data Catalog table name when working with a data catalog.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#connection ⇒ Types::Option
The Glue connection to the Redshift cluster.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#crawler_connection ⇒ String
Specifies the name of the connection that is associated with the catalog table used.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#iam_role ⇒ Types::Option
Optional. The role name use when connection to S3. The IAM role ill default to the role on the job when left blank.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#merge_action ⇒ String
The action used when to detemine how a MERGE in a Redshift sink will be handled.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#merge_clause ⇒ String
The SQL used in a custom merge to deal with matching records.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#merge_when_matched ⇒ String
The action used when to detemine how a MERGE in a Redshift sink will be handled when an existing record matches a new record.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#merge_when_not_matched ⇒ String
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.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#post_action ⇒ String
The SQL used before a MERGE or APPEND with upsert is run.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#pre_action ⇒ String
The SQL used before a MERGE or APPEND with upsert is run.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#sample_query ⇒ String
The SQL used to fetch the data from a Redshift sources when the SourceType is ‘query’.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#schema ⇒ Types::Option
The Redshift schema name when working with a direct connection.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#selected_columns ⇒ Array<Types::Option>
The list of column names used to determine a matching record when doing a MERGE or APPEND with upsert.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#source_type ⇒ String
The source type to specify whether a specific table is the source or a custom query.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#staging_table ⇒ String
The name of the temporary staging table that is used when doing a MERGE or APPEND with upsert.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#table ⇒ Types::Option
The Redshift table name when working with a direct connection.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#table_prefix ⇒ String
Specifies the prefix to a table.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#table_schema ⇒ Array<Types::Option>
The array of schema output for a given node.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#temp_dir ⇒ String
The Amazon S3 path where temporary data can be staged when copying out of the database.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |
#upsert ⇒ Boolean
The action used on Redshift sinks when doing an APPEND.
297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 |
# File 'lib/aws-sdk-glue/types.rb', line 297 class AmazonRedshiftNodeData < Struct.new( :access_type, :source_type, :connection, :schema, :table, :catalog_database, :catalog_table, :catalog_redshift_schema, :catalog_redshift_table, :temp_dir, :iam_role, :advanced_options, :sample_query, :pre_action, :post_action, :action, :table_prefix, :upsert, :merge_action, :merge_when_matched, :merge_when_not_matched, :merge_clause, :crawler_connection, :table_schema, :staging_table, :selected_columns) SENSITIVE = [] include Aws::Structure end |