Give your customers fast and delightful analytics

From ingestion to visualization, Propel equips product engineering teams with
the most complete platform
to ship awesome analytics products under tight deadlines.

ingestion diagram

Built-in ingestion pipelines

Bring your data together, unifying your warehouse and streaming data.

  • Ingest real-time streaming data.
  • Sync from your data warehouse.
  • Sync from your database.
  • Complete pipeline observability.
  • Works with Fivetran and Airbyte.
Read the docs

Serverless ClickHouse

Serve blazing-fast queries at scale without managing infrastructure.

  • Sub-second query latencies over billions of rows.
  • Serverless auto-scaling for high-concurrency.
  • Mission-critical reliability.
  • Secure GraphQL and SQL APIs.
Read the docs

Control Access

Securely build analytics into multi-tenant apps.

  • Scoped API credentials
  • Column- and row-level Access Policies.
  • Multi-tenant access controls.
Read the docs

Data APIs

Build faster with APIs for every data feature.

  • Counter
  • Data Grid
  • Leaderboard
  • Metric Report
  • Records by ID
  • Time Series
  • Top Values
  • SQL API
Read the docs

Semantic layer

Define metrics once and query them anywhere.

  • SUM, AVG, MIN, MAX, COUNT, and COUNT_DISTINCT Metrics.
  • Custom Metrics.
  • Metric Query API.
  • Metric Management API.
  • Terraform Metric definitions.
Read the docs
react components

React Components

Bring your data together, unifying your warehouse and streaming data.

  • <TimeSeries>, <PieChart> & <Leaderboard> components.
  • Time and date range picker components.
  • Simple and advanced filter components.
  • Access token request and refresh management.
  • Integrated data fetching.
  • Loading and error states.
Read the docs
Trusted by
calliper logo
tackle.io logo
Backed by
Use cases

One platform, all your use cases

Power multiple customer-facing analytics use cases with a single platform.

Embedded analytics

Deliver in-product analytics experiences that look and feel native to your product.

“We delivered our enterprise embedded analytics in two sprints with Propel.” - Courier

Data APIs

Deploy instant low-latency data APIs in minutes over Kafka, JSON Events, ClickHouse, Snowflake, Parquet files in S3, or PostgreSQL.

“Data APIs gave us the flexibility to power many use cases, from personalization APIs to product usage emails, with the same platform.” - Top Travel Company

SaaS dashboards

Launch the analytics your customers have been asking for in days, not months.

““With Propel, we met a 30-day deadline to launch analytics in our product 💪🏽” - Tango

IoT and operational insights

Deliver flexible, fast, real-time customizable dashboards to deliver the operational insights your users need.

“Data shows up in seconds and dashboards load super fast.” - Lumeo

Product usage metering

Define metrics and measure, report, and alert on product usage.

“Our operational metrics are huge differentiator as it enables our customers to scale with confidence.” - Top API Company

ChatGPT usage analytics

Track, meter, report, bill, and enforce limits on ChatGPT usage metrics.

“Our own UI without having to worry about the analytics backend, fuck yeah. This is it.” - ChatHQ

Self-service custom reporting

Deliver custom reports to your highest-value customers without engineering or manual work.

“Customers that create their own reports see more value in our product.” - Property Vista

Data sharing

Give your customers their data via a SQL interface compatible with any BI tool.

“The SQL interface has unlocked an insane amount of customer value. We are now offering it as a premium feature.” - Top SaaS Company

Property Vista Dashboard
Courier’s enterprise analytics dashboard powered by Propel. Courier Customer Story
data apis diagram
tango graphic
Tango’s workflow analytics powered by Propel.
Lumeo's dashboard
Lumeo’s real-time analytics dashboard powered by Propel.
metering diagram
ChatHQ dashboard
ChatHQ’s dashboard powered by data from their MongoDB ingested into Propel.
property vista dashbaord
data sharing diagram
Development workflow

How Propel Works

The complete toolkit to ship the best analytics products on the planet.

Ingest

Get fresh data from anywhere

Unify and bring your batch and streaming together. It is as simple as connecting your data source or sending JSON events.

Data sourcesData sources
Transform

Unify, transform, aggregate, and enrich in real time

Use Propel's powerful Materialized Views tools to clean, join, format, aggregate, and enrich your data, preparing it for analysis in real time.

Transform diagram
Model

Model data into metrics

Define metrics from your data that represent key performance indicators for your product. These metrics can create insightful dashboards and reports for your customers.

Metrics Graphic
Develop

Query using the SQL that you already know

Query using SQL through the API, React Query Hooks, or a PostgreSQL-compatible SQL connector. Our multi-tenant access policies ensure that end customers can only query their own data.

Integrate with any framework or programming language

query {
  sqlV1(input: { query: "SELECT * FROM \"TacoSoft Demo Data\" LIMIT 10" }) {
    columns { columnName }
    rows
  }
}
curl -X POST https://api.us-east-2.propeldata.com/graphql \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer <Access Token>" \
  -d '{
    "query": "query sql($input: SqlV1Input!) { sqlV1(input: $input) { columns { columnName } rows } }",
    "variables": {
      "input": {
        "query": "SELECT * FROM \"TacoSoft Demo Data\" LIMIT 3"
      }
    }
  }'
import { useSql, useAccessToken } from '@propeldata/ui-kit'

function Sql() {
  const { accessToken } = useAccessToken()
  const { data } = useSql({
    accessToken,
    query: 'SELECT * FROM "TacoSoft Demo Data" LIMIT 5'
  })
  const { columns, rows } = data?.sqlV1 ?? {}

  return (
    
        {columns?.map((col, i) => (
          
        ))}
      
      {rows?.map((row, i) => (
        
          {row?.map((col, j) => (
            
          ))}
        
      ))}
    
{col?.columnName}
{col}
) }
$ psql -h postgresql.us-east-2.propeldata.com propel $PROPEL_APPLICATION_ID

propel=> SELECT * FROM "TacoSoft Demo Data" LIMIT 3;
Read the docs
Develop

Serve data through ultra-fast, low-latency GraphQL APIs

Build data apps without backend dependencies with highly optimized data APIs for common access patterns.

# Revenue this month vs last month
query {
  revenueThisMonth: counter(input: {
    metric: { name: "Revenue" },
    timeRange: { relative: THIS_MONTH },
		filters: [],
  }) {
    value
  }
  revenuePreviousMonth: counter(input: {
    metric: { name: "Revenue"},
    timeRange: { relative: PREVIOUS_MONTH }
		filters: [],
  }) {
    value
  }
}
# Most recent 5 items
query {
  dataGrid(input: {
		dataPool: { "name": "TacoSoft Demo Data" },
    timeRange: { relative: THIS_MONTH },
    columns: ["timestamp", "order_item_id", "taco_name", "taco_total_price"],
    orderByColumn: 1,
    sort: DESC,
    filters: [],
    first: 5
  }) {
    headers
    rows
    pageInfo {
      hasNextPage
      hasPreviousPage
      endCursor
      startCursor
    }
  }
}
# Top restaurants by revenue this month
query {
  leaderboard(input: {
    metric: { name: "Revenue"},
    sort: DESC,
    timeRange: { relative: THIS_MONTH },
    rowLimit: 10,
    dimensions: [{ columnName: "restaurant_name" }]
  }) {
    headers
    rows
  }
}
# Restaurant by taco revenue and orders report
query {
  metricReport(input: {
    timeRange: { relative: THIS_MONTH },
    dimensions: [
      { columnName: "restaurant_name" }, 
			{ columnName: "taco_name"}
    ],
    metrics: [
      { uniqueName: "Revenue" },
      { uniqueName: "Taco Sales Count" }
    ],
    orderByColumn: 1,
    first: 10
  }) {
    headers
    rows
    pageInfo {
      startCursor
      endCursor
      hasNextPage
      hasPreviousPage
    }
  }
}
# Look up taco orders by unique ID
query {
  recordsByUniqueId(input: {
    dataPool: { "name": "TacoSoft Demo Data" },
    columns: ["timestamp", "order_item_id", "taco_name", "taco_total_price"],
    uniqueIds: ["1234567890"]
  }) {
    columns
    values
  }
}
# Top 5 tacos sold this month
query {
  topValues(input: {
    dataPool: { "name": "TacoSoft Demo Data" },
    columnName: "taco_name",
    timeRange: { relative: THIS_MONTH },
    maxValues: 5
  }) {
    values
  }
}
# Daily revenue for this month
query {
  timeSeries(input: {
    metric: { name: "Revenue"},
    granularity: DAY,
    timeRange: { relative: THIS_MONTH },
    filters: []
  }) {
    labels
    values
  }
}
Read the docs
Visualize

Embed pixel-perfect dashboards in minutes with React components

Simply add the <TimeSeries/>, <Counter/>, <Leaderboard/>, or <SimpleFilter/> React components for your dashboard functionality. Match it to your brand with any CSS library, then deploy it as part of your app — no more janky-looking embedded iframes!

UI component
UI components
Deployment

Deploy Your Way

No matter how you choose to deploy we have you covered

Connect your own ClickHouse

Clickhouse Diagram
  • Works with self-hosted ClickHouse.
  • Works with ClickHouse Cloud.
  • Full control of your ClickHouse deployment.
  • Data stays in your infrastructure.
  • Data is encrypted in transit.
  • Only pay for data passthrough.
  • All the Propel APIs and UI components.

Fully managed serverless cloud

Serverless diagram
  • Ingest data from any data source.
  • No infrastructure to manage or scale.
  • Serverless auto-scaling.
  • Mission-critical availability.
  • Unlimited storage.
  • Data is encrypted at rest and in transit.
  • Only pay for the storage you use and queries you make.

Fully managed dedicated instances

Dedicated Diagram
  • Ingest data from any data source.
  • Completely dedicated memory and vCPUs.
  • Control instance size for your needs.
  • Unlimited storage.
  • No infrastructure to manage.
  • Data is encrypted at rest and in transit.
  • Predictable monthly pricing.
Customers

Trusted by CTOs 
that get Sh*t done

"I've had to own this in the past, and it's not cheap. With Propel, we launched our enterprise dashboards in a couple of sprints.”

Seth Carney

CTO

"My goal is to deliver meaningful business insights to our customers. Propel makes this an easy and scalable process."

Joe McCorkle

CTO

"Propel is the way to go. It enabled us to launch user-friendly yet robust analytics quickly and efficiently on a large scale.”

Kristie Howard

Director of Engineering
Advanced Security

Secure & Compliant

Visit the Trust Center to view more details on Propel’s security and compliance.

View the Trust Center
GDPR Icon
GDPR compliant
SOC2 compliant Icon
SOC 2 Type 2 compliant
GCPA Icon
GCPA compliant
Social

Stay updated and connected

Mark Roberts
February 26, 2024
twitter icon

Twitter

Newsletter

Start shipping today

Deliver the analytics your customers have been asking for.