1

I am having trouble completing an excersice on the Microsoft Learn platform.

https://learn.microsoft.com/en-us/learn/modules/examine-components-of-modern-data-warehouse/5-exercise-azure-synapse

I have followed the instructions, but get the following error

Error message

Source settings

Does anyone know what's causing this, and how I can fix the issue?

Regards, Anders

BareAnders
  • 27
  • 4

2 Answers2

0

I followed the same document. When I tried in my environment, I got the same error.

Ref2

Solution :

I was able to solve by Connecting with GitHub and Troubleshooting Git integration.

Note: Disconnect from the existing git repo. Reconnect back to the same repo, and create a new git branch. Then use git to create more commits on top of that branch.

Ref2

Sample dataset:

Ref1

Deployment status:

Ref6

Linked service:

Ref8

For more in detail, please refer to the below links:

https://learn.microsoft.com/en-us/azure/data-factory/source-control#connect-to-a-git-repository

https://learn.microsoft.com/en-us/azure/data-factory/continuous-integration-delivery#best-practices-for-cicd

B. B. Naga Sai Vamsi
  • 2,386
  • 2
  • 3
  • 11
  • The Synapse tutorial does not require the existence of git repository. Products.csv access through HTTP does not require git repo. Or may be I am missing out on something. – Pallavi May 30 '22 at 14:22
  • Thanks you @Pallavi for the comment ,After previewing the data, on the Source/Configuration **step 6** try to change **Row delimiter** as **Default (\r,\n, or \r\n)** and also **Step 9** Configuration substep ,please change Row delimiter as **Default (\r,\n, or \r\n)** . – B. B. Naga Sai Vamsi May 31 '22 at 08:49
0

I ran into this issue too. Unless I missed a step in the Explore Azure Synapse Analytics exercise (https://learn.microsoft.com/en-us/learn/modules/examine-components-of-modern-data-warehouse/5-exercise-azure-synapse), I found the issue to be that the source linked service was not being created for some reason in Steps 3 and 4. I suggest doing the following in a different tab, so you can come back to Ingest Data wizard later to pick up where you left off. I created the source linked service by going to my workspace, then clicking on the "Manage" icon (the one with the wrench on the briefcase). After that, click on "Linked services" followed by clicking on "+ New". At this point, a number of connection icon should appear. In the search bar type "HTTP" and click on it and click "continue". This will bring up a form that will be the same as the one you saw in step 3 of the Explore Azure Synapse Analytics exercise. Fill it out as directed in the exercise, and you should have a source linked service connection of Type "HTTP" created. Screenshot of Buttons to Click on to Create Source Linked Service

As long as you've completed the rest of the steps of the exercise, going back to the Deployment step and proceeding should now allow it successfully complete.

Jarrett Richard
  • 16
  • 1