Visualize Data in Rockset with Redash

Redash is a powerful open source query and visualization tool that helps you make sense of your data. It connects to variety of data sources and also includes a native connector for Rockset. In this post we will demonstrate how to use Redash to build rich dashboards on Rockset data sets.

Configure

If you've never used Redash before, you need to set it up first. You have two options: either run it yourself or use the hosted version provided by Redash.

Once you have set up Redash, you need to create a new Rockset data source. Read about Redash adding Rockset as a supported data source in Redash v6.

Look for "Rockset" in the New Data Source view.

redash1

To configure the data source, you should give it a name and an API key that you can create in the Rockset console. In most cases you can leave API Server as is, using https://api.rs2.usw2.rockset.com.

redash2

Query

Create the data source and you are ready to query Rockset! On the first load you might need to give some time for Redash to preload the schema of all Rockset tables. Once that's done, you should see a list of all Rockset collections in your account and you can start executing SQL statements. Click Create in the nav bar and then Query to start your SQL query.

redash3

Visualize

By default, Redash shows you a table with results of the query. However, you can also build rich visualizations based on your results. Click on New Visualization, and from there you can select many different visualization options, such as Bar charts, Pie charts, Scatter plots and others. You can also add the visualization to a dashboard that will automatically refresh as new data comes in.

redash4

Find more info on the Rockset-Redash integration in our docs. Give it a spin and let us know what you think!

Real-time SQL on raw data

Related Posts

true

Rockset adds Excel spreadsheet support: Use SQL across XLSX files and join with other JSON, CSV or Parquet data

Run complex SQL across multiple Excel spreadsheets and join XLSX files with JSON, Parquet or CSV data.
true

How to Do Data Science Using SQL on Raw JSON

How to query nested JSON and CSV using SQL (including joins), without any upfront data preparation or complex data pipelines - for interactive data science using Python notebooks.