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
  • User Role (By default, PUBLIC will be used)

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

User Role Setup

If the user is already created, the details can be found in Admin -> User & Roles. If not. the following queries can be used to create a new user role or it can be done in the Admin UI. 

  • Create a new role that will be used to manage these permissions.

CREATE ROLE new_role_name;
  • Assign the newly created role to users who require these permissions.
GRANT ROLE new_role_name TO USER syncariuser;
  • Grant usage on the schema, which allows the role to access the schema but does not permit viewing or manipulating data in its tables.
GRANT USAGE ON SCHEMA DATABASE.SCHEMA TO ROLE new_role_name;
  • Grant permissions for selecting, inserting, updating, and deleting data from all tables in the schema. This covers the full range of CRUD (create, read, update, delete) operations for existing tables.
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA DATABASE.SCHEMA TO ROLE new_role_name;

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. Enter [User Role]
  7. Click "Next"

Screenshot 2024-04-16 at 5.23.39 PM.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