🔧 Setup

Setting up dbt with Snowflake:

• dbt Snowflake adapter
• Official guide

Authentication options:

Key pair authentication

• This is the recommended method for authenticating into Snowflake when using dbt
• It provides a secure setup suitable for automated workflows without requiring additional logins

User-password MFA

• To avoid push notifications for every model build, ensure the ALLOW_CLIENT_MFA_CACHING parameter is set to TRUE at the account level when using user-password MFA
• Snowflake also supports other TOTP-based MFA methods (e.g. Google Authenticator). While suitable for one-time logins, they are not compatible with running dbt models