The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:
TypeScript analyticsbibusiness-intelligencebusinessintelligenceclojuredashboarddatadata-analysisdata-visualizationdatabasemetabasemysqlpostgrespostgresqlreportingslacksql-editorvisualization
# Test changelog for metabase.app-db.liquibase.rollback-test/rollback-reverses-reran-changesets-newer-than-the-target-test.
# `versioned-roc-run1.yaml` as shipped by 65.1: only the runOnChange view's SQL was edited in place, so Liquibase
# re-runs it (RERAN) and moves its changelog row into 65.1's deployment.
databaseChangeLog:
- logicalFilePath: migrations/065/versioned_roc.yaml
- changeSet:
id: v65.roc-table
author: test
comment: table of 65.0 (scenario test)
changes:
- createTable:
tableName: vroc_table
columns:
- column:
name: id
type: int
rollback:
- dropTable:
tableName: vroc_table
- changeSet:
id: v65.roc-column
author: test
comment: column of 65.0 that the view reads (scenario test)
changes:
- addColumn:
tableName: vroc_table
columns:
- column:
name: extra
type: int
rollback:
- dropColumn:
tableName: vroc_table
columnName: extra
- changeSet:
id: v65.roc-view
author: test
runOnChange: true
comment: runOnChange view over the 65.0 column (scenario test)
changes:
- sql:
sql: CREATE OR REPLACE VIEW v_vroc AS SELECT extra, 2 AS x FROM vroc_table
rollback:
- sql:
sql: DROP VIEW IF EXISTS v_vroc