Ship data products with tools developers love

Patch is a  zero-config backend for building customer-facing analytics features and data products. Connect a source and deploy low latency Data APIs instantly without infra. No need to pre-define models, metrics, or OLAP cubes.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

By providing, I agree to the Terms of Use and Privacy Policy

Several analytics charts and graphs.

Your data, in production

No infrastructure or configuration required
Deploy powerful and secure REST or GraphQL APIs on demand. Compute time series metrics on the fly without pre-aggregations.

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.

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.

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

A single row read.
Look up single rows blazing fast

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

Fully equipped GraphQL and REST APIs

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

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.

Integrated into developer workflows

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

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

Encode claim filters in your JWT

Build with Patch

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

By providing, I agree to the Terms of Use and Privacy Policy