Exam DP203 Copy Data tool: Difference between revisions
No edit summary |
No edit summary |
||
| Line 13: | Line 13: | ||
=== Destination === | === Destination === | ||
In Destination, choose type '''Azure Data Lake Storage Gen 2''', and select the existing connection item into there from the popup list: '''synapse9cxqfg2-WorkspaceDefaultStorage''' | In Destination, choose type '''Azure Data Lake Storage Gen 2''', and select the existing connection item into there from the popup list: '''synapse9cxqfg2-WorkspaceDefaultStorage''' | ||
(note this existing connection can be seen beforehand under the '''Data''' - '''Linked''' tab. | |||
Give it a relative path of: files/product_data | |||
and file name: products.csv | |||
'''Run job''' | |||
Run the job, to do the data load. | |||
Then back in Azure Synapse Studio, | |||
Revision as of 18:37, 15 November 2024
Copy Data Tool
In Azure Synapse Analytics Studio, under the "Home" section on the left hand side: Click the "Ingest" large button.
From:
Select "Built-in copy task".
Source
In the definition of the source, click "New Connection". Create a new connection, and in the Linked service pane that appears, on the Generic protocol tab, select HTTP. Then enter the URL to a .csv file hosted on a Github share.
Destination
In Destination, choose type Azure Data Lake Storage Gen 2, and select the existing connection item into there from the popup list: synapse9cxqfg2-WorkspaceDefaultStorage
(note this existing connection can be seen beforehand under the Data - Linked tab.
Give it a relative path of: files/product_data
and file name: products.csv
Run job
Run the job, to do the data load.
Then back in Azure Synapse Studio,