Ocean.io can connect with dbt for joining Ocean fit data and segments with data in dbt
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.

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
Sample prompt
“Ask Ocean for our segments and tiers, then query dbt for revenue and usage by account and tell me which segment performs best.”

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

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