How can I use SnowSQL to test my Snowflake connection before using it in Power BI?

Responsive Ad Header

Question

Grade: Education Subject: Support
How can I use SnowSQL to test my Snowflake connection before using it in Power BI?
Asked by:
82 Viewed 82 Answers

Answer (82)

Best Answer
(458)
SnowSQL is a command-line client for Snowflake that allows you to test your connection directly. You can use the `snowsql` command to connect to your Snowflake instance and execute SQL queries. If you can successfully connect and run queries using SnowSQL, it indicates that the basic connection to Snowflake is working, making it more likely that the HY000 error in Power BI is due to a Power BI-specific configuration issue. This helps isolate the problem.