Problem
When attempting to query data from Snowflake, you may encounter the following error message:
“Cannot perform SELECT. This session does not have a current database. Call ‘USE DATABASE’, or use a qualified name.”
Solution
This issue could happen when your Snowflake user has a default role that does not have access to the tables you want to query. So make sure to assign a role to the Snowflake connection that has the necessary permissions to access the desired tables.
