Deliver in-product analytics with tools developers love

Patch is a zero-config backend for building analytics features and data products for your customers. Connect a source and deploy low latency analytics APIs instantly. No need to pre-define metrics or set up infrastructure.

Generate production grade Dataset APIs in minutes

Your data, in production

Instantly deploy production APIs with built-in analytics primitives

Compute time series metrics on the fly without pre-aggregations. No infrastructure or configuration required.

Connect

Configure Snowflake or BigQuery data sources using the Patch CLI.

View Source connectors ->

Generate

Instantly deploy REST or Graph APIs over key tables, such as dbt models.

Explore the CLI ->

Query

Aggregate time series, read single rows, or subscribe to change events.

Check out the Data APIs ->

Customer-facing Dashboards

Compute metrics on the fly

Time bucketing and aggregations

Flexible interface for all time series functions such as bucketing by grain, lookback ranges, and aggregations.

Explore supported queries ->

Ship data products without the mess

Query time series data with dynamic filters and segmentation. No need to define metrics or cubes ahead of time.

Read the documentation->

query {
	purchasesQuery(
    filter: {
      item_type: {
        in: ["pants", "skirts", "shorts"]
      }
      payment_status: {
        eq: "successful"
      }
    }
    groupBy: [purchase_timeDay,item_type]
  ) {
    purchase_amountSum 
    purchase_timeDay 
    item_type 
  }
}

GET /payments_received
?purchase_timestamp:last=7:DAY
&_agg=purchase_amount:SUM
&_group_by=purchase_timestamp:DAY,item_type
&purchase_status=successful
&item_type=pants,skirts,shorts

Total purchase amount per day in key categories

Live endpoints in minutes

Ultra low latency table scans and single row reads

Look up single rows blazing fast

Even analytics apps need to support ultra low latency reads for individual records by primary key.

Explore key lookups->

Fully equipped GraphQL and REST APIs

All the power and conveniences you'd expect in an API - limits, pagination, sorting, grouping, and more.

Request access ->

Read our API documentation -->

Built for development teams

Secure, scalable, and designed for your workflow

Flexible multi-tenancy model

Securely access customer data, whether all customers' data is in a single table or separate databases.

Explore Patch access layer ->

Integrated into developer workflows

Configure Patch datasets and APIs in code using dbt, Terraform, or common CI tools.

Talk to us ->

{
    "patch.tech": {
        "active_users": {
            "where": {
                "account_id": "0823756123",
                "isVerified": true
            }
        }
    }
}

Encode claim filters in your JWT