Exam DP203 Serverless SQL Pool: Difference between revisions
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
<pre> | <pre> | ||
SELECT | SELECT | ||
TOP 100 * | TOP 100 * | ||
FROM | FROM | ||
OPENROWSET( | OPENROWSET( | ||
BULK '<nowiki>https://datalake9cxqfg2.dfs.core.windows.net/files/product_data/products.csv'</nowiki>, | BULK '<nowiki>https://datalake9cxqfg2.dfs.core.windows.net/files/product_data/products.csv'</nowiki>, | ||
FORMAT = 'CSV', | FORMAT = 'CSV', | ||
PARSER_VERSION = '2.0' | PARSER_VERSION = '2.0' | ||
) AS [result] | ) AS [result] | ||
</pre> | </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]