Scheduled sync
Recipe — copy tables every night from an operational database to a reporting database with sql_copy, refresh the aggregates with sql_query, and be warned when it fails or does not run.
API pull
Recipe — fetch records from a REST API every hour with a Python step and write them through a connector's query, with the token kept out of the job.
Conditional cleanup
Recipe — purge old rows every night, but only when there are enough of them, in batches, with the decision and the counts in the run log.