Error on BigQuery Schema Generate using Simba JDBC Driver

Hey All,

I am trying to generate change log for bigquery, so i am trying to use simba JDBC driver to connect and generate, but getting below error,

----- ERROR STARTS -----
10:09:12.250 INFO [liquibase.database.core.UnsupportedDatabase]: Error getting default schema

liquibase.exception.DatabaseException: Error executing SQL call current_schema: [Simba]BigQueryJDBCDriver Error executing query job. Message: Encountered " "call β€œβ€ at line 1, column 1.
----- ERROR ENDS -----

Any thoughts?

1 Like

Hi @sriarun87 and welcome!

I am not sure that Liquibase does support Google BigQuery. The only reference I found was someone asking if there was a tool that could do manage the BQ schema changes.

But, if I look here at supported dbs:
https://www.liquibase.org/get-started/databases
I don’t see BigQuery supported.

If you would like to request that support you could log an issue or if you know java, you can submit a PR.

Thanks,

Ronak