Exam DP203 Storage 3 Azure Lake Database: Difference between revisions
No edit summary |
No edit summary |
||
| Line 8: | Line 8: | ||
In the design section, you can choose a template from different business scenarios, or choose to create it as empty. Then after you can add tables to it, including key relationships between tables. | In the design section, you can choose a template from different business scenarios, or choose to create it as empty. Then after you can add tables to it, including key relationships between tables. | ||
You can run select statements on the tables either with the Serverless pool using standard SQL syntax like: | |||
Revision as of 21:13, 16 November 2024
The third Storage type is: Azure Lake Database.
The underlying data is in Parquet or CSV files only.
Serverless SQL Pool, or Spark.
To create a Lake Database, go into Synapse Studio Data tab, and click the + button and select Lake Database under "Workspace". This creates a new section "Lake Database" under which the database is created, under Data - Workspace.
In the design section, you can choose a template from different business scenarios, or choose to create it as empty. Then after you can add tables to it, including key relationships between tables.
You can run select statements on the tables either with the Serverless pool using standard SQL syntax like: