The fundamentals of building a lakehouse with Synapse

The lakehouse architecture is growing in popularity as an alternative to traditional data warehousing approaches, but it can be difficult to know how to glue it altogether and the 'gotchas' along the way.

In this session I will go through the fundamental elements of building a lakehouse architecture using Synapse.

In particular I will cover; why a lakehouse and the differences to traditional warehouse design, the technologies and tools within Azure to assist you, how you can make the lakehouse accessible to business users using low/no-code technologies, how technologies like Synapse SQL Serverless can simplify the migration to a lakehouse architecture, and the some of the common 'gotchas' along the way.

Some of the technologies we will cover include; Azure Data Lake Store Gen 2, Synapse PIpelines, Synapse SQL Serverless, Synapse Spark with Delta, Synapse Dataflows and Synapse Link.

feedback link:

Starts: 10:10 10th Mar 2022
Ends: 11:00 10th Mar 2022


Short Description
- The fundamentals of building a lakehouse with Synapse


Luke Moloney


AzureIntelligence and AnalyticsManaging Big DataDevelopingOptimisingData LakeSynapse AnalyticsBeginnerWhat

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference


Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.