Redash

Redash exists so the one person who writes SQL is not a bottleneck for everybody else. SQL users explore, query and visualize data from any connected source, and their work turns into dashboards and shareable URLs that colleagues without technical training can read and act on.

Everything happens in the browser. A query editor with a schema browser and auto-complete handles both SQL and NoSQL sources, visualizations are assembled by drag and drop and combined into a single dashboard, and every action available in the interface is exposed through a REST API as well.

Beyond writing queries, the parts teams lean on are operational.

• Scheduled refreshes: Charts and dashboards update automatically at intervals you define.
• Alerts: Conditions on query results fire the moment the underlying data changes.
• Sharing: Visualizations travel with their queries, so reports and the SQL behind them can be peer reviewed.
• Data sources: More than 35 connectors span warehouses, relational databases, NoSQL stores and plain files.
• Extensibility: The data source API accepts new connectors when a system is not covered yet.

That built-in list runs from Athena, BigQuery, Redshift, Snowflake and Databricks through PostgreSQL, MySQL, SQL Server and Oracle to Elasticsearch, MongoDB, Prometheus, Google Sheets, CSV files and shell scripts. Setup documentation covers running your own instance, including ready-made AWS and Google Compute images.