Logo of dbtPlusHusprey's logo

dbt™ integration

Husprey fully integrates with dbt to sync transformation metadata. Descriptions, dbt models, freshness and columns constraints are now available directly in your notebooks.

Read documentation

Notion integration

Husprey integrates with Notion to automatically synchronize notebooks to the Notion database of your choice.

Read documentation
Trusted by many data lovers
Withings LogoMalt LogoHorace LogoAnkorstore LogoShine LogoGojob LogoLe Figaro LogoShipfix Logo
How it works

Bring dbt metadata in Husprey

Once connected to a dbt Core or dbt Cloud project, Husprey displays transformation metadata directly in the Documentation Panel.

Light Gray Dot CircleGray Dot CircleDark Gray Dot Circle
Logo of dbt
Screenshot of a model in dbt documentation
Husprey's logo
Screenshot of a table documentation in Husprey

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.

Read documentation
Setup

2 minutes to sync your models

Whether you're using dbt Core or dbt Cloud, Husprey got you cover. Both our integrations are quick and easy to set up.

Screenshot of dbt cloud connection modal

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.

Screenshot of dbt core connection modal

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.

Loading Icon

Automatic export of your notebooks to Notion

All notebooks published in your workspace are automatically synchronized with the database of your choice in your Notion workspace.

Scheduled notebooks get automatically updated when executed.
Read documentation
Chart Icon

Entire notebooks as Notion pages

SQL, tables, charts, business goals, takeaways, in your notebooks are all exported seamlessly to Notion.

Eye Icon

Dedicated Notion views for everyone

Customize the Notion database with your notebooks to show up exactly as your business users need it.

Glossary Icon

Business glossary sync (coming soon)

Get your business glossary terms in sync with your business users in Notion.

Frequently Asked Questions

Have another question? Contact us at hello@husprey.com

What metadata is synced with the dbt integration?

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)

How is this additional metadata displayed in the Husprey app?

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.

Is the dbt integration available in the Starter plan?

No, the dbt integration is not available on our Starter plan but is included both in the Pro 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.

How often is the data refreshed?

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.

Frequently Asked Questions

Have another question? Contact us at hello@husprey.com

How easy is it to integrate Notion to Husprey?

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.

How do I keep my Notion up-to-date?

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.

Is the Notion integration available in the Starter plan?

No, the Notion integration is not available on our Starter plan but is included both in the Pro 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.

How can I manage my Notion integration in the Husprey app?

Only an admin of a workspace can add the Notion integration. Management for all integrations can be accessed in the dedicated section in the workspace settings. There, you can connect or disconnect your Notion integration.

4

4

Sorry, we couldn't find the page you're looking for.
Yes. We know. We're shocked too.
CONNECTORS

Connect to your favorite data source

Connect to the data warehouse technology of your choice. Husprey will automatically sync your schema so you can easily find the information you want.
Big Query Logo
Google BigQuery
Clickhouse Logo
ClickHouse
Snowflake Logo
Snowflake
PostgreSQL Logo
Postgres
Redshift Logo
Amazon Redshift
Panoply Logo
Panoply
Can't find the connector you need? Drop us a line!
Husprey Logo

Learn more about Husprey

Husprey is a powerful, yet simple, platform that provides tools for Data Analysts to create SQL notebooks effortlessly, collaborate with their team and share their analyses with anyone.