Snowflake
DLH.io documentation for Snowflake
The Data Cloud, aka "Snowflake", is accessible to you as both a source and a target. Snowflake is the Data Warehousing platform that enables massive compute and storage separation for robust data workload processing and consumption.
As a data governed invention machine it solves many of the problems with modern data complexity and growth. It is the perfect destination for the majority of workloads most companies would fathom. As such DLH.io (DLH.io) as a Snowflake partner is delighted to offer Snowflake as a target destination for synchronizing your data to enable your data driven and data democratization journey; also as a source to enable Data Catalog and Snowflake Management capabilities to allow your organization to use more of the Snowflake features you're paying for but probably not benefiting from.
Setup Instructions
Follow the setup steps guide for configuring your Snowflake connection to enable data to flow into your destination via DLH.
Supported Features
Here are key features supported for this connector.
| Sync Feature | Supported | Details |
|---|---|---|
| Custom Data and Development | ✓ | Ability to enhance connector upon request |
| Historical Re-Load/Load | ✓ | |
| Incremental/Delta Load | ✓ | Gets most recent records and changes |
| Column Selection | ✓ | |
| Column Hashing | ✓ | |
| Re-Sync Table/Entity | ✓ | Select at the table level to reload data history (on next Sync Bridge run) |
| Custom Queries | Utilizing SQL Data Query Connector | |
| Custom Data | ||
| Captures Deleted Rows | ✓ | On all supported tables |
| API Sync Bridge Initiation | ✓ | |
| Priority Scheduling | ✓ | |
| Private VPC/Link | ☂ | |
| DLH Data Model Available | - |
If you have any questions about these supported features please reach out to our Customer Support team.
Details on Sync Processing
For this connector, we believe the sync processing is straightforward. We've provided a number of details, steps, and other guidance here and in the setup steps guide. Be sure to also check the change log and notes page from time to time for any changes.
Snowflake Connector Types
DLH.io has three types of Snowflake connectors for various use cases:
- Snowflake Terraform
- Enables usage of the Reverse Terraform Snowflake (RTS) functionality native only to DLH.io.
- This is found under the "Source" connectors list of connectors.
- Snowflake as a Source/Management
- Provides a connector to Snowflake that has more administrative privileges on your Snowflake account which enables features such as Object Tagging in the DLH.io Simple Data Catalog (SDC)
- Snowflake as a Target
- This is the standard Snowflake target destination connector which must be created and linked to a Sync Bridge along with a source connector.