Data Routing is an add-on
Contact your account manager to let them know you'd like to use this feature.
If you're not using Data Routing, skip this guide and continue on to step 3.
Data Routing is Simon's solution for enriching your Snowflake data warehouse with data from your other vendors, as well as routing data collected on your website via Simon Signal to your data warehouse.
Our data routing product loads data into your Snowflake from temporary storage in a Simon-owned S3 bucket. In order to support this, you need to build a storage integration within Snowflake to enable access to our S3 bucket.
Before you begin
Before configuring your Data Routing integration, complete the steps in 2: Connect to Snowflake
Creating these requires you to have access to the ACCOUNTADMIN role in your Snowflake instance.
USE ROLE ACCOUNTADMIN;
CREATE STORAGE INTEGRATION SD_S3_DATA_ROUTING
TYPE = EXTERNAL_STAGE
STORAGE_PROVIDER = 'S3'
ENABLED = TRUE
STORAGE_AWS_ROLE_ARN = 'arn:aws:iam::709223122281:role/<client identifier>-snowpipe-s3-integration'
STORAGE_ALLOWED_LOCATIONS = ('s3://<client identifier>.simondata.com/data-routing/');
CREATE NOTIFICATION INTEGRATION SD_S3_DATA_ROUTING_ERRORS
ENABLED = TRUE
TYPE = QUEUE
NOTIFICATION_PROVIDER = AWS_SNS
DIRECTION = OUTBOUND
AWS_SNS_TOPIC_ARN = 'arn:aws:sns:us-east-1:709223122281:snowpipe-errors-<client identifier>'
AWS_SNS_ROLE_ARN = 'arn:aws:iam::709223122281:role/<client identifier>-snowpipe-sns-integration';
Note that our Data Routing product depends on creating an S3 storage integration, which can only be created using your
ACCOUNTADMIN role. Talk to your solutions architect to determine the
client identifer to use when running this command.
DESC INTEGRATION SD_S3_DATA_ROUTING;
DESC INTEGRATION SD_S3_DATA_ROUTING_ERRORS;
Share the results of those commands with your solutions architect.
GRANT USAGE ON INTEGRATION SD_S3_DATA_ROUTING TO ROLE SIMONDATA;
GRANT USAGE ON INTEGRATION SD_S3_DATA_ROUTING_ERRORS TO ROLE SIMONDATA;
Updated 16 days ago