Can not generate-changelog for Azure Synapse Analytics (formerly SQL DW) database

[Frt-els]

Search first

• I searched and no similar issues were found

Description

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 😃

Steps To Reproduce

• liquibase.properties :
  changeLogFile: dbchangelog.xml
  url: jdbc:sqlserver://pzbdmicb00001.database.windows.net:1433;database=dwmicbas01
  username: u_pzbdmicb00001_owner
  password: *******

• dbchangelog.xml :

<include file="changelogs/init-db.xml" />
<include file="changelogs/add-created.xml" />

• CLI command :
  liquibase generate-changelog --changelog-file=example-changelog.xml

Expected/Desired Behavior

expecting a full changelog file for my database.

Liquibase Version

Liquibase Community 4.17.0

Database Vendor & Version

SQL Server 2014

Liquibase Integration

CLI

Liquibase Extensions

No response

OS and/or Infrastructure Type/Provider

Windows 10

Additional Context

I have already post in the Liquibase's Forum : https://forum.liquibase.org/t/can-not-generate-changelog-for-a-dedicated-sql-pool-formerly-sql-dw-database/7947

Are you willing to submit a PR?

• I'm willing to submit a PR (Thank you!)

[nvoxland]

Thanks for filing the issue, that makes tracking the request easier.

Likely a new database extension needs to be made to support azure synapse analytics. I updated the title slightly to make that more explicit. Without that, Liquibase is likely seeing the database as an "unsupported" database, meaning it tries to use sql-standard calls which tend to not cover the metadata queries used in generate-changelog well.

I'm working on some new documentation that pulls together the scattered info we have on creating support for a new database but it's not quite ready to launch yet. But, if anyone is interested in helping with the database support I can send you a preview link and help you get started. Let me know at nathan@liquibase.org

[LeRiton]

Hi @nvoxland
We are facing the same issue.
Can you tell us if there is any schedule behind:

• Synapse support
• New database support process

Thanks in advance!

[MarcinZegar]

Same issue here as well.