Hi, i tried to add Simba driver. It is working but queries are very slow. I do not know if this is because of Art tool or JDBC driver itself.
Another thing, i also tried to setup https://github.com/jonathanswenson/bqjdbc but not able to insert username in username field as it is more then 50 characters long. I did managed to resize username column in Art DB but again this driver is for some reason not connecting, even thouugh when i test connection it reports Connection succesfull.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
With the samba driver you can use it in any other reporting tool and see if there's a difference e.g the squirrel sql tool.
For the other driver, if there's an error you can post that.
I also tested simba driver on Dbeaver client and it works much faster. Is there possibility to see why Art is executing queries slowly with SImba drivers?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
A connection pool doesn't exist error typically means there was an error when the datasource was being created. I would suggest you re-save the datasource i.e. click on edit and then save and try to run the report again. If there is an error, you can check the details in the View | Logs page.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I just want to confirm that the driver work slow only in Art. I tried several version of the driver and it always take 5 second or more to show the result. Is there a possibility that there are some additional setup in Art itself in order that this work correctly?
In SQuirell client queries are returned after 2 seconds tops.
Regards,
Savo
Last edit: Savo 2020-11-10
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Noted about the driver from google being free. As far as I saw it's not available for redistributing so wouldn't be included in ART.
There is additional logic when running a query in art e.g. whether you have permission to run the report, formatting of column values etc that may not be done by squirrel or another client. Not sure it would account for the 3 seconds but I don't think there's too much that can be done about that.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
Is the Google BigQuery database supported as Datasource?
Regards,
Savo
There is no driver included for this, but if you can get a jdbc driver and include it in the WEB-INF\lib directory, you should be able to query.
This driver will be included in the next release.
Thanks Timothy! When can we expect new release of Art to be out?
Perhaps in a month's time.
Ok great!
Is it possible to use this JDBC driver if i put it in WEB-INF\lib?
https://www.simba.com/products/BigQuery/doc/JDBC_InstallGuide/content/jdbc/files.htm
It should be. I believe there's mention of a license so I'm not sure how that will affect the driver.
Hi, i tried to add Simba driver. It is working but queries are very slow. I do not know if this is because of Art tool or JDBC driver itself.
Another thing, i also tried to setup https://github.com/jonathanswenson/bqjdbc but not able to insert username in username field as it is more then 50 characters long. I did managed to resize username column in Art DB but again this driver is for some reason not connecting, even thouugh when i test connection it reports Connection succesfull.
With the samba driver you can use it in any other reporting tool and see if there's a difference e.g the squirrel sql tool.
For the other driver, if there's an error you can post that.
I also tested simba driver on Dbeaver client and it works much faster. Is there possibility to see why Art is executing queries slowly with SImba drivers?
Are you allowed to post the driver here? Or provide the download link to the driver.
Last version of driver
https://storage.googleapis.com/simba-bq-release/jdbc/SimbaJDBCDriverforGoogleBigQuery42_1.2.11.1014.zip - this version works slow in Art
Older version
https://storage.googleapis.com/simba-bq-release/jdbc/SimbaJDBCDriverforGoogleBigQuery42_1.2.4.1007.zip -- This version is working in Dbeaver much faster. I will test it also in Art
Ther error for other driver is when running report:
Connection pool doesn't exist for datasource id 19
But when connection is tested there are no errors - it said Connection succesfull
Just to confirm that i tested the older version of Simba driver and it works faster then the new one. I tested on squirrel sql tool.
New Simba driver:
select 1; query runs 6 seconds
Old Simba Driver:
Select 1; query runs 1.5 seconds
Also tested starschema jdbc driver on Squirell and it runs more then 20 seconds and finishes with error exception :-(
Last edit: Savo 2020-10-29
So I guess the issue is with the driver, or perhaps changes on google cloud in the way connections are made.
For the starschema driver, you can check from the ART logs page and see details of any exception that is there and post here.
Hi,
For startschema Ther error for other driver is when running report:
Connection pool doesn't exist for datasource id 19
But when datasource/connection is tested there are no errors - it said Connection succesfull
A connection pool doesn't exist error typically means there was an error when the datasource was being created. I would suggest you re-save the datasource i.e. click on edit and then save and try to run the report again. If there is an error, you can check the details in the View | Logs page.
Hi,
Just an quick update on Simba drivers. They are actually free and can be downloaded directly from Google https://storage.googleapis.com/simba-bq-release/jdbc/SimbaJDBCDriverforGoogleBigQuery42_1.2.11.1014.zip
I just want to confirm that the driver work slow only in Art. I tried several version of the driver and it always take 5 second or more to show the result. Is there a possibility that there are some additional setup in Art itself in order that this work correctly?
In SQuirell client queries are returned after 2 seconds tops.
Regards,
Savo
Last edit: Savo 2020-11-10
Noted about the driver from google being free. As far as I saw it's not available for redistributing so wouldn't be included in ART.
There is additional logic when running a query in art e.g. whether you have permission to run the report, formatting of column values etc that may not be done by squirrel or another client. Not sure it would account for the 3 seconds but I don't think there's too much that can be done about that.
OK thanks Timothy!