Oss 4.33: Use UUID and load data

Use UUID and load data

Last updated: November 18, 2025

Liquibase uses Universally Unique Identifiers (UUID)s to define tables so they are more easily searchable.

Procedure

Define a table

Results

Tables are created by Liquibase successfully (changesets 1 and 2)
Liquibase inserts the data into that table (project_objectives).
Liquibase also supports adding UUIDs to the database successfully.

<?xml version="1.0" encoding="utf-8"?>
<databaseChangeLog
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
    xmlns:pro="http://www.liquibase.org/xml/ns/pro"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/dbchangelog-ext
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd
        http://www.liquibase.org/xml/ns/pro
        http://www.liquibase.org/xml/ns/pro/liquibase-pro-latest.xsd">
	<changeSet id="1" author="mike">
		<createTable tableName="project">
			<column name="id" type="uuid">
				<constraints primaryKey="true" nullable="false"/>
			</column>
		</createTable>
	</changeSet>
	<changeSet id="2" author="mike">
		<createTable tableName="project_objectives">
			<column name="objectives_id" type="uuid">
				<constraints nullable="false"/>
			</column>
			<column name="project_id" type="uuid">
				<constraints nullable="false"/>
			</column>
		</createTable>
		<addPrimaryKey columnNames="project_id, objectives_id" tableName="project_objectives"/>
	</changeSet>
	<changeSet id="2-data" author="mike" context="test">
		<loadData
				file="test-data/project_objectives.csv"
				separator=";"
				tableName="project_objectives">
			<column name="objectives_id" type="uuid"/>
			<column name="project_id" type="uuid"/>
		</loadData>
	</changeSet>
</databaseChangeLog>

Add a CSV for Liquibase to insert

Add a CSV for Liquibase to insert with the same name as the loadData file above. In this exmple, it is project_objectives.csv in the test-data folder:

CSV to insert

objectives_id;project_id			
8d1208fc-f401-496c-9cb8-483fef121234;ea5bc0ab-6ccf-4791-a048-694a5be1d309
8d1208fc-f401-496c-9cb8-483fef121234;1a8aebee-2061-4220-99ce-ddaf2b22d23f
cce54793-00b8-4830-8f3c-e4cb97b8fb70;1bc59ddb-8d4d-41d0-9c9a-34e837de5678
234c2416-e7f2-47bf-afdc-03645b3a98ab;1bc59ddb-8d4d-41d0-9c9a-34e837de5678
234c2416-e7f2-47bf-afdc-03645b3a98ab;1482cc79-fd01-42e4-b5a1-a7f0db546d00
12349c78-454a-4167-9a1e-8e853a4cf2f5;072e217f-76b3-4cae-b3bd-f7c71a8e0003
1234bf02-0ffa-4b52-b22f-a10e76e31cb5;98f275cd-934d-42cd-91e4-fa0acd7dc5eb
e6b920b7-4ac4-4b62-aea7-36f75e3ad610;dddd728e-fd2c-4a1c-8a10-ffd84ed1603c
ef8614c9-f4d7-4b56-9aaa-088cbe9f7e71;dddd728e-fd2c-4a1c-8a10-ffd84ed1603c
678abcde-898a-4cd9-8aae-99a1943b2ebf;dddd728e-fd2c-4a1c-8a10-ffd84ed1603c

Run liquibase update to create the table and insert the data.

Results

Tables are created by Liquibase successfully (changesets 1 and 2)
Liquibase inserts the data into that table (project_objectives).
Liquibase also supports adding UUIDs to the database successfully.