RisingWave

Point Cube at RisingWave using the Postgres-compatible driver and your cluster host, database, and credential settings.

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:

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
CUBEJS_DB_HOST	The host URL for a database	A valid database host URL	✅
CUBEJS_DB_PORT	The port for the database connection	A valid port number	❌
CUBEJS_DB_NAME	The name of the database to connect to	A valid database name	✅
CUBEJS_DB_USER	The username used to connect to the database	A valid database username	✅
CUBEJS_DB_PASS	The password used to connect to the database	A valid database password	✅
CUBEJS_DB_SSL	If true, enables SSL encryption for database connections from Cube	true, false	❌
CUBEJS_DB_MAX_POOL	The maximum number of concurrent database connections to pool. Default is 8	A valid number	❌
CUBEJS_CONCURRENCY	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.

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.