Book Image

Redash v5 Quick Start Guide

By : Alexander Leibzon, Yael Leibzon
Book Image

Redash v5 Quick Start Guide

By: Alexander Leibzon, Yael Leibzon

Overview of this book

Data exploration and visualization is vital to Business Intelligence, the backbone of almost every enterprise or organization. Redash is a querying and visualization tool developed to simplify how marketing and business development departments are exposed to data. If you want to learn to create interactive dashboards with Redash, explore different visualizations, and share the insights with your peers, then this is the ideal book for you. The book starts with essential Business Intelligence concepts that are at the heart of data visualizations. You will learn how to find your way round Redash and its rich array of data visualization options for building interactive dashboards. You will learn how to create data storytelling and share these with peers. You will see how to connect to different data sources to process complex data, and then visualize this data to reveal valuable insights. By the end of this book, you will be confident with the Redash dashboarding tool to provide insight and communicate data storytelling.
Table of Contents (10 chapters)

Query snippets

Query snippets are parts of a query that often repeat themselves, and hence can be reused.

For example, a join between tables, a large where [not] in, or simply a frequently used constraint.

Use of the query snippets is time-saving, since now you can autocomplete large pieces of SQL code in seconds, and it can be shared between colleagues.

To create query snippets, go to Settings | Query snippets:

On the query snippets screen, you will see all the previously created snippets.

Click on the +New Snippet button to start creating a new snippet.

The new query snippet page is displayed and the following fields need to be filled in:

Trigger: This is the word that will be used to invoke the query snippet. The query editor will suggest auto-completion for this word when the user starts to type in the first few letters.

Description: This includes several words to describe...