Is it doable to schedule my workflow according to specific datetime column in database table ?
Redshift database > calendar_table > due_datetime_column
example:
2024-01-01
2024-01-08
2024-01-10
2024-02-06
etc...
no pattern on the dates
@ahmadhw - I would create a simple workflow that would read your db and compare values in db against the current date. Then, if TRUE, would trigger the required workflow via API.
Alternatively, you can create a workflow that will create schedules based on values in the table leveraging API V3 (POST /v3/schedules).
Hope that helps.
You could make use of control containers...
Schedule your workflow daily. If your date-table contains todays date, the following containers will be executed.
.
this gonna work on alteryx gallery as custom schedule, right ?
Great Great idea actually, I will use it as plan B, But I wish I can do that in custom dates only on alteryx server (Gallery)