Run SQL File Task in Astera Data Stack

Run SQL File Task in Astera Data Stack

Feb 23, 2024

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