# Redash (https://redash.io/help/)
###### tags: `HH`

- 安裝:
- 透過docker安裝:
https://github.com/justinclift/redash/blob/redash-centos7/setup/setup.sh
redis、postgres、nginx

- web ui:
http://10.57.232.173:80
email: [e-mail]
password:123qwe

- 操作流程:
1. add datasource
- Databases:
MySQL、SQL SERVER、SQLite……
- Integrations:
JSON、Google Spreadsheets……
2. create query
3. create new visualization
4. add dashboard
5. set alerts

- 功能介紹:
1. Query
- Published vs Unpublished
Unpublished狀態:
1. 只有建立者才看得到自己建立的Query
2. 無法加入到dashboard

- Archive A Query
針對久未使用的Query archive

- Duplicating (Forking) A Query
複製Query

- Download Query(Export URLs and API Key)

- Settings -> Query Snippets
自訂auto complete trigger

- Scheduling A Query
設定固定時間refresh query查詢

2. Visualizations
- Formatting Numbers in Visualizations
調整欄位format

3. Dashboard
- Sharing and Embedding Dashboards
4. Alerts
- Adding Slack Alert Destination
- Set rule