SQLBits 2022

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: https://sqlb.it/?7224

Luke Moloney's other proposed sessions for 2026

Airflow in Fabric - an introduction informed by experience - 2026

Fabric for ISVs - Develop multi-tenancy apps on Fabric - 2026

Practical lessons in optimizing Data Engineering with Spark - Part 1 - 2026

Practical lessons in optimizing Data Engineering with Spark - Part 2 - 2026

Luke Moloney's previous sessions

Flying High with Data Engineering in Microsoft Fabric

In this session demo centric session we will walk through Data Engineering in Microsoft including: Getting started with Notebooks, Learning how Fabric Lakehouse's provides flexibility to use the tools you prefer, The flexibility of data engineering in Spark - including Cluster Configuration, Environments and Library Management and finally, How Copilot enables all developers to be more efficient with Spark.

Harnessing Data Science and AI in Fabric

In this session you will learn about all the latest data science developments in Microsoft Fabric. We will show you how Fabric supports the end-to-end data science workflow and how we plan to evolve these capabilities. We will also look at exciting new AI capabilities including Copilot experiences and more!

Synapse Q&A with PG

SQLBits' has brought members of the Azure Synapse Program Group to Wales to ask YOUR questions. Bring your questions for: Dedicated SQL Pools, Serverless SQL Pools, Spark Pools, Pipelines, Kusto and everything else Synapse related.

The fundamentals of building a lakehouse with Synapse