Error creating a column type JSON in Spanner

General Discussion
1

I’m working with Java this is my changelog

databaseChangeLog:
  - changeSet:
      author: ntapia
      id: 8c4258ae
      comment: create table
      changes:
        - createTable:
            tableName: remote_dir
            columns:
              - column:
                  name: id
                  type: STRING(36)
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: name
                  type: STRING(36)
              - column:
                  name: supported
                  type: JSON

The migration fails:

[ERROR] Failed to execute goal org.liquibase:liquibase-maven-plugin:4.5.0:update (default-cli) on project dnm-core:
[ERROR] Error setting up or running Liquibase:
[ERROR] liquibase.exception.MigrationFailedException: Migration failed for change set changes/v.20211129110421749__create_remote_directory_table.yaml::8c4258ae::ntapia:
[ERROR] Reason: liquibase.exception.DatabaseException: INVALID_ARGUMENT: io.grpc.StatusRuntimeException: INVALID_ARGUMENT: Error parsing Spanner DDL statement: CREATE TABLE remote_dir (id STRING(36) NOT NULL, name STRING(36), su
pported JSON) PRIMARY KEY (id) : Syntax error on line 1, column 77: Encountered ‘JSON’ while parsing: column_type [Failed SQL: (3) CREATE TABLE remote_dir (id STRING(36) NOT NULL, name STRING(36), supported JSON) PRIMARY KEY (id)]

2

I’m not sure that JSON is a supported column type in Liquibase using the yaml createtable changeset.
You might be able to use a sql based changeset to get around this for now as a workaround.