Redash is a robust open supply question and visualization instrument that helps you make sense of your information. It connects to number of information sources and likewise features a native connector for Rockset. On this submit we’ll reveal the best way to use Redash to construct reside dashboards on Rockset information units.
For those who’ve by no means used Redash earlier than, you must set it up first. You’ve got two choices: both run it your self or use the hosted model supplied by Redash.
After getting arrange Redash, you must 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 Knowledge Supply view.
To configure the info supply, it’s best to give it a reputation and an API key that you may create within the Rockset console. Usually you possibly can depart API Server as is, utilizing
Create the info supply and you might be prepared to question Rockset! On the primary load you would possibly want to provide a while for Redash to preload the schema of all Rockset tables. As soon as that is performed, it’s best 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 start out your SQL question.
Reside Dashboards and Visualizations
By default, Redash reveals you a desk with outcomes of the question. Nonetheless, you too can 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, comparable to Bar charts, Pie charts, Scatter plots and others. You can too add the visualization to a dashboard that can robotically 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!