Class: Aws::Firehose::Types::SnowflakeDestinationDescription

Inherits:
Struct
  • Object
show all
Defined in:
gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb

Overview

Optional Snowflake destination description

Constant Summary collapse

SENSITIVE =
[:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]

Instance Attribute Summary collapse

Instance Attribute Details

#account_urlString

URL for accessing your Snowflake account. This URL must include your account identifier. Note that the protocol (https://) and port number are optional.

Returns:

  • (String)


5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#buffering_hintsTypes::SnowflakeBufferingHints

Describes the buffering to perform before delivering data to the Snowflake destination. If you do not specify any value, Firehose uses the default values.



5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#cloud_watch_logging_optionsTypes::CloudWatchLoggingOptions

Describes the Amazon CloudWatch logging options for your Firehose stream.



5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#content_column_nameString

The name of the record content column

Returns:

  • (String)


5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#data_loading_optionString

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.

Returns:

  • (String)


5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#databaseString

All data in Snowflake is maintained in databases.

Returns:

  • (String)


5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#meta_data_column_nameString

The name of the record metadata column

Returns:

  • (String)


5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#processing_configurationTypes::ProcessingConfiguration

Describes a data processing configuration.



5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#retry_optionsTypes::SnowflakeRetryOptions

The time period where Firehose will retry sending data to the chosen HTTP endpoint.



5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#role_arnString

The Amazon Resource Name (ARN) of the Snowflake role

Returns:

  • (String)


5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#s3_backup_modeString

Choose an S3 backup mode

Returns:

  • (String)


5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#s3_destination_descriptionTypes::S3DestinationDescription

Describes a destination in Amazon S3.



5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#schemaString

Each database consists of one or more schemas, which are logical groupings of database objects, such as tables and views

Returns:

  • (String)


5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#secrets_manager_configurationTypes::SecretsManagerConfiguration

The configuration that defines how you access secrets for Snowflake.



5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#snowflake_role_configurationTypes::SnowflakeRoleConfiguration

Optionally configure a Snowflake role. Otherwise the default user role will be used.



5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#snowflake_vpc_configurationTypes::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



5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#tableString

All data in Snowflake is stored in database tables, logically structured as collections of columns and rows.

Returns:

  • (String)


5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end

#userString

User login name for the Snowflake account.

Returns:

  • (String)


5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
# File 'gems/aws-sdk-firehose/lib/aws-sdk-firehose/types.rb', line 5133

class SnowflakeDestinationDescription < Struct.new(
  :account_url,
  :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_destination_description,
  :secrets_manager_configuration,
  :buffering_hints)
  SENSITIVE = [:account_url, :user, :database, :schema, :table, :meta_data_column_name, :content_column_name]
  include Aws::Structure
end