Quick setup guide to installing dbt Core on an M1 Mac

Overview on getting started with dbt Core via CLI on an M1 Mac.

This is a high-level overview on getting started with dbt Core via CLI, and is by no means canonical. This is targeted for those with an M1 Mac who prefer not to manage Python virtual environments or Docker.

Summary

Install Rosetta
Install Homebrew
Install dbt
Clone GitHub repo
Configure your .dbt/profile.yml

Install Rosetta

‍

From dbt: “If you’re using an M1 Mac, we recommend that you install dbt via Homebrew with Rosetta. This is necessary for certain dependencies that are only supported on Intel processors.”

/usr/sbin/softwareupdate --install-rosetta

Install Homebrew

/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

Install dbt

`brew update brew install git brew tap dbt-labs/dbt

brew install dbt-snowflake@1.0.0 ` Make sure to match the dbt version of the project!

Clone GitHub repo

Helpful resources:

Configure profiles.yml

Create a profiles.yml file using the next template:

`analytics: target: dev outputs: dev: type: snowflake account: ******** role: ******** # User/password auth user: ******** password: ********

database: ANALYTICS warehouse: INTEGRATION schema: ANALYTICS_DEV threads: 10 ` and put this file into ~/.dbt/profiles.yml or set an environment variable DBT_PROFILES_DIR with a path to a directory with your profiles.yml file.

dbt debug —config-dir is helpful for finding your directory:

`dbt-beers [master] dbt debug —config-dir 21:52:48 Running with dbt=1.1.1 21:52:48 To view your profiles.yml file, run:

open /Users/kylemcnair/.dbt `