Sign inTry Free

Connect with Dremio

On this page

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.

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 Dremio.

  2. Download and install the latest version of The SingleStore JDBC Driver.

  3. Make sure the SingleStore cluster is running on the server.

  4. Download 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, and place this .jar plugin in the $DREMIO_HOME/jars directory in Dremio.

  2. Download The SingleStore JDBC Driver.jar file from GitHub, and place this .jar file in the $DREMIO_HOME/jars/3rdparty directory.

  3. Start (or restart) the dremio service:

    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

Last modified: February 3, 2023

Was this article helpful?

On this page

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK