Class: Aws::Firehose::Types::SnowflakeDestinationConfiguration
- Inherits:
-
Struct
- Object
- Struct
- Aws::Firehose::Types::SnowflakeDestinationConfiguration
- Defined in:
- gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb
Overview
Configure Snowflake destination
Constant Summary collapse
- SENSITIVE =
[:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
Instance Attribute Summary collapse
-
#account_url ⇒ String
URL for accessing your Snowflake account.
-
#cloud_watch_logging_options ⇒ Types::CloudWatchLoggingOptions
Describes the Amazon CloudWatch logging options for your delivery stream.
-
#content_column_name ⇒ String
The name of the record content column.
-
#data_loading_option ⇒ String
Choose to load JSON keys mapped to table column names or choose to split the JSON payload where content is mapped to a record content column and source metadata is mapped to a record metadata column.
-
#database ⇒ String
All data in Snowflake is maintained in databases.
-
#key_passphrase ⇒ String
Passphrase to decrypt the private key when the key is encrypted.
-
#meta_data_column_name ⇒ String
The name of the record metadata column.
-
#private_key ⇒ String
The private key used to encrypt your Snowflake client.
-
#processing_configuration ⇒ Types::ProcessingConfiguration
Describes a data processing configuration.
-
#retry_options ⇒ Types::SnowflakeRetryOptions
The time period where Firehose will retry sending data to the chosen HTTP endpoint.
-
#role_arn ⇒ String
The Amazon Resource Name (ARN) of the Snowflake role.
-
#s3_backup_mode ⇒ String
Choose an S3 backup mode.
-
#s3_configuration ⇒ Types::S3DestinationConfiguration
Describes the configuration of a destination in Amazon S3.
-
#schema ⇒ String
Each database consists of one or more schemas, which are logical groupings of database objects, such as tables and views.
-
#secrets_manager_configuration ⇒ Types::SecretsManagerConfiguration
The configuration that defines how you access secrets for Snowflake.
-
#snowflake_role_configuration ⇒ Types::SnowflakeRoleConfiguration
Optionally configure a Snowflake role.
-
#snowflake_vpc_configuration ⇒ Types::SnowflakeVpcConfiguration
The VPCE ID for Firehose to privately connect with Snowflake.
-
#table ⇒ String
All data in Snowflake is stored in database tables, logically structured as collections of columns and rows.
-
#user ⇒ String
User login name for the Snowflake account.
Instance Attribute Details
#account_url ⇒ String
URL for accessing your Snowflake account. This URL must include your account identifier. Note that the protocol (https://) and port number are optional.
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#cloud_watch_logging_options ⇒ Types::CloudWatchLoggingOptions
Describes the Amazon CloudWatch logging options for your delivery stream.
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#content_column_name ⇒ String
The name of the record content column
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#data_loading_option ⇒ String
Choose to load JSON keys mapped to table column names or choose to split the JSON payload where content is mapped to a record content column and source metadata is mapped to a record metadata column.
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#database ⇒ String
All data in Snowflake is maintained in databases.
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#key_passphrase ⇒ String
Passphrase to decrypt the private key when the key is encrypted. For information, see Using Key Pair Authentication & Key Rotation.
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#meta_data_column_name ⇒ String
The name of the record metadata column
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#private_key ⇒ String
The private key used to encrypt your Snowflake client. For information, see Using Key Pair Authentication & Key Rotation.
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#processing_configuration ⇒ Types::ProcessingConfiguration
Describes a data processing configuration.
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#retry_options ⇒ Types::SnowflakeRetryOptions
The time period where Firehose will retry sending data to the chosen HTTP endpoint.
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#role_arn ⇒ String
The Amazon Resource Name (ARN) of the Snowflake role
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#s3_backup_mode ⇒ String
Choose an S3 backup mode
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#s3_configuration ⇒ Types::S3DestinationConfiguration
Describes the configuration of a destination in Amazon S3.
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#schema ⇒ String
Each database consists of one or more schemas, which are logical groupings of database objects, such as tables and views
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#secrets_manager_configuration ⇒ Types::SecretsManagerConfiguration
The configuration that defines how you access secrets for Snowflake.
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#snowflake_role_configuration ⇒ Types::SnowflakeRoleConfiguration
Optionally configure a Snowflake role. Otherwise the default user role will be used.
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#snowflake_vpc_configuration ⇒ Types::SnowflakeVpcConfiguration
The VPCE ID for Firehose to privately connect with Snowflake. The ID format is com.amazonaws.vpce.[region].vpce-svc-<[id]>. For more information, see Amazon PrivateLink & Snowflake
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#table ⇒ String
All data in Snowflake is stored in database tables, logically structured as collections of columns and rows.
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |
#user ⇒ String
User login name for the Snowflake account.
4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 |
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 4058 class SnowflakeDestinationConfiguration < Struct.new( :account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :snowflake_role_configuration, :data_loading_option, :meta_data_column_name, :content_column_name, :snowflake_vpc_configuration, :cloud_watch_logging_options, :processing_configuration, :role_arn, :retry_options, :s3_backup_mode, :s3_configuration, :secrets_manager_configuration) SENSITIVE = [:account_url, :private_key, :key_passphrase, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name] include Aws::Structure end |