Skip to main content
Best answer

Network error when executing SQL in Snowflake


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?

 

Best answer by SamBBest answer by SamB

Hi there, ​@LucaP. Welcome to the Community! 🎉

I’ve seen cases of that error happening where the full Snowflake instance URL was entered instead of just the account name when connecting.

Can you try adding a new connection and make sure it’s just your Snowflake account’s name that’s added in the Account field:

33a905d8948b4bc9cef7383d7300b157.png

Keen to ensure this gets sorted so please keep us updated on how that goes! 🙂

View original
Did this topic help you find an answer to your question?

3 replies

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7472 replies
  • Answer
  • January 8, 2025

Hi there, ​@LucaP. Welcome to the Community! 🎉

I’ve seen cases of that error happening where the full Snowflake instance URL was entered instead of just the account name when connecting.

Can you try adding a new connection and make sure it’s just your Snowflake account’s name that’s added in the Account field:

33a905d8948b4bc9cef7383d7300b157.png

Keen to ensure this gets sorted so please keep us updated on how that goes! 🙂


  • Author
  • Beginner
  • 1 reply
  • January 8, 2025

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


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7472 replies
  • January 9, 2025

Yay! That’s great news ​@LucaP! 🎉 I’m so glad that did the trick, even though the connection seemingly shouldn’t succeed.

Please do reach back out if we can help with anything further at all. Until then, happy Zapping! 😁⚡