terraform-provider-snowflake
Terraform provider for managing Snowflake accounts, databases, warehouses, users, roles, and other resources.
What is terraform-provider-snowflake?
The Snowflake Terraform Provider is an open-source Terraform provider that allows developers and DevOps teams to manage Snowflake cloud data warehouse resources using infrastructure as code. It solves the problem of manual, error-prone Snowflake configuration by enabling automated, version-controlled provisioning of databases, warehouses, users, roles, and other account objects.
DevOps engineers, data engineers, and platform teams who use Snowflake and want to automate its infrastructure management through Terraform for consistency, reproducibility, and collaboration.
Developers choose this provider because it is the official and most comprehensive Terraform integration for Snowflake, offering stable resources, preview features for early access, and strong support through documentation, migration guides, and community discussions.
Overview
Terraform provider for managing Snowflake accounts
Use Cases
Best For
- Automating Snowflake account setup and resource provisioning
- Managing Snowflake user roles and permissions as code
- Version-controlling database and warehouse configurations
- Integrating Snowflake infrastructure into CI/CD pipelines
- Ensuring consistent environments across development, staging, and production
- Querying existing Snowflake resources for Terraform state management
Not Ideal For
- Teams needing immediate, fully stable access to all Snowflake features without experimental resources
- Projects on unsupported architectures like FreeBSD or Windows 386 where fixes are not prioritized
- One-off or ad-hoc Snowflake tasks where Terraform setup overhead outweighs benefits
- Organizations lacking DevOps expertise to manage Terraform state and authentication securely
Pros & Cons
Pros
Supports creating and managing a wide range of Snowflake resources like databases, warehouses, and users, enabling full infrastructure as code, as detailed in the Key Features.
For stable resources from v2.0.0, Snowflake provides official support through their support channels, ensuring reliability for production use, as noted in the Support section.
Offers access to experimental resources via configuration flags, allowing teams to test new features early, though with clear warnings about stability from the disclaimer.
Officially supports key architectures like Linux amd64/arm64 and Darwin amd64/arm64, making it versatile for different deployment environments, as listed in Supported Architectures.
Cons
Preview resources are subject to breaking changes without major version bumps and are not officially supported, posing risks for production environments, as warned in the disclaimer.
Official support only covers stable resources from v2.0.0; users on older versions or using preview features must rely on community help, limiting assurance for critical issues.
Additional configurations like FreeBSD or 386 are not officially supported, and fixes are not prioritized, which can hinder deployment in niche environments.
Frequently Asked Questions
Related Projects
terraform-provider-githubTerraform GitHub provider
terraform-provider-dominosThe Terraform plugin for the Dominos Pizza provider.
terraform-provider-keycloakTerraform provider for Keycloak
terraform-provider-hcloudTerraform Hetzner Cloud provider
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.