# Copy to .env (gitignored) and fill in. Dagster's commands and dbt (1.12+) load it automatically.
# Credentials only. The database is NOT set here: `make dev` / `make prod` choose it via NFL_ENV
# (a value in .env would override what you type in the shell, because Dagster's .env wins).
# Absolute key path: neither dbt-snowflake nor dagster-snowflake expands "~".
# Account identifier: <orgname>-<accountname>, e.g. myorg-myaccount
SNOWFLAKE_ACCOUNT=
SNOWFLAKE_USER=NFL_SVC
SNOWFLAKE_PRIVATE_KEY_PATH=/absolute/path/to/nfl_dagster_key.p8
# Where there's no key file (Dagster+), set SNOWFLAKE_PRIVATE_KEY to the key's PEM text instead.
# Set one or the other, never both.
SNOWFLAKE_ROLE=NFL_ROLE
SNOWFLAKE_WAREHOUSE=NFL_WH

# Serving database (Prisma Postgres) that the website reads: one direct (not pooled) connection
# string per environment. NFL_ENV picks which one is used.
SERVING_DB_URL_DEV=postgres://...@db.prisma.io:5432/postgres?sslmode=require
SERVING_DB_URL_PROD=postgres://...@db.prisma.io:5432/postgres?sslmode=require