Airflow EDW Grants

System Requirements

• Airflow Versions: 2.4.0 or newer
• Redshift EDW

Overview

The Airflow EDW Grants plugin is an Apache Airflow extension designed to facilitate the management of user roles and permissions within an Enterprise Data Warehouse (EDW), specifically for Amazon Redshift. This plugin empowers data engineers and administrators to create, modify, and connect user roles seamlessly from the Airflow UI, enhancing operational efficiency and security within your data environment.

Features

• User Management: Create and manage users directly from the Airflow UI.
• Role Management: Define and modify roles associated with users.
• Connection Management: Easily connect users to their respective roles, ensuring proper access control and security.
• Integration with Redshift: Specifically designed to work with Amazon Redshift, making it ideal for organizations leveraging this data warehousing solution.

Installation

You can install the plugin via pip:

pip install airflow-edw-grants

and restart the web server.

Add redshift_connection_grants_name variable with your Redshift connection name or create Redshift connection with a name edw_con.