Liquibase Change Types for Databricks

You can use the following Change Types in the Liquibase extension for Databricks.

For more information about Databricks features, see Using Liquibase with Databricks Platforms. For a getting started tutorial, see Using Liquibase with Databricks SQL.

List of Change Types

Databricks-specific Change Types available in Liquibase Open Source and Liquibase Pro:

• alterCluster: alter a clustered table
• alterTableProperties: alter existing properties on a table
• alterViewProperties: alter existing properties on a view
• analyzeTable: analyze a table to improve query performance
• optimizeTable: optimize table layout to improve performance
• vacuumTable: remove unused files in a table directory

Liquibase Change Types that accept Databricks attributes or sub-tags:

• createTable: create a table 
  • Databricks sub-tag: extendedTableProperties: specify additional properties on a table, including clusters and partitions
• createView: create a view on a Databricks table
  • Databricks attribute: tblProperties: similar to extendedTableProperties, but for a view

Related links

• Databricks Documentation: SQL language reference
• Databricks REST API Reference