Configure the Reltio Data Pipeline for Snowflake for AWS

Learn how to configure your Amazon Web Services (AWS) Snowflake account to receive data from your Reltio tenant.

User journey at a glance

This page covers the overall journey at a high level. If you want the blow-by-blow for all sections, keep reading!

Note: Before you can use the Reltio Data Pipeline for Snowflake, you need the ARN based on your data's Health Insurance Portability and Accountability Act (HIPAA) status. You will need this information to edit the trust policy during your role creation in the cloud storage integration stage of the configuration process mentioned in the User journey at a glance section. With this information, you are allowing Reltio to connect to your cloud storage and write events to that location. For help finding your ARN, login to Support and check out Reltio Roles for Reltio Snowflake Connector.

Integrate cloud storage with Reltio

Follow these steps to integrate Reltio and your Snowflake cloud storage. Need more help? Use the links to navigate to topics with more detail.


Step	Action
1	Create: S3 storage location IAM policy with write permissions to S3 IAM role
2	Establish Snowflake Access to Cloud Storage to trust Reltio's IAM role.
3	Provision your Reltio tenant for the Reltio Data Pipeline for Snowflake (AWS) with your: AWS S3 bucket name role with write access that is assumed by the Reltio user. tenant ID tenant environment name external ID
4	Validate: Connection with S3 bucket Reltio UI Reltio API

Connect Snowflake to cloud storage

Follow these steps to connect Snowflake to your AWS cloud storage. Need more help? Use the links to navigate to topics with more detail.


Step	Action
1	Create: IAM policy for giving Snowflake read access to S3. Note: Reltio does not require any permissions here. These permissions are strictly internal to your organization. You only need to grant the following read permissions between your S3 storage and Snowflake:s3:GetObjects3:ListBuckets3:GetObjectLocation s3:GetObjectVersion AWS IAM role with an external ID for Snowflake.
2	Create a snowflake integration with a read-only role that is assumed by the Snowflake user, and the partial S3 bucket location.
3	Retrieve the AWS IAM user and external ID.
4	Update the AWS trust policy for Snowflake

Configure Snowflake to accept Reltio data from cloud storage

Follow these steps to configure Snowflake to recognize your Reltio data in your AWS cloud storage. Need more help? Use the links to navigate to topics with more detail.


Step	Action
1	Create an external stage in snowflake with the complete S3 bucket location.
2	Create: A JSON file format A landing table A pipe The notification integration A stream with staging table A staging table for each object type Note: If you do this step even if the object types don't exist in your tenant, object type tables are created but no data is processed in the tables. A task for each object type
3	Start the task

Validate and sync

Follow these steps to validate the connection and sync Snowflake with your Reltio data in your AWS cloud storage. Need more help? Use the links to navigate to topics with more detail.


Step	Action
1	Validate event transfer in Snowflake with the Reltio UI.
2	Validate event transfer in Snowflake with the Reltio API.
3	Sync data between Reltio and Snowflake: `POST {{apihost}}/reltio/api/syncToDataPipeline`

Accelerate the Value of Data