Quick tip: Using Dremio with SingleStoreDB Cloud
Tags: singlestoredb, dremio
Published: 2023-02-09 11:16:41

## Abstract
A range of [Analytics and BI tools](https://docs.singlestore.com/managed-service/en/query-data/connect-with-analytics-and-bi-tools.html) can be connected to SingleStoreDB. In this short article, we'll connect Dremio to SingleStoreDB. We'll see the ease with which this can be done and how we can easily access data from SingleStoreDB using Dremio.

The SQL code used in this article is available in a [GitHub Gist](https://gist.github.com/VeryFatBoy/587479244e6f44c6578161c0e5db3e8d).

## Introduction
We'll need to perform a few simple steps to prepare our development environment, and the following sections will show how to do this. For the Dremio installation, we'll use a Virtual Machine running Ubuntu 20.04.3.

## Create a SingleStoreDB Cloud account
A [previous article](https://dev.to/singlestore/quick-tip-using-dbt-with-singlestoredb-161g) showed the steps required to create a free SingleStoreDB Cloud account. We'll use **Dremio Demo Group** as our Workspace Group Name and **dremio-demo** as our Workspace Name.

In our SingleStoreDB Cloud account, we'll use the **SQL Editor** to create a new database and some sample data using a [GitHub Gist](https://gist.github.com/VeryFatBoy/587479244e6f44c6578161c0e5db3e8d).

Finally, we'll make a note of our **password** and **host** name.

## Download the Files
We need to download the following files:

- [Dremio Community Edition](https://download.dremio.com/community-server/dremio-community-LATEST.tar.gz)
- [SingleStore JDBC Client](https://github.com/memsql/S2-JDBC-Connector/releases/download/v1.1.4/singlestore-jdbc-client-1.1.4.jar)
- [SingleStore Dremio Connector](https://github.com/memsql/dremio-singlestore/releases/download/v1.0.0/dremio-singlestore-plugin-23.1.0-1.0.0.jar)

## Install Dremio
We'll follow the Dremio [Tarball Install](https://docs.dremio.com/software/deployment/standalone/standalone-tarball/) instructions. Once the installation is complete, we'll copy the **SingleStore JDBC Client** to:

```
/opt/dremio/jars/3rdparty
```

and the **SingleStore Dremio Connector** to:

```
/opt/dremio/jars
```

We'll then start Dremio from the command line:

```shell
sudo /opt/dremio/bin/dremio start
```

## Connect to Dremio
Next, we'll open the following webpage:

```http
http://localhost:9047/
```

We should see an invitation to create an **Admin Account**, as shown in Figure 1.

![Figure 1. Create Admin Account.](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/0dtg6v39jdj2lpgpwz26.png)

<center>Figure 1. Create Admin Account.</center>

On the next page, we can see an option to **Add Source** at the bottom of the left-hand navigation pane, as shown in Figure 2.

![Figure 2. Add Source.](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5er8rejggibemjigoyj1.png)

<center>Figure 2. Add Source.</center>

If we click **Add Source**, we'll see several Data Source options for **Metastores**, **Object Storage** and **Databases**.

## Configure SingleStoreDB Connection
We'll select SingleStore from the list, as shown in Figure 3.

![Figure 3. Select SingleStore.](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/zpxb030fwyuqhpejiuej.png)

<center>Figure 3. Select SingleStore.</center>

We'll need to fill in the details for our connection, as follows:

- **Name:** S2
- **Host:** `<host>`
- **Port:** 3306
- **Database:** iris_db
- **Username:** admin
- **Password:** `<password>`

We'll replace the `<host>` and `<password>` with the values from our SingleStoreDB Cloud account.

We'll click the **Save** button.

## Run Queries
Next, we should see the table we created earlier in SingleStoreDB, as shown in Figure 4.

![Figure 4. Database Table.](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/vvi3wqw6zhxjchzuy5b4.png)

<center>Figure 4. Database Table.</center>

If we click on the table name, we can start running queries on the next page, as shown in Figure 5.

![Figure 5. Run Queries.](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/o5c8y1vmo9eghtlmv88t.png)

<center>Figure 5. Run Queries.</center>

## Summary
In this short article, we have seen how to connect to SingleStoreDB Cloud from a local Dremio installation.