Advancing Spark - Databricks Delta Streaming

It can be hard to build processes that detect change, filtering for rows within a window or keeping timestamps/watermarks in separate config tables. Delta Streaming allows you to write a streaming query over a delta table, whether it was streamed to or not, and automatically keep track of updates & change.
In this video, Simon walks through the basics of streaming with Delta and shows a couple of tips & tricks from his time working with realtime & batch streaming processes!
For more info about Delta Streaming, check out: docs.databricks.com/delta/del...
As always, don't forget to like and subscribe, and check out how we can help you master Databricks - www.advancinganalytics.co.uk/...

[@prashanthxavierchinnappa9457]

I've said it a million times. The best Spark videos on KZbin.

[@NeumsFor9]

It's because Simon and team prep beforehand and strike the right pace so that it moves just right for both newbies to absorb and seasoned vets to have a speed-of-thought experience. It's art and science.

[@manu4ever249]

The tutorial is so good probably saved me many hours or even days on my work. Thank you!

[@AdvancingAnalytics]

Thanks. That's all we ever hope to do

[@rupeshagarwal5896]

I am a big fan of your work. Really big. Noone understands problems of us better than you

[@diogodallorto1]

You are helping me a lot with this stuff! Just keep going! Thank you!

[@patrickchan2503]

thank you for checkpoint explanation + everything else

[@sumashruthika7852]

Great video!

[@HiteshTulsaniAtGooglePlus]

You got a new sub from Aus. Epic stuff mate! Helps a lot.

[@onnovanderhorst6161]

Working for Microsoft but you're my main source of information :D

[@deepjyotimitra1340]

Thank you for such an amazing video. Nice explanation

[@tanushreenagar3116]

awesome content

[@rohithamaz8767]

Your explanation is awesome!! i am trying it now... Just wanted to explore a lot of Streaming use cases, It would be great if you can put across some challenging streaming examples..

[@samk_jg]

its very helpful, thanks!

[@uscgpsu1]

Great video very helpful

[@Sunkarakrwutarth9389]

Thanks For the video

[@anilpeyyala3332]

Thanks a lot with these videos. They help a lot. I got a question though, how can we perform Stream-Stream joins and Stream-Static data joins? I have a need to multiple joins with multiple streaming sources each arriving at separate times?

[@sid0000009]

Thanks ! do you also share a Github where we can pick your notebooks?

[@fgnb-md4ln]

Great video! Love your clear explaination. BTW Where can I find your notebook? I noticed that your github updated 4 years ago.

[@rahulsood81]

Can you explain the difference between using Auto-loader and Structured Streaming (readStream/writeStream) Also, when/how to use foreachBatch in Databricks ??

[@muchirajunior9751]

great

[@abhijeetnaib]

If there are lot of files at the source then exactly once semantics might not help considering the listing files will take a lot of time

[@sonamjain4567]

Thanks a lot for sharing these videos. I have gone through the series of videos and its been really very helpful. I have got 1 doubt. Can you please let me know what is the difference when we write checkpointLocation as you have shown in this video vs autoloader. I have seen that in auto loader also, we give checkpoint. Are these referring to the same feature or there is any difference. Kindly help. Thanks!

[@AdvancingAnalytics]

Hey! Yep, the checkpoint mechanism is the same between autoloader and Delta streaming, although it holds slightly different metadata depending on the streaming source - delta sources hold the latest delta version that was read, autoloader sources hold the details of the queue it should reference & the files read so far.

[@sonamjain4567]

@@AdvancingAnalytics Thanks for quick reply. So what are the use cases for using each approach? Are there any pros and cons of both the approaches? Kindly suggest

[@AdvancingAnalytics]

@@sonamjain4567 I use them very differently - autoloader is good for bringing source data into the lake from external sources, delta is for change in between layers of your lake. It's less of a pro/con between the two, more depends which scenario you are trying to implement!

[@quentindelignon1587]

Hey ! i dont know if you still answer questions but does this apply to any kind of source ? can we get this versioning and increment processing on any source like HDFS ?

[@MrDeedeeck]

Hi, not really clear exactly how different the _checkpoint file is from the _delta_log files. It seems like you could run your entire example using just _delta_log and specifying the version of the delta table to read from?

[@RubenAlvarezMtz]

Check this video out, they clearly explain the difference and how they work together kzbin.info/www/bejne/Z5SldXqpiMeqiKM

[@adyashreemahapatra370]

Thank you for the video. Can we process this streaming data using readStream and writeStream inside a .py script in databricks. As, I am getting an error while reading data from the location where data is written using writeStream() function?

[@nmounika7927]

Hi, i want to trigger the data bricks whenever there is a new file loaded in delta table, do we have any option for that?

[@edamextreme]

The tutorial was incredible. But I have a question, can I stream from a view?

[@AdvancingAnalytics]

Hrrrrrrrm. Good question - don't think so but I've not tried it. You can use Views in Delta Live Tables continuous mode, which makes me think it's possible, but maybe only with some manual coding around to bring the elements together! I'll add it to my "things to try" list :)

[@besafal1]

I am trying to write a streaming application and need to create a new df by taking every event as input. Now since spark is not available on executor so it errors or every time. Can you please help how can we create df from a separate source in streaming application

[@PersonOfBook]

Does it only work with delta tables or also with plain text files in the data lake?

[@AdvancingAnalytics]

You can use standard spark file streaming over files in the lake, although it can slow down over time as it scans the entire directory each micro-batch. Delta streaming is way more efficient as it can use the transaction log to isolate only new files

[@lukasu-ski4325]

Is it really a big difference between writeStream with option trigger(once=True) and a classic run of write.format("delta").mode("overwrite")? Don't we overcomplicate it with streaming? It seems for me we can achieve the same thing with batch with less complexity. Let me know your thoughts!

[@AdvancingAnalytics]

Yeah, absolutely streaming makes it more complicated, but streaming from a delta table means you don't have to work out what has changed, it automatically picks up only new files. So you're reducing complexity of change detection, but at the price of additional complexity through streaming. Both approaches have pros/cons - for me, it's another useful tool in my toolbelt! Simon

[@crazybauns]

i am new to databricks and streaming so apologies for the dumb question you create a table in your databricks db which gets its data from your delta file you then insert data to that table your streaming df is mapped to your delta files when you insert to your table; why is the data inserted to your delta file? the table and delta are always mapped to one another? even if you dont make it explicit, inserting to a table means inserting to a delta file?

[@AdvancingAnalytics]

No dumb questions - we're all learning! The "table" is just a logical pointer to the delta files, not like a physical table in a SQL database. Each time you query the table, it's going to the delta files regardless. So inserting into the table, or into the delta files, does the same thing. That said, you can create those logical/external tables over other files/folders if you don't want to use delta. Simon

[@crazybauns]

@@AdvancingAnalytics Thank you!

[@qweasdzxc2007]

Going further in this question: if i manually copy file in folder, where delta table already resides, will i get information from this new file also with old rows, when i select from this delta table?

[@HughMcBrideDonegalFlyer]

Is the notebook available to experiment with

[@AdvancingAnalytics]

Not yet! The notebooks are all fairly heavily plumbed into our training, which we can't give away. We'll figure out the best way to share, how much we want to make available etc. Just needs some free time to pull things apart :)

[@user-eg1ss7im6q]

how did you write to data lake storage? .save("/mnt/xxx") did not work for me?