Fuel Your Master
Data Management
Learning Journey.
Reltio Connected Data for Snowflake
Overview
Reltio Connected Data for Snowflake delivers Connected Customer 360 data residing in the Reltio platform seamlessly into your Snowflake data warehouse. The rich Reltio data model is automatically converted to flat relational views, allowing you to extract insights from the data using standard Business Insight tools of your choice. Reltio Connected Data for Snowflake is an add-on subscription. Once the subscription is activated, you can set up the data flow pipeline in a self-service manner.
This course provides you with an overview of how you can use Reltio and Snowflake together to better solve business problems. It outlines the steps required to integrate Reltio and Snowflake in order to seamlessly export data from Reltio to Snowflake and provides some best practices to manage and export data for Snowflake. You will also learn about the various options available to export quality data from Reltio to Snowflake and how to execute queries in Snowflake to access the exported data.
Course Prerequisites & Target Audience
This course is designed for users who are responsible for exporting data from Reltio to Snowflake. The target audience for this course includes Snowflake Administrators, Reltio Administrators, Snowflake Data Engineers/Report Developers, and Business Users.
Course Prerequisites:
| Courses/Content | Required/Recommended |
|---|---|
| Introduction to Master Data Management | Recommended |
| Introduction to ReST Protocol | Recommended |
| Introduction to the JSON Document Format | Recommended |
Skills:
| Skills | Required/Recommended |
|---|---|
| Familiarity with the Reltio Platform | Required |
| Basic understanding of Master Data Management | Recommended |
| Cloud computing | Recommended |
| Snowflake (user account, security, SQL) | Required |
| Using REST APIs | Required |
| JSON processing | Nice to have |
Course Content
The Reltio Connected Data for Snowflake course covers the following topics:
- Reltio Connected Data for Snowflake Overview
- Benefits of using Reltio Connected Data for Snowflake
- Overview of Reltio Connected Data for Snowflake features
- Setting Up and Configuring Reltio Connected Data for Snowflake
- Setting up Reltio Connected Data for Snowflake
- Creating a pipeline to export Reltio objects
- Managing Snowflake Data Export Jobs
- Creating batch and incremental jobs
- Scheduling a pipeline job
- Monitor the progress of export to Snowflake jobs
- Writing Queries in Snowflake to Access Reltio Data
- Accessing simple, nested, and reference attributes of entity types
- Accessing relationship attributes
- Accessing interaction attributes
- Accessing match and merge attributes
- Reltio Connected Data for Snowflake Best Practices and Troubleshooting
Course Expectations
Learners can access the Reltio Connected Data for Snowflake self-paced training modules through our learning management system at their convenience. The course also includes a scenario-based exercise that allows learners to reflect on the key concepts learned during the course.
Time Commitment
The course duration is 2.5 hours. Instructor support is NOT available for this course.
