Network error when executing SQL in Snowflake

Question

I would like to Execute some SQL in Snowflake. More specifically I would like to run a procédure with a query of the “CALL MY_PROCEDURE(bla)” type.

I used a “Execute SQL” step and I can connect to Snowlflake. The connection test succeeds (see below).

On the other hand when I test the step it fails with a Network error (see below). N.B.: We do not have any rules restricting IPs.

The query is supersimple and I trie with and without absolute path to the object with the same result.

I also tried to launch the query with the same user directly on Snowflake and it succeeds.

Any clue?

SamB · Accepted Answer

Hi there, ​@LucaP. Welcome to the Community! 🎉I’ve seencases of that error happening wherethefullSnowflake instance URLwas entered instead of just the account name when connecting.Can you try adding a new connection and make sure it’s just your Snowflakeaccount’s name that’s added in the Account field:Keen to ensure this gets sorted so please keep us updated on how that goes!🙂

LucaP · Answer

It works thanks! The wired thing is that the connection shouldn’t succeed…Anyway thanks it works now!

Reply

Useful links

Code of conduct

Using the Community

Community expectations

Reply

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded