Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

We are encountering issues when attempting to write data to Snowflake.

For more context, we are attempting to write data to Snowflake via Zapier in a Granola “Note Added to Folder” → “Snowflake: Create Rows” flow. The Granola trigger appears to be functioning as expected, but the Snowflake action fails during testing.
 

Workflow Context

  • Trigger: Granola (Note Added to Folder - seems fine)

  • Action: Snowflake (Create Rows)

  • Auth Method: Key-Pair (RSA) Authentication

Screenshots below:

  1. Snowflake Key-Pair Auth setup screen in Zapier (method we are using)

  2. Zapier workflow showing Granola trigger and Snowflake action

  3. Error message from Zapier connection test
     

Steps Taken So Far

  1. Verified that the Zapier Snowflake connection setup passes the initial validation.

  2. Confirmed username, private key format, and PEM/PKCS8 requirements per Snowflake documentation.

  3. Attempted test run in Zapier → setup step passes, but table selection fails (“table is not accessible”).

  4. On explicit connection test, we receive the following error: “Snowflake is expired
    Unexpected token 'A', "An error o"... is not valid JSON”

Observations

  • The Granola portion of the workflow does not seem related to the failure.

  • Zapier reports the connection is OK at setup, but subsequent actions cannot retrieve tables or insert rows.

  • The returned error from Snowflake is malformed JSON, which may indicate an issue on Snowflake’s side or with how Zapier is handling the response.

  • This could also be tied to authentication token/session expiry during the test step.

Request for Support

We need assistance to:

  1. Identify why the Snowflake connection passes initial validation but fails when retrieving tables.

  2. Determine if this is due to:

    • Snowflake session expiry during the Zapier test

    • Incorrect key formatting or encryption method

    • Permission/role issues for the Snowflake user in question

    • Zapier handling/mapping error for Snowflake responses

  3. Provide any steps we can take to mitigate or confirm the source of the malformed JSON error.

Thanks to anyone who can help!

 

Hi ​@Jean at Renegade 

Help links for using Snowflake in Zaps: https://zapier.com/apps/snowflake/integrations#help

 

Make sure you are inputting the correct values as expected without any leading/trailing whitespace around the values.

 

How to get started with Snowflake on Zapier

Updated 4 months ago
 

Connect to Snowflake on Zapier

Snowflake uses OAuth to authenticate your account on Zapier. 

  • Log into Snowflake to authenticate.
  • Grant Zapier permission to access your account if prompted to.

Required fields

  • Account
  • Client ID
  • Client Secret

Optional fields

  • MFA Token
  • Role
  • Database
  • Warehouse
  • Schema

About Snowflake Computing's app

Are self-hosted or cloud-hosted accounts supported? Cloud-hosted accounts only
Is a paid Snowflake Computing plan required? No
  • View Snowflake's plans.
Are any special account permissions required? Yes
  • You must have access control to use Snowflake on Zapier.
  • If you have MFA enabled, you will need to provide the MFA token from the Duo app.
  • Learn more about Snowflake's account permissions.
Are there usage limits? Yes
Are there pagination limits? No
  • Snowflake does not have a pagination limit but there is a 30-second limit for queries to run.
Do trigger samples use real data from your account or generic data? Real trigger samples  
Are custom fields supported? Yes  
Do update actions overwrite or append to existing data? Not applicable  
Is there any additional info? Yes

Thank you - we will try this and get back ASAP if it solves the issue for us

Terms & ConditionsAccessibility statement