Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

Scenario - Run daily and send report every 2 weeks

Music1392
Level 2
Scenario - Run daily and send report every 2 weeks

I have a project's current scenario as daily refresh of data and sending to Tableau server based on SQL query change trigger. I have a SQL that is checking the system load date. If system load date = today's date then the trigger will start. My question is how do I keep the current scenario and send dataset via email every 2 weeks?


Operating system used: Windows


Operating system used: Windows

0 Kudos
1 Reply
LouisDHulst

Hi,

My first idea would be to configure the built-in Mail reporter, and to change the Run condition to include a variable that you can set in a Python step. You would first have to set up a global variable as a reference point for the 2 weeks condition.

So something like:

 

Mail Report + Run condition:

image.png

 

 

 

 

 

 

Global variable:

image.png

 

 

 

 

Custom Python step:

image.png

 

 

 

 

 

 

 

 

 

Its not very pretty but I hope it helps!

0 Kudos