Liquibase with Simba JDBC, INVALID_ARGUMENT: Type not found: INT

[adilev26-fs]

hi,

trying to work with Liquibase + Liquibase Bigquery extension + Simba JDBC + emulator. JDBC version 1.3.0 (https://storage.googleapis.com/simba-bq-release/jdbc/SimbaJDBCDriverforGoogleBigQuery42_1.3.0.1001.zip)

connection URL set as follow: jdbc:bigquery://localhost:49946;ProjectId=project;DefaultDataset=dataset;Location=us-central1;RootURL=http://localhost:49946;OAuthType=2;OAuthAccessToken=a25c7cfd36214f94a79d;OAuthRefreshToken=1jt9Pcyq8pr3lvu143pfl4r86;OAuthClientId=11b5516f132211e6;LogLevel=6

liquibase tries to create it's metadata table with no success : {"query": "CREATE TABLE dataset.DATABASECHANGELOGLOCK (ID INT, LOCKED BOOLEAN, LOCKGRANTED datetime, LOCKEDBY STRING(255))", "values": []}

{"error": "jobInternalError: failed to analyze: INVALID_ARGUMENT: Type not found: INT [at 1:48]"}

same code works fine with real BQ.

[ohaibbq]

INT is not recognized in the Google ZetaSQL library. One workaround is to use a more explicit integer type i.e. INT64 in your queries.