Analyze data in a lake database

DP-203-Labs-04

Azure Synapse Analytics enables you to combine the flexibility of file storage in a data lake with the structured schema and SQL querying capabilities of a relational database through the ability to create a lake database. A lake database is a relational database schema defined on a data lake file store that enables data storage to be separated from the compute used to query it. Lake databases combine the benefits of a structured schema that includes support for data types, relationships, and other features typically only found in relational database systems, with the flexibility of storing data in files that can be used independently of a relational database store. Essentially, the lake database "overlays" a relational schema onto files in folders in the data lake.

Before you start

You'll need an Azure subscription in which you have administrative-level access.

Review the Lake database and Lake database templates articles in the Azure Synapse Analytics documentation.

Modify container permissions

Create a lake database

3 Ways to Create lake database tables

Work with lake database tables