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.