The Execute SQL flow runs any SQL statement, multiple ;-separated statements, or an anonymous SQL block in a configured database. The SQL runs directly in the target database engine and does not use local resources.
How do I set this up?
- In Connections, create a database connection and test it.
- In Flows, create a new Execute SQL flow.
- Select the destination connection.
- Enter the SQL and save the flow.
- Execute the flow manually.
-
Schedule the flow to run periodically.