Materialize

The driver for Materialize is supported by its vendor. Please report any issues to their Slack.

The driver for Materialize is supported by its vendor. Please report any issues to their Slack.

Prerequisites

• The hostname for the Materialize database server

Setup

Manual

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

CUBEJS_DB_TYPE=materialize
CUBEJS_DB_HOST=my.materialize.host
CUBEJS_DB_PORT=6875
CUBEJS_DB_NAME=materialize
CUBEJS_DB_USER=materialize
CUBEJS_DB_PASS=materialize
CUBEJS_DB_MATERIALIZE_CLUSTER=quickstart

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_MAX_POOL	The maximum number of concurrent database connections to pool. Default is 8	A valid number	❌
CUBEJS_DB_MATERIALIZE_CLUSTER	The name of the Materialize cluster to connect to	A valid cluster name	❌
CUBEJS_CONCURRENCY	The number of concurrent queries to the data source	A valid number	❌

SSL

To enable SSL-encrypted connections between Cube and Materialize, set the CUBEJS_DB_SSL environment variable to true. For more information on how to configure custom certificates, please check out Enable SSL Connections to the Database.