Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev | vasudevpathak(*) |
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | DB - BigQuery |
| Version | 18.0 |
First, some background information:
- Refer to va:#2781. We were not able to support connecting to public projects directly due to limitation of the USE [publicdata] command.
- Refer to va:#3673. The INCLUDE_PUBLICDATA option in SHOW DATASETS hard-coded the public project ID as publicdata.
Recent upgrades of Google BigQuery have introduced new public projects. See attachment BigQueryConsole.png.
1. Using the latest BigQuery API, is there a way to query the list of public project IDs?
2. Does the latest BigQuery API allow us to enhance the USE command to work with public projects?
|
|
247 KB
|
|
44 KB
As per Google's documentation we can list only those projects which user have any granted role.
In screenshot, these are the public datasets which are hosted by Bigquery. Reference
Only the datasets are shared therefore user don't have any role granted on public projects. I don't found any API which lists the IDs of public projects.
Since BigQuery doesn't provide any API to query the list of public projects, we won't make any code changes.
To access public projects, go to the Advanced tab in the Server Properties dialog and enter a comma-separated list of public project IDs. The public projects will then appear in the schema browser.
See attachment PublicProjects.png.
Since BigQuery doesn't provide any API to query the list of public projects, we won't make any code changes.
To access public projects, go to the Advanced tab in the Server Properties dialog and enter a comma-separated list of public project IDs. The public projects will then appear in the schema browser.
See attachment PublicProjects.png.
Issue #14616 |
| Closed |
| Won't Fix |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
As per Google's documentation we can list only those projects which user have any granted role.
In screenshot, these are the public datasets which are hosted by Bigquery. Reference
Only the datasets are shared therefore user don't have any role granted on public projects. I don't found any API which lists the IDs of public projects.