Exam DP203 Storage 3 Azure Lake Database: Difference between revisions

From MillerSql.com
NeilM (talk | contribs)
No edit summary
NeilM (talk | contribs)
No edit summary
Line 6: Line 6:


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'''.
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.

Revision as of 21:10, 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.