Exam DP203 Serverless SQL Pool: Difference between revisions
No edit summary |
No edit summary |
||
| Line 18: | Line 18: | ||
Give the script a name on the right hand side, and click Publish. Thenafter it can be seen under the "Develop" tab. | Give the script a name on the right hand side, and click Publish. Thenafter it can be seen under the "Develop" tab. | ||
Output the results instead as a chart by clicking the "Chart" button in the output pane, setting appropriate values in the "Category" and "Legend" popup lists. | |||
Revision as of 19:30, 15 November 2024
Serverless SQL Pool. Reads from data lake files.
In Synapse Studio Data - Linked tab, go into the Azure Data Lake Gen2 header, and drill down and right-click a file there. Right-click and select "New SQL Script".
This generates the following script:
SELECT
TOP 100 *
FROM
OPENROWSET(
BULK 'https://datalake9cxqfg2.dfs.core.windows.net/files/product_data/products.csv',
FORMAT = 'CSV',
PARSER_VERSION = '2.0'
HEADER_ROW = TRUE
) AS [result]
Click the "Connect to" popup list, and select "Built-in", and run it.
Give the script a name on the right hand side, and click Publish. Thenafter it can be seen under the "Develop" tab.
Output the results instead as a chart by clicking the "Chart" button in the output pane, setting appropriate values in the "Category" and "Legend" popup lists.