1. [Integrations](/integrations.md)
2. dbt

![Ocean.io can connect with dbt for joining Ocean fit data and segments with data in dbt](https://cdn-bunny.ocean.io/assets/custom/marketing/integrations/dbt-tile.webp?width=224)

Connect today

# dbt integration with Ocean.io

Your data team trusts dbt. Put fit where they can check it.

Whether a segment actually performs is a question for the data team, and it needs fit next to revenue and usage. Ocean's tier, segment and firmographics reach dbt through the API and your existing pipeline tooling, keyed on domain.

[Start now](https://app.ocean.io/signup)

---

## Ways to connect dbt

| Route              | Status      | What it does                                                                                                                                                                           |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Ocean API          | Works today | Search, enrichment, lookalikes, segments and exclusion lists from your own code or pipeline, authenticated with an API token.                                                          |
| CSV or spreadsheet | Works today | Export a segment as CSV, or append it live to a spreadsheet from a workflow, then import it wherever the list is needed.                                                               |
| HTTP request step  | Works today | A workflow step calls dbt's REST API with your own API key, kept in an encrypted header. Ocean fills the URL and body per record, caps requests per window and retries a failure once. |

## What lands in dbt

* Fit score, tier and segment per company, as a table in dbt
* Firmographics and buying signals alongside them
* A refresh whenever scores change

## Who it's for

* Data teams: fit as a joinable table, no custom pipe
* Leadership: retention and expansion by segment

## Ocean acts as a context layer on dbt

Run Ocean's MCP server and dbt's on one agent. Ocean supplies fit and segments. dbt supplies what actually happened.

Ocean Company and people search, lookalikes, segments, fit scores and buying committees

MCP Any AI agent that supports MCP carries the context across

dbt Adds its own data next to Ocean's context

> “Ask Ocean for our segments and tiers, then query dbt for revenue and usage by account and tell me which segment performs best.”
>
> — Sample prompt

Needs dbt's MCP server, which depends on your plan and setup. Searches and exports spend Ocean credits.

## Frequently asked questions

### Does Ocean.io integrate with dbt?

Yes, through the Ocean API, a CSV or spreadsheet and an HTTP request step. It can also be done with MCP: dbt publishes an MCP server, so one agent can use Ocean's server and dbt's together, if your plan includes it.

### How does Ocean data get into dbt today?

Through the Ocean API and whatever loads data into your warehouse now, or as a CSV for a first look.

## A worked example (illustrative)

An analyst joins Ocean tiers to net revenue retention by account in dbt and splits it by segment. The question is concrete: which segments keep and expand customers, and does the tier predict it?

1. Pull tier, segment and firmographics with the Ocean API.
2. Load them next to revenue and usage tables in dbt.
3. Join on domain.
4. Compare retention and expansion by tier and segment.

## Related integrations

![Ocean.io is building an integration with Snowflake for joining Ocean fit data with warehouse data](https://cdn-bunny.ocean.io/assets/custom/marketing/integrations/snowflake-tile.webp?width=160)

### [Snowflake](/integrations/snowflake.md)

In development

Fit data next to revenue, in your warehouse.

![Ocean.io is building an integration with BigQuery for joining Ocean fit data with warehouse data](https://cdn-bunny.ocean.io/assets/custom/marketing/integrations/bigquery-tile.webp?width=160)

### [BigQuery](/integrations/bigquery.md)

In development

Fit and segments, joined to revenue in BigQuery.

![Ocean.io integrates with API for company and people search](https://cdn-bunny.ocean.io/assets/custom/marketing/integrations/api-tile.webp?width=160)

### [API](/integrations/api.md)

Search, enrichment and segments for your own tools.

[All integrations](/integrations.md)

---

[ocean.io logomark](/index.md)

ocean.io logotype

[Home](/index.md)

[Discovery](/index.md)

[Workflows](/index.md)

[Context studio](/index.md)

[Search](/index.md)

[Assistant](/index.md)

[Leads](/index.md)

[API](/index.md)

[Extension](/index.md)

Recommendations

Segments

Models

### Recommendations 1,304 companies

Tier 1 · 68 Tier 2 · 241 Tier 3 · 512 Tier 4 · 483

All CRM statuses

1

| Company                                                                                                                           | Score | Segment            | Matched signals                    | Status  | Location       |
| --------------------------------------------------------------------------------------------------------------------------------- | ----- | ------------------ | ---------------------------------- | ------- | -------------- |
| ![Moss logo](https://cdn-bunny.ocean.io/logos/getmoss.com/5cd47a9faf8cd98ac4805334af0a3a31be1edb6c.png?width=72) Moss             | T1 92 | Mid-market FinTech | Industries: FinTech  +2            | Net new | Germany        |
| ![Spendesk logo](https://cdn-bunny.ocean.io/logos/spendesk.com/680a4a70ec12e26b7920057edb74b23cfc8af299.png?width=72) Spendesk    | T1 89 | Mid-market FinTech | Industries: FinTech  +2            | Net new | France         |
| ![Brex logo](https://cdn-bunny.ocean.io/logos/brex.com/2c66f22edd5c0a2cb1eec442e151128e4e8019a8.png?width=72) Brex                | T1 86 | Mid-market FinTech | Industries: FinTech  +2            | Net new | United States  |
| ![Payhawk logo](https://cdn-bunny.ocean.io/logos/payhawk.com/a80969444c1e52f57ae3374048cab1e00e0fdb22.png?width=72) Payhawk       | T1 83 | Mid-market FinTech | Industries: FinTech  +2            | Net new | United Kingdom |
| ![Ramp logo](https://cdn-bunny.ocean.io/assets/custom/pricing/ramp-logomark.webp?width=72) Ramp                                   | T2 79 | Mid-market FinTech | Industries: FinTech  +2            | Net new | United States  |
| ![Rydoo logo](https://cdn-bunny.ocean.io/logos/rydoo.com/32e0ac2fe888f3db8ff3e0eeef98dacb410722b6.png?width=72) Rydoo             | T2 74 | Mid-market FinTech | Industries: Software  +2           | Net new | Belgium        |
| ![Circula logo](https://cdn-bunny.ocean.io/logos/circula.com/7a2303a2a1b191b8bcda9eff1af4ec066361f27d.png?width=72) Circula       | T2 68 | Mid-market FinTech | Industries: Software  +2           | Net new | Germany        |
| ![Wallester logo](https://cdn-bunny.ocean.io/logos/wallester.com/91c6be05eb0e08e95d0b13c9b1216345389226c2.png?width=72) Wallester | T2 63 | Mid-market FinTech | Industries: Financial Services  +2 | Net new | Estonia        |

## Put Ocean to work in your stack

* Ranked accounts and the reason each one fits
* Scores, segments and signals written to the fields you choose

[Start now](https://app.ocean.io/signup)
