SingleStore (opens in a new tab) is a distributed SQL database that offers high-throughput transactions (inserts and upserts) and low-latency analytics.

SingleStore support is available in Cube Cloud on Enterprise Premier (opens in a new tab) tier. Contact us (opens in a new tab) for details.


When creating a new deployment in Cube Cloud, at the Set up a database connection step, choose SingleStore.

Then, provide credetials: host name, database name, user name (admin by default), and password.

Host name

To obtain the host name, navigate to the necessary group and workspace in the side bar, then click Connect and choose CLI client:

On the Connect to Workspace page, you can find the host name (svc-<UUID>-dml.<REGION>

Database name

To obtain the database name, navigate to the necessary group and workspace in the side bar. You'll see databases on the right:


You have set the password when creating the workspace. If you'd like to reset the password, navigate to the Access tab within your workspace.

Pre-Aggregation Feature Support


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

Pre-Aggregation Build Strategies

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

FeatureWorks with read-only mode?Is default?
Export Bucket--

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


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


SingleStore does not support batching.

Export Bucket

SingleStore does not support export buckets.