Amazon Redshift Operators

Amazon Redshift manages all the work of setting up, operating, and scaling a data warehouse: provisioning capacity, monitoring and backing up the cluster, and applying patches and upgrades to the Amazon Redshift engine. You can focus on using your data to acquire new insights for your business and customers.

Airflow provides operators to manage your Redshift clusters.

Prerequisite Tasks

Manage Amazon Redshift Clusters

Amazon Redshift Cluster Operator

To create an Amazon Redshift Cluster with the specified parameters ~airflow.providers.amazon.aws.operators.redshift_cluster.RedshiftCreateClusterOperator.

/../../airflow/providers/amazon/aws/example_dags/example_redshift_cluster.py

Amazon Redshift Cluster Sensor

To check the state of an Amazon Redshift Cluster until it reaches the target state or another terminal state you can use ~airflow.providers.amazon.aws.sensors.redshift_cluster.RedshiftClusterSensor.

/../../airflow/providers/amazon/aws/example_dags/example_redshift_cluster.py

Resume an Amazon Redshift Cluster

To resume a 'paused' Amazon Redshift Cluster you can use RedshiftResumeClusterOperator <airflow.providers.amazon.aws.operators.redshift_cluster>

/../../airflow/providers/amazon/aws/example_dags/example_redshift_cluster.py

Pause an Amazon Redshift Cluster

To pause an 'available' Amazon Redshift Cluster you can use RedshiftPauseClusterOperator <airflow.providers.amazon.aws.operators.redshift_cluster>

/../../airflow/providers/amazon/aws/example_dags/example_redshift_cluster.py

Delete an Amazon Redshift Cluster

To delete an Amazon Redshift Cluster you can use RedshiftDeleteClusterOperator <airflow.providers.amazon.aws.operators.redshift_cluster>

/../../airflow/providers/amazon/aws/example_dags/example_redshift_cluster.py

Reference

AWS boto3 Library Documentation for Amazon Redshift