Lightdash

Lightdash | BI for teams that move fast

Lightdash instantly turns your dbt™️ project into a full-stack BI platform. Analysts write metrics and Lightdash enables self-serve for the entire business.

Paradime integrates natively with Lightdash CLI to enable you to develop Lightdash metrics in your dbt™️ project.

Setup a Lightdash instance

To get started you will need to setup a Lightdash instance. You can choose between Lightdash Cloud or Self-Host.

Lightdash Cloud vs. Self-Hosted | Documentation | Lightdash

Develop Lightdash metrics

To get started developing in the Paradime Integrated Terminal open a new terminal tab and login to authenticate with Lightdash depending on your authentication method.

Authenticating your CLI (login) | Documentation | Lightdash

Lightdash CLI

Paradime support Lightdash CLI to help your develop your Lightdash metrics at scale. Autogenerate Lightdash-ready YAML, Lightdash Preview to experiment with your metrics and deploy your new metrics to Lightdash.

To see the full list of CLI options, in the Paradime Terminal use:

lightdash --help

Deploy Lightdash

You can use Paradime Bolt schedules to deploy to Lightdash new changes from your dbt™️ project after a PR is merged using a Paradime CD schedule or after each production run.

Sync your changes with Lightdash deploy | Documentation | Lightdash

1. Add your Lightdash credentials to your Paradime workspace

In Paradime, navigate to account settings > workspaces and add the Lightdash required credentials to enabled the Paradime scheduler to trigger lightdash deploy during a run.

You should set the below credentials as environment variables for your workspace in Paradime.

• LIGHTDASH_API_KEY

• LIGHTDASH_PROJECT

• LIGHTDASH_URL

💡 How can I find the required credentials in Lightdash?

• 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. Setup a paradime schedule with the lightdash deploy command

In your Paradime Bolt schedule, in the commands section add the lightdash deploy step. This will trigger a lightdash deploy after your dbt™️ commands have been executed. This will ensure changes in your dbt™️ project are made available in your lightdash project.

paradime_schedules.yml

schedules:
  - name: run_with_re_data
    schedule: "*/10 * * * *"
    environment: production
    commands:
      - dbt seed
      - dbt run
      - lightdash deploy
    owner_email: "[e-mail]"
    slack_on:
      - passed
      - failed
    slack_notify:
      - "#data-alerts"
      - "@john"
    email_notify:
      - "[e-mail]"
      - "[e-mail]"
    email_on:
      - passed
      - failed