Exam DP203 Serverless SQL Pool: Difference between revisions
No edit summary |
No edit summary |
||
| Line 13: | Line 13: | ||
FORMAT = 'CSV', | FORMAT = 'CSV', | ||
PARSER_VERSION = '2.0' | PARSER_VERSION = '2.0' | ||
HEADER_ROW = TRUE | |||
) AS [result] | ) AS [result] | ||
</pre>Click the "Connect to" popup list, and select "Built-in", and run it. | </pre>Click the "Connect to" popup list, and select "Built-in", and run it. | ||
Revision as of 19:23, 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.