vladaman opened a new issue, #21934:
URL: https://github.com/apache/superset/issues/21934

   Importing dataset with Snowflake Account Usages causes multiple errors. Read 
more about read-only shared database named SNOWFLAKE 
https://docs.snowflake.com/en/sql-reference/account-usage.html
   
   1. Setup new Database Connection with URL: 
`snowflake://SUPERSET:[email protected]/snowflake?role=MY_ROLE&warehouse=MY_WAREHOUSE`
 (please note the showflake database name)
   2. Go to the SQL Lab and pick new Database connection, select schema 
`account_usage` and table schema `access_history`
   
   Instantly you get following error:
   
![image](https://user-images.githubusercontent.com/907206/197832575-b1596622-9bab-4f3c-a9c1-7339615fbcc1.png)
    
   ### Root cause
   Likely the issue is that the where warehouse is not selected. But snowflake 
doesn't allow you to execute `USE WAREHOUSE MY_WAREHOUSE` command in SQL Lab


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to