Exam DP203 Serverless SQL Pool

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]