liquibase with Azure Synapse Analytics (SQL DW)?

Liquibase Development
1

how to use liquibase with Azure Synapse Analytics (SQL DW)?, because it does not use jdbc standar I am get compatibility error : com.microsoft.sqlserver.jdbc.SQLServerException: Stored procedure sp_addextendedproperty does not exist or is not supported.

2

@arocha welcome!
Could you tell me a little more of what you are trying to do? I would love to see

  • what command you are trying to run (ex. liquibase update)
  • could you share your liquibase properties file (please take out any passwords)
  • steps to repro issue you are facing
  • complete output (I just see a small excerpt, that’s not enough for me to see what’s going on).

Would love to see if I can reproduce it. MS says you can connect using JDBC here. So, I suspect your classpath is not pointed to the driver.

Looking forward to getting you going!

-Ronak

3

@arocha I just tried using Liquibase with Azure Synapse Analytics and the version 9.2.0 of the mssql-jdbc driver. I got as far as I could and got the error below.

COLUMNPROPERTY’ is not a recognized built-in function name.

Have you been able to successfully use Liquibase with Azure Synapse?

Thanks,
Eric

1 Like