Build: ADS 17.0.0-dev-14
ADS 16.0.3-11
Database: Google BigQuery
Connection: Generic JDBC
OS: Ubuntu 14.04 LTS
Drivers: bqjdbc-1.4.jar [6.8 MB]
bqjdbc-1.4-standalone.jar [460.3 kB] - Ref. Link
Issue: Datasets are not listed properly for some Projects
and Tables of different Dataset are listed under single Dataset
Steps to reproduce Issue:
1. Copy the drivers under directory /datastudio/lib/drivers
2. Register GoogleBigQuery in ADS using Generic JDBC, using below credentials.
ADS Register Server window: Select Generic JDBC
Name: GoogleBigQuery2
Login Name: ##
Password: ##
URL: jdbc:BQDriver:projectid(urlencoded)?withServiceAccount=false
Driver: net.starschema.clouddb.jdbc.BQDriver
Driver Location: /datastudio/lib/drivers/bqjdbc-1.4.jar
## - Enter Login Name and Password
3. In Schema tree node, Expand the Database server node, It will list Projects.
4. Expand Project node, It should list Datasets.
For some Project, it doesn't list Dataset. It display 'DEFAULT' as dataset.
Though there are multiple Datasets, all the Tables of this different Dataset are listed under 'DEFAULT' Dataset.
Expected: All Datasets should be listed. Tables should be listed under respective Dataset.
Information:
I have compared this with other SQL tool.
Other SQL tool is also connected with same credentials as Generic JDBC connection with same drivers.
The tool don't provide native support for this database.
|
279 KB
|
95 KB
Issue #13231 |
Closed |
Won't Fix |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
In ADS 17.0.0-dev-87, we now have native BigQuery support. We won't fix any problem with using BigQuery as a Generic JDBC connection.