An Overview of Unito's Snowflake Integration

Ready to start syncing records from Snowflake to your other tools? Here's all you need to know.

What does this article cover?

• What does Unito sync from Snowflake?
• Which fields can Unito sync?
• How do I connect Snowflake to Unito?
• Limitations and other considerations

What does Unito sync from Snowflake?

Unito syncs records from your Snowflake tables to other tools in one direction. After choosing the table you want to sync from, you'll need to select a Database and Schema to sync data from. Here's what that looks like in Unito.

Once you've chosen these, Unito can map Snowflake fields with fields in other tools. Here's an example of Snowflake fields mapped with columns in Google Sheets.

Here's an example of Snowflake records synced to Google Sheets with Unito

Which Snowflake fields can Unito sync?

Much like spreadsheet tool integrations, Unito can sync all records from your Snowflake tables, mapping columns to fields in other tools. Records are synced as individual work items. So if you sync a Snowflake table with a Google Sheets spreadsheet, each record will become a row, populated with the information in each column.

What counts as an item in sync?

For Snowflake, Unito counts every synced row as an item in sync.

How do I connect Snowflake to Unito?

To connect Snowflake to Unito, you'll need your Dedicated Login URL, which contains a unique account identifier, as well as your Snowflake username and password. 

In this example, the dedicated login URL is: https://ttohsre.gs90210.snowflakecomputing.com

Here's how to find your Dedicated Login URL for Snowflake:

1. While logged in to Snowflake, click on Accounts in the left-hand menu.
2. Click on the ellipsis (...) on the right-most column of the account you wish to connect.
3. Select Manage URLs. 
4. Under Current URL click the link icon beside the URL that matches your account information to copy it.

Limitations and other considerations

Expect this integration to always be expanding with new features, fields, and use cases. For now, here are some limitations you should be aware of.

• One-way flows: Any flow with Snowflake will only sync records out of Snowflake and to other tools. Two-way flows aren't currently supported for this integration.
• Number of records synced: Each Unito flow can only sync up to 10,000 rows.
• Live sync: Because this integration doesn't support webhooks, live sync isn't supported. Unito will only sync changes every five minutes.
• Historical data: Unito's default rules will automatically sync all historical Snowflake records. You can add a rule to determine a desired data set instead.
• Table selection: Unito can only sync tables that have a primary key set. If you can't find the table you're trying to sync when building your flow, it may be because you haven't set a primary key for it.