Using MinIO

This page isn’t applicable to ClickHouse Cloud. The feature documented here isn’t available in ClickHouse Cloud services. See the ClickHouse Cloud Compatibility guide for more information.

All S3 functions and tables and compatible with MinIO. You may experience superior throughput on self-hosted MinIO stores, especially in the event of optimal network locality. Also backed merge tree configuration is compatible too, with some minor changes in configuration:

<clickhouse>
    <storage_configuration>
        ...
        <disks>
            <s3>
                <type>s3</type>
                <endpoint>https://min.io/tables//</endpoint>
                <access_key_id>your_access_key_id</access_key_id>
                <secret_access_key>your_secret_access_key</secret_access_key>
                <region></region>
                <metadata_path>/var/lib/clickhouse/disks/s3/</metadata_path>
            </s3>
            <s3_cache>
                <type>cache</type>
                <disk>s3</disk>
                <path>/var/lib/clickhouse/disks/s3_cache/</path>
                <max_size>10Gi</max_size>
            </s3_cache>
        </disks>
        ...
    </storage_configuration>
</clickhouse>

Note the double slash in the endpoint tag, this is needed to designate the bucket root.

Data sources

Data visualization

Data ingestion

Data integrations

SQL-clients

Tools