What is warehouse-native product analytics?

Warehouse-native product analytics is a category of tools that run funnel, retention, and path analysis directly on the events already in your data warehouse (DuckDB, Snowflake, ClickHouse, Databricks, Postgres) — with no event ingestion pipeline and no duplication of data into a third-party SaaS.

Who is stratif.io for, and who is it not for?

stratif.io is for teams whose product events are already in a SQL warehouse and who want self-hosted funnels, retention, and path analysis on that data. It is not a full-stack replacement for Mixpanel or Amplitude — it does not ship SDKs, experimentation, session replay, or push notifications.

Warehouse-Native Product Analytics Docs

stratif.io is an open-source product analytics dashboard that queries your data warehouse directly — no event pipelines to maintain, no vendor lock-in, no per-event pricing. Connect it to DuckDB, PostgreSQL, ClickHouse, Snowflake, or Databricks and start exploring in minutes.

Mission Control — stratif.io dashboard overview

How it works

stratif.io runs as a lightweight server alongside your warehouse. You configure a connection, write (or let stratif.io generate) the SQL that defines your events, and every chart, funnel, and retention table executes a live query against your data. There is no intermediate storage and no ingestion delay — the numbers you see are always up to date.

Every metric ships with a SQL viewer so you can inspect the exact query behind any chart, adapt it, or run it yourself.

Features

Mission Control Your daily analytics home — active users, top events, session summary, and device breakdown.

Trends Track how event counts change over time with daily, weekly, or monthly granularity.

Retention Measure how many users return after performing a first action.

Funnel Quantify conversion rates between sequential steps in a user journey.

Paths (Journey) Explore the routes users take through your product, forward and backward.

People Browse individual user profiles, properties, and full event history.

Events Explorer Inspect raw events, filter by property, and audit your instrumentation.

Pivot Cross-tabulate any two dimensions against a metric for ad-hoc breakdowns.

SQL Studio Write and run raw SQL directly against your warehouse from the dashboard.

Global Filters Apply date range, device, and custom filters across every view simultaneously.

Supported warehouses

DuckDB · PostgreSQL · ClickHouse · Snowflake · Databricks

Get started

Installation Install stratif.io on your server or laptop in under 5 minutes.

Configuration Environment variable reference for ports, auth, and encryption.

Try the demo Explore live with a sample e-commerce dataset — no install required.