Lucee JDBC Connection to Google BigQuery

Hi All,
Been trying to use the Simba JDBC driver to Connect Lucee 5.2 RC to Google BigQuery

This is mainly to run select queries against large datasets for Analysis.

  1. Can this be done with Lucee ?
  2. Has anyone been able to successfully accomplish this ? If So Any insights would be great?

I am trying to create the datasource using the “Other - JDBC Driver”.

I have Tried the OAuth method and Service account method with no success.

Thank you in advance for any feedback / help.