# Connect with Dataloop

Dataloop is an end-to-end AI development platform that enables you to integrate data models and applications for building and deploying AI systems (applications). The SingleStore integration in Dataloop streamlines data processing, table updates, and data uploads between SingleStore Helios and Dataloop datasets.

This integration allows you to: 

* Directly run queries from Dataloop in SingleStore using the integrated service.

* Automatically create and update tables based on Dataloop dataset information.

* Upload SingleStore query results directly to Dataloop datasets.

The SingleStore integration in Dataloop uses the [SingleStore Python Client](https://docs.singlestore.com/cloud/developer-resources/connect-with-application-development-tools/connect-with-python/connect-using-the-singlestore-python-client.md).

## Prerequisites

* An active SingleStore Helios deployment.

* Access to the [Dataloop Platform](https://console.dataloop.ai/) (console).

* A table in the SingleStore database with at least the following columns:

  * `id`: Auto-generated field.

  * `prompt`: Contains the prompt to create in Dataloop.
  * `response`: Stores the model responses. This field is automatically populated from the Reinforcement Learning Human Feedback (RLHF) pipeline.

## Pipeline Nodes

The SingleStore integration in Dataloop provides the following nodes:

* Import SingleStore
* Export SingleStore

## Import SingleStore

The Import SingleStore node retrieves the prompts from a SingleStore table, adds them to a specified dataset in Dataloop, and creates the prompt items accordingly.

## Export SingleStore

The Export SingleStore node updates the best marked response, model name, and `id` from Dataloop in the corresponding row in the SingleStore table.

## Connect to SingleStore from Dataloop

To connect to SingleStore:

1. [Install the SingleStore Integration](https://docs.singlestore.com/#section-idm234882358149887.md) from Dataloop Marketplace.

2. (Optional) Create a Secret and store the password of the SingleStore database user. The Secret (password) can also be created/specified while configuring the Dataloop pipelines.

3. [Create a Dataloop pipeline to SingleStore](https://docs.singlestore.com/#section-idm234882358414866.md) and specify the SingleStore connection configuration in the Import/Export node configuration.

## Install the SingleStore Integration

To install the SingleStore integration in Dataloop,

1. Log in to the [Dataloop Platform](https://console.dataloop.ai/) (console).

2. On the left navigation pane, select **Marketplace**.

3. Under Dataloop Hub, select **Applications**.

4. From the list of applications, select **SingleStore Integration**.

5. Select **Install** to install the SingleStore Integration.

6. On the **Install Application** dialog, select **Proceed**.

7. From the **SingleStore Password** list, select **Add New Secret**. You can also select an existing Secret. To create or specify a Secret later, select **Set Up Later**.

8. On the **Create Secret** dialog, enter the following:

   1. **Secret Name**: A name for the Secret.

   2. **Secret**: The password for the SingleStore database user used to connect to your SingleStore deployment.

9. Select **Create Secret > Install Application**. The SingleStore Integration is now installed.
   > **📝 Note**: The SingleStore Integration only supports username/password based authentication. Specify the SingleStore connection configuration in the Import/Export node configuration.

## Create a Pipeline to SingleStore

To create a pipeline in Dataloop,

1. On the Dataloop Platform, on the left navigation pane, select **Pipelines > Create Pipeline > Start from Scratch**.

2. On the **Set Pipeline Name** dialog, enter a name for the pipeline and select **Create Pipeline**.

3. From the **Node Library** pane, drag the **Import SingleStore** or **Export SingleStore** node to the canvas.

4. Select the node added to the canvas, and set the following parameters for each node:

   * **host**: IP address or hostname of the SingleStore Helios deployment.

     Refer to [SingleStore Helios Endpoints](https://docs.singlestore.com/cloud/connect-to-singlestore/singlestore-helios-endpoints.md) to determine the endpoint (`host:port`) of your deployment.
   * **user**: Name of the SingleStore database user with which to connect.
   * **database**: Name of the SingleStore database.
   * **table\_name**: Name of the table in the SingleStore database.

5. To specify a different access credential, select **Actions > Edit Access Credentials**, and select (or create) a Secret.

6. Configure the pipelines as required, and start the pipelines to start data processing.

***

Modified at: September 26, 2025

Source: [/cloud/load-data/integrate-with-singlestore-helios/connect-with-dataloop/](https://docs.singlestore.com/cloud/load-data/integrate-with-singlestore-helios/connect-with-dataloop/)

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