0

What are the different options to export a workspace let's say from Development into another workspace in TEST, UAT OR Production Synapse Analytics. Most of the options I have come across has been around copying code and pasting it in the intended environment. But, I want it to be automated so there's less moving parts and seamlessly move pipelines, linked services & datasets into different environments and less prone to run into errors.

enter image description here

paone
  • 828
  • 8
  • 18
  • have you seen this article ? https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery – Thomas Jan 04 '23 at 22:27
  • Hi @Thomas, Yes, I did and run into the error `Configured repository, but failed to import resource from workspace, this could happen if there are invalid resources.` updated OP with screenshot. – paone Jan 05 '23 at 00:10
  • Hi paone, could you share some more details of your issue in `azure devops pipeline` scenario? – Ceeno Qi-MSFT Jan 05 '23 at 02:34
  • Hi @CeenoQi-MSFT, I have a new synapse workspace and trying to configure Git repository the workspace has a couple of pipelines few linked services and datasets and using a self hosted integration run time. When I try to configure Azure DevOps Git run into the error `failed to import resource from workspace` and how do I find invalid resources? – paone Jan 05 '23 at 05:32
  • 1
    @paone I suppose that you could follow this doc [Source control in Synapse Studio](https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/source-control) to establish the integration. And also you need to check your role assignments in access control for the workspace. – Ceeno Qi-MSFT Jan 05 '23 at 08:15
  • @paone, any update? did the reference doc I shared help? – Ceeno Qi-MSFT Jan 09 '23 at 01:43
  • Hi @CeenoQi-MSFT, Yes, I had to redo from scratch and works fine now. But, When I import the repository from DEV to TEST I want DEV code to be independent of TEST and not commit my changes back to the repository. After I import the repository to TEST I had to change SQL database connection string in the source from DEV to TEST I have to commit the changes and the triggers I have setup for the pipelines don't run in TEST and fail in DEV because of the changes I did in TEST. How do I make all the environments independent once I import repository? – paone Jan 09 '23 at 05:27

1 Answers1

1

I suppose that you could follow this doc Source control in Synapse Studio to establish the integration. And also you need to check your role assignments in access control for the workspace.

Ceeno Qi-MSFT
  • 924
  • 1
  • 3
  • 5