基于docker-compose

运行环境

  • docker-compose 文件
version: "3.8"
services:
lightdash:
image: lightdash/lightdash:latest
depends_on:
- db
environment:
- PGHOST=${PGHOST:-db}
- PGPORT=${PGPORT:-5432}
- PGUSER=${PGUSER:-postgres}
- PGPASSWORD=${PGPASSWORD}
- PGDATABASE=${PGDATABASE:-postgres}
- SECURE_COOKIES=${SECURE_COOKIES:-false}
- TRUST_PROXY=${TRUST_PROXY:-false}
- LIGHTDASH_SECRET=${LIGHTDASH_SECRET}
- PORT=${PORT:-8080}
- LIGHTDASH_LOG_LEVEL=${LIGHTDASH_LOG_LEVEL}
- LIGHTDASH_INSTALL_ID=${LIGHTDASH_INSTALL_ID}
- LIGHTDASH_INSTALL_TYPE=${LIGHTDASH_INSTALL_TYPE:-docker_image}
- AUTH_DISABLE_PASSWORD_AUTHENTICATION=${AUTH_DISABLE_PASSWORD_AUTHENTICATION}
- AUTH_GOOGLE_OAUTH2_CLIENT_ID=${AUTH_GOOGLE_OAUTH2_CLIENT_ID}
- AUTH_GOOGLE_OAUTH2_CLIENT_SECRET=${AUTH_GOOGLE_OAUTH2_CLIENT_SECRET}
- SITE_URL:${SITE_URL}
- EMAIL_SMTP_HOST=${EMAIL_SMTP_HOST}
- EMAIL_SMTP_PORT=${EMAIL_SMTP_PORT}
- EMAIL_SMTP_SECURE=${EMAIL_SMTP_SECURE}
- EMAIL_SMTP_USER=${EMAIL_SMTP_USER}
- EMAIL_SMTP_PASSWORD=${EMAIL_SMTP_PASSWORD}
- EMAIL_SMTP_ALLOW_INVALID_CERT=${EMAIL_SMTP_ALLOW_INVALID_CERT}
- EMAIL_SMTP_SENDER_NAME=${EMAIL_SMTP_SENDER_NAME}
- EMAIL_SMTP_SENDER_EMAIL=${EMAIL_SMTP_SENDER_EMAIL}
volumes:
- "${DBT_PROJECT_DIR}:/usr/app/dbt"
ports:
- ${PORT:-8080}:${PORT:-8080}


db:
image: postgres
restart: always
environment:
POSTGRES_PASSWORD: ${PGPASSWORD}
POSTGRES_USER: ${PGUSER:-postgres}
POSTGRES_DB: ${PGDATABASE:-postgres}
volumes:
- db-data:/var/lib/postgresql/data
volumes:
db-data:

.env 文件

PORT=8080
PGHOST=db
PGPORT=5432
PGUSER=postgres
PGDATABASE=postgres
PGPASSWORD=dalongdemo
SECURE_COOKIES=false
TRUST_PROXY=false
DBT_PROJECT_DIR=.
LIGHTDASH_SECRET=dalongdemo

说明

lightdash 支持本地的dbt 以及git 还有dbt 的cloudide，实际上上对于dbt 项目都会clone本地的

参考配置

​​https://docs.lightdash.com/get-started/setup-lightdash/install-lightdash​​

​​https://docs.lightdash.com/get-started/setup-lightdash/install-lightdash#deploy-manually​​

​​https://docs.lightdash.com/guides/how-to-deploy-to-kubernetes​​