# Connect with Dremio

Dremio is an open source project that enables business analysts and data scientists to explore and analyze any data at any time, regardless of its location, size, or structure. Dremio combines a scale-out architecture with columnar execution and acceleration to achieve interactive performance on any data volume. You can connect Dremio to SingleStore using the [SingleStore connector for Dremio](https://github.com/memsql/dremio-singlestore).

The following certification matrix shows the recommended version of Dremio:

| Certification Matrix | Versions |
| -------------------- | -------- |
| Dremio               | 17.0.0+  |

## Prerequisites

Before connecting Dremio to SingleStore, perform the following tasks:

1. [Download and install](https://www.dremio.com/deploy/) Dremio.

2. Download and install the latest version of [The SingleStore JDBC Driver](https://docs.singlestore.com/db/v9.1/developer-resources/connect-with-application-development-tools/connect-with-java-jdbc/the-singlestore-jdbc-driver.md).

3. Ensure the SingleStore cluster is running on the server.

4. [Download](https://github.com/memsql/dremio-singlestore/releases/latest) the SingleStore connector for Dremio.

## Configure JARS and Run Dremio

Log in to a linux machine, and perform the following tasks:

1. Download the `.jar` plugin from [GitHub](https://github.com/memsql/dremio-singlestore/releases/latest), and place this `.jar` plugin in the **$DREMIO\_HOME/jars** directory in Dremio.

2. Download [The SingleStore JDBC Driver](https://docs.singlestore.com/db/v9.1/developer-resources/connect-with-application-development-tools/connect-with-java-jdbc/the-singlestore-jdbc-driver.md) `.jar` file from [GitHub](https://github.com/memsql/S2-JDBC-Connector/releases/latest), and place this `.jar` file in the **$DREMIO\_HOME/jars/3rdparty** directory.

3. Start (or restart) the `dremio` service:
   ```shell
   sudo /opt/dremio/bin/dremio start 
   ```

4. Open a browser, and connect to Dremio running on the linux server:

   **http\://\<IP\_address\_of\_the\_server\_running\_the\_Dremio\_service>:9047/**

## Connect Dremio to SingleStore

1. Open a the following URL in a browser to connect to Dremio running on the linux server:

   **http\://\<IP\_address\_of\_the\_server\_running\_the\_Dremio\_service>:9047/**

2. On the Welcome to Dremio screen, enter the **Username** and **Password** to log into Dremio.

3. On the left navigation pane, select **Sources > Add Source**.

4. On the **Add Data Source** dialog, from the list, select **SingleStore**.

5. In the **New SingleStore Source** window, enter the following information:

   * **Name**: Name of the connection.
   * **Host**: IP address or hostname of the SingleStore cluster.
   * **Database**: Name of the database to connect with.
   * **Port**: Default is `3306`.
   * **Username** and **Password**: Username and password of the database user.

6. Select **Save**.

Your new SingleStore connection is now available and ready to use.

## In this section

* [Data Reflection and Query Acceleration](https://docs.singlestore.com/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-dremio/data-reflection-and-query-acceleration.md)
* [Best practices guide](https://docs.singlestore.com/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-dremio/best-practices-guide.md)

***

Modified at: September 26, 2025

Source: [/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-dremio/](https://docs.singlestore.com/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-dremio/)

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