× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
anilkalshetti reported 2015-04-10T09:10:12Z  · tariqrahiman last modified 2015-07-24T04:09:12Z

Google BigQuery - Datasets are not listed properly for some Projects in ADS Schema tree node


Dev
Jenny Nishimura
JennyNishimura
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component App - General
Version 17.0

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.

Please refer the attached screenshot- BigQuery_ADS-OtherSQL-Tool.png
Please refer screenshot : bigQuery-WebUI.png , for comparing this with bigQuery Web Interface.
2 attachments

Issue #13231

Closed
Won't Fix
Resolved 2015-07-23T21:51:12Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017