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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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’.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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.
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 |
# File 'lib/aws-sdk-glue/types.rb', line 316 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 |