foem/sample.env at main · fastomop/foem · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
# Database Configuration
# Uncomment and configure the appropriate section for your database type

# =============================================================================
# PostgreSQL Configuration (default)
# =============================================================================
DB_TYPE=postgresql
DB_CONNECTION_STRING=postgresql://username:password@localhost:5432/omop_database

# =============================================================================
# Databricks Configuration
# =============================================================================
# DB_TYPE=databricks
# DATABRICKS_SERVER_HOSTNAME=your-workspace.cloud.databricks.com
# DATABRICKS_HTTP_PATH=/sql/1.0/warehouses/abc123def456789
# DATABRICKS_ACCESS_TOKEN=your_personal_access_token_here
# DATABRICKS_CATALOG=main
# DATABRICKS_SCHEMA=default

# =============================================================================
# How to get Databricks configuration values:
# =============================================================================
# 1. DATABRICKS_SERVER_HOSTNAME:
#    - Go to your Databricks workspace
#    - Found in the URL: https://<SERVER_HOSTNAME>/
#    - Example: dbc-12345678-abcd.cloud.databricks.com
#
# 2. DATABRICKS_HTTP_PATH:
#    - Go to SQL Warehouses in your Databricks workspace
#    - Select your warehouse
#    - Go to "Connection details" tab
#    - Copy the "HTTP Path" value
#    - Example: /sql/1.0/warehouses/abc123def456789
#
# 3. DATABRICKS_ACCESS_TOKEN:
#    - Go to User Settings > Developer > Access tokens
#    - Click "Generate new token"
#    - Copy and save the token securely
#
# 4. DATABRICKS_CATALOG (optional):
#    - Your Unity Catalog name (default: main)
#
# 5. DATABRICKS_SCHEMA (optional):
#    - Your schema/database name (default: default)