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/work...