Visual Code – Snowflake Error: You don’t have any connection

Did you receive an error trying to execute a SQL on Snowflake from Visual Code?

Error: you don’t have any connection, even though you clearly see the extension has connection established, and you are able to see the objects, and query history in your side bar.

The reason is – that you are trying to execute a sql, that is in a .sql file extension or SQL type category in Code, instead of ‘Snowflake SQL’ type.

Make sure you change the file type in the lower right corner of the Code IDE, and you should be able to execute the query.

Hope this helps 😉