Cannot Publish Synapse Main Branch - Renamed Dataset

Andrew Kay 31 Reputation points
2022-09-20T07:49:34.633+00:00

I'm having a similar issue as discussed here: https://learn.microsoft.com/en-us/answers/questions/392914/cannot-publish-azure-synapse-main-branch-ranamed-r.html

I was performing some housekeeping on duplicate datasets (i.e. different names, but all being used for similar purposes / pointing at the same linked service) - these are the steps I took.

  1. Created a dev branch from Main
  2. Deleted some datasets and re-named 5 datasets
  3. Committed / Created a PR for dev to Main / Completed PR / (dev branch removed)
  4. Attempted to publish from Main
  5. Received the following error for one of the renamed datasets

The Dataset

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,378 questions
0 comments No comments
{count} votes

Accepted answer
  1. Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
    2022-09-20T20:08:35.883+00:00

    Hello @Andrew Kay ,

    Welcome to the MS Q&A platform.

    As per the error message, the datasets already exist in the live mode, but you have already confirmed they don't exist.

    I understand you cannot publish from your collaboration branch(main branch) to live mode and see the error message. As mentioned on the other thread, the most likely cause is a naming conflict. But you are sure that you don't have any naming conflicts.

    If your Main branch has the most recent changes from the feature branches, then you can overwrite live mode from the Git configuration in one step. Please see the below screenshot for your reference.

    Note: This will overwrite everything in your Azure Synapse Analytics live mode by publishing each resource in the git repository and deleting any resources that do not exist in the git repository.

    I hope this helps. Please let me know if you have any further questions.

    243109-image.png

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    5 people found this answer helpful.

0 additional answers

Sort by: Most helpful

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.