Does anyone know how to execute a SQL query BEFORE starting a data Export in Celigo? We need to run a query that updates a table, before the export should run.

@scottvonduhn can you just daisy-chain the flows? Have one flow that runs the table update, and then have a second flow run immediately after it? https://docs.celigo.com/hc/en-us/articles/5926335821211-Daisy-chain-flows

Yep, I think that is the way to do it. I was hoping to do it all in one flow, rather than have a flow that just runs a single query, but I don’t see any other option. Thank you!

We considering adding something like that would help — see https://integrator.io/productPortal | “Under Consideration” | “Add pre-flow and post-flow steps”, which you can vote on. 😉

thanks, i’ll do just that! in the meanwhile, this isn’t the worst workaround

Thanks for confirming, @scottvonduhn, glad it works for you