Abstract
A range of Analytics and BI tools 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.
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 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.
Finally, we'll make a note of our password and host name.
Download the Files
We need to download the following files:
Install Dremio
We'll follow the Dremio Tarball Install 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:
sudo /opt/dremio/bin/dremio start
Connect to Dremio
Next, we'll open the following webpage:
http://localhost:9047/
We should see an invitation to create an Admin Account, as shown in Figure 1.
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.
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.
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.
If we click on the table name, we can start running queries on the next page, as shown in Figure 5.
Summary
In this short article, we have seen how to connect to SingleStoreDB Cloud from a local Dremio installation.
Top comments (0)