source
, for the Pages
Table in Lightdash:
source
and the type will be inferred from the column in your database. You can see the full list of dimension types supported in Lightdash here.
Once you’ve added your dimensions, you can use them in Lightdash to build charts and filter results. Dimensions appear in the Explore view, above metrics and, if selected, pop us as blue fields in your results table.
source
and I wanted to add it as a dimension to Lightdash, I would just add the column to my .yml file like so:
lightdash preview
lightdash preview
comes in handy.
Developer previews are temporary Lightdash projects where you can safely experiment with your metrics, dimensions and charts without affecting your production project.
So, let’s spin up a developer preview and check out our changes. In your terminal, run the commands:
cmd
+ click
to open the preview link from your terminal. Once you’re in Lightdash go to Explore
—> Tables
, then click on the model you just updated to see your test
column and play around with it.
meta
tag of your columns, under dimension
:
main
or master
). You’ll also want to make sure that you’ve run your dbt models so that your new columns exist in your data warehouse.
Once they’ve been merged or if you’re just working off of main
(rebel 😏), you can deploy your changes. Just run these commands in your terminal from your dbt project:
dbt_khindson.my_model_names
), then you’ll need to pass the production target in your lightdash deploy
command. Something like: lightdash deploy --target prod
.main
or master
). You’ll also want to make sure that you’ve run your dbt models so that your new columns exist in your data warehouse.
Once they’ve been merged or if you’re just working off of main
(rebel 😏), you can deploy your changes.
To do this, you just need to hit refresh dbt
on the Explore View page in your project. Then, the new dimensions should appear for everyone in your project, automatically.