Reltio Data Pipeline for Snowflake at a glance
Get a high-level view of Reltio Data Pipeline for Snowflake.
Are you a data scientist or business analyst who is in charge of managing and analyzing data in your organization's Snowflake data platform? If you’d like a better way to report accurate insights and critical updates quickly and efficiently, then this is the topic for you!
Note: Reltio Data Pipeline for Snowflake is an add-on that requires a separate subscription.
The Reltio Data Pipeline for Snowflake delivers clean, merged, and validated profile data to your Snowflake environment using an event-driven, near real-time architecture. This allows you to analyze continuously updated Reltio data without custom exports or integration overhead.
Key features and benefits
- Low-code onboarding with Reltio-managed automation
- Just provide your Snowflake connection details and Reltio sets up the required resources in your Snowflake environment. You don’t need to build ingestion logic or maintain intermediate storage layers.
- Comprehensive, query-ready profile data
- Reltio automatically populates entity, relationship, interaction, match, merge, activity, and workflow tables. These include deduplicated and enriched records aligned with your Reltio data model, ready for direct analysis in Snowflake.
- Near real-time updates
- All relevant changes in your Reltio tenant — such as merges, deletions, and attribute updates — are reflected in your Snowflake environment in near real-time.
- Automatic schema evolution
- Schema updates in Reltio, such as new entity types or modified attributes, are automatically synced with your Snowflake environment. No manual schema alignment is required.
- Cloud-agnostic integration
- The Snowflake pipeline works with Snowflake accounts hosted on AWS, Azure, or Google Cloud.
- Built-in monitoring and observability
- The pipeline includes internal consistency checks, staging tables with time travel support, and self-service monitoring APIs. You can audit data movement and ensure reliability across your Snowflake environment. See Entity Monitoring API and Event Monitoring API.
Pipeline architecture
We support two architectures for delivering data to Snowflake:
- Recommended pipeline architecture
- This is the latest and recommended implementation. It delivers data directly to your Snowflake internal stage using JDBC. Reltio automatically provisions and manages required resources including landing tables, streams, views, and tasks inside your Snowflake environment. For more information, see Reltio Data Pipeline for Snowflake architecture.
- Legacy pipeline architecture
- This architecture delivers data to customer-managed cloud storage (e.g., Amazon S3, Azure Blob, Google Cloud Storage). Snowflake ingests the data using Snowpipe and a custom event queue. This model is still supported for existing customers but is no longer recommended for new implementations. For more information, see Reltio Data Pipeline for Snowflake architecture (legacy).