> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/analytics/mariadb-columnstore/clients-and-tools.md).

# 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 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.