New features, fixes, and improvements.
SHOW DATABASES
SHOW TABLES
SHOW COLUMNS
SHOW INDEXES
SHOW CREATE DATABASE
SHOW CREATE TABLE
SHOW FUNCTIONS
SHOW ENGINES
system.databases
system.tables
system.columns
system.aggregate_function_combinators
system.formats
system.functions
system.licenses
system.settings
system.settings_changed
system.table_engines
system.table_functions
system.time_zones
date_time_output_format = 'simple'
when Faraday user agent is detectedcurrentDatabase()
to return “propel”
wait_end_of_query
parameter used by Python clients
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 |
<GroupBy>
component is a dropdown menu that allows users to dynamically change the grouping of data for multidimensional analysis.<GroupBy>
component.X-ClickHouse-User
and X-ClickHouse-Key
headers.PENDING
state.chartConfigProps
in the <TimeSeries>
component.groupBy
functionality to <TimeSeries>
and <FilterProvider>
components for dynamic data grouping.<Leaderboard>
component to properly sync with time range from <FilterProvider>
.legendPosition
prop in <PieChart>
component.accentColors
prop to <Leaderboard>
component for visual styling.DATA_POOL_READ
, DATA_POOL_STATS
, METRIC_READ
, and METRIC_STATS
scopes will no longer be able to set these scopes as they are now deprecatedDATA_POOL_READ
, DATA_POOL_STATS
, METRIC_READ
, and METRIC_STATS
API scopes.DATA_POOL_QUERY
, METRIC_QUERY
API scopes to allow seeing the schema for the Data Pools and columns they have access to.AND
and OR
operators=
to include >
, <
, LIKE
, and IN
among others.position
, locate
, positionCaseInsensitive
, positionUTF8
, positionCaseInsensitiveUTF8
- multiSearch functions for various use cases (e.g., AllPositions
, FirstPosition
, FirstIndex
)match
, REGEXP
, multiMatchAny
, multiMatchAnyIndex
, multiMatchAllIndices
- Fuzzy matching: multiFuzzyMatchAny
, multiFuzzyMatchAnyIndex
, multiFuzzyMatchAllIndices
extract
, extractAll
, extractAllGroupsHorizontal
, extractAllGroupsVertical
- like
, notLike
, ilike
, notILike
functionsngramDistance
, ngramSearch
(with case-sensitive and UTF8 variants)- countSubstrings
, countMatches
(with case-insensitive options)regexpExtract
, hasSubsequence
, hasToken
(with various options for case sensitivity and UTF8)<Container>
, <Flex>
, <Grid>
, and <Card>
.<Text>
and <Heading>
.<Tabs>
component for tab-based layouts with support for Card components as tabs.gray
) from "@propeldata/ui-kit/colors"
for consistent styling across the application.<TimeRangePicker>
now integrates seamlessly with <FilterProvider>
for improved data filtering across components.<TimeGrainPicker>
component that also integrated seamlessly with the <FilterProvider>
.groupBy
functionality to the <TimeSeries>
component, enabling data grouping and more flexible visualizations.<SimpleFilter>
component with clearable functionality. Developers can use the disableClearable
prop to turn off this feature if needed.accentColor
with accentColors
to provide more versatile theming options.partition_by
, order_by
, and primary_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.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.<SimpleFilter>
component styles with select-based components like the <TimeRangePicker>
for a more uniform user interface.order_by
, partition_by
, and primary_key
columns were being applied in an incorrect order when defining Table Settings during Data Pool creation. We replaced Set
with List
to ensure order is preserved in fields where it’s critical.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.tupleNames
: Returns the names of tuple elements.tupleElement
: Extracts a specific element from a tuple.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% |
FROM
statement.ver
param for MergeTree tables, causing creation to fail.FINAL
clause was not being correctly added to the underlying ClickHouse queries, and _propel_is_deleted
filtering wasn’t working in some cases.timestamp
field in the Data Pool API.uniqueId
and tenantId
fields are now deprecated in the Webhook Connection Settings objectfilters
, you can now provide filterSql
. For example, see the filterSql
parameter in the counter API.filterSql
parameter that supports SQL-style filters._propel_synced_at
that was incorrectly set for some Webhook Data Pools, resulting in out-of-range values.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
toStartOfWeek
, toStartOfMonth
, and toStartOfYear
SQL functions.NOW()
and CURRENT_DATE
functions in SQL.INTERVAL
in SQL.timestamp
can be supplied to TimeRangeInput
when querying.engine
, partitionBy
, primaryKey
, and orderBy
) for their Data Pools via the API.timestamp
via the API.engine
, partitionBy
, primaryKey
, and orderBy
) when creating a Data Pool via the API.processedRecords
instead of newRecords
in the Processed Records column for the Syncs table.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.toStartOfWeek
, toStartOfMonth
, and toStartOfYear
SQL functions.data_pool:read
scope to list Data Pools and their schemas.timeRange
optional in GraphQL API.