SingleStore

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

<Note>

Available on the Enterprise plan. Contact us for details.

</Note>

Setup

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

<Frame> </Frame>

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:

<Frame> </Frame>

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

<Frame> </Frame>

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:

<Frame> </Frame>

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

<Info>

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

</Info>

Feature	Works 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.