Flyway Snapshot History Table Setting

{% include enterprise.html %}

Description

The name of the Flyway snapshot history table in which to store snapshots, e.g. for drift detection.

By default the snapshot history table is placed in the default schema for the connection provided by the datasource. When the defaultSchema or schemas property is set, the snapshot history table is placed in the specified default schema.

For more information on the concept of the snapshot history table, see Snapshots.

Default

"flyway_snapshot_history"

Usage

Flyway Desktop

This can't be added to a configuration file via Flyway Desktop.

Command-line

./flyway snapshot -historyTable=flyway_snapshot_history

TOML Configuration File

[flyway.snapshot]
historyTable = "flyway_snapshot_history"

Configuration File

flyway.snapshot.historyTable=flyway_snapshot_history

Environment Variable

Not available