Exam DP203 Serverless SQL Pool: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
Serverless SQL Pool. Reads from data lake files. | 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: | |||
-- This is auto-generated code | |||
SELECT | |||
TOP 100 * | |||
FROM | |||
OPENROWSET( | |||
BULK '<nowiki>https://datalake9cxqfg2.dfs.core.windows.net/files/product_data/products.csv'</nowiki>, | |||
FORMAT = 'CSV', | |||
PARSER_VERSION = '2.0' | |||
) AS [result] | |||
Revision as of 19:20, 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:
-- This is auto-generated code
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]