Deploy Lightdash

Open-source BI on your dbt project: web, scheduler, renderer, Postgres, S3

Deploy Lightdash

/var/lib/postgresql/data

Just deployed

Bucket

Bucket

Just deployed

Deploy and Host Lightdash on Railway

Lightdash is an open-source business intelligence tool that sits on top of your dbt project. Metrics and dimensions you define in dbt YAML become a point-and-click explorer, a SQL runner, charts, dashboards and scheduled deliveries, so analysts and business users work from the same definitions that live in version control.

About Hosting Lightdash

Lightdash needs more than its web server. This template runs the stack upstream uses in production, wired over Railway's private network: the Lightdash web app and API (public, runs database migrations on boot), a separate Scheduler worker for scheduled deliveries, CSV/XLSX exports and validation, a Browserless headless Chromium that renders chart and dashboard images, PostgreSQL 18 on a volume for Lightdash's metadata, and a Railway Bucket for query results and exports. The encryption secret and database password are generated at deploy time, and the deployer isn't asked for anything. Open the public URL and register: the first account creates the organization and becomes admin, and later users need an invite.

Common Use Cases

  • Self-serve analytics on top of an existing dbt project, with metrics defined once in code
  • Dashboards and scheduled Slack or email deliveries of charts and CSV exports
  • A self-hosted alternative to Looker or Metabase for teams already using dbt

Dependencies for Lightdash Hosting

  • A data warehouse Lightdash can query (BigQuery, Snowflake, Postgres, Redshift, Databricks, Trino, ClickHouse and others)
  • A dbt project, connected from GitHub, GitLab, Bitbucket, Azure DevOps or dbt Cloud, or pushed with the Lightdash CLI

Deployment Dependencies

Implementation Details

Services in this template:

  • Lightdash: web app and API, the only public service. Health check /api/v1/health.
  • Scheduler: background worker (node dist/scheduler.js) for scheduled deliveries, exports and validation jobs. The web service runs with SCHEDULER_ENABLED=false, as upstream recommends when a separate worker runs.
  • Browserless: headless Chromium, private network only, used for chart and dashboard images.
  • Postgres: Lightdash's metadata (users, projects, charts, dashboards, schedules), on a volume.
  • Bucket: query results, exports and rendered images. Downloads go through presigned links.

After deploy: register the first user at the public URL, then connect your warehouse and dbt project. Optional features are added as variables on both Lightdash and Scheduler: SMTP (EMAIL_SMTP_*) for invites and email deliveries, Slack (SLACK_*), Google SSO (AUTH_GOOGLE_*). If you add a custom domain, set SITE_URL on both services to it. Don't change LIGHTDASH_SECRET after the first deploy: it encrypts your warehouse credentials.

Updates: every app service builds from the template's GitHub repo. When the pinned versions are bumped there, Railway shows an update notice on your project and you choose when to apply it. Read the repo's CHANGELOG first. Lightdash migrates its database on boot.

Why Deploy Lightdash on Railway?

Railway is a singular platform to deploy your infrastructure stack. Railway will host your infrastructure so you don't have to deal with configuration, while allowing you to vertically and horizontally scale it.

By deploying Lightdash on Railway, you are one step closer to supporting a complete full-stack application with minimal burden. Host your servers, databases, AI agents, and more on Railway.


Template Content

More templates in this category

View Template
Plausible WordPress
Cookie-free WordPress stats from your own Plausible

onepush
0
View Template
Typesense Multilingual
Locale-aware multilingual search with Typesense

onepush
0
View Template
Formbricks
Surveys, NPS and in-app feedback on your own Postgres, Hub and Cube

Two Workspaces
3