Redash is designed to enable anyone, regardless of the level of technical sophistication, to harness the power of data big and small. SQL users leverage Redash to explore, query, visualize, and share data from any data sources. Their work in turn enables anybody in their organization to use the data. Every day, millions of users at thousands of organizations around the world use Redash to develop insights and make data-driven decisions.
Redash features:
- Browser-based: Everything in your browser, with a shareable URL.
- Ease-of-use: Become immediately productive with data without the need to master complex software.
- Query editor: Quickly compose SQL and NoSQL queries with a schema browser and auto-complete.
- Visualization and dashboards: Create beautiful visualizations with drag and drop, and combine them into a single dashboard.
- Sharing: Collaborate easily by sharing visualizations and their associated queries, enabling peer review of reports and queries.
- Schedule refreshes: Automatically update your charts and dashboards at regular intervals you define.
- Alerts: Define conditions and be alerted instantly when your data changes.
- REST API: Everything that can be done in the UI is also available through REST API.
- Broad support for data sources: Extensible data source API with native support for a long list of common databases and platforms.
- Setting up Redash instance (includes links to ready-made AWS/GCE images).
- Documentation.
Redash supports more than 35 SQL and NoSQL data sources. It can also be extended to support more. Below is a list of built-in sources:
- Amazon Athena
- Amazon DynamoDB
- Amazon Redshift
- Axibase Time Series Database
- Cassandra
- ClickHouse
- CockroachDB
- CSV
- Databricks (Apache Spark)
- DB2 by IBM
- Druid
- Elasticsearch
- Firebolt
- Google Analytics
- Google BigQuery
- Google Spreadsheets
- Graphite
- Greenplum
- Hive
- Impala
- InfluxDB
- JIRA
- JSON
- Apache Kylin
- OmniSciDB (Formerly MapD)
- MemSQL
- Microsoft Azure Data Warehouse / Synapse
- Microsoft Azure SQL Database
- Microsoft SQL Server
- MongoDB
- MySQL
- Oracle
- PostgreSQL
- Presto
- Prometheus
- Python
- Qubole
- Rockset
- Salesforce
- ScyllaDB
- Shell Scripts
- Snowflake
- SQLite
- TiDB
- TreasureData
- Vertica
- Yandex AppMetrrica
- Yandex Metrica
- Issues: https://github.com/getredash/redash/issues
- Discussion Forum: https://discuss.redash.io/
- Want to report a bug or request a feature? Please open an issue.
- Want to help us build Redash? Fork the project, edit in a dev environment and make a pull request. We need all the help we can get!
Please email [email protected] to report any security vulnerabilities. We will acknowledge receipt of your vulnerability and strive to send you regular updates about our progress. If you're curious about the status of your disclosure please feel free to email us again. If you want to encrypt your disclosure email, you can use this PGP key.
BSD-2-Clause.
In adition to Redash functionalities we have made the following changes:
-
We have enabled Redash to report users' emails on scheduled queries
-
We have disallowed access to refresh queries for users that share queries but do not belong to the same team.
To achieve this have modified redash/permissions.py#L45 file.
In the following piece of code
if beat_ro_access == False and len(matching_groups) == 1 and str(list(matching_groups)[0]) == '2':
return False
we block users from being able refresh queries that belong to other users when users' only common group is the default
(2
) one.