Redash

Redash is a self-hosted analytics platform and SQL data visualization tool. It provides a web-based SQL query editor for writing, executing, and scheduling database queries, and functions as a business intelligence dashboard for monitoring metrics via visual widgets.

The platform distinguishes itself through its data source connectors, which integrate with various SQL, NoSQL, and API-based stores to retrieve information for analysis. It enables self-service analytics by allowing users to run queries with dynamic parameters and supports shared data reporting via public links or embedded dashboards.

The system covers a broad range of capabilities, including a data visualization engine for creating charts and maps, automated data alerting for monitoring query thresholds, and role-based access control for managing user permissions. It also includes utilities for database schema browsing and exporting query results.

Administration is supported through a command-line interface for system tasks and database schema initialization.

Features

Business Intelligence Dashboards - Provides a comprehensive business intelligence dashboard for monitoring company performance and trends via visual widgets.

SQL-Driven Visualization - Transforms raw SQL query results directly into a variety of maps, charts, and tables.

Self-Hosted Analytics Platforms - Provides a self-hosted, open-source system for transforming raw data into visual reports and monitoring alerts.

Self-Service Business Intelligence - Empowers non-technical team members to run their own queries using dynamic parameters without writing code.

Data Source Connections - Provides interfaces for establishing connections to a wide variety of external SQL, NoSQL, and API-based data sources.

Data Visualization - Transforms structured query results into a variety of interactive charts, maps, tables, and funnels.

Database Driver Abstractions - Implements a standardized abstraction layer to ensure uniform query execution across diverse SQL and NoSQL drivers.

Remote Data Source Connectors - Integrates with various SQL, NoSQL, and API-based data stores to retrieve information for analysis.

Visualization Platforms - Provides a visualization platform that transforms SQL data into interactive, shareable dashboards.

SQL Query Interfaces - Offers a web-based interface for writing, executing, and scheduling database queries with dynamic parameters.

Role-Based Access Control - Restricts data source and dashboard visibility by mapping user identities to specific permission groups and roles.

Alerts and Notifications - Monitors query results and sends external notifications when specific data conditions are met.

Query Output Caches - Stores query outputs in a cache layer to ensure fast dashboard loading and reduce load on remote data sources.

Query Parameter Filters - Allows users to add dynamic inputs to queries to filter results by dates or text without modifying SQL code.

Multi-Source Data Aggregation - Enables the retrieval and aggregation of information across various data store types for comprehensive analysis.

Dynamic Parameter Injection - Injects dynamic user inputs into raw data queries at runtime to filter results without manual code modification.

RESTful - Exposes backend data services and query management to the frontend through a standardized RESTful API gateway.

Background Job Processing - Offloads intensive data tasks to background workers to maintain a responsive user interface.

Identity Provider Integrations - Integrates with external identity providers to synchronize user identities and manage secure logins.

User Access Management - Controls user permissions and group memberships to restrict access to specific queries and dashboards.

Redis-Backed Queues - Uses a Redis-backed distributed task queue to manage asynchronous query execution and scheduled jobs.

SQL Query Schedulers - Automates the periodic execution of database queries to keep data visualizations current.

Automated Alerting Workflows - Monitors query results and triggers notifications when data hits predefined thresholds or conditions.

Dashboard Sharing - Generates public links and embeds to share interactive data visualizations with external stakeholders.

Grid Layouts - Provides a grid layout system for arranging multiple visualizations into a single monitoring view.

Visualization and Analysis - Visualization framework for querying and displaying big datasets.

Analytics - Data visualization and dashboarding platform for multiple data sources.

Analytics and Search - Platform for data visualization and dashboarding.

Analytics Platforms - Dashboarding and visualization tool for various data sources.

Analytics Tools - Listed in the “Analytics Tools” section of the Awesome Selfhosted awesome list.

Business Intelligence - Platform for querying and visualizing data sources.

Dashboards and BI - Tool for visualizing and sharing data insights.

Data Management Systems - Dashboard construction and data visualization for business intelligence.

Data Processing - Query, share, and visualize database datasets.

Database GUI Clients - Platform for connecting, visualizing, and sharing database data.

Open Source Projects - Data visualization and dashboarding platform.

getredashredash

Features

Star history