You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2022/10/25 16:58:07 UTC
[GitHub] [superset] vladaman opened a new issue, #21934: Unable to query Snowflake Account Usage from Superset
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:XXXXXXXXXX@dr123456.eu-west-2.aws/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:
### 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: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Unable to query Snowflake Account Usage from Superset [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #21934:
URL: https://github.com/apache/superset/issues/21934#issuecomment-1939775602
Closing this as stale since it's been silent for so long, and we're trying to steer toward a more actionable Issues backlog. If people are still encountering this in current versions (currently 3.x) please open a new Issue or a PR to address the problem.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Unable to query Snowflake Account Usage from Superset [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #21934: Unable to query Snowflake Account Usage from Superset
URL: https://github.com/apache/superset/issues/21934
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org