Snowflake integration

Snowflake is a cloud data platform that enables organizations to store, analyze, and share data securely.

With this integration, you can connect to your Snowflake data warehouse and import data directly into Clay.

Creating a table with Snowflake

1. In a workbook, click + Add at the bottom.
2. Search for Snowflake and select from the results.
3. In the modal, you will be asked to Select Snowflake account.
   • If you haven't already connected your Snowflake account, click + Add account and go through authentication.
   • If your organization uses Okta, enter your Okta URL (e.g., example.okta.com) to ensure the integration functions correctly.

Source Import from Snowflake

You can use Snowflake as a source for a new or existing table.

Inputs

• Snowflake Account ID
• Database Name
• Schema
• Table Name
• Snowflake Warehouse
• Role (Optional)

Enriching data with Snowflake

1. While in a Clay table, click Add enrichment and search for Snowflake.
2. Under Integrations, select one of the Snowflake options.
3. In the modal, you will be asked to Select Snowflake account.
   • If you haven't already connected your Snowflake account, click + Add account and go through authentication.
   • If your organization uses Okta, enter your Okta URL (e.g., example.okta.com) to ensure the integration functions correctly.

Action Insert Row

Insert a row into a Snowflake database.

Inputs

• Snowflake Account ID
• Database Name
• Schema
• Table Name
• Snowflake Warehouse
• Role (Optional)

Action Lookup Row

Check if row exists in your Snowflake database.

Inputs

• Snowflake Account ID
• Database Name
• Schema
• Snowflake Warehouse (Optional)
• Role (Optional)
• Query: The Raw SELECT SQL Query to run.

Action Upsert Row

Upsert row into Snowflake Database using a single field as a unique identifier. If the identifier exists, we'll update the row. If not, we'll create a new row.

Inputs

• Snowflake Account ID
• Database Name
• Schema
• Table Name
• Snowflake Warehouse
• Role (Optional)

Action Update Row

Upsert row into Snowflake Database using a single field as a unique identifier. If the identifier exists, we'll update the row. If not, we'll create a new row.

Inputs

• Snowflake Account ID
• Database Name
• Schema
• Table Name
• Snowflake Warehouse
• Role (Optional)

Run settings

• Auto-update
• Only run if: The enrichment will only run if conditions are met. (Learn more about conditional formulas here!)