This page describes how to setup Redash and configure it for use with Rockset.
Setting up a Redash instance can be done using pre-built images on AWS or GCE, from source, or using Docker. Redash’s website has an excellent guide on each of these approaches. There are also hosted versions of Redash you can use.
If you are interested in a quick prototype Redash deployment to test out integrating with Rockset, you can use the Redash docker-compose file in the Rockset community repository. To use this you will need both Docker and docker-compose installed in your development environment.
Here are the Docker installation guides for:
A docker-compose installation guide can be found here.
Once Docker is ready to go, you can run
git clone email@example.com:rockset/community.git cd community/redash docker-compose up -d
Then navigate to http://localhost:5000 to start using Redash (it may take up to 60s for everything to start up).
Whichever method of installation you choose for Redash, configuring your integration with Rockset is the same:
To add Rockset as a Database source in Redash, press the settings icon on the upper right-hand corner then
Data Sources > New Data Source and select Rockset from the list.
Configure the source as follows:
You can test the connection and if everything seems fine, click
To create a new query, click
Create > New Query. Select the Rockset Database added in the previous step.
This will populate the various collections.
Select the collection you want to run the query on and enter the SQL statement to execute.
You can now click on
New Visualization to visualize and create dashboards over the query results.
To further explore how to build visualizations, dashboards and alerts, refer to
the Redash Getting Started Guide.
Note: We recommend that you use Rockset’s interactive query editor as the starting point to refine your queries and then copy-paste them into the Redash query page when you are done. Rockset’s query editor supports more fully featured auto-complete, type hints, and more descriptive error messages to help you get to your desired end query faster and with fewer mistakes along the way.
Note: If you are running into strange behavior with your queries in Redash, one possible solution is to turn off caching on your browser (by default, the Cache-Control header Redash sends to the browser is very high). Here are some guides to disable browser-side caching for Chrome, Safari, and Firefox.