Synapse Espresso: Introduction to Delta Tables

Рет қаралды 13,795

Жыл бұрын

Welcome to the 9th video of the Synapse Espresso series!
In this video, Stijn is joined by Jovan Popovic, a Program Manager on the Serverless SQL team, to walk us through the basics of Delta Lake, such as what Delta Lake format is and how it enables us to update our data in the Lake. They will also show us how serverless SQL pool enables us to query data in Delta Lake format.
Delta Lake delta.io/
Querying Delta Lake format in serverless pool learn.microsof...
Jovan Popovic - Senior Program Manager
/ jovan-popovic
/ jovanpop_msft
Stijn Wynants - Fasttrack Engineer
/ stijn-wynants-ba528660
sql-stijn.com/
/ sqlstijn
#azuresynapse #serverless #sql #analytics #deltalake

Пікірлер: 18

@ViniciusRibeiro-kz2pe 10 ай бұрын

Jovan gave us a very clear explanation about how we can travel in time with the data to read. Tks a lot!

@bernardherrok9748 Жыл бұрын

Total commander on the taskbar. Respect, Jovan.

@vijaykj1819 Жыл бұрын

simple & nice explanation of delta protocol how it works.

@aditiiyer3476 5 ай бұрын

Very well explained, Thank you!

@germanareta7267 Жыл бұрын

Great video.

@SilvanoPaxia Жыл бұрын

Great Video, very clear! Any chance of creating a video on how to manage SCD Type 2 in Delta Lake?

@stijnwynants7307 Жыл бұрын

Hi Silvano, Let's see if we can set that up!

@AlexWalton Жыл бұрын

Were you able to set that up? I have the same question!

@LaurentKoelink Жыл бұрын

Wondering, if you have many changes to the source data, aren't you replicating the data that isn't changed often? Is there a recommended filesize (# of records) per parquet file? Are files split up when changes are made (all the old unchanged data, and a separate file for just the changes). Any recommendations / considerations? Could be "old school thinking" ;-) - Great video by the way!

@omerturkoglu4259 2 ай бұрын

can we say that delta is based on parquet? So Delta is nothing but an advanced Parquet?

@lijnenjoost Жыл бұрын

Thx! Will it be possible to timetravel with SQL scripts as well?

@stijnwynants7307 Жыл бұрын

Hi Joost, at this point in time it is not possible

@encryptedunlimited1094 Жыл бұрын

How do i get my own synapse tshirt. I love it

@sid0000009 Жыл бұрын

Can an API hosted on an App service in anyway fetch Delta tables data ? thanks

@pini22ki Жыл бұрын

Hiw can i read delta versions in serverless?

@advaithdenesh9906 Жыл бұрын

The best soft cos when ur stoned

@avicool08 Жыл бұрын

Pls show how to connect to PBI too

@AzureSynapse Жыл бұрын

Abinash, check out this video: kzfaq.info/get/bejne/jrOPaMajnd7Dco0.html. In the demo part related to Power BI datamart we show how to connect to Azure Synapse serverless SQL endpoint. And here is the whole Azure Synapse + Power BI Datamart video series: kzfaq.info/sun/PLzUAjXZBFU9MQ1GEPcSv1hOgZ9r7dJodn.