u/Data-Queen-Mayra

Most Snowflake setups end up as a mix of tools, scripts, and manual clicks. We built Snowcap to handle it all in one place: warehouses, roles, grants, masking policies, dynamic tables, etc.

No state file. It queries Snowflake directly on every run and generates the SQL to match your config. If someone makes a change outside the tool, it catches it next run.

We wrote up the full overview here: https://datacoves.com/post/snowcap-snowflake-infrastructure-as-code

Happy to answer questions if anyone's dealing with Snowflake RBAC or provisioning headaches.

We put together a guide for setting up dbt with Snowflake from scratch and figured it might be useful here.

What it covers:

• Python, venv, and dbt-snowflake install
• Setting up the Snowflake user, role, warehouse, and database with the actual SQL
• Key pair authentication end-to-end
• profiles.yml and dbt_project.yml settings worth knowing about (transient tables, query tags, copy_grants, warehouse overrides)
• Official Snowflake Labs packages worth adding: dbt_constraints and dbt_semantic_view
• VS Code extensions the official Snowflake Extension, Power User for dbt, and SQLFluff
• How Snowflake Cortex CLI and other AI tools fit into the workflow
• Managing Snowflake infrastructure (roles, grants, masking, RBAC) alongside dbt

Anything we missed that you would add?

https://datacoves.com/post/dbt-snowflake