Synapse Lake Database movement from dev to test environment using Azure DevOps

Jaya Ojha 65 Reputation points
2024-01-11T15:35:39.61+00:00

Hi, I am using Azure DevOps for my CI/CD deployments with Synapse Workspace Deployment task (https://marketplace.visualstudio.com/items?itemName=AzureSynapseWorkspace.synapsecicd-deploy)with operation type Validate and Deploy. I am able to deploy my artifacts but when it comes lake databases, I am able to view the databases but not the tables that were present inside the lake databases. However, can see the tables in the repository in form of json scripts under database folder name but those scripts are not present in synapse analytics in which deployment is done. Any help would be appreciated!

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,178 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,602 Reputation points Microsoft Employee
    2024-01-12T01:21:05.05+00:00

    @Jaya Ojha Welcome to Microsoft Q&A forum and thanks for reaching out here.

    Have you got a chance to go through this thread where a similar issue has been discussed? If not kindly review let us know if that helps - CI CD for Synapse spark pool lake database objects.

    Thank you

    ---Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.