Liquibase Generate CSV for Change Types LoadData

Liquibase allows to loading of records into a table from CSV files, Liquibase also allows to create CSV files from the existing database records.

Along with the CSV file from the Liquibase Generates a ChangeLog file with metadata of tables as well.

liquibase.properties (update changeLog File file format with SQL, XML, YAML, JSON as per changelog.mysql.)

changeLogFile=changelog.mysql.xml
liquibase.command.url:jdbc:mysql://localhost:3306/appleDb?createDatabaseIfNotExist=true&autoReconnect=true&useSSL=false&allowPublicKeyRetrieval=true
liquibase.command.username : root
liquibase.command.password : rootroot
dataOutputDirectory:csvData

Run command liquibase generate-changelog