New features
🔎 SQL API
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.
🐘 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.
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.
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.
💚💙💜 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.
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.
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.
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.
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.
Learn more about the Query Hooks.
Fixes
- Fix timezone argument on
toStartOfWeek,toStartOfMonth, andtoStartOfYearSQL functions. - Fixed login loop for accounts with Okta integration.
Improvements
- 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:readscope to list Data Pools and their schemas. - We made
timeRangeoptional in GraphQL API. - The dimensions stats API has now been deprecated and replaced with the Top Values API.