# Load Data SingleStore provides several options for loading data from various sources such as files, cloud repositories, external databases, and third-party ETL or CDC tools. ## Data Loading Methods Available in SingleStore * **SingleStore Flow**: A GUI-based tool designed for database migration and change data capture (CDC) replication. It supports a wide range of enterprise databases. * **SingleStore Pipelines**: A built-in, real-time ingestion mechanism ideal for streaming and ETL scenarios, allowing continuous loading and transformation of data from file storages and streaming platforms. * **LOAD DATA SQL Command**: A SQL-based method for directly loading data from local or remote files into SingleStore tables. ## Supported File Formats SingleStore supports loading data from the following file formats: * [CSV](https://docs.singlestore.com/db/v9.1/load-data/load-data-from-files/load-data-from-csv-files.md) * [JSON](https://docs.singlestore.com/db/v9.1/load-data/load-data-from-files/load-data-from-json-files.md) * [BSON](https://docs.singlestore.com/db/v9.1/load-data/load-data-from-files/load-data-from-json-files.md) * [Avro](https://docs.singlestore.com/db/v9.1/load-data/load-data-from-files/load-data-from-avro-files.md) * [Parquet](https://docs.singlestore.com/db/v9.1/load-data/load-data-from-files/load-data-from-parquet-files.md) ## Data Sources And the Corresponding Loading Methods in SingleStore **Note**: Click a check mark (**✓**) to view the associated guide. | Data Sources | SingleStoreFlow | Pipelines | LOAD DATA Command | Notes/Special Features | | -------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **FIle Systems** | | | | | | Amazon Web Services (AWS) S3 | | [**✓**](https://docs.singlestore.com/db/v9.1/load-data/data-sources/load-data-from-amazon-web-services-aws-s-3.md) | [**✓**](https://docs.singlestore.com/db/v9.1/load-data/data-sources/load-data-from-amazon-web-services-aws-s-3.md) | | | Azure Blob Storage | | [**✓**](https://docs.singlestore.com/db/v9.1/load-data/data-sources/load-data-from-azure-blob-storage-using-a-pipeline/#connect-to-azure-blob-storage-from-singlestore.md) | [**✓**](https://docs.singlestore.com/db/v9.1/load-data/data-sources/load-data-from-azure-blob-storage-using-a-pipeline/#connect-to-azure-blob-storage-from-singlestore-2.md) | | | Google Cloud Storage (GCS) | | [**✓**](https://docs.singlestore.com/db/v9.1/load-data/data-sources/load-data-from-google-cloud-storage-gcs-using-a-pipeline.md) | [**✓**](https://docs.singlestore.com/db/v9.1/load-data/data-sources/load-data-from-google-cloud-storage-gcs-using-a-pipeline.md) | | | Hadoop Distributed File System (HDFS) | | **[✓](https://docs.singlestore.com/db/v9.1/load-data/data-sources/load-data-from-hdfs-using-a-pipeline.md)** | | | | Apache Iceberg | | **[✓](https://docs.singlestore.com/db/v9.1/load-data/data-sources/iceberg-ingest.md)** | | | | Filesystem paths (local or network drives) | | **[✓](https://docs.singlestore.com/db/v9.1/load-data/data-sources/load-data-from-the-filesystem-using-a-pipeline.md)** | [**✓**](https://docs.singlestore.com/db/v9.1/load-data/load-data-from-files/load-data-from-local-files.md) | | | **Streaming Systems** | | | | | | Kafka | | [**✓**](https://docs.singlestore.com/db/v9.1/load-data/data-sources/load-data-from-kafka.md) | | | | Amazon Kinesis | | **[✓](https://docs.singlestore.com/db/v9.1/load-data/data-sources/load-data-from-amazon-kinesis-using-a-kafka-connect-pipeline.md)** | | | | **Database Sources** | | | | | | Oracle & Oracle RAC | **[✓](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow.md)** | | | | | Microsoft SQL Server | **[✓](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow.md)** | | | | | MySQL | **[✓](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow.md)** | **[✓](https://docs.singlestore.com/db/v9.1/load-data/about-singlestore-pipelines/pipeline-concepts/aggregator-pipelines.md)** | | When using pipelines; there is a cap of 16 pipelines for the MySQL source.Also supports[mysqlimport](https://docs.singlestore.com/db/v9.1/load-data/data-sources/replicate-data-from-mysql/load-data-from-mysql.md)utility. | | PostgreSQL | [**✓**](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow.md) | | | | | Snowflake | **[✓](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow.md)** | | | Data migration only. | | Any JDBC-compliant database | **[✓](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow.md)** | | | Limited to non-production preview, available for testing. | | MongoDB® | **[✓](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow.md)** | **[✓](https://docs.singlestore.com/db/v9.1/load-data/about-singlestore-pipelines/pipeline-concepts/aggregator-pipelines.md)** | | When using pipelines; there is a cap of 16 pipelines for MongoDB® source. | | **Third-party Integration Tools** | | | | | | Apache Beam/Flink, AWS Glue, Azure Data Factory, dbt, Fivetran, Informatica, Qlik, StreamSets and similar platforms. | | | | Supports JDBC, ODBC, REST APIs.[Third-party and Custom Connectors](https://docs.singlestore.com/db/v9.1/load-data/integrate-with-singlestore.md) | ## In this section * [Load Data with SingleStore Flow](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow.md) * [Load Data with SingleStore Flow on Helios](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow-on-helios.md) * [About SingleStore Pipelines](https://docs.singlestore.com/db/v9.1/load-data/about-singlestore-pipelines.md) * [Data Sources](https://docs.singlestore.com/db/v9.1/load-data/data-sources.md) * [Load Data from Files](https://docs.singlestore.com/db/v9.1/load-data/load-data-from-files.md) * [Integrate with SingleStore](https://docs.singlestore.com/db/v9.1/load-data/integrate-with-singlestore.md) *** Modified at: May 25, 2026 Source: [/db/v9.1/load-data/](https://docs.singlestore.com/db/v9.1/load-data/) (An index of the documentation is available at /llms.txt)