Skip to main content

​
SingleStore

SingleStore is a distributed SQL database that offers high-throughput transactions (inserts and upserts) and low-latency analytics.
Available on the Enterprise Premier plan. Contact us for details.

​
Setup

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>.svc.singlestore.com):

​
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:

​
Password

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

​
count_distinct_approx

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?
Simple✅✅
Batching--
Export Bucket--
By default, SingleStore uses a simple strategy to build pre-aggregations.

​
Simple

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

​
Batching

SingleStore does not support batching.

​
Export Bucket

SingleStore does not support export buckets.