New! – Spin up instant copies of your dev databases in the cloud for free Learn more

Flyway Documentation

Poll

Google BigQuery

Supported Versions

  • Latest

Support Level

Compatible
Certified ⏳ Pending certification
Guaranteed

Support Level determines the degree of support available for this database (learn more).

Driver

URL format jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=project_id;OAuthType=0;OAuthServiceAcctEmail=service_account_name;OAuthPvtKeyPath=path_to_key;
SSL support No
Ships with Flyway Command-line No
Maven Central coordinates None. The Simba driver is available for download here
Supported versions -
Default Java class com.simba.googlebigquery.jdbc42.Driver

Flyway Teams Features for BigQuery

GCP BigQuery can suffer from performance issues while executing schema changes.

Flyway Teams edition solves this via batching which combines schema changes to reduce the network overhead and improves performance.

To find out more about Flyway Teams click here.

Using Flyway with Google BigQuery

Google BigQuery is in the process of being certified. The process of certification involves getting real world usage feedback from beta users.

If you’d like to use Google BigQuery and you are happy to provide feedback as we build support for this database, please complete the form below to get access to the getting started documentation

Limitations

While the Simba JDBC driver supports a number of different modes for authentication, Google User Account authentication (that is, OAuthType=1) is not recommended for desktop use and is not supported at all for unattended use, or use in Docker, as it requires a browser to be available to get an access token interactively.