Merging your data in a modern lakehouse data warehouse

Learn how you can move your data through different tiers using MERGE either with pySpark or SQL in Azure Synapse Analytics. Stijn Wynants walks you through the different steps. Stijn Wynants   / sqlstijn   pyspark.sql.SparkSession.createDataFrame https://spark.apache.org/docs/latest/... Table deletes, updates, and merges https://docs.delta.io/latest/delta-up... Delta Lake Documentation https://docs.delta.io/latest/delta-in... 📢 Become a member: https://guyinacu.be/membership ******************* Want to take your Power BI skills to the next level? We have training courses available to help you with your journey. 🎓 Guy in a Cube courses: https://guyinacu.be/courses ******************* LET'S CONNECT! ******************* --   / guyinacube   --   / awsaxton   --   / patrickdba   --   / guyinacube   --   / guyinacube   -- https://guyinacube.com **Gear** 🛠 Check out my Tools page - https://guyinacube.com/tools/ #AzureSynapse #merge #GuyInACube

Rounding out the lakehouse with the GOLD layer in Azure Synapse
▶︎

Rounding out the lakehouse with the GOLD layer in Azure Synapse

What is this delta lake thing?
▶︎

What is this delta lake thing?

Modern Data Lakehouse? Where do you even start??? Azure Synapse of course!
▶︎

Modern Data Lakehouse? Where do you even start??? Azure Synapse of course!

Microsoft Fabric: Data Warehouse vs Lakehouse vs KQL Database
▶︎

Microsoft Fabric: Data Warehouse vs Lakehouse vs KQL Database

Building ETL Pipelines in Databricks | Data Engineering in Databricks
▶︎

Building ETL Pipelines in Databricks | Data Engineering in Databricks

Behind the Hype: Should you ever build a Data Vault in a Lakehouse?
▶︎

Behind the Hype: Should you ever build a Data Vault in a Lakehouse?

Confused About Delta Transactions in Fabric? Here’s How They Work in PySpark
▶︎

Confused About Delta Transactions in Fabric? Here’s How They Work in PySpark

Building a Data Lakehouse Tutorial with Iceberg, Spark & Dremio | Dremio
▶︎

Building a Data Lakehouse Tutorial with Iceberg, Spark & Dremio | Dremio

Azure End-To-End Data Engineering Project for Beginners (FREE Account) | SQL DB Tutorial
▶︎

Azure End-To-End Data Engineering Project for Beginners (FREE Account) | SQL DB Tutorial

Learn ETL Pipelines in Databricks in Under 1 Hour | Data Engineering in Databricks
▶︎

Learn ETL Pipelines in Databricks in Under 1 Hour | Data Engineering in Databricks

Microsoft Fabric Explained in less than 10 Minutes (Start Here)
▶︎

Microsoft Fabric Explained in less than 10 Minutes (Start Here)

Architecting for Data Quality in the Lakehouse with Delta Lake and PySpark
▶︎

Architecting for Data Quality in the Lakehouse with Delta Lake and PySpark

Microsoft Fabric: Role of the Silver Lakehouse in the Medallion Architecture
▶︎

Microsoft Fabric: Role of the Silver Lakehouse in the Medallion Architecture

Trump Attends NBA Finals, Cries Election Fraud in California & Storms Out of Interview
▶︎

Trump Attends NBA Finals, Cries Election Fraud in California & Storms Out of Interview

I Hacked This Temu Router. What I Found Should Be Illegal.
▶︎

I Hacked This Temu Router. What I Found Should Be Illegal.

Azure Data LakeHouse in an Hour Virtual Workshop
▶︎

Azure Data LakeHouse in an Hour Virtual Workshop

Extract and Load from External API to Lakehouse using Data Pipelines (Microsoft Fabric)
▶︎

Extract and Load from External API to Lakehouse using Data Pipelines (Microsoft Fabric)

Database vs Data Warehouse vs Data Lake | What is the Difference?
▶︎

Database vs Data Warehouse vs Data Lake | What is the Difference?

Achieving Lakehouse Models with Spark 3.0
▶︎

Achieving Lakehouse Models with Spark 3.0

Lakehouse Deep Dive - Everything You Need to Know
▶︎

Lakehouse Deep Dive - Everything You Need to Know