Integrate with Data Routing

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.

Overview

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

Step 1: Create the Storage and Error Integrations

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.

Step 2: Share the Storage and Error Integration Config with Simon

DESC INTEGRATION SD_S3_DATA_ROUTING;
DESC INTEGRATION SD_S3_DATA_ROUTING_ERRORS;

Share the results of those commands with your solutions architect.

Step 3: Grant Simon Privileges to Use the Storage and Error Integration

GRANT USAGE ON INTEGRATION SD_S3_DATA_ROUTING TO ROLE SIMONDATA;
GRANT USAGE ON INTEGRATION SD_S3_DATA_ROUTING_ERRORS TO ROLE SIMONDATA;