# Clients & Tools

- [StorageManager](https://mariadb.com/docs/analytics/mariadb-columnstore/clients-and-tools/storagemanager.md): The ColumnStore StorageManager manages columnar data storage and retrieval, optimizing analytical queries.
- [Certified S3 Object Storage Providers](https://mariadb.com/docs/analytics/mariadb-columnstore/clients-and-tools/storagemanager/certified-s3-object-storage-providers.md): Certified S3-compatible object storage providers for MariaDB ColumnStore: Quantum ActiveScale, IBM Cloud Object Storage, Dell EMC ECS, AWS S3, and Google Cloud Storage.
- [Sample storagemanager.cnf](https://mariadb.com/docs/analytics/mariadb-columnstore/clients-and-tools/storagemanager/storagemanager-sample-storagemanagercnf.md): Sample storagemanager.cnf for MariaDB ColumnStore showing \[ObjectStorage], \[S3], and \[LocalStorage] sections with credentials, paths, and concurrency tuning options.
- [Using StorageManager With IAM Role](https://mariadb.com/docs/analytics/mariadb-columnstore/clients-and-tools/storagemanager/using-storagemanager-with-iam-role.md): MariaDB ColumnStore StorageManager can authenticate to S3 via an AWS IAM role attached to the EC2 instance, removing credentials from storagemanager.cnf; from ColumnStore 5.5.2.
- [Data Ingestion Methods & Tools](https://mariadb.com/docs/analytics/mariadb-columnstore/clients-and-tools/data-ingestion.md): Data ingestion options for MariaDB ColumnStore: cpimport for fast bulk loads, LOAD DATA INFILE, batch insert mode, INSERT INTO .. SELECT, DML, plus Bulk Write SDK and streaming adapters.
- [ColumnStore Batch Insert Mode](https://mariadb.com/docs/analytics/mariadb-columnstore/clients-and-tools/data-ingestion/columnstore-batch-insert-mode.md): Batch insert mode uses cpimport for non-transactional LOAD DATA INFILE and INSERT INTO .. SELECT statements in MariaDB ColumnStore, controlled via infinidb\_use\_import\_for\_batchinsert.
- [ColumnStore Bulk Data Loading](https://mariadb.com/docs/analytics/mariadb-columnstore/clients-and-tools/data-ingestion/columnstore-bulk-data-loading.md): Bulk data loading in MariaDB ColumnStore uses cpimport for fast append-only ingestion of delimited flat files, with tokenization and atomic high-water-mark commits.
- [ColumnStore Streaming Data Adapters](https://mariadb.com/docs/analytics/mariadb-columnstore/clients-and-tools/data-ingestion/columnstore-streaming-data-adapters.md): Streaming data adapters for MariaDB ColumnStore built on the Bulk Data API, including the deprecated MaxScale CDC adapter and a Kafka adapter for ETL and real-time ingestion.
- [ColumnStore Insert Cache](https://mariadb.com/docs/analytics/mariadb-columnstore/clients-and-tools/data-ingestion/columnstore-insert-cache.md): The MariaDB ColumnStore Insert Cache buffers small INSERTs in a hidden Aria table before flushing in batches to columnar storage, improving throughput for HTAP and write-heavy workloads.
- [Data Import](https://mariadb.com/docs/analytics/mariadb-columnstore/clients-and-tools/data-import.md): Data import methods for MariaDB ColumnStore: cpimport, INSERT INTO .. SELECT and LOAD DATA INFILE auto-translation, batch insert mode, and load\_from\_s3 from S3 cloud storage.
- [Data Loading with cpimport](https://mariadb.com/docs/analytics/mariadb-columnstore/clients-and-tools/data-import/mariadb-enterprise-columnstore-data-loading-with-cpimport.md): Data loading into MariaDB ColumnStore with cpimport: a non-blocking, append-only bulk load that bypasses the SQL layer and supports text, binary, and stdin sources.
- [Data Loading with INSERT .. SELECT](https://mariadb.com/docs/analytics/mariadb-columnstore/clients-and-tools/data-import/mariadb-enterprise-columnstore-data-loading-with-insert-select.md): MariaDB ColumnStore translates INSERT INTO .. SELECT into a cpimport bulk load when batch insert mode is on and the statement runs outside a transaction.
- [Data Loading with LOAD DATA INFILE](https://mariadb.com/docs/analytics/mariadb-columnstore/clients-and-tools/data-import/mariadb-enterprise-columnstore-data-loading-with-load-data-infile.md): MariaDB ColumnStore translates LOAD DATA INFILE statements into cpimport bulk loads when batch insert mode is on and the statement runs outside a transaction.
- [Data Loading With load\_from\_s3](https://mariadb.com/docs/analytics/mariadb-columnstore/clients-and-tools/data-import/mariadb-enterprise-columnstore-data-loading-with-load_from_s3.md): Load delimited data files from S3-compatible cloud object storage into MariaDB ColumnStore using the columnstore\_info.load\_from\_s3 stored procedure, available from CS 23.02.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/analytics/mariadb-columnstore/clients-and-tools.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.