PlatformMonitor

Insights

Inngest Insights allows you to query and analyze your event data using SQL directly within the Inngest platform. Every event sent to Inngest contains valuable information, and Insights gives you the power to extract meaningful patterns and analytics from that data.

Insights support is currently in Public Beta. Some details including SQL syntax and feature availability are still subject to change during this period. Read more about the Public Beta release phase here and the roadmap here.

Overview

Insights provides an in-app SQL editor and query interface where you can:

  • Query event data using familiar SQL syntax
  • Save and reuse common queries
  • Analyze patterns in your event triggers
  • Extract business intelligence from your workflows

Currently, you can only query events. Support for querying function runs will be added in future releases.

Getting Started

Access Insights through the Inngest dashboard by clicking on the "Insights" tab in the left navigation.

Getting Started Dashboard View

We have several pre-built query templates to help you get started exploring your data.

Getting Started Templates View

SQL Editor

The Insights interface includes a full-featured SQL editor where you can:

  • Write and execute SQL queries against your event data
  • Save frequently used queries for later access
  • View query results in an organized table format
  • Access query history and templates from the sidebar

Sql Editor View

Available Columns

When querying events, you have access to the following columns:

ColumnTypeDescription
idStringUnique identifier for the event
nameStringThe name/type of the event
dataJSONThe event payload data - users can send any JSON structure here
tsUnix timestamp (ms)Unix timestamp in milliseconds when the event occurred - reference
vStringEvent format version

For more details on the event format, see the Inngest Event Format documentation.

Data Retention

Refer to pricing plans for data retention limits.

Result Limits

  • Current page limit: 1000 rows
  • Future updates will support larger result sets through async data exports

SQL Support

Insights is built on ClickHouse, which provides powerful SQL capabilities with some differences from traditional SQL databases.

Sql Editor View

Supported Functions

Arithmetic Functions

Basic mathematical operations and calculations. View ClickHouse arithmetic functions documentation

String Functions

String manipulation and search capabilities.

JSON Functions

Essential for working with events.data payloads. View ClickHouse JSON functions documentation

Date/Time Functions

For analyzing event timing and patterns. View ClickHouse date/time functions documentation

Other Supported Function Categories

Aggregate Functions

The following aggregate functions are supported:

FunctionDescription
ARRAY_AGG()Aggregates values into an array *
AVG()Calculates average
COUNT()Counts rows
MAX()Finds maximum value
MIN()Finds minimum value
STDDEV_POP()Population standard deviation
STDDEV_SAMP()Sample standard deviation
SUM()Calculates sum
VAR_POP()Population variance
VAR_SAMP()Sample variance
median()Finds median value

SQL Syntax Limitations

Some SQL features are not yet supported but are planned for future releases:

  • CTEs (Common Table Expressions) using WITH
  • IS operator
  • NOT operator

Working with Event Data

Event-Specific Schema

Within events.data, users can send any JSON they want, so the structure and available fields will be specific to their payloads. You can use ClickHouse's JSON functions to extract and query specific fields within your event data.

Example Queries

Basic Event Filtering

SELECT count(*)
FROM events
WHERE name = 'inngest/function.failed'
AND simpleJSONExtractString(data, 'function_id') = 'generate-report'
AND ts > toUnixTimestamp(addHours(now(), -1)) * 1000;

Extracting JSON Data and Aggregating

SELECT simpleJSONExtractString(data, 'user_id') as user_id, count(*) 
FROM events
WHERE name = 'order.created'
GROUP BY user_id
ORDER BY count(*) DESC
LIMIT 10;

Saved Queries

You can save frequently used queries for quick access. Queries are only saved private for you to use; they are not shared across your Inngest organization.

Roadmap

Coming Soon

  • Query support for function runs
  • received_at column for tracking event receipt time
  • Pagination for large result sets
  • Async data exports for results larger than 1000 rows

Future Enhancements

  • Support for CTEs (Common Table Expressions)
  • IS and NOT operators
  • Advanced visualization capabilities

Need Help?

If you encounter issues or have questions about Insights:

  1. Check this documentation for common solutions
  2. Review the ClickHouse SQL reference for advanced function usage
  3. Contact support through the Inngest platform

Insights is actively under development. Features and column names may change as we continue to improve the product.