In this tutorial, you'll setup Lightdash and connect it to your dbt project on dbt cloud. dbt cloud provides a development environment that makes it really easy to your develop your dbt project code, with Lightdash you can also visualise your dbt models while developing you code.
- A dbt cloud account. If you don't have one, sign up for a free here
- A heroku account. We'll use heroku to deploy your own self-hosted lightdash instance. Signup for free here
- Your dbt cloud account should have at least one environment (data warehouse) configured
- Your dbt cloud account environment should be using dbt version
Click to deploy the latest version of Lightdash to heroku. This provides a secure, production-ready deployment connected to your dbt cloud account:
Note if you don't have an account, you'll be prompted to signup. It's free to deploy Lightdash!
After you hit deploy, you'll be asked to provide some credentials to connect to your dbt cloud project:
2a. Get your
project_id from your dbt cloud project#
Login to dbt cloud and follow these instructions to get your account and project id:
- Make sure you have the correct project selected in the drop down settings
- Get your
account_idfrom the URL after
- Get your
project_idfrom the URL after
project_id in the heroku setup form.
2b. Get your
Use the sidebar to see all your environments. To connect to your dbt IDE you must select your development credentials with
type: development. This should be the environment you usually use when developing in the dbt cloud IDE.
Once you've located your environment follow these steps to get your environment id:
- Get your
environment_idfrom the URL after
- Check that your environment is using dbt
0.20.0or above (you can change this in environment settings)
environment_id to your heroku setup form.
2c. Get your
You can get your personal api key by visiting your API Access - Your profile.
It's a secret! Remember to keep your api key safe as it enables access to your dbt cloud account.
api_key to your
lightdash.yml heroku setup form.
Open your development environment in dbt cloud.
Heroku will show that it's setting up and deploying Lightdash. When it's complete you should see an option to view your Lightdash app.
As the first user for Lightdash, you'll be prompted to create an admin account to secure your instance: