env.example.env

# Copy to env.env at the repository root and fill in credentials.
# Repo-relative paths work from the repository root.

OPENAI_API_KEY=sk-your-key-here

PGHOST=localhost
PGPORT=5432
PGUSER=postgres
PGPASSWORD=your-password
PGDATABASE=rental_shop
PGSCHEMA=public

# Restricted consumer login for RBAC live tests (see scripts/sql/grant_pguser2_rental_shop.sql).
# Create role pguser2 in PostgreSQL first, then apply the grant script before running live_tests.
PGUSER2=pguser2
PGPASSWORD2=your-password

DATABRICKS_HOST=your-workspace.cloud.databricks.com
DATABRICKS_HTTP_PATH=/sql/1.0/warehouses/your-warehouse-id
DATABRICKS_TOKEN=dapi-your-token
DATABRICKS_CATALOG=dev
DATABRICKS_SCHEMA=rental_shop

MYSQL_HOST=localhost
MYSQL_PORT=3306
MYSQL_USER=root
MYSQL_PASSWORD=your-password
MYSQL_DATABASE=rental_shop

MARIADB_HOST=localhost
MARIADB_PORT=3306
MARIADB_USER=root
MARIADB_PASSWORD=your-password
MARIADB_DATABASE=rental_shop

SNOWFLAKE_ACCOUNT=your-account
SNOWFLAKE_USER=your-user
SNOWFLAKE_PRIVATE_KEY_PATH=secrets/snowflake/rsa_key.p8
SNOWFLAKE_WAREHOUSE=COMPUTE_WH
SNOWFLAKE_DATABASE=RENTAL_SHOP
SNOWFLAKE_SCHEMA=PUBLIC

SQLSERVER_HOST=localhost
SQLSERVER_PORT=1433
SQLSERVER_USER=sa
SQLSERVER_PASSWORD=your-password
SQLSERVER_DATABASE=rental_shop
SQLSERVER_SCHEMA=dbo
SQLSERVER_AUTH_MODE=sql
SQLSERVER_DRIVER=ODBC Driver 18 for SQL Server

ORACLE_HOST=localhost
ORACLE_PORT=1521
ORACLE_USER=rental_shop
ORACLE_PASSWORD=your-password
ORACLE_SERVICE_NAME=FREEPDB1
ORACLE_SCHEMA=RENTAL_SHOP
ORACLE_AUTH_MODE=password

BIGQUERY_PROJECT=your-gcp-project
BIGQUERY_DATASET=rental_shop
# Dataset region (must match where the dataset was created), not your GCP account country
BIGQUERY_LOCATION=region

REDSHIFT_HOST=your-cluster.region.redshift.amazonaws.com
REDSHIFT_PORT=5439
REDSHIFT_USER=admin
REDSHIFT_PASSWORD=your-password
REDSHIFT_DATABASE=dev
REDSHIFT_SCHEMA=dvdrental_new

DUCKDB_PATH=scripts/duckdb/rental_shop.duckdb
DUCKDB_SCHEMA=main

SQLITE_PATH=scripts/sqlite/rental_shop.sqlite