Redash was created in 2013 by Arik Fraimovich as an open-source alternative to expensive BI tools. Its philosophy is SQL-first: you write queries, visualize the results, and assemble dashboards. There’s no drag-and-drop chart builder trying to hide the SQL from you.
Databricks acquired Redash in 2020, primarily for the team’s expertise and to bolster its own SQL analytics capabilities. The open-source project continues, though development pace has slowed since the acquisition as the team focuses on Databricks SQL.
The tool connects to over 35 data sources including PostgreSQL, MySQL, BigQuery, Redshift, MongoDB, Elasticsearch, and even Google Sheets. Each query can be turned into a visualization with a few clicks, and visualizations snap together into dashboards.
Redash’s scheduling feature lets you run queries on a recurring basis, so dashboards stay current without manual refreshes. Query results can be used as data sources for other queries, enabling a basic form of data transformation within the tool itself.
Alerts are another practical feature — set a threshold on any query result, and Redash sends notifications via email, Slack, or webhooks when the condition is met. It’s a lightweight monitoring system that many teams use to track business metrics.
The self-hosted version is free and handles most use cases well. The interface is clean and fast, if somewhat spartan compared to more polished commercial tools. For teams where analysts are comfortable with SQL and just need a way to share results, Redash remains a solid choice despite its uncertain future under Databricks.
