dbt-core

Setting up dbt-core locally involves automated environment checks, dependency installation via pip or conda, and configuration of profiles.yml with your Snowflake credentials. This Skill automates those steps, validating your Python environment and virtualenv or conda setup, then generating secure connection templates for Snowflake authentication methods including PAT, SSO, key pair, and OAuth.

Configuring dbt-core for Snowflake requires selecting the right environment manager (conda or venv), installing dbt and Snowflake packages, then editing profiles.yml with authentication credentials. This Skill automates environment detection, guides you through dependency installation, and provides pre-built configuration templates for all Snowflake authentication methods, eliminating manual configuration errors.

Both conda and pip can install dbt-core; the choice depends on your environment and existing Python setup. This Skill diagnoses your system, offers both conda and virtualenv paths, validates your choice, installs dependencies through the appropriate package manager, and confirms successful installation before proceeding to project configuration.

Installation problems typically stem from missing dependencies, conflicting Python versions, or incomplete environment setup. This Skill runs diagnostic scripts to identify environment gaps, validates conda or venv availability, checks curl and pip functionality, and guides remediation before initiating fresh installation and project initialization.

Yes, dbt-core project setup can be fully automated through environment validation, dependency installation, and template generation. This Skill initializes new dbt projects non-interactively, generates dbt_project.yml and profiles.yml with Snowflake templates, and validates configuration readiness for development workflows without manual file editing.