Skip to main content

Dremio Test Drive

Test Drive is a Dremio environment that lets you 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 and has over 1 billion rows.

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 side 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 and has 3800+ rows.

  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 This is the icon that represents the home space. icon and your email address.

  5. Click Save.

    image

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

    note

    Using this new view you've created, try answering the following questions:

    • Which month had the most number of taxi rides?
    • Are there more or less rides taken when it rains?

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

This section provides steps to create a report using 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 over the User icon (user initials) in side navigation bar and select Account Settings.

      • In the Account Settings dialog, select Personal Access Tokens in the sidebar, 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 over the User icon (user initials) in the side navigation bar and select Account Settings.

    • In the Account Settings dialog, select Personal Access Tokens in the sidebar, 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.