Issues creating report on Google BigQuery Data Source (v9.16)
Hi Fishies,
We have an upcoming PoC with a client wanting to use Yellowfin to report on their Google BigQuery data source.
Background: Getting the connection to work was a bit painful, it's not just a case of loading the jar file via the Data Source connection window. There are 68 jar files involved, far too many to upload one by one. I got the data source connection working using the Generic JDBC driver option.
Issue: When creating a report, adding any column triggers the [/ReportDataAjax.i4] ErrorAction entered. Oddly, if you cancel the refresh and edit the view, change nothing but publish it again, the column values appear. When you add another column, the same issue persists but you can just cancel the operation and enter the Design screen to make the new column values appear.
I have attached clean Yellowfin & Catalina output files, covering the session from Yellowfin startup.
There is a screen recording available here.
| System Information | |
| Application Version: | 9.16.0 |
| Build: | 20250806 |
| Java Version: | 17.0.17 |
| Operating System: | Linux 6.14.0-1014-aws (amd64) |
The same problem 
Hi Lex,
I hope you're doing well.
The generic JDBC driver is not recommended for BigQuery, you are likely to encounter issues when using it.
There are a large number of dependency JAR files when using the Simba BigQuery driver, so the easiest way to upload these is to use Yellowfin's plugin management screen. Extract all the .jar files from the download to a new folder, then ZIP up that folder and rename the extension to .yfp. You can then upload them all in one go to the Plugin Manager.
Alternatively, Google has a pre-release one file JDBC BigQuery driver, but that might not be as reliable.
You may also need to use Java 21 as Java 17 gives a warning about missing classes when using the Simba driver.
Kind regards,
Chris
Hi Lex,
I hope you're doing well.
The generic JDBC driver is not recommended for BigQuery, you are likely to encounter issues when using it.
There are a large number of dependency JAR files when using the Simba BigQuery driver, so the easiest way to upload these is to use Yellowfin's plugin management screen. Extract all the .jar files from the download to a new folder, then ZIP up that folder and rename the extension to .yfp. You can then upload them all in one go to the Plugin Manager.
Alternatively, Google has a pre-release one file JDBC BigQuery driver, but that might not be as reliable.
You may also need to use Java 21 as Java 17 gives a warning about missing classes when using the Simba driver.
Kind regards,
Chris
Hi Chris,
Thanks for the info, and the quick response.
I'm getting a version of 9.16.1.1 installed on Java 21 as we speak. I'll try the yfp extension approach and get back to you.
Hi Chris,
Thanks for the info, and the quick response.
I'm getting a version of 9.16.1.1 installed on Java 21 as we speak. I'll try the yfp extension approach and get back to you.
Hi Lex,
No worries. Let me know how it goes!
Kind regards,
Chris
Hi Lex,
No worries. Let me know how it goes!
Kind regards,
Chris
Hi Chris,
That worked a treat. Thanks for the pointer.
Hi Chris,
That worked a treat. Thanks for the pointer.
Hi Lex,
That's great! No problem. Let me know if there's anything else, otherwise I think we can close this off!
Kind regards,
Chris
Hi Lex,
That's great! No problem. Let me know if there's anything else, otherwise I think we can close this off!
Kind regards,
Chris
Hi Lex,
I hope you're doing well.
Just to let you know I'm marking this ticket as resolved. If you have any other questions, please contact us again by opening up a new ticket and we will provide additional support.
You should also receive a very quick survey to evaluate our support. I would be very grateful if you could hit us with a Satisfied on that survey. It really helps both me and the team.
Many thanks,
Chris
Hi Lex,
I hope you're doing well.
Just to let you know I'm marking this ticket as resolved. If you have any other questions, please contact us again by opening up a new ticket and we will provide additional support.
You should also receive a very quick survey to evaluate our support. I would be very grateful if you could hit us with a Satisfied on that survey. It really helps both me and the team.
Many thanks,
Chris
Replies have been locked on this page!