Redash is a robust open supply question and visualization device that helps you make sense of your information. It connects to number of information sources and in addition features a native connector for Rockset. On this publish we’ll show how you can use Redash to construct reside dashboards on Rockset information units.
Configure
For those who’ve by no means used Redash earlier than, you’ll want to set it up first. You have got two choices: both run it your self or use the hosted model supplied by Redash.
Upon getting arrange Redash, you’ll want to create a brand new Rockset information supply. Examine Redash including Rockset as a supported information supply in Redash v6.
Search for “Rockset” within the New Information Supply view.
To configure the information supply, you need to give it a reputation and an API key you could create within the Rockset console. Most often you possibly can go away API Server as is, utilizing https://api.rs2.usw2.rockset.com.
Question
Create the information supply and you might be prepared to question Rockset! On the primary load you may want to present a while for Redash to preload the schema of all Rockset tables. As soon as that is finished, you need to see an inventory of all Rockset collections in your account and you can begin executing SQL statements. Click on Create within the nav bar after which Question to begin your SQL question.
Stay Dashboards and Visualizations
By default, Redash reveals you a desk with outcomes of the question. Nonetheless, it’s also possible to construct wealthy dashboards and visualizations based mostly in your outcomes. Click on on New Visualization, and from there you possibly can choose many alternative visualization choices, akin to Bar charts, Pie charts, Scatter plots and others. You too can add the visualization to a dashboard that can routinely refresh as new information is available in.
Discover extra data on the Rockset-Redash integration in our docs. Give it a spin and tell us what you suppose!