Creating a Data Lakehouse with Azure Synapse Analytics (Part 4 of 5)

Nicolas Rehder
11 min readOct 12, 2023

1. Create Azure Synapse Lake Database

The Lake Database is a new way of defining data structures on data that is hosted on Azure Data Lake Storage and processed with Azure Synapse. This Database type is synchronized between the Spark and the SQL Serverless engines in Azure Synapse and allows interoperability between the different compute engines (Spark and SQL). It is within this database type that you can create and query delta formatted data using delta tables.

1.1 Create a Synapse Notebook

We can now create delta tables based on the delta formatted data in the silver-container and the gold-container using the Apache Spark Pool.

1.1.1 Silver Database

  • Select the (1) Develop tab to the left, select the + button, and create a new (3) Notebook.
  • Rename the newly created Notebook to Setup Silver Database.

--

--

Nicolas Rehder
Nicolas Rehder

Written by Nicolas Rehder

My passions lie in challenging the status quo as well as finding and visualizing meaningful patterns in data.

No responses yet