.env.example

# ============================================================================
# Databricks SQL Co-Pilot — Environment Variables
# ============================================================================
# Copy this file to .env.local and fill in your values:
#   cp .env.example .env.local
#
# On Databricks Apps, most of these are injected automatically via app
# resources and the service principal. See docs/07_DEPLOYMENT.md.
# ============================================================================

# --- Required (Databricks connection) ---

# Workspace hostname (e.g. adb-1234567890123456.7.azuredatabricks.net)
DATABRICKS_HOST=

# SQL Warehouse ID (bound via app.yaml valueFrom: sql-warehouse on Databricks Apps)
DATABRICKS_WAREHOUSE_ID=

# --- Authentication (choose one mode) ---

# Auth mode: "obo" (on-behalf-of, default) or "sp" (service principal)
# AUTH_MODE=obo

# Service principal credentials (injected by Databricks Apps, or set manually)
# DATABRICKS_CLIENT_ID=
# DATABRICKS_CLIENT_SECRET=

# Personal access token (local dev only — do NOT use in production)
# DATABRICKS_TOKEN=

# --- Optional (persistence with Lakebase) ---

# Set to "true" to enable Lakebase auto-provisioning for query actions,
# rewrite cache, triage cache, and health snapshots.
# ENABLE_LAKEBASE=false

# If you have an existing Lakebase/Postgres URL, set it here instead.
# When set, auto-provisioning is skipped.
# DATABASE_URL=

# --- Optional (AI / observability) ---

# Directory for prompt debug logs (default: ./logs/prompts)
# PROMPT_LOG_DIR=./logs/prompts

# Set to "true" to log full AI prompts and responses (includes SQL text!)
# WARNING: Only enable in dev — raw SQL will be written to disk.
# PROMPT_LOG_VERBOSE=false

# Data source for performance insights: "system" (default) or "custom"
# INSIGHT_SOURCE=system

# --- Optional (Databricks Apps port) ---

# Port the app listens on (default: 3000, Databricks Apps sets this automatically)
# DATABRICKS_APP_PORT=3000