Terraform Snowflake Access Setup
Budget: $25 – $50 USD
I already manage my infrastructure with Terraform and now want my Snowflake environment folded into the same workflow. The repository, remote state, and CI pipeline are in place; what I am missing is clean, reusable code that provisions Snowflake user permissions (read + write) and the supporting database roles.
Here is what I need you to deliver:
• Terraform modules (or additions to my existing ones) that create the required database roles and map them to users with read-and-write privileges.
• Role hierarchy that follows Snowflake best practices—separation of duties, least-privilege, and future-grant support.
• Parameterised variables so new roles or users can be added by editing tfvars only.
• A brief README explaining module usage and any SnowSQL or provider requirements.
I will provide repository access, current backend configuration, and a sample list of users/roles. The work is complete when a plan/apply cycle finishes cleanly in my pipeline and the roles and privileges appear in Snowflake as specified.
Here is what I need you to deliver:
• Terraform modules (or additions to my existing ones) that create the required database roles and map them to users with read-and-write privileges.
• Role hierarchy that follows Snowflake best practices—separation of duties, least-privilege, and future-grant support.
• Parameterised variables so new roles or users can be added by editing tfvars only.
• A brief README explaining module usage and any SnowSQL or provider requirements.
I will provide repository access, current backend configuration, and a sample list of users/roles. The work is complete when a plan/apply cycle finishes cleanly in my pipeline and the roles and privileges appear in Snowflake as specified.