Hipposys - Data & AI Engineering
When managing multiple Redshift databases, especially if you have a separate Airflow instance for each one (like we do for a client), handling users, roles, and access can quickly become a complex task. Traditionally, this would require running SQL queries to create roles, users, and manage permissions on your Redshift databases. For those not familiar with SQL, this can be a daunting challenge.
In this post, we introduce the Airflow-EDW-Grants plugin—a solution that simplifies the process. With this plugin, you can easily create users, roles, and manage their relationships directly from Airflow, without needing to write a single line of SQL or interact with Redshift metadata tables.
This plugin is designed for users who need to manage Redshift roles and users but don't necessarily work with Redshift every day. Whether you're a Project Manager or someone without deep SQL knowledge, this tool provides an easy interface to control access to your Redshift databases. Once set up, non-technical users can manage roles and users efficiently, all within Airflow.
Thanks for reading Hipposys - Data & AI Engineering! Subscribe for free to receive new posts and learn more about our work.
