CI/CD for Synapse database object


Requirement is to run SQL scripts stored in Synapse Dev instance on subsequent PPE & PROD env. Please keep in minds following points:

  1. In Synapse dev workspace, sql files are stored as .sql files

  2. When pushed to repository, the files are stored as .json files.

  3. During CD release pipeline the code flow through the env from dev to ppe and then to production.

  4. But we also want to execute our sql scripts during release pipeline so that the changes in database would also flow through.

Please let me know how to do that.

0 Replies