How to resolve ‘Cannot Perform SELECT’ Error in Snowflake


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.”


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.