RedshiftSQLOperator

Amazon

Executes SQL Statements against an Amazon Redshift cluster

View on GitHub

Last Updated: May. 23, 2022

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

sqlRequiredthe 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

Was this page helpful?