Snowflake Setup

Syncaroo
Syncaroo
  • Updated

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.

  1. Account Name
  2. Warehouse Namemceclip1.png
  3. Database Namemceclip2.png
  4. Schema Namemceclip3.png

Synapse Setup

Step 1: Start by logging in to your Syncari subscription

  1. Navigate to Synapses
  2. Find Snowflake in the Synapse Library
  3. Drag the Snowflake Synapse to the canvas

mceclip0.png

Step 2: Configure your Synapse parameters

  1. Enter [Synapse Name]
  2. Enter [Account Name]
  3. Enter [Warehouse Name]
  4. Enter [Database Name]
  5. Enter [Schema Name]
  6. Click "Next"

mceclip4.png

[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:

  1. Enter [User Name]
  2. Enter [Password]
  3. Click "Authenticate"
  4. Click "Next"

mceclip5.png

 

Step 4: Activate your Synapse

  1. Click "Make Synapse Active"
  2. Click "Close"

mceclip6.png

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.

Share this

Was this article helpful?

0 out of 0 found this helpful