🔎 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.
🗄️ 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.
📌 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.
🧮 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.
🔓 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.
⏳ 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.
🍰 UI Kit Pie Chart component
The PieChart component is designed to create pie or doughnut charts using the Leaderboard API.
🪝 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.
- Fix timezone argument on
- 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.
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.