Warehouse

A warehouse that comes with the workspace.

Serverless analytical storage, isolated per workspace and priced on what you store and query. The pipeline writes it, the ontology replicates into it, and apps and agents read it.

cloud.segmentstream.com
The console's warehouse explorer: bronze, silver, gold and ontology datasets on the left, a gold table of revenue per client and month on the right
Bronze, silver and gold tables, browsable with their schemas, beside the ontology's replicated records.

Created with the workspace

Every workspace gets its own BigQuery warehouse, created with the workspace in the EU or the US, isolated from every other.

Bronze, silver, gold

Raw, cleaned and business-ready tables keep source data replayable and reports stable.

The ontology, replicated

By default, every record in the ontology replicates to the warehouse, so analysts join decisions made in the app with the rest of your data.

Query from anywhere

Read-only SQL from the console, the CLI or an app, with named parameters. Measures declared in the ontology count over warehouse tables.

Usage-priced

Billed on storage and the data your queries process. When nothing runs, nothing is billed.

In code

terminal
$ segmentstream warehouse query --sql \    "SELECT client, SUM(revenue) AS revenue       FROM gold.revenue_by_client      WHERE month >= '2026-09-01'      GROUP BY client ORDER BY revenue DESC"
CLI reference →

Use it, build on it, or have it built

Use it

Created with every workspace, in the region you choose.

Build it with your agent

Your agent creates tables through pipelines and queries them to check its own work.

Have our engineers build it

Our engineers move the tables and reports you need from the warehouse you run today.

Replaces Snowflake, Databricks SQL and Redshift.

Works with

Solutions built with it

Read more

Enterprise pilot

Start a pilot.

Want warehouse set up for you? Our forward-deployed engineers build it with you in your workspace, as code you own.

  • One solution, on your data, in your own workspace
  • First version live in two weeks
  • Parity proven before anything is switched off
  • Fixed scope and price, credited to your contract if you continue

Not ready for a pilot? Send the form anyway with your question. An engineer will reply, not a sales rep.

How the pilot works

Goes to our founder’s inbox. No sales queue, no newsletter.

Your company’s software, built by agents, owned by you.

$ segmentstream workspace create acme --region eu --subdomain acme

▸ Created workspace acme · database, warehouse and a private git repository

$ segmentstream workspace WORKSPACE-ID clone acme && cd acme

▸ your agent writes the five folders and runs the checks

$ git add -A && git commit -m "First version"

$ segmentstream deploy

▸ app, ontology API and MCP tools live for your invited members

Start a pilot

Our engineers build the first version on your data in two weeks, at a fixed price.

Or join the waitlist for self-serve:

We’ll email you product updates, tips and onboarding help. Unsubscribe anytime.

Self-serve opens to the waitlist first.