Snowflake and Zapier connect to automate your data warehouse workflows. You can trigger Zaps when rows are created or updated, execute SQL commands, and sync data across your apps.
Prerequisites
To use the Snowflake integration on Zapier, you must have:
- A Snowflake cloud-hosted account. Self-hosted accounts are not supported.
- Access control permissions in Snowflake.
- Your Snowflake account identifier, Client ID, and Client Secret.
Find your Snowflake credentials
To connect Snowflake to Zapier, you'll need your:
-
Account identifier: Your Snowflake account identifier, which typically includes your organization and account name (for example,
xy12345.us-east-1). - Client ID and Client Secret: To create OAuth credentials, refer to Snowflake's OAuth documentation.
Optional: MFA token
If you have multi-factor authentication (MFA) enabled on your Snowflake account, you'll need to provide the MFA token from your authenticator app (such as Duo) when connecting. Learn more about setting up MFA in Snowflake.
Connect Snowflake to Zapier
To create an app connection to Snowflake on Zapier:
- Go to the Apps page.
- Click + Add connection.
- A new dialog box will appear. Search for and select Snowflake.
- Click Add connection.
- A Connect an Account page will open in a browser tab or window.
- Complete the following required fields:
- Account: Enter your Snowflake account identifier.
- Client ID: Enter your OAuth Client ID.
- Client Secret: Enter your OAuth Client Secret.
- (Optional) Complete the following optional fields:
- MFA Token: Enter your MFA token if you have multi-factor authentication enabled.
- Role: Enter a specific role to use for the connection.
- Database: Enter a default database.
- Warehouse: Enter a default warehouse.
- Schema: Enter a default schema.
- Click Yes, Continue to Snowflake.
Your Snowflake account is now successfully connected to Zapier.
Tip
For Zapier Team or Enterprise users, you can use a static IP address to connect to Zapier.
About Snowflake's app
Triggers, searches, and actions
Triggers
- New or Updated Row: Triggers when a row is created or updated in a selected table.
- New Column: Triggers when a new column is created on a selected table.
Searches
- No search actions are available for Snowflake.
Actions
- Execute SQL Command: Run custom SQL queries for data management.
- API Request (Beta): This is an advanced action that makes a raw HTTP request with Snowflake authentication.
Limitations
- Snowflake queries have a 30-second time limit to complete.
- If you receive a
{"message":"Failed: Numeric value '1,2,3' is not recognized"}error, your data may be comma-separated. Check your data formats as line items. - Learn more about Snowflake error messages.
Templates
View all of Snowflake's templates.