Delta Live Tables: Building Reliable ETL Pipelines with Azure Databricks

In this session, we will see how to use Delta Live Tables to build fast, reliable, scalable, and declarative ETL pipelines on Azure Databricks platform.
Speaker: Mohit Batra SQLbits.com/speakers/Mohit_Batra
SQLbits.com/Sessions/Delta_Liv...
Tags: Azure,Spark,Data Lake,Big data analytics,Developing,Data Bricks,Big Data & Data Engineering,Data Loading Patterns & Techniques

[@germanareta7267]

Great video, thanks.

[@amadoumaliki]

As usual! Mahit wonderful!

[@menezesnatalia]

Nice tutorial. Thanks for sharing. 👍

[@samanthamccarthy9765]

Awesome thanks so much . this is really useful for me as a Data Architect . much is expected from us with all the varying technology

[@walter_ullon]

Great stuff, thank you!

[@starmscloud]

Learned a Lot from this . Thank You for this video !

[@SQLBits]

Glad it was helpful!

[@Rangapetluri]

Wonderful session. Sensible questions asked. Cool

[@artus198]

I sometimes feel, the good old ETL tools like SSIS , Informatica were easier to deal with ! 😄 (I am a seasoned on premise SQL developer, transitioning into the Azure world slowly).

[@ananyanayak7509]

Well explained with so much clarity. Thanks 😊

[@SQLBits]

Our pleasure 😊

[@ADFTrainer]

@@SQLBits Can you provide code. Thanks in advance..

[@MichaelEFerry]

Great presentation.

[@SQLBits]

Thanks for watching :)

[@srinubathina7191]

Wow super stuff thank you sir

[@SQLBits]

Glad you liked it!

[@pankajjagdale2005]

crystal clear explanation thank you so much can you provide that notebook ?

[@user-cg6yw8ei6j]

For complex rule based transformations how we can leverage it?

[@priyankpant2262]

Great video ! Can you share the github location of the files used ?

[@olegkazanskyi9752]

Is there a video on how data is pulled from the original source, like a remote SQL/noSQL server, or some API? I wonder how data is getting to the data lake? I assume this first extraction should be a bronze layer.

[@anantababa]

Awesome training, can you please share the data file, i want to try it.

[@Databricks]

Nice video🤩

[@SQLBits]

🥳

[@ashwenkumar]

Does delta live tables in all the layers has filesystem linked to it as like in hive or Databricks ?

[@prashanthmally5765]

Thanks SQLBits. Question: Can we create a "View" on Gold Layer instead having "Live Table" ?

[@user-cg6yw8ei6j]

Is there any way to load new files sequentially if bunch of files arrived at a time?

[@trgalan6685]

Great presentation. No example code. What's zero times zero?

[@lostfrequency89]

Can we create dependency between two notebooks?

[@guddu11000]

shoud have showed us how to trobleshoot or debug

[@ADFTrainer]

pls provide code links

[@thinkbeyond18]

I have a general doubt in autoloader . does autoloader required to run in a job or notebook triggering manually .Or no need to touch anything once we written the code as when as the file arrives it will run automatically and processed the files.

[@Databricks]

Trigger your notebook that contains your DLT + Auto Loader code with Databricks Workflows. You can trigger it using a schedule, a file arrival, or choose to run the job continuously. It doesn't matter how you trigger the job. Auto Loader will only process each file once.

[@MohitSharma-vt8li]

Can you please provide us the notebook DBC file or ipynb.. By the way great session, Thanks

[@SQLBits]

Hi Mohit, you can find all resources shared by the speaker here: events.sqlbits.com/2023/agenda You just need to find the session you're looking for and if they have supplied us with their notes etc, you will see it there once you click on it!

[@MohitSharma-vt8li]

@@SQLBits thanks so much

[@tratkotratkov126]

Hm … Where in these pipelines you have specified that nature of the created/maintained entity - bronze, silver or gold other then the name of the object itself. Also where these LIVE tables are exactly stored - from your demonstration it appear they all live in the same schema / database while in real live the bronze, silver and gold entities have designated catalogs and schemas.

[@TheDataArchitect]

I don't get the usage of VIEWS between Bronze and Silver tables.

[@TheDataArchitect]

Anyone?

[@SQLBits]

Hi Shzyincu, you can get in touch with the speakers who taught this video via LinkedIn and Twitter if you have any questions!

[@richardslaughter4245]

My understanding (as an "also figuring out data bricks" newb: * View: Because the difference between bronze and silver in this instance is very small (no granularity changes, no joins, no heavy calculations, just one validation constraint), it doesn't really make sense to make another copy of the table when the view would be just as performant in this case. * "Live" view: I think maybe this is required because the pipeline needs it to be a live view to properly calculate pipeline dependencies Hopefully that understanding is correct, or others will correct me :) My follow up question would be: As I think about that validation constraint, it really seems like in this case it seems functionally identical to just applying a filter on the view. Is that correct? If so, is the reason to use the validation constraint rather than a filter, mostly to keep code consistency between live tables and live views?

[@Ptelearn4free]

Databricks have pathetic UI...