Overview:
Titan Core is an open-source infrastructure-as-code tool designed specifically for provisioning, deploying, and securing resources in Snowflake. It replaces separate tools like Terraform, Schemachange, and Permifrost by offering a unified declarative configuration approach. Instead of writing ad-hoc SQL scripts, users define their desired Snowflake state in YAML or Python files, and Titan Core generates the necessary SQL. It is built for DevOps engineers, analytics engineers using dbt, data platform teams managing Snowflake via CI/CD, and organizations preferring a git-based workflow for infrastructure management.
Core Features:
Declarative Configuration: Users define the desired state of Snowflake resources; Titan Core generates the SQL to match the account to that configuration.
Comprehensive Resource Support: Nearly every Snowflake resource type can be managed, including users, roles, warehouses, databases, schemas, integrations, pipes, stages, stored procedures, user-defined functions, and more.
Dual Configuration Format: Resource definitions can be written in either YAML or Python files.
Dynamic Role Switching: Automatically detects and switches to the correct Snowflake role required for each change, simplifying multi-role setups and reducing permission errors.
No State File Dependency: Plans and executes changes without relying on a state file, providing more accurate plans and eliminating stale state issues.
Export Functionality: A CLI command can generate configuration from existing Snowflake resources, aiding migration from manual setups or other tools.
Use Cases:
DevOps engineers automating the provisioning and ongoing management of Snowflake infrastructure.
Analytics engineers using dbt who want to manage Snowflake users, roles, schemas, and other objects without writing SQL migration scripts or dbt macros.
Data platform teams integrating Snowflake infrastructure changes into CI/CD pipelines with a git-based workflow.
Teams migrating away from Terraform specifically for Snowflake-related tasks, or replacing separate tools like Schemachange (for migrations) or Permifrost (for access management).
Why It Matters:
Titan Core addresses the complexity of managing Snowflake infrastructure by consolidating multiple tool categories—Terraform-like provisioning, schema migration, and permissions management—into a single, declarative tool. Its dynamic role switching directly solves a limitation of the Terraform Snowflake provider, which requires complex multi-provider setups. By being state-file-free and offering an export CLI, it lowers the friction of adopting infrastructure-as-code for existing Snowflake accounts. The open-source, Apache 2.0 license, combined with support for Python-based configurations, makes it accessible to teams wanting full control and transparency over their Snowflake infrastructure management.
