Database access permissions as code

Does anyone know of any tools that let you manage data warehouse permissions as code (kinda like terraform for managing infrastructure)?

dan-hunt's avatar

If you're using Snowflake, the excellent Chan-Zuckerberg terraform provider is a good bet.
We use this, paired with Atlantis for managing the pull request workflow (plan, approve,

Permifrost by the Gitlab team is also intended for this purpose, although I haven't tried using this one.

1 point
pablankley's avatar
@pablankley (replying to @dan-hunt )

Thanks for the Chan Zuckerberg option, I hadn't heard of that and it looks spot on for my use case!

1 point
The community for power users.