Is there a way for a Flow to be interrupted if the database is not updated?

[41f685681a7a84139e18]

I have a Flow that adds data to a BigQuery table every day at 8am, but I don't want it to run if the source table isn't up to date.

Can Dataprep do this?

[rajeshkannanr]

Hi Lucas,

This use case is achievable as below:

Develop a python script which does the below. Also, you can evaluate GCP Cloud Function service for automating your use case.

• Check if the database table is updated.
• If updated, call our jobGroup or FlowRun API to trigger the job.

Documentation for API

Run Job Group API

https://api.trifacta.com/dataprep-enterprise-cloud22/index.html#operation/runJobGroup

Run Flow API

https://api.trifacta.com/dataprep-enterprise-cloud22/index.html#operation/runFlow

I hope the above information helps.

Regards,

Rajesh.