Can not generate-changelog for a dedicated SQL pool (formerly SQL DW) database

General Discussion
1

Hi fellas,

I’m trying the cli command ‘generate-changelog’ for my database (dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics. this database have many schemas.

my command :

liquibase generate-changelog --changelog-file=test-changelog-dwmicbas01.xml

the error :

Unexpected error running Liquibase: Error executing SQL

SELECT SEQUENCE_NAME,
cast(START_VALUE AS BIGINT) AS START_VALUE,
cast(MINIMUM_VALUE AS BIGINT) AS MIN_VALUE,
cast(MAXIMUM_VALUE AS BIGINT) AS MAX_VALUE,
CAST(INCREMENT AS BIGINT) AS INCREMENT_BY,
CYCLE_OPTION AS WILL_CYCLE
FROM INFORMATION_SCHEMA.SEQUENCES
WHERE SEQUENCE_SCHEMA = ‘dbo’

: Catalog view ‘SEQUENCES’ is not supported in this version.

Can anyone help me with this error.

  • Liquibase’s version : Liquibase Community 4.17.0
  • SQL Server version : SQL Server 2014

Thanks in advance :smiley:

2

This looks like it is likely an issue that Azure Synapse Analytics (aka SQL Data Warehouse) does not support SEQUENCES. The code in liquibase.snapshot.jvm.SequenceSnapshotGenerator around line 251 checks to see if we are working with a MSSQLDatabase. That’s probably going to have to change to take this variation into account.

Would you mind creating an issue in Github for this? Issues · liquibase/liquibase · GitHub

- PJ