Liquibase insert JSON data

Question

What is the best way to insert a big JSON data using Liquibase?

So I have a big JSON data that I need to insert the database using Liquibase, how can I achieve that? I make my changes using xml format.

loadData only supports csv file.

Answer 1

If you can convert json to csv, you can use change-set to import data from csv file.

    <changeSet id="1" author="author1">
        <loadData file="db/changelog/test.csv" separator=";" tableName="table-name">
        </loadData>
    </changeSet>