Exam DP203 Serverless SQL Pool: Difference between revisions
No edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
This generates the following script: | This generates the following script: | ||
<pre> | |||
SELECT | SELECT | ||
| Line 22: | Line 22: | ||
) AS [result] | ) AS [result] | ||
</pre> | |||
Revision as of 19:21, 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' ) AS [result]