Redash is a robust open supply question and visualization instrument 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 submit we’ll exhibit the best way to use Redash to construct reside dashboards on Rockset knowledge units.
Configure
If you happen to’ve by no means used Redash earlier than, it’s worthwhile to 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, it’s worthwhile to 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 Information Supply view.
To configure the info supply, it is best to give it a reputation and an API key which you can create within the Rockset console. Generally you possibly can depart API Server as is, utilizing https://api.rs2.usw2.rockset.com.
Question
Create the info supply and you’re prepared to question Rockset! On the primary load you may want to provide a while for Redash to preload the schema of all Rockset tables. As soon as that is finished, it is 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.
Stay Dashboards and Visualizations
By default, Redash reveals you a desk with outcomes of the question. Nonetheless, you can too 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, corresponding to Bar charts, Pie charts, Scatter plots and others. You may as well add the visualization to a dashboard that can 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!
