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.

Hi,

I’m trying to set up a trigger with Snowflake to detect new or updated rows. The connection works and I can see the tables that are available in my schema, but when I select one, there are no columns retrieved. Doesn’t matter which table I choose, it happens with them all. 

 

The account I’m using has the same role as the user that created both the schema and the table, and that role has ownership of both, so I don’t think it’s an issue with permissions.

Any ideas?

Hi @PilarFH 

Help article to reference for possible guidance about using Snowflake in Zaps: https://help.zapier.com/hc/en-us/articles/13872142076173-How-to-get-started-with-Snowflake-on-Zapier

 

Connect to Snowflake on Zapier

Snowflake uses basic authentication to authenticate your account on Zapier. Enter your Snowflake username and password to authenticate. 

About Snowflake Computing's app

Are self-hosted or cloud-hosted accounts supported? Cloud-hosted accounts only We don't support accounts connected using SAML SSO. Users will need to provide us a username and password. Learn more about Snowflake's supported accounts.
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.

Learn more about Snowflake's account permissions.
Are there usage limits? Yes Learn more about Snowflake's usage limits.
Are there pagination limits? No We don't have a pagination limit but we have 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
Learn more about Snowflake's custom fields.
Do update actions overwrite or append to existing data? Not applicable  
Is there any additional info? Yes

Yes, I already checked that out. We have managed to make it work with an account that has an AccountAdmin role, which shouldn’t be the case since the account we created for the zap should work with the role it has (ownership of the schema and table).

Hi @PilarFH,

 

Did you manage to fix your issue already?

I'm running into the same problem.

Hi @ffm online marketing,

I believe @PilarFH managed to fixed the issue by using an account with an “AccountAdmin” role.

Hopefully, this helps!

Hi @ken.a,

Thanks for your reply.

Our Tech team is very strict with assigning AccountAdmin roles in Snowflake. Therefore it is not an option to fix this issue via your suggested fix. Would you happen to know an alternative solution?

 

Best,

Mart

Hi @ffm online marketing,

Unfortunately, there are no alternative way about this, but to have an AccountAdmin role in Snowflake. This role is vital to create an API integration according to Snowflake here: https://docs.snowflake.com/en/sql-reference/external-functions-security#api-integrations

Hopefully, this helps!

Reply


Terms & Conditions