This is a reference to all environment variables that can be used to configure a Lightdash deployment.
Variable
Description
Required?
Default
PGHOST
Hostname of postgres server to store Lightdash data
PGPORT
Port of postgres server to store Lightdash data
PGUSER
Username of postgres user to access postgres server to store Lightdash data
PGPASSWORD
Password for PGUSER
PGDATABASE
Database name inside postgres server to store Lightdash data
PGCONNECTIONURI
Connection URI for postgres server to store Lightdash data in the format postgresql://user:password@host:port/db?params. This is an alternative to providing the previous PG variables.
LIGHTDASH_SECRET
Secret key used to secure various tokens in Lightdash. This must be fixed between deployments. If the secret changes, you won’t have access to Lightdash data.
SECURE_COOKIES
Only allows cookies to be stored over a https connection. We use cookies to keep you logged in. This is recommended to be set to true in production.
false
COOKIES_MAX_AGE_HOURS
How many hours a user session exists before the user is automatically signed out. For example if 24, then the user will be automatically after 24 hours of inactivity.
TRUST_PROXY
This tells the Lightdash server that it can trust the X-Forwarded-Proto header it receives in requests. This is useful if you use SECURE_COOKIES=true behind a HTTPS terminated proxy that you can trust.
Internal Lightdash host for the Headless browser to send requests when your Lightdash instance is not accessible from the Internet. Needs to support https if SECURE_COOKIES=true
Same as SITE_URL
STATIC_IP
Server static IP so users can add the IP to their warehouse allow-list.
http://localhost:8080
LIGHTDASH_QUERY_MAX_LIMIT
Query max rows limit
5000
SCHEDULER_ENABLED
Enables/Disables the scheduler worker that triggers the scheduled deliveries.
true
SCHEDULER_CONCURRENCY
How many scheduled delivery jobs can be processed concurrently.
3
SCHEDULER_JOB_TIMEOUT
After how many milliseconds the job should be timeout so the scheduler worker can pick other jobs.
600000 (10 minutes)
LIGHTDASH_CSV_CELLS_LIMIT
Max cells on CSV file exports
100000
LIGHTDASH_CHART_VERSION_HISTORY_DAYS_LIMIT
Configure how far back the chart versions history goes in days
3
LIGHTDASH_PIVOT_TABLE_MAX_COLUMN_LIMIT
Configure maximum number of columns in pivot table
60
GROUPS_ENABLED
Enables/Disables groups functionality
false
AUTH_ENABLE_OIDC_LINKING
Enables/Disables linking the new OIDC(aka SSO) identity to an existing user if they already have another OIDC with the same email
These variables allow you to customize the default appearance settings for your Lightdash instance’s organizations. This color palette will be set for all organizations in your instance. You can’t choose another one while these env vars are set.
Variable
Description
Required?
Default
OVERRIDE_COLOR_PALETTE_NAME
Name of the default color palette
OVERRIDE_COLOR_PALETTE_COLORS
Comma-separated list of hex color codes for the default color palette (must be 20 colors)