Lightdash

Lightdash transforms your dbt™ project into a full-stack BI platform, enabling self-serve analytics for your entire organization. Paradime's native integration with Lightdash CLI allows you to develop and deploy Lightdash metrics directly from your development environment.

Prerequisites

Development Setup

Authenticating with LightDash

  1. In the Code IDE, open the Paradime Integrated Terminal

  2. Follow Lightdash documentation and run authentication commands.

  3. Follow the prompts to complete authentication

Using Lightdash CL

The Lightdash CLI in Paradime enables you to:

View available commands:

lightdash --help

Deployment Setup

Enable automatic deployment of your dbt™ project changes to Lightdash using Paradime Bolt schedules.

1. Configure Lightdash Credentials

  1. From any page in Paradime, Click Settings

  2. Navigate to Workspaces > Environment Variables

  3. In the Bolt Schedules section, click Add New

  4. Configure each required variable:

    • LIGHTDASH_API_KEY: Personal access token

    • LIGHTDASH_PROJECT: Project UUID

    • LIGHTDASH_URL: Instance URL

Finding your Lightdash credentials
  • LIGHTDASH_API_KEY

Create a new personal access token, by going to Settings > Personal Access Tokens. This is the token you'll put in for LIGHTDASH_API_KEY.

  • LIGHTDASH_PROJECT

The UUID for your project. For example, if your URL looks like https://eu1.lightdash.cloud/projects/3538ab33-dc90-aabb-bc00-e50bba3a5f69/tables, then 3538ab33-dc90-45f0-aabb-e50bba3a5f69 is your LIGHTDASH_PROJECT

  • LIGHTDASH_URL

This is either https://eu1.lightdash.cloud or https://app.lightdash.cloud (check the URL to your Lightdash project)

2. Configure Deployment Schedule

  1. Create or edit a Bolt schedule

  2. Add the lightdash deploy command

  3. This will:

    • Execute after your dbt™ commands complete

    • Deploy changes to your Lightdash project

    • Keep metrics in sync with your dbt™ project

You can configure this as part of a CD schedule to deploy changes automatically after PR merges.

Last updated

Was this helpful?