Request a 30-minute demo

Our product expert will guide you through our demo to show you how to automate testing for every part of your workflow.

See data diffing in real time
Data stack integration
Discuss pricing and features
Get answers to all your questions
Submit your credentials
Schedule date and time
for the demo
Get a 30-minute demo
and see datafold in action
///
February 15, 2024

Quick Setup Guide to Installing dbt Core on an M1 Mac

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

No items found.
Kyle McNair

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 <span class="code">.dbt/profile.yml</span>

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 [email protected]

Make sure to match the dbt version of the project!

Clone GitHub repo

Helpful resources:

Configure profiles.yml

  1. 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 <span class="code">~/.dbt/profiles.yml</span> or set an environment variable <span class="code">DBT_PROFILES_DIR</span> with a path to a directory with your profiles.yml file.

<span class="code">dbt debug --config-dir</span> 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

Test your connection

Run <span class="code">dbt debug</span>

If checks pass, you’re ready to contribute to your dbt project!