Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

DWH Daily Exports - rolling date Ranges

laetizia_w
Level 5
Level 5

Is there a possibility to have a daily dwh export with rolling date ranges? I have tried something like this:

date 1.1.2018 until yesterday and granularity daily. Then I have set it up for send it later plus changed ith to schedule daily. But it swnds me data only once and then the schedule stops and I get nothing afterwards.

I would like to get something like this.

What I have done for now to have at least the daily data to set it for yesterday and on daily basis and scheduling it daily so I get at least daily the data for yesterday.

I hope someone could help out.

Best

1 Accepted Solution
Gigazelle
Correct answer by
Employee
Employee

Data Warehouse doesn't allow daily scheduling if the data range is too wide. I think(?) anything longer than 2 weeks won't allow daily scheduling.

Try shortening your date range then scheduling it for daily delivery. Let me know if that doesn't work for you.

View solution in original post

1 Reply
Gigazelle
Correct answer by
Employee
Employee

Data Warehouse doesn't allow daily scheduling if the data range is too wide. I think(?) anything longer than 2 weeks won't allow daily scheduling.

Try shortening your date range then scheduling it for daily delivery. Let me know if that doesn't work for you.

View solution in original post