Snowflake Connection Database error

[aditichowbey]

I am trying to query data from Snowflake and the data is pulled successfully and can be seen in the preview in when I am in the Query Editor. When I try to 'Apply changes', there is an error message: "This session does not have a current database" but the database field was inputted when I enter the required fields for the query. I have attached a screenshot. Any advice will be appreciated!

[SeanM77]

For me this is a random but frequent occurance.  If I just try a few times it eventually works without changing anything in the query.

[Vijay_A_Verma · Accepted solution]

Did you input any SQL query? if yes, then that query has to have fully qualified table name like DATABASENAME.SCHEMANAME.TABLENAME.