Run SQL File Task in Astera Data Stack
In this video, we will be learning how to seamlessly integrate SQL code stored in a.SQL file into a workflow, automating database operations effortlessly by using the Run SQL File Task.
The Run SQL File task runs the SQL code inside a file of.sql extension as part of a workflow.
Contents of the video:
- Establishing a database connection
- Configuring the Run SQL File Properties
- Workflow scenario demonstration
- Integration with Run Dataflow and Send Mail tasks
Read more about using the Run SQL File task:
https://documentation.astera.com/workflows/run-sql-file