# Load Data with Pipelines

This part of the tutorial shows how to ingest stock trades data from a public AWS S3 bucket into the SingleStore database using pipelines.

> **📝 Note**: The **SQL Editor** only runs the queries that you select, so ensure you have them all selected before selecting **Run**.

1. Run the following SQL commands to create the pipelines:
   ```sql
   USE trades;

   CREATE OR REPLACE PIPELINE company
   AS LOAD DATA S3 's3://singlestore-docs-example-datasets/trades/company.csv'
   CONFIG '{"region":"us-east-1"}'
   SKIP DUPLICATE KEY ERRORS
   INTO TABLE company;

   CREATE OR REPLACE PIPELINE trade
   AS LOAD DATA S3 's3://singlestore-docs-example-datasets/trades/trade.csv'
   CONFIG '{"region":"us-east-1"}'
   SKIP DUPLICATE KEY ERRORS
   INTO TABLE trade;
   ```

2. Run the following SQL commands to start the pipelines:
   ```sql
   USE trades;
   START ALL PIPELINES;

   ```

Once the **Success** message is returned for all the created pipelines, SingleStore starts ingesting the data from the S3 bucket.

***

Modified at: October 10, 2024

Source: [/db/v9.1/introduction/sample-data/load-stock-trading-data-into-singlestore/load-data-with-pipelines/](https://docs.singlestore.com/db/v9.1/introduction/sample-data/load-stock-trading-data-into-singlestore/load-data-with-pipelines/)

(An index of the documentation is available at /llms.txt)