RedshiftDataOperator

Amazon

Executes SQL Statements against an Amazon Redshift cluster using Redshift Data

View on GitHub

Last Updated: Jun. 22, 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

databasethe name of the database
sqlthe SQL statement text to run
cluster_identifierunique identifier of a cluster
db_userthe database username
parametersthe parameters for the SQL statement
secret_arnthe name or ARN of the secret that enables db access
statement_namethe name of the SQL statement
with_eventindicates whether to send an event to EventBridge
await_resultindicates whether to wait for a result, if True wait, if False don’t wait
poll_intervalhow often in seconds to check the query status
aws_conn_idaws connection to use
regionaws region to use

Documentation

Executes SQL Statements against an Amazon Redshift cluster using Redshift Data

See also

For more information on how to use this operator, take a look at the guide: Execute a statement on an Amazon Redshift cluster

Was this page helpful?