Lightdash connects to Honeydew via JDBC connection, using the Trino protocol.
With Metadata Sync, Honeydew can synchronize metadata such as field definitions and descriptions to Lightdash. This allows users to see in Lightdash all attributes and metrics that are available in Honeydew.
Create a new repository in your git provider, or use an existing repository
Create a new dbt project in the repository, or use an existing dbt project
Here’s a sample empty dbt_project.yml
file, if starting a new dbt project:
Create a folder named models
in the repository, in same folder as dbt_project.yml
Create a new empty model sql file in the models
folder, matching the domain you’re exporting from Honeydew (for example mydomain.sql
)
Create a new empty model yaml file in the models
folder, matching the domain you’re exporting from Honeydew (for example mydomain.yml
)
In Honeydew, go to Branch integrations -> Lightdash -> Export to Lightdash and copy the displayed content
Paste the content into the model yaml file (e.g. mydomain.yml
)
Commit and push the changes to the git repository
If no domain is selected, the default domain is called world
.
Each Lightdash project is mapped to a Honeydew workspace and branch.
If you would like to use multiple Honeydew domains, you can create them as multiple models in the dbt project.
It is recommended to use an API Key for setting up the connection.
Create project
Create a new project and give it a name
Warehouse connection
jdbc.honeydew.cloud
<workspace>__<branch>
value, based on the Honeydew workspace
and branch
you would like to connect to.
Omit the branch value if connecting to prod
.
For example, for workspace tpch
, branch prod
, the value would be: tpch
.
And for workspace tpch
, branch dev
, it would be tpch__dev
.
(or to the user’s password in Honeydew).443
and SSL mode to https
If your organization uses a custom hostname for the JDBC connection, you can locate it in the Honeydew UI, under the JDBC section in Settings.
dbt connection
Test and deploy
Click Test and deploy project
If you have multiple models in the dbt project, you will be asked to select the models to use in Lightdash. Select the model(s) you have imported from Honeydew for this project.
If you would like to use multiple Honeydew domains, you can create them as multiple models in the dbt project.
Honeydew automatically converts Honeydew metadata properties to Lightdash metadata properties.
Honeydew synchronizes the following metadata to Lightdash:
label
Lightdash field property). When no display name is set, Honeydew creates an automatic user friendly name.groups
and group_details
Lightdash properties). When no folder is set, Honeydew uses the entity name as folder names.type
Lightdash measure property). Note that Honeydew can support any SQL aggregation function as a measure, hence
the measure type is not always a direct mapping to Lightdash measure types.hidden
Lightdash field property).description
Lightdash field property).In addition, the following metadata properties are also synchronized:
Attributes and Metrics: You can add Lightdash-specific metadata, that specifies formatting and a url, to an attribute or a metric in the schema:
For additional information on formatting, see Lightdash documentation for dimensions and metrics formatting.
It is recommended to use https://customformats.com/ to help you building format expressions.
For additional documentation on urls, see the Lightdash documentation.
You can now run queries or create dashboards on top of the Honeydew connection, using the Lightdash user interface.