astronomer.providers.amazon.aws.operators.redshift_sql

Module Contents

Classes

RedshiftSQLOperatorAsync

Executes SQL Statements against an Amazon Redshift cluster"
class astronomer.providers.amazon.aws.operators.redshift_sql.RedshiftSQLOperatorAsync(*, redshift_conn_id='redshift_default', poll_interval=5, **kwargs)[source]

Bases: airflow.providers.amazon.aws.operators.redshift_sql.RedshiftSQLOperator

Executes SQL Statements against an Amazon Redshift cluster”

Parameters:

  • sql – the 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_id (str) – reference to Amazon Redshift connection id

  • parameters – (optional) the parameters to render the SQL query with.

  • autocommit – if True, each command is automatically committed. (default value: False)

execute(context)[source]

Makes a sync call to RedshiftDataHook and execute the query and gets back the query_ids list and defers trigger to poll for the status for the query executed

execute_complete(context, event=None)[source]

Callback for when the trigger fires - returns immediately. Relies on trigger to throw an exception, otherwise it assumes execution was successful.