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 2021/06/25 06:41:46 UTC
[GitHub] [superset] codegeekjk opened a new issue #15382: BigQuery Shared DataSets Schema is Not Showing in SQL Lab
codegeekjk opened a new issue #15382:
URL: https://github.com/apache/superset/issues/15382
A clear and concise description of what the bug is.
### Expected results
I have datasets belongs to some other GCP Project, which has been shared to our in house GCP Project, our service account has access to it.
We Created a connection to our GCP Project, which was successful and on SQL Lab we are able to run the queries to datasets belongs to other GCP PROJECT.
i.e select * from some_other_project.data_set.schema.
But in SQL LAB i.e in Schema and Table Drop Down those datasets are not visible.
How we can create a new data connection which can show us the schemas and tables belong to the other GCP PROJECT as our service account has access to it ?
From the logs it try to query this :
`"POST /bigquery/v2/projects/My_other_GCP Project/jobs` getting 403 None as we don't have job permission to that project
My Connection :
bigquery://MY_OTHER_GCP_PROJECT
Provided our service account json in extra parameters.
### Actual results
Able to connect to other shared GCP project using service account json which has access to the datasets.
--
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.
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
[GitHub] [superset] Guillaume-bytel commented on issue #15382: BigQuery Shared DataSets Schema is Not Showing in SQL Lab
Posted by GitBox <gi...@apache.org>.
Guillaume-bytel commented on issue #15382:
URL: https://github.com/apache/superset/issues/15382#issuecomment-1033738509
It's working with your trick but in this case Bigquery processing cost is apply on second projet.
It's also not possible to have sql query join data from multiple projets.
--
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
[GitHub] [superset] ad-m commented on issue #15382: BigQuery Shared DataSets Schema is Not Showing in SQL Lab
Posted by GitBox <gi...@apache.org>.
ad-m commented on issue #15382:
URL: https://github.com/apache/superset/issues/15382#issuecomment-1038617764
I would like to add that using shared datasets will allow easy try to use Superset, thanks to public datasets of BigQuery: https://cloud.google.com/bigquery/public-data
--
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
[GitHub] [superset] JianhaoZhang edited a comment on issue #15382: BigQuery Shared DataSets Schema is Not Showing in SQL Lab
Posted by GitBox <gi...@apache.org>.
JianhaoZhang edited a comment on issue #15382:
URL: https://github.com/apache/superset/issues/15382#issuecomment-947092796
We ran into a similar problem recently and found the root cause of it.
In your case, you should grant "bigquery.jobs.create" permission to "My_other_GCP Project" on the service account to avoid this error.
--
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
[GitHub] [superset] JianhaoZhang commented on issue #15382: BigQuery Shared DataSets Schema is Not Showing in SQL Lab
Posted by GitBox <gi...@apache.org>.
JianhaoZhang commented on issue #15382:
URL: https://github.com/apache/superset/issues/15382#issuecomment-947092796
We ran into a similar problem recently.
In your case, you should grant "bigquery.jobs.create" permission to "My_other_GCP Project" on the service account to avoid this error.
--
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