# ClickHouse

This reference documents the Kubernetes configuration options for the ClickHouse chart, which provides an analytics database for the Grafbase Enterprise Platform.

All configuration options are nested under the `clickhouse` key.

You can find the ClickHouse chart source code from the [ArtifactHub](https://artifacthub.io/packages/helm/bitnami/clickhouse?modal=values).

## zookeeper

Zookeeper configuration for the ClickHouse cluster.

**Defaults**:

```yaml
zookeeper:
  enabled: false
```

## shards

Number of shards for the ClickHouse cluster.

**Defaults**:

```yaml
shards: 1
```

## replicaCount

[Kubernetes ReplicationController Docs](https://kubernetes.io/docs/concepts/workloads/controllers/replicationcontroller/)

**Defaults**:

```yaml
replicaCount: 1
```

## initdbScripts

List of scripts to run during the ClickHouse initialization.

**Defaults**:

```yaml
initdbScripts:
  create_database.sh: |
    #!/bin/bash
    clickhouse-client --user "$CLICKHOUSE_ADMIN_USER" --password "$CLICKHOUSE_ADMIN_PASSWORD" --query "CREATE DATABASE IF NOT EXISTS analytics;"
```

## auth

Authentication configuration for the ClickHouse database.

**Defaults**:

```yaml
auth:
  username: grafbase
  password: grafbase
```

## commonAnnotations

[Kubernetes Common Annotations](https://kubernetes.io/docs/concepts/overview/working-with-objects/annotations/)

**Defaults**:

```yaml
commonAnnotations:
  'helm.sh/hook': pre-install
  'helm.sh/hook-weight': '-15'
```

## resources

Resource requests and limits for the ClickHouse container.

**Defaults**:

```yaml
resources:
  requests:
    cpu: 1
    memory: 1024Mi
  limits:
    cpu: 1
    memory: 2048Mi
```