Valid format for Array<String> in loading CSV data

[vedantsali]

Is there a valid format for loading data using csv file is one of the column is array of strings

listId;listName;applicationName;isActive;description;type;createdBy;createdOn;updatedBy;updatedOn
10;Timezone;[xyz];true;Global Timezones;;SYSTEM;PENDING_COMMIT_TIMESTAMP();SYSTEM;PENDING_COMMIT_TIMESTAMP()

[olavloite]

@vedantsali No, unfortunately that is not supported:

1. Liquibase does not have any built-in support for loading arrays. All data types that Liquibase does not have any special handling for will be passed on to the underlying JDBC driver as a string.
2. Spanner and the Spanner JDBC driver do not support any automatic conversion from a string to an array when it is given as a PreparedStatement parameter.

Instead of using loadData for this, I would recommend that you create a sql change set. That allows you to run any set of SQL statements, which again allows you to specify an array literal. See this for YAML example:

databaseChangeLog:
  - preConditions:
     onFail: HALT
     onError: HALT
  - changeSet:
     id:     v0.1-insert-data-with-sql
     author: spanner-liquibase-tests
     changes:
       - sql: |
           insert into my_table (id, name, other_languages)
           select 1, 'One', ['En', 'Eins', 'Uno']
           union all
           select 2, 'Two', ['To', 'Zwei', 'Dos'];
           
           insert into my_table (id, name, other_languages)
           select 3, 'Three', ['Tre', 'Drei', 'Tres']
           union all
           select 4, 'Four', ['Fire', 'Vier', 'Cuatro'];

https://github.com/cloudspannerecosystem/liquibase-spanner/blob/44d1f080cbf9c26359b9b84091d63a9ca3701df0/src/test/resources/sql.yaml