Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Scenario - Run daily and send report every 2 weeks
Added on November 2, 2023 8:10PM
Likes: 0
Replies: 1
Music1392
Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 6 ✭✭✭
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
Answers
-
LouisDHulst Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Neuron, Registered, Neuron 2023 Posts: 55 NeuronHi,
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:
Global variable:
Custom Python step:
Its not very pretty but I hope it helps!