.env.example

# Which backend Calibrate talks to. "duckdb" runs entirely locally against a
# real TPC-H benchmark dataset generated by DuckDB's own tpch extension - no
# account needed. "snowflake" points at a real Snowflake account's
# SNOWFLAKE_SAMPLE_DATA.TPCH_SF1 database.
CALIBRATE_BACKEND=duckdb

# Which LLM powers agent/core.py's generation loop. "anthropic" (default)
# needs ANTHROPIC_API_KEY and real account credit. "gemini" needs
# GEMINI_API_KEY only - Google AI Studio's free tier needs no credit card.
CALIBRATE_LLM_PROVIDER=anthropic

# Required when CALIBRATE_LLM_PROVIDER=anthropic.
# Get one at https://console.anthropic.com/settings/keys
ANTHROPIC_API_KEY=

# Required when CALIBRATE_LLM_PROVIDER=gemini.
# Get a free key (no credit card) at https://aistudio.google.com/apikey
GEMINI_API_KEY=
CALIBRATE_GEMINI_MODEL=gemini-flash-lite-latest

# Only required when CALIBRATE_BACKEND=snowflake. Sign up for a free trial
# at https://trial.snowflake.com - the sample data ships on every account.
SNOWFLAKE_ACCOUNT=
SNOWFLAKE_USER=
SNOWFLAKE_PASSWORD=
SNOWFLAKE_WAREHOUSE=COMPUTE_WH
SNOWFLAKE_ROLE=ACCOUNTADMIN
SNOWFLAKE_DATABASE=SNOWFLAKE_SAMPLE_DATA
SNOWFLAKE_SCHEMA=TPCH_SF1

# Where dbt writes BUILT models (staging/marts). Must be a database/schema
# your role can create objects in - SNOWFLAKE_SAMPLE_DATA above is
# read-only. On a fresh trial account, create these once with:
#   CREATE DATABASE IF NOT EXISTS CALIBRATE;
#   CREATE SCHEMA IF NOT EXISTS CALIBRATE.CALIBRATE_MARTS;
SNOWFLAKE_TARGET_DATABASE=CALIBRATE
SNOWFLAKE_TARGET_SCHEMA=CALIBRATE_MARTS

# Local DuckDB file path (used when CALIBRATE_BACKEND=duckdb)
DUCKDB_PATH=data/calibrate.duckdb

# Where governance audit log + validation run history are persisted
CALIBRATE_STATE_DB=data/calibrate_state.db