Configure the Reltio Data Pipeline for Snowflake for Azure
Learn how to configure Snowflake to receive data from your Reltio tenant in the Azure cloud.
Ready to move your data with your Reltio Data Pipeline for Snowflake? Configure the Reltio Data Pipeline for Snowflake to keep your Snowflake tables and views in sync with your Reltio data model.
Configuring the Reltio Data Pipeline for Snowflake for Azure involves these stages:
- Configure Azure cloud storage for Snowflake
- Integrate Azure cloud storage with Snowflake
- Connect Reltio to Azure cloud storage
- Validate and sync with the Reltio Data Pipeline for Snowflake for Azure
The topics in this section provide step-by-step instructions for these stages.
Before you start
Before you start configuring the Reltio for Reltio Data Pipeline for Snowflake, ensure you have the necessary permissions and information at hand. You may find it helpful to consult this page for easy reference.
| Prerequisite | Required information | Your details |
|---|---|---|
| Configure Azure cloud storage for Snowflake | ||
| Azure storage account management permissions | You are an Azure administrator OR Ask your Azure administrator to perform these tasks | |
| Integrate Azure cloud storage with Snowflake | ||
| Azure storage account management permissions | You are an Azure administrator OR Ask your Azure administrator to perform these tasks | |
| Snowflake account administrator permissions | You've been assigned either of these roles:
OR Ask your Snowflake administrator to perform these tasks | |
| Configure the Reltio Data Pipeline for Snowflake | ||
| Reltio tenant | Tenant Environment Name | |
| Tenant ID | ||
| Support request | Snowflake configuration request | |
| Validate and sync with the Reltio Data Pipeline for Snowflake for Azure | ||
| Reltio administrator permissions | You have one of these roles:
OR Ask your Reltio administrator to perform these tasks. | |
Take note
As you work through the configuration, you'll want to make a note of some values you'll need in later steps and stages. You may find it helpful to download and make a copy of this page and record your information as you go along.
| Stage/section | Entry field | Your details |
|---|---|---|
| Configure Azure cloud storage for Snowflake | ||
| Create an Azure resource group | Resource group | |
| Create an Azure storage account | Storage account name | |
| Create an Azure storage account queue | Storage queue URL | |
| Create an Azure storage account container | Storage container name | |
| Create an Azure event grid subscription | Event subscription name | |
| Create Azure client credentials | Application display name | |
| Application (client) ID | ||
| Directory (tenant) ID | ||
| Client secret | ||
| Create Azure access controls | Custom role name | |
| Integrate Azure cloud storage with Snowflake | ||
| Create a Snowflake warehouse | Snowflake warehouse name | |
| Create a Snowflake database | Snowflake database name | |
| Create a Snowflake schema | Snowflake schema name | |
| Create a JSON file format in Snowflake | JSON file format name | |
| Create a cloud storage integration in Snowflake (Azure) | Storage integration name | |
| Azure permissions request page URL | ||
| Azure application name for your Snowflake client | ||
| Create event notification integrations in Snowflake (Azure) | Notification integration name | |
| Azure permissions request page URL | ||
| Azure application name for your Snowflake client | ||
| Create an external stage (Azure) | Stage name | |
| Create a landing data table in Snowflake | Landing table name | |