# 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. All of these methods are accessible through the Helios Portal Load Data UI for easy setup and management. ## Supported File Formats SingleStore supports loading data from the following file formats: * [CSV](https://docs.singlestore.com/cloud/load-data/load-data-from-files/load-data-from-csv-files.md) * [JSON](https://docs.singlestore.com/cloud/load-data/load-data-from-files/load-data-from-json-files.md) * [BSON](https://docs.singlestore.com/cloud/load-data/load-data-from-files/load-data-from-json-files.md) * [Avro](https://docs.singlestore.com/cloud/load-data/load-data-from-files/load-data-from-avro-files.md) * [Parquet](https://docs.singlestore.com/cloud/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/cloud/load-data/data-sources/load-data-from-amazon-web-services-aws-s-3.md) | [**✓**](https://docs.singlestore.com/cloud/load-data/data-sources/load-data-from-amazon-web-services-aws-s-3.md) | | | Azure Blob Storage | | [**✓**](https://docs.singlestore.com/cloud/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/cloud/load-data/data-sources/load-data-from-azure-blob-storage-using-a-pipeline/connect-to-azure-blob-storage-from-singlestore.md) | | | Google Cloud Storage (GCS) | | [**✓**](https://docs.singlestore.com/cloud/load-data/data-sources/load-data-from-google-cloud-storage-gcs-using-a-pipeline.md) | [**✓**](https://docs.singlestore.com/cloud/load-data/data-sources/load-data-from-google-cloud-storage-gcs-using-a-pipeline.md) | | | Hadoop Distributed File System (HDFS) | | **[✓](https://docs.singlestore.com/cloud/load-data/data-sources/load-data-from-hdfs-using-a-pipeline.md)** | | | | Apache Iceberg | | **[✓](https://docs.singlestore.com/cloud/load-data/data-sources/iceberg-ingest.md)** | | | | Filesystem paths (local or network drives) | | **[✓](https://docs.singlestore.com/cloud/load-data/data-sources/#load-data-from-the-filesystem-using-a-pipeline.md)** | [**✓**](https://docs.singlestore.com/cloud/load-data/load-data-from-files/load-data-from-local-files.md) | | | Stage | | [**✓**](https://docs.singlestore.com/cloud/load-data/load-data-from-files/stage.md) | [**✓**](https://docs.singlestore.com/cloud/load-data/load-data-from-files/stage.md) | SingleStoremanaged storage | | **Streaming Systems** | | | | | | Kafka | | [**✓**](https://docs.singlestore.com/cloud/load-data/data-sources/load-data-from-kafka.md) | | | | **Database Sources** | | | | | | Oracle & Oracle RAC | **[✓](https://docs.singlestore.com/cloud/load-data/load-data-with-singlestore-flow.md)** | | | | | Microsoft SQL Server | **[✓](https://docs.singlestore.com/cloud/load-data/load-data-with-singlestore-flow.md)** | | | | | MySQL | **[✓](https://docs.singlestore.com/cloud/load-data/load-data-with-singlestore-flow.md)** | **[✓](https://docs.singlestore.com/cloud/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/cloud/load-data/data-sources/replicate-data-from-mysql/load-data-from-mysql.md)utility. | | PostgreSQL | [**✓**](https://docs.singlestore.com/cloud/load-data/load-data-with-singlestore-flow.md) | | | | | Snowflake | **[✓](https://docs.singlestore.com/cloud/load-data/load-data-with-singlestore-flow.md)** | | | Data migration only. | | Any JDBC-compliant database | **[✓](https://docs.singlestore.com/cloud/load-data/load-data-with-singlestore-flow.md)** | | | Limited to non-production preview, available for testing. | | MongoDB® | **[✓](https://docs.singlestore.com/cloud/load-data/load-data-with-singlestore-flow.md)** | **[✓](https://docs.singlestore.com/cloud/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/cloud/load-data/integrate-with-singlestore-helios.md) | ## In this section * [Load Data with SingleStore Flow](https://docs.singlestore.com/cloud/load-data/load-data-with-singlestore-flow.md) * [Load Data with SingleStore Flow on Helios](https://docs.singlestore.com/cloud/load-data/load-data-with-singlestore-flow-on-helios.md) * [About SingleStore Pipelines](https://docs.singlestore.com/cloud/load-data/about-singlestore-pipelines.md) * [Data Sources](https://docs.singlestore.com/cloud/load-data/data-sources.md) * [Load Data from Files](https://docs.singlestore.com/cloud/load-data/load-data-from-files.md) * [Integrate with SingleStore Helios](https://docs.singlestore.com/cloud/load-data/integrate-with-singlestore-helios.md) *** Modified at: May 25, 2026 Source: [/cloud/load-data/](https://docs.singlestore.com/cloud/load-data/) (An index of the documentation is available at /llms.txt)