Azure Synapse live workspace is messed up - git overwrite is not working and spark notebooks are not visible in pipeline run

Stephane Massat 81 Reputation points
2022-12-08T07:47:37.13+00:00

Hello,

I am experiencing a severe issue with my synapse workspace starting yesterday. Can you please help me ?

We are using GIT for version control, and everything works well in the "Git" branches.
But we were having issues when publishing, so we have been running "GIT overwrite" to force updating the content of the live workspace. The publish succeed, but the workspace is not updated. (the overwrite detect all objects of the workspace as "new" each time i run it, and i get the "publish succeed" message, but the workspace is still not updated.
I tried the following :

  • disconnect git
  • removed manually all objects from the workspace (notebooks, pipelines, linked services)
  • reconnect git and run "git overwrite"

--> it recreates all my objects in the workspace, and i can see the objects in synapse studio, but i still get the same issue :

  • running "git overwrite" one more time detect all objects of the workspace as "new"
  • in the pipelines, in the "notebook" activities, the Notebook selection of the Settings tab is empty. I should see all the notebooks, but it is left empty.

Is there any way to fix that mess ?

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.
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
{count} votes

1 answer

Sort by: Most helpful
  1. Bhargava-MSFT 31,351 Reputation points Microsoft Employee Moderator
    2022-12-12T16:06:51.26+00:00

    Hello @Stephane Massat ,
    Thanks for the confirmation.

    Regarding your other issue. It seems like this is expected behavior. When I tried to "overwrite live mode" it always detected as (New) objects.

    With this "overwrite live mode" option, we can directly overwrite Azure Synapse Analytics or Azure Data Factory Live mode code with the current Branch from Azure Dev Ops.

    It will use the Publish option to overwrite everything into Azure Synapse Analytics/Azure Data Factory. So I believe this is why it shows as (New) every time.

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

    269698-image.png


Your answer

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