RedshiftSQLOperator
AmazonExecutes SQL Statements against an Amazon Redshift cluster
Access Instructions
Install the Amazon 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’
redshift_conn_idreference to Amazon Redshift 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
See also
For more information on how to use this operator, take a look at the guide: Amazon Redshift