Husprey fully integrates with dbt to sync transformation metadata. Descriptions, dbt models, freshness and columns constraints are now available directly in your notebooks.
Husprey integrates with Notion to automatically synchronize notebooks to the Notion database of your choice.
Once connected to a dbt Core or dbt Cloud project, Husprey displays transformation metadata directly in the Documentation Panel.
When investigating a data quality issue or answering an ad-hoc request, you are now able to iterate faster knowing about the details of any column transformation. Whether it comes from a source or a model.
Whether you're using dbt Core or dbt Cloud, Husprey got you cover. Both our integrations are quick and easy to set up.
dbt Cloud integration relies on the powerful dbt Metadata API to sync both sources and models metadata.
Generate and paste credentials of the dbt Cloud job you’d like to use and that’s it. We told you, less than 2 minutes.
Note: The dbt Metadata API is available to accounts on the Team and Enterprise plans, for all dbt versions above v0.19.0.
Read documentation
->
Read dbt Metadata API documentation
->
dbt Core integration works by uploading dbt artifacts to Husprey.
After a dbt invocation that builds models and generates documentation, run a single command to do so. This specific command and the API key is available from your Husprey settings page.
TIP: If you want metadata to stay up-to-date add this command to your usual data orchestrator.
Read documentation
->
Husprey syncs the metadata that you would need the most in order to iterate faster on your work. In details it means:
· For sources: description, freshness status and criteria
· For models: description, SQL (source and compiled), columns list, source tables lineage, freshness status (based on source tables lineage)
· For columns: description, tests (unicity, nullity, etc)
Metadata is directly linked to any actual table (or view) and its columns.
When displaying details about your data warehouse (data types, column preview, queries’ examples, ...), you can also see all dbt metadata. If you already use Husprey, your workflow stays intact.
No, the dbt integration is not available on our Free plan but is included in both the Team and the Enterprise plans.
If you have a small team but would like the integration, you can contact our support and we will find a solution together.
With dbt Core, the data is refreshed as soon as you upload new artifacts. Most of the teams using the integration, added the command line to their data orchestrator. We will let you pick your favorite.
With dbt Cloud™, the data is refreshed on a frequent schedule. If you’re part of the dbt webhook beta, ping us so we can activate this for you.
SQL, tables, charts, business goals, takeaways, in your notebooks are all exported seamlessly to Notion.
Customize the Notion database with your notebooks to show up exactly as your business users need it.
Get your business glossary terms in sync with your business users in Notion.
It's quick and easy to connect your Notion with Husprey.
We use the Notion API, which we connect with an integration token. On your side, you will need to manually create an integration in your Notion workspace.
Each change made on a notebook will automatically reciprocate on your Notion page, including updates or scheduled executions.
On the other hand, a Notion page will be archived when a notebook is set as unpublished.
No, the Notion integration is not available on our Free plan but is included in both the Team and the Enterprise plans.
If you have a small team but would like the integration, you can contact our support and we will find a solution together.
Only an admin of a workspace can add the Notion integration. All integration management can be accessed in the dedicated section in the workspace Settings. There, you can connect or disconnect your Notion integration.
4
4