Materialize

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.

ksqlDB MongoDB

⌘I

Connect to data

Users & Permissions

SSO & Identity Providers

Deployment

Monitoring

AI

Account

Prerequisites

Setup

Manual

Environment Variables

SSL

​Prerequisites

​Setup

​Manual

​Environment Variables

​SSL

Prerequisites

Setup

Manual

Environment Variables

SSL