Skip to the card

Card 259 of 9992026-09-02 issue

Observed arrival · 2026-09-02

Factcat, Analytics Without the SDK

factcat.dev Observed source
Editorial interest 82/100 Selection signal · not a rating of the site

An open-source product-analytics tool that generates SQL for BigQuery or Snowflake and runs it inside your own warehouse.

Landing page captured for the 2026-09-02 issue.

Field notes

The project models analytics around an explicitly chosen entity, such as a subscription or account, rather than silently reducing every metric to users and events. Its Python specifications generate warehouse-specific SQL, including predicates over source columns and derived fields such as period_index and within_period_offset. The examples cover a 35-day payment-retention period with a five-day dunning window, plus ordered funnels completed within 30 days.

Observed signals

Read the marks

Editorial observations of this landing page, not a rating.

OpenPublic substance visible
LoginAccess appeared gated
PrettyNotable craft visible
ProPolished or operationally mature
NicheUnusually specific use

One card from the complete issue

A Commons Made of Smoke

312,505 arrived 1,000 judged 999 catalogued Enter the complete issue
factcat.dev

Landing page observed 2026-09-02. The live site may have changed.