To use Liquibase and Teradata, you need two JAR files:

• The Teradata JDBC driver

• The Liquibase extension for Teradata

To use Liquibase with Maven, you must instead include the driver JAR as a dependency in your pom.xml file. Using this information, Maven automatically downloads the driver JAR from Maven Central when you build your project.

• Ensure your Teradata database is configured. See Teradata Quickstarts for more information.

• Specify the database URL in the liquibase.properties file (defaults file), along with other properties you want to set a default value for. Liquibase does not parse the URL. You can either specify the full database connection string or specify the URL using your database's standard JDBC format: url: jdbc:teradata://hostname/DATABASE=myDatabase

1. Create a text file called changelog ( .xml, .sql, .json, or.yaml) in your project directory and add a changeset.

2. If you have already created a changelog using the init project command, you can use that instead of creating a new file. When adding to an existing changelog, be sure to add only the changeset, not duplicate the changelog header.

Navigate to your project folder in the CLI and run the Liquibase status command to see whether the connection is successful:

liquibase status --username=test --password=test --changelog-file=<your-changelog.xml>

Note: You can specify arguments in the CLI or keep them in the Liquibase properties file.

If your connection is successful, you'll see a message like this:

4 changesets have not been applied to <your_jdbc_url> Liquibase command 'status' was executed successfully.

Inspect the SQL with the update-sql command. Then make changes to your database with the update command.

liquibase update-sql --changelog-file=<changelog.xml> liquibase update --changelog-file=<changelog.xml>

If your update is successful, Liquibase runs each changeset and displays a summary message ending with:

Liquibase: Update has been successful.

From a database UI tool, ensure that your database contains the test_table you added along with the DATABASECHANGELOG table and DATABASECHANGELOGLOCK table.