Connector

Enable business reporting from your Snowflake data

Turn your data warehouse into a real reporting library. Connected Data Marts, ready for an API.

SnowflakeConnected
Data MartPublishedone definition
APIDaily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get started free

Hand this to your AI

Apps query Snowflake tables directly, so each one rebuilds the same metric and gets a slightly different number.

Paste this into your AI assistant. It turns your Snowflake tables into published Data Marts with OWOX Data Marts, so your apps and scripts read the same rows over HTTP with an API key, with totals by date bucket.

The prompt

publish a Data Mart on our Snowflake data and show me how our app reads its rows over HTTP with an API key, totalled by week, so the app shows the same numbers as our reports

S01 · Step 1

Start from your Snowflake data

Pick the Snowflake database and schema that hold the data your apps need.

  • Nothing to move or copy.
SnowflakeYour data warehouseDatabaseSchema
Unified Ad SpendConnected dataNothing to move or copy

S02 · Step 2

Build a reporting library in Snowflake

Each Data Mart in Snowflake is a ready report, described by AI, and joins to other Data Marts through the data model.

  • Business users browse reports, not tables.
Data martsUnified Ad SpendAISessionsAI
Unified Ad SpendData modelplatform_roas · platform_cpa
Unified Ad Spend + Sessions
SessionsJoined by a shared key

S03 · Step 3

Serve Snowflake data through an API

Your app asks OWOX for the rows of a Data Mart over HTTP, with aggregations and date buckets, and gets the rows back.

  • Apps read the numbers the reports show.
Your app or scriptHTTP request
APIUnified Ad SpendRows over HTTP
JSON rowscostInUsdclicksimpressions

S04 · Step 4

Keep your apps connected to the same data

Ask in Claude, export to a sheet, share with the boss: your app is one more tool on the same data.

  • One source, every tool.
Unified Ad SpendOne source
ClaudeAsk in chat
Google SheetsExport to a sheet
Your bossShare the answer

Recent updates

Why OWOX

Why OWOX for Snowflake reporting

Apps and scripts need the same numbers as the reports. OWOX serves the rows of a Data Mart in your Snowflake over HTTP, per Data Mart or per report.

  • You own the data. The rows come from published Data Marts on your Snowflake; apps read only published Data Marts.
  • Aggregations and date buckets. Ask for totals by date bucket instead of grouping raw rows yourself.
  • Per Data Mart or per report. Serve a whole Data Mart, or one report with its own columns and filters.
  • One source, every tool. Dashboards, spreadsheets, assistants and apps read the same Data Marts.
  • For your own code. A script or an app reads the same Snowflake Data Marts as the dashboards, so the business and the code agree.

Book a callGet started free

Trust

The Data Partner You Can Trust

users

166K Source: Internal OWOX data as of 2026-11-15

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers