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
- Using Liquibase with Google BigQuery Pro: configure the Liquibase Pro extension for Google BigQuery and access all Liquibase Pro features
- Using Liquibase with Google BigQuery Open Source: configure Liquibase Open Source to work with Google BigQuery
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:
- Quality 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
addColumn
addForeignKeyConstraint
addLookupTable
addPrimaryKey
createFunction
createProcedure
createTable
createView
delete
dropAllForeignKeyConstraints
dropColumn
dropForeignKeyConstraint
dropFunction
dropPrimaryKey
dropProcedure
dropTable
dropView
insert
loadData
loadUpdateData
mergeColumns
modifyDataType
modifySql
renameColumn
renameTable
sql
sqlFile
Supported commands
- Update Commands
- Rollback Commands
- Init Commands
- Change Tracking Commands
- Database Inspection Commands
- Utility Commands
- Flow Commands
- Quality Checks Commands
Verified database versions
Google BigQuery Version | Liquibase Compatible Version |
---|---|
2.13.6+ | 4.29.0+ |