Using Liquibase with Google BigQuery Platforms

Google BigQuery is a fully managed analytics data warehouse. For more information, see BigQuery Documentation.

Support for Google BigQuery is built into Liquibase Open Source and Liquibase Pro, so no additional download is needed.

Read more about Database DevOps with Liquibase and BigQuery.

Getting started tutorials

Features

The Google BigQuery Pro extension supports all the features of Liquibase that are supported by BigQuery in Liquibase Open Source. In addition, Google BigQuery Pro lets you use Liquibase Pro features including:

  • Policy Checks: automatically analyze your changelogs for desired format and behavior to increase deployment success rates and uphold security best practices
  • Secrets Management: keep your authentication data secure by integrating with third-party secrets vaults
  • Structured Logging: improve your database observability by easily reading Liquibase data in your favorite analytics tool
  • Operation Reports: generate reports of operations you perform on your database
  • Flow Files: create repeatable, portable, and platform-independent Liquibase workflows to run in any of your CI/CD tools
  • DATABASECHANGELOGHISTORY table (DBCLH): record a history of all changes you make to the database, including changes that are not tracked by the DATABASECHANGELOG table (DBCL)
  • Remote file access: centralize file management with AWS S3 to build a reusable repository of Liquibase files you can update and retrieve
  • Targeted rollback: avoid collateral damage by specifying which changesets in your changelog to undo
  • Stored Logic: capture stored logic objects like procedures, functions, packages, and triggers

Supported Change Types

Supported commands

Verified database versions

Google BigQuery Version Liquibase Compatible Version
2.13.6+ 4.29.0+

Related links