RisingWave

RisingWave is a distributed streaming database that enables processing and management of real-time data with a Postgres-style SQL syntax. It is available as an open-source edition and a managed cloud service.

Prerequisites

Credentials for the RisingWave cluster

Setup

RisingWave provides a Postgres-compatible interface. You can connect Cube to RisingWave as if it's a regular Postgres data source.

Manual

Add the following to a .env file in your Cube project:

dotenv

CUBEJS_DB_TYPE=postgres
CUBEJS_DB_HOST=risingwave_host
CUBEJS_DB_PORT=risingwave_port
CUBEJS_DB_NAME=risingwave_database
CUBEJS_DB_USER=risingwave_user
CUBEJS_DB_PASS=risingwave_password

Environment variables

Environment Variable	Description	Possible Values	Required
<EnvVar>CUBEJS_DB_HOST</EnvVar>	The host URL for a database	A valid database host URL	✅
<EnvVar>CUBEJS_DB_PORT</EnvVar>	The port for the database connection	A valid port number	❌
<EnvVar>CUBEJS_DB_NAME</EnvVar>	The name of the database to connect to	A valid database name	✅
<EnvVar>CUBEJS_DB_USER</EnvVar>	The username used to connect to the database	A valid database username	✅
<EnvVar>CUBEJS_DB_PASS</EnvVar>	The password used to connect to the database	A valid database password	✅
<EnvVar>CUBEJS_DB_SSL</EnvVar>	If `true`, enables SSL encryption for database connections from Cube	`true`, `false`	❌
<EnvVar>CUBEJS_DB_MAX_POOL</EnvVar>	The maximum number of concurrent database connections to pool. Default is `8`	A valid number	❌
<EnvVar>CUBEJS_CONCURRENCY</EnvVar>	The number of concurrent queries to the data source	A valid number	❌

Pre-aggregation feature support

`count_distinct_approx`

Measures of type count_distinct_approx can not be used in pre-aggregations when using RisingWave as a source database.

Pre-aggregation build strategies

To learn more about pre-aggregation build strategies, head here.

</InfoBox>

Feature	Works with read-only mode?	Is default?
Simple	✅	✅
Batching	-	-
Export bucket	-	-

By default, RisingWave uses a simple strategy to build pre-aggregations.

Simple

No extra configuration is required to configure simple pre-aggregation builds for RisingWave.

Batching

RisingWave does not support batching.

Export bucket

RisingWave does not support export buckets.