Automating Your Local DBT & Snowflake Playground with Python
This project automates the creation of dbt source YAML and SQL model files for Snowflake databases by extracting metadata via the Snowflake API — freeing users from manual file creation.
Build your Snowflake playground faster, with scripts:
- Pull metadata from Snowflake
- Generate correct dbt source files
- Prepare ready-to-use dbt models
- Connects securely to Snowflake using environment variables
- Supports multiple schemas via configuration
- Creates directory structure matching dbt conventions
- Generates YAML & SQL files per table/view
- Compatible with dbt Core and Snowflake adapter
- Python 3.13+
- Snowflake account (trial or production)
- Installed packages:
dbt-core,dbt-snowflake,snowflake-connector-python,pandas
Detailed and step-by-step instructions at https://dev.to/arunkumar_panneerselvam_2/automating-your-local-dbt-snowflake-playground-with-python-7gl