Redash is our take on freeing the data within our company in a way that will better fit our culture and usage patterns.
Prior to Redash, we tried to use traditional BI suites and discovered a set of bloated, technically challenged and slow tools/flows. What we were looking for was a more hacker'ish way to look at data, so we built one.
Redash was built to allow fast and easy access to billions of records, that we process and collect using Amazon Redshift ("petabyte scale data warehouse" that "speaks" PostgreSQL). Today Redash has support for querying multiple databases, including: Redshift, Google BigQuery, PostgreSQL, MySQL, Graphite, Presto, Google Spreadsheets, Cloudera Impala, Hive and custom scripts.
Redash consists of two parts:
- Query Editor: think of JS Fiddle for SQL queries. It's your way to share data in the organization in an open way, by sharing both the dataset and the query that generated it. This way everyone can peer review not only the resulting dataset but also the process that generated it. Also it's possible to fork it and generate new datasets and reach new insights.
- Visualizations and Dashboards: once you have a dataset, you can create different visualizations out of it, and then combine several visualizations into a single dashboard. Currently Redash supports charts, pivot table, cohorts and more.
- Setting up Redash instance (includes links to ready made AWS/GCE images).
- Documentation.
Redash supports more than 35 data sources.
- 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 security@redash.io 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.
这个版本只是修改了其后天,从python2.7迁移到了python3,依赖在:
- requirements-run.txt 运行需要的依赖
- requirements-else.txt hive,mysql,influxdb,elasticsearch相关的依赖
需要pg 10以上和redis,默认的数据库连接为:postgresql://postgres:123123@localhost/redash和redis://localhost:6379/0
- npm install
- npm run build
结果会在client/dist中
- 使用虚拟环境
python -m venv env
env/bin/python -m pip install -r requirements-run.txt
env/bin/python -m pip install -r requirements-else.txt
- 初始化数据库
env/bin/python manage.py database create-tables
- 启动worker和scheduler
bash entrypoint worker
bash entrypoint scheduler
- 测试环境使用manage.py启动服务
env/bin/python manage.py run
在端口5000启动
- 正式启动
bash entrypoint server
在端口8222启动
- celery有一处bug会引起无法识别错误,可以按这个pr来修改
- csv/excel文件下载默认文件名是bytes的字符串