The Snowflake Synapse enables data synchronization between Snowflake schema and Syncari entities using the Snowflake API. After the Synapse is Authenticated, a user can Activate the Snowflake Synapse, which enables Syncari to replicate the schema of Snowflake and make it available within the Unified Data Model. Using the Sync Studio, a user can map Snowflake objects to Syncari entities, and Snowflake fields to Syncari fields.
If your Snowflake security requires you to whitelist an IP you can find that here.
Snowflake Information
You will need the following information from Snowflake:
- Account Name
- Warehouse Name
- Database Name
- Schema Name
After you login to your Snowflake subscription, these steps will help you locate the information you need for the Synapse Setup.
- Account Name
- Warehouse Name
- Database Name
- Schema Name
Synapse Setup
Step 1: Start by logging in to your Syncari subscription
- Navigate to Synapses
- Find Snowflake in the Synapse Library
- Drag the Snowflake Synapse to the canvas
Step 2: Configure your Synapse parameters
- Enter
[Synapse Name]
- Enter
[Account Name]
- Enter
[Warehouse Name]
- Enter
[Database Name]
- Enter
[Schema Name]
- Click "Next"
[OPTIONAL] Enable Syncari to automatically create entities in Snowflake
Most customers use Snowflake as a source Synapse and therefore would NOT set this option.
However, the "Instantiate with Syncari entities" option enables all the existing entities in Syncari to be created as tables in Snowflake. This feature is useful if you want the schema from the Syncari Unified Data Model to be replicated in Snowflake.
Talk to one of our Onboarding and Support Team members if you would like any clarification or a recommendation.
Step 3: Define your authentication parameters:
- Enter
[User Name]
- Enter
[Password]
- Click "Authenticate"
- Click "Next"
Step 4: Activate your Synapse
- Click "Make Synapse Active"
- Click "Close"
Congratulations! You have completed the setup of Snowflake.
If you receive any errors message after clicking Authenticate, confirm each of the parameters in the previous steps are configured properly. If the error persists, contact one of our Onboarding and Support team members.
What's Next?
Checkout this article to learn how to designate the Id and Watermark fields for Snowflake Entities.