2024 Changelog
New features, fixes, and improvements.
1️⃣ ClickHouse SQL interface
We’ve launched a native ClickHouse SQL HTTP interface that lets you query Propel’s Serverless ClickHouse directly. You can use any standard ClickHouse library or SDK to run SELECT
and SHOW
queries against your data.
To get started, use the following connection details:
Parameter | Value |
---|---|
Host | https://clickhouse.us-east-2.propeldata.com |
Port | 8443 |
Database | propel |
user | Your Propel Application ID |
password | Your Propel Application secret |
Here’s an example of querying data using the ClickHouse HTTP interface with curl:
Learn more about the ClickHouse SQL interface.
2️⃣ New docs
We’ve completely revamped our documentation to make it easier for developers to get started and be successful with Propel.
The new docs include the following sections:
-
Serverless ClickHouse: Connection details, supported SQL syntax, SQL reference, functions, and everything you need to know to manage, transform and query your data.
-
Ingestion: Guides on ingesting data from a variety of sources to Propel, including Webhooks, events streams, and data warehouses.
-
Query APIs: Guides and examples for using the SQL and Query APIs for common analytics use cases and data visualizations.
-
Embeddable UIs: Guides and documentation for embedding Propel’s visualization components into your applications.
Explore the new docs.
3️⃣ Server-side authentication
You can now authenticate server-side applications using HTTP Basic Authentication with your Application ID and secret.
Learn more about server-side authentication.
4️⃣ New GroupBy UI component
The <GroupBy>
component is a dropdown menu that allows users to dynamically change the grouping of data for multidimensional analysis.
Learn more about the <GroupBy>
component.
Improvements and fixes
Serverless ClickHouse
- Added support for authentication using
X-ClickHouse-User
andX-ClickHouse-Key
headers. - Fixed issues with Materialized Views and Copy Jobs that contain common table expressions (CTEs).
Ingestion
- Fixed an issue that ocassionally prevented Webhook syncs from progressing beyond the
PENDING
state.
Console
- Fixed issue with GitHub login authentication.
- Added new Console start page and insights section.
- For SSO-enabled accounts, the “Invite Users” button is now disabled and displays a message explaining that user management must be done through the SSO provider.
- Added ability to modify the default timestamp column in Data Pools.
- Added SQL dialect selector to the SQL Console, allowing users to switch between ClickHouse and PostgreSQL syntax
API
- Exposed the SQL dialect in the SQL API.
- Fixed a case where the Metric Report API was not returning correct results.
Embeddable UI
- Fixed type definitions for
chartConfigProps
in the<TimeSeries>
component. - Removed unintended Storybook environment variable exports.
- Added
groupBy
functionality to<TimeSeries>
and<FilterProvider>
components for dynamic data grouping. - Standardized border radius styling across all components.
- Updated
<Leaderboard>
component to properly sync with time range from<FilterProvider>
. - Corrected type definition for
legendPosition
prop in<PieChart>
component. - Added customizable
accentColors
prop to<Leaderboard>
component for visual styling.
Improvements
Ingestion
- Improved Webhook Data Pool performance: Increased request per second (RPS) and concurrent request capacity 4x, significantly reducing 429 responses.
- The Webhook Data Pool now accepts payloads up to 1 MiB.
Console
- Enhanced account security: Users can now set up Multi-Factor Authentication (MFA) for their accounts.
- Improved user experience: The last selected Propeller for the Data Pool’s Preview Data will be remembered and displayed for future sessions.
- Updated console for deprecated API Scope: Applications without prior access to
DATA_POOL_READ
,DATA_POOL_STATS
,METRIC_READ
, andMETRIC_STATS
scopes will no longer be able to set these scopes as they are now deprecated
API
- Deprecated
DATA_POOL_READ
,DATA_POOL_STATS
,METRIC_READ
, andMETRIC_STATS
API scopes. - Expanded
DATA_POOL_QUERY
,METRIC_QUERY
API scopes to allow seeing the schema for the Data Pools and columns they have access to. - Improved the resiliency of copy jobs for large tables, reducing errors and preventing jobs from getting stuck. Enhanced error messages to provide more informative feedback when jobs fail.
- Propellers no longer have a limit on maximum bytes to read making them more powerful.
- Materialize View creation now tests the SQL query prior to creating the Materialized View. This protects developers from creating Materialized Views with incorrect SQL. I handles the case when queries take a long time for large datasets gracefully.
SQL
- Enhanced JOIN clause functionality:
- Added support for multiple column expressions using
AND
andOR
operators - Expanded operator support beyond
=
to include>
,<
,LIKE
, andIN
among others.
- Added support for multiple column expressions using
- Increased query result size limit from 500KB to 10MB, allowing for larger data retrieval
- New ClickHouse functions for enhanced string manipulation and searching:
- Position and Search functions like:-
position
,locate
,positionCaseInsensitive
,positionUTF8
,positionCaseInsensitiveUTF8
- multiSearch functions for various use cases (e.g.,AllPositions
,FirstPosition
,FirstIndex
) - Pattern Matching:-
match
,REGEXP
,multiMatchAny
,multiMatchAnyIndex
,multiMatchAllIndices
- Fuzzy matching:multiFuzzyMatchAny
,multiFuzzyMatchAnyIndex
,multiFuzzyMatchAllIndices
- Extraction and Comparison:-
extract
,extractAll
,extractAllGroupsHorizontal
,extractAllGroupsVertical
-like
,notLike
,ilike
,notILike
functions - N-gram and Substring Operations:-
ngramDistance
,ngramSearch
(with case-sensitive and UTF8 variants)-countSubstrings
,countMatches
(with case-insensitive options) - Specialized String Functions:-
regexpExtract
,hasSubsequence
,hasToken
(with various options for case sensitivity and UTF8)
- Position and Search functions like:-
Embeddable UI (0.11.1)
- New layout components:
<Container>
,<Flex>
,<Grid>
, and<Card>
. - New typography components:
<Text>
and<Heading>
. - New
<Tabs>
component for tab-based layouts with support for Card components as tabs. - Added importable theme colors: Users can now import specific colors (e.g.,
gray
) from"@propeldata/ui-kit/colors"
for consistent styling across the application. <TimeRangePicker>
now integrates seamlessly with<FilterProvider>
for improved data filtering across components.- Added new
<TimeGrainPicker>
component that also integrated seamlessly with the<FilterProvider>
. - Improved React compatibility: All components are now compatible with React Server Components (RSC) and exported as client-side components, enhancing performance and flexibility.
- Enhanced debugging capabilities: Components now log prop mismatch errors, facilitating easier troubleshooting and development.
- Added
groupBy
functionality to the<TimeSeries>
component, enabling data grouping and more flexible visualizations. - Enhanced the
<SimpleFilter>
component with clearable functionality. Developers can use thedisableClearable
prop to turn off this feature if needed. - Improved color customization: Replaced
accentColor
withaccentColors
to provide more versatile theming options.
Terraform (v1.3.4)
- Enhanced flexibility in Data Pool configuration: Added support for explicitly setting empty values for
partition_by
,order_by
, andprimary_key
fields. Users can now use the syntax[""]
to define these fields as empty when needed. This improvement allows for more precise control over Data Pool settings.
Fixes
Console
- Resolved issues with Google sign-in for accepting invitations.
- Fixed a bug that prevented sign-ups for users who had previously registered but not verified their email.
- Fixed a bug that caused the SQL Console to attempt to send a Propeller for Applications resulting in an error.
API
- The API now returns a
NOT_FOUND
error when the requested resource doesn’t exist. This applies to Materialized Views, Copy Jobs, and Data Pool access policies, improving error handling and user experience.
Embeddable UI
- Fixed inconsistent border radius across components for improved visual coherence.
- Aligned
<SimpleFilter>
component styles with select-based components like the<TimeRangePicker>
for a more uniform user interface.
Terraform (v1.3.4)
- Fixed an issue where
order_by
,partition_by
, andprimary_key
columns were being applied in an incorrect order when defining Table Settings during Data Pool creation. We replacedSet
withList
to ensure order is preserved in fields where it’s critical.
Improvements
Console
- Developers can now sign up and sign in using their Google account.
- Developers can now sign up and sign in using their GitHub account.
SQL
- Enhanced support for ClickHouse and PostgreSQL array functions.
- Introduced new ClickHouse SQL functions:
arrayJoin
: Allows for the expansion of arrays into separate rows.JSONExtractArrayRaw
: Extracts an array from a JSON string.JSONExtractKeys
: Retrieves keys from a JSON object.JSONArrayLength
: Determines the length of a JSON array.
- Added ClickHouse tuple manipulation functions:
tupleNames
: Returns the names of tuple elements.tupleElement
: Extracts a specific element from a tuple.
- Added ClickHouse geospatial functions for advanced geographical data processing.
New Features
Up to 47% price reduction for your queries
Our most powerful Propellers, the P1_LARGE and P1_X_LARGE, which can read 250 and 500 million rows per second respectively, now have a significantly lower price.
Propeller | Old price | New price | % Price drop |
---|---|---|---|
P1_MEDIUM | $0.10 per GB read | $0.06 per GB read | 40% |
P1_LARGE | $0.12 per GB read | $0.07 per GB read | 42% |
P1_X_LARGE | $0.15 per GB read | $0.08 per GB read | 47% |
As we gain scale, we are committed to passing those savings to our customers.
User management in Console
Customers can now invite their team members to their Propel account. This feature enhances collaboration by allowing multiple users to access and work on the same account. Team members can share resources, manage Data Pools, and streamline their workflows within a single, unified account.
Log in and invite your teammates.
Fixes
Console
- SQL Playground will not show an error when the query is missing a
FROM
statement. - We fixed an issue where the Snowflake Data Pool creation flow was incorrectly sending
ver
param for MergeTree tables, causing creation to fail. - Customers will not see cached tables after running an introspection on any data source.
Ingestion
- We fixed an issue with new Snowflake Data Pools on ReplacingMergeTree that were not supporting Re-sync functionality, the
FINAL
clause was not being correctly added to the underlying ClickHouse queries, and_propel_is_deleted
filtering wasn’t working in some cases.
API
- We fixed an issue when creating and modifying Applications that was not allowing nullable values for the unique name and description fields. Now unique name and description fields are optional as defined in the GraphQL schema.
Improvements
Console
- The SQL Console and Materialized View creation flow now supports formatting the current query.
- When creating a Materialized View with an existing Data Pool, developers will only see Data Pools with a compatible schema.
- Customers will be able to enable/disable access control on Snowflake Data Pool creation.
- You can now copy Metric name and ID from the Metric list page.
Terraform
- Developers can now manage (create, delete, update) Applications via Terraform.
Materialized Views
We’re introducing Materialized Views in Propel’s Serverless ClickHouse as a powerful tool for data transformation. Developers can leverage Materialized Views to reshape, filter, or enrich data with SQL. Materialized Views are persistent query results that update dynamically as the original data changes.
The key benefit? Data is transformed in real time. No scheduling. No full-refreshes.
Learn more about Materialized Views
Rockset Migration Service
OpenAI has announced the acquisition of Rockset, and as a result, the Rockset service will cease to operate. For those unfamiliar with Rockset, it was a cloud-hosted real-time analytics database that enabled millisecond-latency queries for aggregations and joins, similar to Propel.
We are pleased to announce the immediate availability of the Rockset Migration Service. This service is designed to offer a seamless transition for companies from Rockset.
To get started with the migration process, please schedule a kick-off call with our team here.
Customizable Table Engine and Sorting Key for all Data Pools
We are thrilled to announce that Propel now supports customizable table engines and sorting keys for all Data Pools. What does this mean? Better query performance, more cost-efficient reads, and support for real-time updates and delete on any Data Pool type.
Table engines in Propel’s Serverless ClickHouse determine how tables store, process, read, and update their data.
The sorting key is a set of one or more columns that Propel uses to organize the rows within a table. It determines the order of the rows in the table and significantly impacts the query performance. If the rows are sorted well, Propel can efficiently skip over unneeded rows and thus optimize query performance.
This enhancement provides users with more flexibility and control over their data, allowing them to optimize their data pools for their specific use cases.
Learn more about the table engine and sorting key
Fixes
Console
- The “Operations” tab for all Data Pool types.
- All Data Pool types can now have a customizable Propeller in the “Preview Data” section.
Improvements
Terraform
- The resource for Kafka Data Pools is now available.
- The resource for ClickHouse Data Pools is now available.
- The resource for Materialized View is now available.
- The Data Pool resource now supports table settings.
- The Unique ID field is now deprecated in the Data Pool resource.
- The Tenant ID field is now deprecated in the Data Pool resource.
- The timestamp field is now Optional in the Data Pool terraform.
API
- The API ADMIN scope is sufficient for Applications to get and list other Applications, but it does not allow them to fetch other Application secrets. This simplifies Terraforming of Data Pool Access Policies, which previously failed when the Terraform Application had only ADMIN scope.
- The ClickHouse Data Source API is now public.
- You can now modify the
timestamp
field in the Data Pool API. - The
uniqueId
andtenantId
fields are now deprecated in the Webhook Connection Settings object
New Features
Expanded SQL function support
We have significantly expanded our SQL function support, extending it to a broad range of functions for PostgreSQL and ClickHouse SQL dialects, as well as unique Propel functions. This improvement offers developers greater flexibility and control when querying, transforming, and managing data.
Learn more about Propel SQL function support.
New Console Navigation
We’ve rolled out an updated Console navigation. The new menu structure and design organizes the Console into two primary sections: “Data” and “API”. The “Data” section houses all Serverless ClickHouse-related functionalities, and “API” contains all API-related functionalities.
Log in to the Console to see the new navigation.
GraphQL Schema Explorer
We introduced a GraphQL Schema Explorer in the Console. Developers can now actively search through the Propel API GraphQL schema, access API endpoints with ease, and directly download the schema from a provided URL.
Check out the new GraphQL Schema Explorer in the Console.
Fixes
Ingestion
- We resolved an issue with the S3 Data Pool that caused a persistent “CONNECTING” state when customers used an “s3://” or “https://” prefix in the URL for their table path, rather than a relative path within the bucket. Now, if the provided “s3://” or “https://” URL points to the named bucket, the URL’s path is used as the relative path into the bucket. Invalid table paths provided by the customer will now be synchronously rejected.
Console
- We fixed the SQL Console to respect the Propeller selection.
- We fixed the GraphQL Playground to respect the Propeller selection.
- When creating a Data Pool, we fixed the case when a timestamp is not selected.
- In the API Playground, we fixed leaderboard dimensions clearing for ClickHouse Data Pools.
- In the API Playground, we fixed the leaderboard table view width and height.
- In the API Playground, we fixed the time dimension not pre-populating.
- In the SQL Console, we fixed result cell wrapping.
- Data Pools created by Materialized Views now see the “Operations” tab.
Improvements
SQL
- The SQL interface now properly handles identifier quoting.
- We now support CASE statements in SQL.
API
- The query APIs now support SQL-style filters. Everywhere you could provide
filters
, you can now providefilterSql
. For example, see thefilterSql
parameter in the counter API. - Data Pool Access Policies can now be defined with the new
filterSql
parameter that supports SQL-style filters.
Console
- The API Playground will now populate filter values using the Top Values API.
- The API Playground now includes an “All time” option for the relative time range.
- The API Playground has a new layout for TimeSeries, Counter, and Leaderboard APIs.
- The API Playground now supports setting a “Time Dimension” that is different from the Data Pool’s default timestamp.
- The API Playground will now show the Data Pool selection first.
- The API Playground will now only show the “Existing Metrics” for the selected Data Pool.
- The SQL Console has a new improved layout.
- The SQL Console has new improved SQL syntax validation.
- The SQL Console will now show long result values in a tooltip when they are trimmed.
- The Data Pool list page will not break if the sync activity query fails.
- When creating and updating Amazon S3 credentials, the path and bucket will be trimmed to prevent white spaces from being accidentally entered.
New features
ClickHouse Data Pool beta
The ClickHouse Data Pool enables you to read through to your self-hosted ClickHouse or ClickHouse Cloud rather than syncing data to Propel. This allows you to utilize the data in your analytic dashboards, reports, and workflows directly from your ClickHouse instance through the Propel APIs and UI components.
Learn more about the ClickHouse Data Pool.
GraphQL Playground
The GraphQL Playground enables you to run GraphQL queries directly from the Console, offering a simple way to interact with your data when building applications.
Key Features:
- GraphQL schema autocompletion
- Code examples
- Access token generator
Log in to the Console and click “Playground”, then select “API: GraphQL”.
Fixes
- Fixed AND/OR logic bug in SQL.
- Fixed typo in default Webhook Data pool name.
- Free trial plan no longer expires incorrectly.
- Fixed case-insensitivity in Materialized Views.
- Fix automatic syncing of HTTP Data Sources which contain multiple HTTP Data Pools.
- Fixed the column
_propel_synced_at
that was incorrectly set for some Webhook Data Pools, resulting in out-of-range values. - Fixed columns length validation for Kafka on Data Pool creation.
- Fixed a race condition while re-assigning Access Policies.
Improvements
- You can now create Data Pools with ClickHouse types via the API.
- Implemented improvements to our access token API that reduced/eliminated the HTTP 500 errors that some customers experienced.
- Added support for AggregatingMergeTree table engine for Data Pools via the API.
- The Webhook Data Pool now returns HTTP 413 Content Too Large error if the payload exceeds 1,048,320 bytes or has more than 500 events.
- Add support for read-only filterSql with a SQL representation of the filters.
- Raised the GraphQL aliases limit to 250.
- Improved the case insensitivity matching for identifiers in SQL.
- Added support lists of strings and lists of numbers in Postgres SQL.
- Added support NOT IN and AT TIME ZONE operators in SQL.
- Added support column auto aliasing in SQL.
- Added support for unary expressions in SQL.
- Added support for CURRENT_DATE in SQL.
⚡️ 10x faster ingestion for the Webhook Data Pool
The Webhook Data Pool now ingests events 10x faster. We have optimized ingestion so that data is available within single digit seconds.
Learn more about the Webhook Data Pool.
🛝 SQL Playground
With Propel’s new SQL Playground, you can now execute SQL queries directly from the Console. It provides you with an easy way to explore your data when building applications.
Key Features:
- Code examples: easily integrate queries into your code. Get code examples for querying data using SQL via the API, cURL, and JavaScript.
- ”Query as” selector: simulate querying as your app. Different apps have unique data query permissions set through Access Policies. The Playground allows you to test queries as a specific app.
- ”Propeller” selector: experiment with query speeds. Test different query speeds to optimize performance and cost for your data application.
Log in to the Console and click “Playground”, then select “API: SQL”.
✈️ Airbyte destination
The Airbyte destination lets you synchronize data from over 350+ sources to Propel’s Serverless ClickHouse infrastructure. It provides an easy way to power your customer-facing analytics and data applications with data from any SaaS application, database, or platform supported by Airbyte.
Learn more about the Airbyte destination.
Fixes
- Customers will be able to change the URL in their ClickHouse credentials on creation flow in the Console.
- Customers will not see stale data when modifying credentials for ClickHouse and Kafka in the Console.
- Signed in customers will be redirected from /login to dashboard.
- In the GraphQL Playground, customers will be able to clear the variables input and run queries with no variables.
- Fixed a bug when parsing table names that contain aliases in SQL.
- Fixed a bug where table aliases where being lowercased in SQL.
Improvements
- By setting the
disable_partial_success=true
query parameter, you can ensure that, if any individual event in a batch of events fails validation, the entire request will fail. For example:https://webhooks.us-east-2.propeldata.com/v1/WHK00000000000000000000000000?disable_partial_success=true
- Added SUBSTRING function to SQL.
- Added support for extracting parts from a timestamp in SQL.
- Raised SQL response size limit to 2 MB.
- The PostgreSQL interface now supports extended queries.
Kafka Data Pool
The new Kafka Data Pool lets you ingest real-time streaming data into Propel. It provides an easy way to power real-time dashboards, streaming analytics, and workflows with a low-latency data API on top of your Kafka topics.
Learn more about the Kafka Data Pool.
🆓 New Generous Free Tier
We are introducing a new, generous free tier! It includes up to $15 of usage per month, and the best part is, it does not expire.
Sign up and get started today.
䷰ Schema evolution: Add a column to Data Pool operation
We are introducing Schema Evolution for Data Pools with the ability to add new columns to your Data Pools. Now, you can add new columns to your Data Pools, allowing you to evolve your data schema as your needs grow and change.
Learn more about the Add column to Data Pool operation.
🚚 Batch delete and update operation
The new batch delete operation helps you stay GDPR compliant by providing a straightforward way to permanently delete data from a Data Pool. Meanwhile, the batch update operation helps maintain data integrity and facilitates data backfilling in the event of schema changes. Both operations can be done via the Console or API.
Learn more about batch updates and deletes.
🪵 React UI Kit logging controls
The Propel UI Kit now features logging capabilities for faster development and clean logging in production. By default, all errors are logged to the browser’s console. This behavior can be customized using the LogProvider component. The LogProvider uses React’s context mechanism to propagate log settings to nested components, allowing for specific component logging. Available log levels include “error”, “warn”, “info”, or “debug”.
Learn more about the React UI Kit’s logging controls.
Fivetran preview
The Fivetran destination lets you synchronize data from over 400 sources to Propel’s Serverless ClickHouse infrastructure.
Learn more about our Fivetran destination.
Bring your own ClickHouse preview
The ClickHouse Data Pool reads through to your self-hosted ClickHouse or ClickHouse Cloud rather than syncing data to Propel.
Learn more about the ClickHouse “read-through” Data Pool.
Fixes
- Fix timezone argument on
toStartOfWeek
,toStartOfMonth
, andtoStartOfYear
SQL functions. - Fixed login loop for accounts with Okta integration.
- Fixed environments dropdown in Console in the new Data Pool page.
- Fixed the Preview Data section of the Console where customers can now change time range and page size when the query results in a time out or an error.
Improvements
- Add support for timestamps without timezones
- Support
NOW()
andCURRENT_DATE
functions in SQL. - Support
INTERVAL
in SQL. - An alternative
timestamp
can be supplied toTimeRangeInput
when querying. - Customers can view TableSettings (
engine
,partitionBy
,primaryKey
, andorderBy
) for their Data Pools via the API. - Allow creating Data Pools (including Webhook Data Pools) without
timestamp
via the API. - Allow setting TableSettings (
engine
,partitionBy
,primaryKey
, andorderBy
) when creating a Data Pool via the API. - In the Console, customers can have a different environment in multiple tabs without losing the last selected state.
- In the Console, Customers will see the
processedRecords
instead ofnewRecords
in the Processed Records column for the Syncs table. - Customers can now change the sort and timestamp column in the Console in the Preview Data tab.
🔎 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
, andtoStartOfYear
SQL 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: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.
Was this page helpful?