How to connect Big Query with python using pyreportjasper

Question

i am using the configuration as follow

{
'driver': 'generic',
'jdbc_url': 'jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId={project_id};OAuthType=0;OAuthServiceAcctEmail={email};OAuthPvtKeyPath={path_to_p12_file};',
'jdbc_driver': 'com.simba.googlebigquery.jdbc.Driver',
'jdbc_dir': path_to_all_jdbc_jar_dir,
}

All the required jar files are in the path_to_all_jdbc_jar_dir I can successfully connect to Jasper studio and dbeaver using similar configuration and it works. Not sure if the pyreportjasper https://github.com/acesseonline/pyreportjasper support connection to big query

However i ended up getting this error `NameError: Error fill report: Erro fill internal: java.lang.ClassNotFoundException: com.simba.googlebigquery.jdbc.Driver Anyone know what could possibly wrong here. Thanks alot

I am using the jdbc driver below from https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers

SimbaJDBCDriverforGoogleBigQuery42_1.2.21.1025

Java version:

java version "11" 2018-09-25
Java(TM) SE Runtime Environment 18.9 (build 11+28)
Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11+28, mixed mode

How to connect Big Query with python using pyreportjasper

0 Answers0