Redash is a strong open supply question and visualization software that helps you make sense of your knowledge. It connects to number of knowledge sources and in addition features a native connector for Rockset. On this publish we’ll exhibit the right way to use Redash to construct stay dashboards on Rockset knowledge units.
Configure
In the event you’ve by no means used Redash earlier than, you should set it up first. You’ve got two choices: both run it your self or use the hosted model offered by Redash.
After you have arrange Redash, you should create a brand new Rockset knowledge supply. Examine Redash including Rockset as a supported knowledge supply in Redash v6.
Search for “Rockset” within the New Knowledge Supply view.
To configure the information supply, it’s best to give it a reputation and an API key that you could create within the Rockset console. Normally you may 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 offer 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 begin your SQL question.
Stay Dashboards and Visualizations
By default, Redash exhibits you a desk with outcomes of the question. Nevertheless, you too can construct wealthy dashboards and visualizations based mostly in your outcomes. Click on on New Visualization
, and from there you may choose many alternative visualization choices, resembling Bar charts, Pie charts, Scatter plots and others. You can even add the visualization to a dashboard that may mechanically refresh as new knowledge is available in.
Discover extra data on the Rockset-Redash integration in our docs. Give it a spin and tell us what you assume!