Exam DP203 Serverless SQL Pool: Difference between revisions
No edit summary |
No edit summary |
||
| Line 24: | Line 24: | ||
No charge for resources reserved, you're only charged for the data processed by queries you run. | No charge for resources reserved, you're only charged for the data processed by queries you run. | ||
Not recommended for OLTP. | |||
Revision as of 22:55, 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.
Give the script a name on the right hand side, and click Publish. Thenafter it can be seen under the "Develop" tab.
Output the results instead as a chart by clicking the "Chart" button in the output pane, setting appropriate values in the "Category" and "Legend" popup lists.
Three file formats can be read: CSV, JSON, Parquet.
No charge for resources reserved, you're only charged for the data processed by queries you run.
Not recommended for OLTP.