#12. Tumbling window triggers in azure data factory | Azure data factory

#azuredatafactory #adf #triggeradf #azuredataengineer #adfproject

In this video we will learn about
1. what is tumbling window trigger
2. how tumbling window trigger works
3. tumbling window vs schedule trigger in adf
4. tumbling window project

Want more similar videos- hit like, comment, share and subscribe

❤️Do Like, Share and Comment ❤️
❤️ Like Aim 5000 likes! ❤️

➖➖➖➖➖➖➖➖➖➖➖➖➖
Please like & share the video.
➖➖➖➖➖➖➖➖➖➖➖➖➖
Chapters:
0:00 Introduction
1:20 schedule vs tumbling window trigger in adf
3:40 tumbling window practical
8:00 azure data factory pipeline
➖➖➖➖➖➖➖➖➖➖➖➖➖
script

create table customer_sales (
product_id int,
product_type nvarchar(128),
sales_price int,
salestime datetime
)

insert into customer_Sales values(1,'mobile',10000,'2024‑03‑01 00:00:07.009')
insert into customer_Sales values(2,'freeze',40000,'2024‑03‑01 00:01:07.009')
insert into customer_Sales values(3,'mobile',40000,'2024‑03‑02 00:01:07.009')
insert into customer_Sales values(4,'tv',40000,'2024‑03‑02 00:01:07.009')
insert into customer_Sales values(5,'cooler',40000,'2024‑03‑03 00:01:07.009')
insert into customer_Sales values(6,'mobile',40000,'2024‑03‑04 00:01:07.009')
insert into customer_Sales values(7,'tv',40000,'2024‑03‑04 00:01:07.009')
insert into customer_Sales values(8,'cooler',40000,'2024‑03‑04 00:01:07.009')
insert into customer_Sales values(9,'mobile',40000,'2024‑03‑05 00:01:07.009')
insert into customer_Sales values(10,'tv',40000,'2024‑03‑05 00:01:07.009')
insert into customer_Sales values(11,'cooler',40000,'2024‑03‑05 00:01:07.009')

create procedure cust_sale
@startdate varchar(128),
@enddate varchar(128)
as begin
select * from customer_Sales
where salestime between @startdate and @enddate end

pipeline parameter

➖➖➖➖➖➖➖➖➖➖➖➖➖

Azure data factory :

PYSPARK PLAYLIST -

➖➖➖➖➖➖➖➖➖➖➖➖➖
📣Want to connect with me? Check out these links:📣

➖➖➖➖➖➖➖➖➖➖➖➖➖
what we have covered in this video:

tumbling window trigger in adf example
Tumbling window trigger adf tutorial
tumbling window vs schedule trigger in adf
Tumbling window trigger adf azure data factory
tumbling window trigger dependency
adf tumbling window trigger not running
event based trigger in adf
when to use tumbling window trigger

➖➖➖➖➖➖➖➖➖➖➖➖➖

Hope you liked this video and learned something new :)
See you in next video, until then Bye-Bye!

➖➖➖➖➖➖➖➖➖➖➖➖➖

[gudiatoka]

brother can we do naming convention dynamically like after stored it output there should be file name with date wise..please cover those

[sona]

one pipeline should trigger only after every 24 hour but why pipeline has triggered multiple times on single day

[vaibhavjoshi]

Awesome, awesome explanation. Thanks so much Sir!

[shankarkr]

Can tumbling window triggee used only for history data?, can we schedule for future as well?

[sureshmolabanti]

Can you please explain the custom trigger.

[coolraviraj]

parameters ka scene thora smjhana bro next time