RedshiftDataOperatorAsync
Astronomer ProvidersExecutes SQL Statements against an Amazon Redshift cluster. If there are multiple queries as part of the SQL, and one of them fails to reach a successful completion state, the operator returns the relevant error for the failed query.
Access Instructions
Install the Astronomer Providers provider package into your Airflow environment.
Import the module into your DAG file and instantiate it with your desired params.
Parameters
sqlthe SQL code to be executed as a single string, or a list of str (sql statements), or a reference to a template file. Template references are recognized by str ending in ‘.sql’
aws_conn_idAWS connection ID
parameters(optional) the parameters to render the SQL query with.
autocommitif True, each command is automatically committed. (default value: False)
Documentation
Executes SQL Statements against an Amazon Redshift cluster. If there are multiple queries as part of the SQL, and one of them fails to reach a successful completion state, the operator returns the relevant error for the failed query.