> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cube.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# SingleStore

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

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

<Note>
  Available on the [Enterprise plan](https://cube.dev/pricing).
  [Contact us](https://cube.dev/contact) for details.
</Note>

## Setup

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

<Frame>
  <img src="https://ucarecdn.com/fd7e2d2d-26f1-4c7a-8b0f-1d82bf78c83b/" />
</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>
  <img src="https://ucarecdn.com/240d483f-9887-4b59-87bf-1673bc46d0dd/" />
</Frame>

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

<Frame>
  <img src="https://ucarecdn.com/e15ff010-15fe-43db-8e4a-f3e55f203b81/" />
</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>
  <img src="https://ucarecdn.com/240d483f-9887-4b59-87bf-1673bc46d0dd/" />
</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`][ref-schema-ref-types-formats-countdistinctapprox] 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][ref-caching-using-preaggs-build-strats].
</Info>

| Feature       | Works with read-only mode? | Is default? |
| ------------- | :------------------------: | :---------: |
| Simple        |              ✅             |      ✅      |
| Batching      |              -             |      -      |
| Export Bucket |              -             |      -      |

By default, SingleStore uses a [simple][self-preaggs-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.

[link-singlestore]: https://www.singlestore.com

[ref-caching-using-preaggs-build-strats]: /docs/pre-aggregations/using-pre-aggregations#pre-aggregation-build-strategies

[ref-schema-ref-types-formats-countdistinctapprox]: /reference/data-modeling/measures#type

[self-preaggs-simple]: #simple