Skip to main content
· 2 min read

April 2024 new features, fixes, and improvements

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.

Propel's Webhook latency demo.

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".

Propel's GraphQL Playground

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.