Skip to main content
ยท 4 min read

January 2024 new features, fixes, and improvements

New featuresโ€‹


You can now query any Data Pool using SQL over the GraphQL API. Need to join, group by, or perform complex queries? No problem. Propel's SQL supports PostgreSQL syntax, including joins, unions, and common table expressions for more complex queries. The SQL API allows you to query your data however you'd like, and Propel's multi-tenant access policies ensure that customers can only query their own data.

Propel's SQL API

Learn more about the SQL API.

๐Ÿ˜ PostgreSQL-compatible SQL interfaceโ€‹

You can now connect any BI tool or PostgreSQL client to Propel. Essentially, Propel mimics a PostgreSQL instance, providing a seamless connection to a variety of tools or client applications.

For SaaS applications, this simplifies the process of providing a customer-facing SQL interface for custom reporting and data sharing.

Propel's SQL interface

Learn more about the SQL interface.

๐Ÿ—„๏ธ Data Grid APIโ€‹

The new Data Grid API efficiently retrieves individual records from a Data Pool, with the added convenience of built-in pagination, filtering, and sorting. It's perfect for displaying data in a table format, making it ideal for data tables with individual events, orders, requests, or log messages.

Propel's Data Grid API use cases

Learn more about the Data Grid API

๐Ÿ“Œ Records by ID APIโ€‹

The new Records by ID API is optimized for quick, unique ID lookups. It returns the records corresponding to the given IDs. This API can present detailed record information in a data table or record detail page.

Learn more about the Records by ID API.

๐Ÿงฎ Top Values APIโ€‹

The new Top Values API returns the most common values in a specified column ordered by frequency. The Top Values API can populate UI filters, prompt available values to AI agents, or showcase trending values within a column.

Propel's Top Values API use cases

๐Ÿ’š๐Ÿ’™๐Ÿ’œ UI Kit themesโ€‹

You can now control the look and feel of all your UI components in one theme. The theme of the UI Kit determines all essential visual elements, including the colors of components, the depth of shadows, and the overall light or dark appearance of the interface. We provide light and dark themes out of the box and the ability to customize your own theme.

Propel's UI Kit Themes

Learn more about themes in the UI Kit.

๐Ÿ”“ UI Kit Access Token Providerโ€‹

You can now easily fetch and refresh API access tokens from the frontend. The newย  AccessTokenProvider component allows you to provide a function that fetches an access token from your backend. Using this function, the provider will serve the fetched access token to all its child components and automatically refresh the token when it expires.

Code example of Propel's UI Kit Access Token provider

Learn more about the Access Token Provider.

โณ UI Kit Filter componentโ€‹

The new Filter component simplifies the process of adding filters to your dashboards. It uses Propel's Top Values API to fill the dropdown list with unique values from a specific column, arranged by their frequency.

Example of Propel's UI Kit Filter component

Learn more about the filter component.

๐Ÿฐ UI Kit Pie Chart componentโ€‹

The PieChart component is designed to create pie or doughnut charts using the Leaderboard API.

Example of Propel's UI Kit Pie Chart component

Learn more about the Pie Chart component.

๐Ÿช UI Kit Query Hooksโ€‹

Propel's UI Kit provides prebuilt React components for querying data from Propel's GraphQL API. These components can be used to query data for custom visualizations or to build with third-party libraries such as D3.js, Recharts, Nivo, or Chart.js.

Code example of Propel's UI Kit Query Hooks

Learn more about the Query Hooks.


  • Fix timezone argument on toStartOfWeek, toStartOfMonth, and toStartOfYear SQL functions.
  • Fixed login loop for accounts with Okta integration.


  • Support LIKE and NOT LIKE filter operators in SQL and the GraphQL API.
  • Support TO_TIMESTAMP function in SQL.
  • Support CAST function in SQL.
  • Mark the tenant ID field in the Data Pool as deprecated. No longer needed with the new Access Policies.
  • Support WITH statements in the SQL API.
  • Support UNION statements in the SQL API.
  • New data_pool:read scope to list Data Pools and their schemas.
  • We made timeRange optional in GraphQL API.
  • The dimensions stats API has now been deprecated and replaced with the Top Values API.