STORAGE.EXTERNAL_TABLE_AWS_SNS_TOPIC

Target database: Snowflake

STORAGE.EXTERNAL_TABLE_AWS_SNS_TOPIC option specifies the ARN of the AWS SNS TOPIC.

Required only when configuring AUTO_REFRESH for Amazon S3 stages using Amazon Simple Notification Service (SNS). Specifies the Amazon Resource Name (ARN) for the SNS topic for your S3 bucket. The CREATE EXTERNAL TABLE statement subscribes the Amazon Simple Queue Service (SQS) queue to the specified SNS topic. Event notifications through the SNS topic trigger metadata refreshes.

See also:

EXTERNAL_TABLE

Usage

OPTION

STORAGE.EXTERNAL_TABLE_AWS_SNS_TOPIC: String

Default: Empty.

Notes

Supports only Snowflake External table

Examples

Snowflake: Set the STORAGE.EXTERNAL_TABLE_AWS_SNS_TOPIC

Setting STORAGE.EXTERNAL_TABLE_AWS_SNS_TOPIC for an External table (e.g. publish.F_TRIP):

OPTION

STORAGE.EXTERNAL_TABLE_AWS_SNS_TOPIC: arn:aws-eu-west-1:s3:project:resource:name

DDL generated by Agile Data Engine:

SQL

CREATE EXTERNAL TABLE publish.F_TRIP (
  ...
)
..
AWS_SNS_TOPIC = 'arn:aws-eu-west-1:s3:project:resource:name'
...;