On this page

    Getting Started with Dremio Test Drive

    Test Drive is a Dremio environment where you can try out selected features such as querying sample data, joining data from sample data sources, and connecting your BI tools to Dremio.

    note:

    When you sign up for Test Drive, you’ll have 24 hours to use it and try out Dremio. When your 24-hour trial expires, your account will be deactivated.

    Goal

    This tutorial walks you through some of the basics of using Dremio Test Drive. After completing the steps that follow, you’ll know how to:

    Prerequisites

    Before you begin, you need to sign up for Dremio Test Drive.

    Step 1. Query an Iceberg Table Stored in Amazon S3

    After you sign up, we’ll use Dremio Sonar to run your first query. In this step, you’ll be working with the nyc_trips view, which has been created from data in S3.

    To run your first query:

    1. From the Datasets page, click the SQL Runner icon This is the icon that represents the SQL runner. in the left navigation bar.

    2. Copy the following SQL and paste it into the SQL editor.

      Querying Sample Data
      SELECT *
      FROM semantic.nyc_trips
      
    3. Click the Run button to execute your query.

      image

      Over 1 million records are returned in sub second response time.

    Step 2. Create a View by Joining Data in Amazon S3 and Postgres

    Now we’ll use Sonar to create a new view using the same nyc_trips view and the nyc_weather view, which is built on data in Postgres.

    1. Copy the following SQL and paste it into the SQL editor.

      Joining Trips and Weather Data
      SELECT pickup_datetime, dropoff_datetime, passenger_count, trip_distance_mi, fare_amount, tip_amount, total_amount, prcp, snow, tempmax, tempmin
      FROM semantic.nyc_trips
      INNER JOIN semantic.nyc_weather ON ("date" = "pickup_date")
      
    2. Click Preview to preview the joined view.

      image

    3. To save this view, click the drop down on the top right and select Save View as….

    4. In the Save View As dialog, enter a name for your view (nyc_trips_weather). Dremio saves the view in your home space, which is private to you and represented by the home icon and your email address.

    5. Click Save.

      image

      After the view is saved, you will be returned to the Datasets page and the original SQL for the view is displayed in the SQL editor.

    Step 3. Connect to Tableau or Power BI to Create a Report

    This section provides steps to create a report using on the following tools:

    Tableau

    1. Add a new connection to Dremio from Tableau and select Dremio from the list of connectors.

    2. For Product, verify that Dremio Cloud is selected.

    3. For Server, verify that sql.dremio.cloud (US) is selected.

    4. Check the following under Authentication:

      • If you signed up to Test Drive using Google, select OAuth 2.0 and click Sign in. When redirected to the Dremio login page, enter the email that you used to sign up for Dremio Test Drive and log in, then navigate back to Tableau.

      • If you signed up to Test Drive using your email and created a password, select Personal Access Token for Authentication. To generate a personal access token in Dremio, hover on the user icon in the bottom of the left navigation bar, then select Account Settings.

        • In the Account Settings dialog, click the Personal Access Tokens tab, then click Generate Token. For Label, enter a name for your token, then click Generate.

        • Copy the Token, paste it into the Password field in the Tableau connector dialog, then click Sign in.

    5. For Database, verify that DREMIO is selected.

    6. For Schema, select your home space, which is your email address. For Table, select the view you created in Step 2 (Join Data), which should be nyc_trips_weather.

    7. In a Tableau sheet, drag Pickup Datetime into the Columns shelf, click on YEAR(Pickup Datetime), then select Month, which has May 2015 in gray on the right side.

    8. Drag Fare Amount into the Rows shelf, click on SUM(Fare Amount), then select Average under Measure(Sum).

    9. Drag Tip Amount into the Rows shelf, click on SUM(Fare Amount), then select Average under Measure(Sum).

    10. Click on AVG(Tip Amount) and select Dual Axis. Notice that the chart response is almost instantaneous, giving the user a truly interactive experience and allowing them to ask business questions at the speed of thought.

    11. Open the Jobs page in Dremio to see the six queries that Tableau sent to Dremio – notice that Dremio responded to all of them in less than a second!

    Microsoft Power BI

    1. From Power BI, click Get data.

      a. In the Get data dialog, search for and select Dremio Cloud (Beta).

      b. Click Connect.

      c. Click Continue in the dialog that indicates the connector is still under development.

    2. In the Dremio Cloud dialog, verify that sql.dremio.cloud (US) is selected for Server, then click OK.

    3. To sign in to your Dremio Test Drive account, select Personal Access Token. To generate a personal access token in Dremio, hover on the user icon in the bottom of the left navigation bar, then select Account Settings.

      • In the Account Settings dialog, click the Personal Access Tokens tab, then click Generate Token. For Label, enter a name for your token, then click Generate.

      • Copy the token, paste it into the Power BI personal access dialog, then click Sign in.

    4. From the datasets listed in the Navigator, search for the view you created in Step 2, (nyc_trips_weather).

    5. Select line chart for the type of visual, add the pickup_datetime field to the report, click on pickup_datetime under X-axis, and select Month for granularity.

    6. Add fare_amount to the report as the Y-axis, click on fare_amount under Y-axis, then select Average.

    7. Add tip_amount to the report as the Y-axis, click tip_amount under Y-axis, then select Average. Notice that the chart response is almost instantaneous, giving the user a truly interactive experience and allowing them to ask business questions at the speed of thought.

    8. Open the Jobs page in Dremio to see the queries that Power BI sent to Dremio – notice that Dremio responded to all of them in less than a second!

    Wrap-Up and Next Steps

    Congratulations! You have successfully completed this tutorial and built a dashboard on a view joining data across two different sources.

    • To try this with your data, sign up for your own Dremio Cloud account.

    • After you’ve signed up, go here to learn more about getting started with Dremio Sonar.

    • To learn how to create a view using SQL, see the CREATE VIEW command.