Redash ãã³ãºãªã³è³æã¯ä»¥äžã®ç°å¢ãåæã«åäœç¢ºèªãããŠããŸãïŒ
- Docker For Mac
- Docker For Windows
ãªãïŒRedash ã®ããŒãžã§ã³ããšã«ãã³ãºãªã³è³æãçšæããŠããŸãïŒææ°ããŒãžã§ã³ä»¥å€ã䜿ãå Žåã¯ïŒä»¥äžã®ã¿ã°ããåç §ã§ããŸãïŒ
- kakakakakku/redash-hands-on at v2.0.1
- kakakakakku/redash-hands-on at v4.0.1
- kakakakakku/redash-hands-on at v4.0.2
Docker Compose 㧠Redash (v5.0.1) ç°å¢ãæ§ç¯ããŸãïŒä»»æã®ãã£ã¬ã¯ããªã« kakakakakku/redash-hands-on ãªããžããªãã¯ããŒã³ããŸãããïŒ
$ git clone https://github.com/kakakakakku/redash-hands-on.git
$ cd redash-hands-on
å
¬åŒã® getredash/redash ãªããžããªã«å
¬éãããŠããèšå®ãããŒã¹ã«ïŒãã¹ãããŒã¿ãäºåã«æå
¥ãã MySQL 5.7 ã³ã³ãããå«ãã docker-compose.yml
ãæºåããŸããïŒ
以äžã®ã³ãã³ããå®è¡ãïŒDocker Compose 㧠Redash ãèµ·åããŸãããïŒ
ååã¯ã€ã¡ãŒãžãããŠã³ããŒãããããïŒå°ãæéããããå ŽåããããŸãïŒ
$ docker-compose run --rm server create_db
$ docker-compose up
èµ·åãããšïŒä»¥äžã® URL 㧠Redash ã«ã¢ã¯ã»ã¹ã§ããããã«ãªããŸãïŒ
æåã« Admin User ãš Organization Name ãç»é²ããŸãããïŒä»¥äžã«ãµã³ãã«ãèŒããŠãããŸãïŒç»é²ãå®äºãããšïŒRedash ã«ãã°ã€ã³ã§ããŸãïŒ
- Admin User
- Name
admin
- Email Address
- Password
ä»»æã®ãã¹ã¯ãŒã
- Name
- General
- Organization Name
hands-on
- Organization Name
ãªãïŒRedash ç°å¢ã®æ§ç¯æ¹æ³ã¯ Docker Compose 以å€ã«ããããŸãïŒèå³ã®ããæ¹ã¯ïŒå ¬åŒããã¥ã¡ã³ããèªãã§ã¿ãŸãããïŒ
次㫠Redash ãã MySQL ã«æ¥ç¶ã§ããããã«ãããŒã¿ãœãŒã¹ããèšå®ããŸãïŒ
ãã°ã€ã³åŸã®ç»é¢ã«ããã1. Connect a Data Sourceãã®ãªã³ã¯ãã¯ãªãã¯ãïŒãNew Data Sourceããã¿ã³ãã¯ãªãã¯ããŸãïŒ
次ã«å³åŽã«ãããMySQLããã¯ãªãã¯ããŸãïŒãMySQL (Amazon RDS)ãã§ã¯ãªããMySQLãã§ãïŒ
以äžã®éãã«èšå®ããããSave â Test Connectionããšã¯ãªãã¯ãïŒæ¥ç¶ç¢ºèªãããŸãããïŒSuccess ãšç»é¢å³äžã«è¡šç€ºãããŸãïŒãªãïŒä»åã¯ãã¹ãããŒã¿ãšã㊠world
ããŒã¿ããŒã¹ã䜿ããŸãïŒ
é ç® | å€ |
---|---|
Name | MySQL |
Host | mysql |
Port | 3306 |
User | root |
Password | - |
Database Name | world |
ç»é¢å³äžã«ãã Settings ã¢ã€ã³ã³ãã¯ãªãã¯ãïŒãSettingsãã¿ããã¯ãªãã¯ããŸãïŒ
æ¥ä»ãã©ãŒãããã以äžã®éãã«å€æŽããŸãïŒ
- General
- Date Format
YYYY-MM-DD
- Date Format
ããããŒãããCreate â Queryããšã¯ãªãã¯ãïŒä»¥äžã®ã¯ãšãªãå ¥åããŸãããïŒ
SELECT * FROM country;
å ¥åããããExecuteããã¿ã³ãã¯ãªãã¯ããŠã¯ãšãªãå®è¡ããŸãïŒãããšãåœã®äžèŠ§ããååŸã§ããŸãïŒ
ã¯ãšãªã®å®è¡ãã§ãããïŒç»é¢å·Šäžã®ãNew Queryããšããéšåãã¯ãªãã¯ãïŒã¯ãšãªã¿ã€ãã«ããåœã®äžèŠ§ãã«å€æŽããŸãïŒå¿ããã«ç»é¢å³åŽã«ãããSaveããã¿ã³ãã¯ãªãã¯ããŸãããïŒ
ããã«ãPublishããã¿ã³ãã¯ãªãã¯ããŸãïŒRedash ã§ã¯ã¯ãšãªãå ¬éããããšã§ïŒä»ã®ãŠãŒã¶ãŒã«å ±æããããšãã§ããŸãïŒ
Redash ã§ã¯ã¯ãšãªã«å¯Ÿããããæ°ã«å ¥ãç»é²ããšãã¿ã°ç»é²ãããµããŒããããŠããŸãïŒ
ãŸãïŒã¯ãšãªåã®å·Šã«ããæã¢ã€ã³ã³ãã¯ãªãã¯ãïŒãæ°ã«å ¥ãç»é²ãããŠã¿ãŸãããïŒæ¬¡ã«ïŒã¯ãšãªåã®å³ã«ãããAdd tagããã¿ã³ãã¯ãªãã¯ãïŒ2åã®ã¿ã°ãåæããŒã ããšããã¹ã¿ããŒã¿ããç»é²ããŠã¿ãŸãããïŒ
ã¯ãšãªãå¢ãããšæ¢ãã«ãããªã£ãŠããŸãããïŒç©æ¥µçã«ããæ°ã«å ¥ãç»é²ããšãã¿ã°ç»é²ãã掻çšããŸãããïŒ
å ã»ã©ãšåæ§ã«æ°èŠã¯ãšãªãäœæãïŒä»¥äžã®ã¯ãšãªãå ¥åããŸãããïŒå®è¡ãããšïŒç»é²ãããŠããåœã®ä»¶æ°ãã239ãã§ããããšãååŸã§ããŸãïŒãã®ä»¶æ°ãã°ã©ãã«ããŠã¿ãŸãããïŒ
SELECT COUNT(*) AS COUNT FROM country;
ãTABLEã ã¿ãã®æšªã«è¡šç€ºãããŠããã+ New Visualizationãã¿ããã¯ãªãã¯ãïŒä»¥äžã®éãã«èšå®ãããŸãïŒãSaveããã¿ã³ãã¯ãªãã¯ãããšïŒä»¶æ°ã®ã°ã©ãã衚瀺ãããŸãïŒææ°å€ãªã©ïŒç¹å®ã®å€ãã°ã©ãã«ããå Žå㯠Counter
ã䟿å©ã§ãïŒ
- Visualization Type
Counter
- Visualization Name
åœã®ä»¶æ°
- Counter Value Column Name
COUNT
ãªã Counter
ã«ã¯ãç®æšå€ããèšå®ããæ©èœããããŸãïŒä»åã®ããŒã¿ãœãŒã¹ã§ã¯ããŒã¿ä»¶æ°ã«å€åããããŸãããïŒãµã³ãã«ãšããŠïŒäœã£ãŠã¿ãŸãããïŒå
ã»ã©ã®ã¯ãšãªã以äžã®éãã«å€æŽããŸãïŒ
SELECT COUNT(*) AS COUNT, 500 AS kpi FROM country;
ãã1床ã+ New Visualizationãã¿ããã¯ãªãã¯ãïŒä»¥äžã®éãã«èšå®ãããŸãïŒå ã»ã©ãšã®éãã¯ãTarget Value Column Nameãã®èšå®ãè¿œå ããç¹ã§ãïŒãã®ããã«ã¯ãšãªã掻çšããããšã§ïŒç®æšå€ãšå®çžŸå€ãäžç·ã«å¯èŠåããããšãã§ããŸãïŒ
Counter
ã«ãç®æšå€ããèšå®ããå ŽåïŒå€ãå®çžŸãäžåãå Žåã¯èµ€ã衚瀺ããïŒäžåãå Žåã¯ç·ã§è¡šç€ºãããŸãïŒ
- Visualization Type
Counter
- Visualization Name
åœã®ä»¶æ°ïŒ+ ç®æšå€ïŒ
- Counter Value Column Name
COUNT
- Target Value Column Name
kpi
ã¯ãšãªã¿ã€ãã«ããåœã®ä»¶æ°ããšãïŒå¿ããã«ä¿åãšå ¬éãããŠãããŸãããïŒ
ã¯ãšãªã®äœæã¯ããæ £ãããšæããŸãïŒä»¥äžã®ã¯ãšãªãäœæãïŒå®è¡ããŸãããïŒ
åœããšã«éœåžã®ä»¶æ°ãååŸã§ããŸãïŒäžåœãšã€ã³ããç¹ã«å€ãããšãããããŸãïŒ
SELECT CountryCode, COUNT(*) AS COUNT
FROM city
GROUP BY CountryCode
ORDER BY COUNT DESC;
å ã»ã©ãšåæ§ã«ã+ New Visualizationãã¿ããã¯ãªãã¯ãïŒä»¥äžã®éãã«èšå®ããããšïŒåã°ã©ããäœãããšãã§ããŸãïŒ
- Visualization Type
Chart
- Visualization Name
éœåžã®ä»¶æ°
- General
- Chart Type
Pie
- X Column
CountryCode
- Y Columns
COUNT
- Chart Type
次ã«æ£ã°ã©ããäœã£ãŠã¿ãŸãããïŒèšå®ã¯ä»¥äžã®éãã§ãïŒ
- Visualization Type
Chart
- Visualization Name
éœåžã®ä»¶æ°ïŒæ£ã°ã©ãïŒ
- General
- Chart Type
Bar
- X Column
CountryCode
- Y Columns
COUNT
- Chart Type
ãããïŒæ£ã°ã©ãã®å ŽåïŒãã®ãŸãŸã§ã¯é åºããã©ãã©ã§ãïŒãGENERALãã¿ãã®é£ã«ãããX AXISãã¿ããã¯ãªãã¯ãïŒè»žã®èšå®ãããå¿ èŠããããŸãïŒ
- Scale
Category
- Sort Values
OFF
ããã§æ£ã°ã©ããäœããŸããïŒ
ã¯ãšãªã¿ã€ãã«ããéœåžã®ä»¶æ°ããšãïŒå¿ããã«ä¿åãšå ¬éãããŠãããŸãããïŒ
次ã«ããã·ã¥ããŒããäœã£ãŠã¿ãŸãããïŒ
ããããŒãããCreate â Dashboardããšã¯ãªãã¯ãïŒããã·ã¥ããŒãã¿ã€ãã«ã«ããã³ãºãªã³:åœããã·ã¥ããŒãããšå ¥åããŸãããïŒ
ãã€ã³ã㯠ã°ã«ãŒãå:ããã·ã¥ããŒãå
ãšããåœåèŠåã«ããããšã§ãïŒ
Redash ã«ã¯ Grouping Dashboards ãšããæ©èœãããïŒããã·ã¥ããŒãã¿ã€ãã«ã«ã³ãã³ãå«ããããšã§ïŒåãã°ã«ãŒãã®ããã·ã¥ããŒãããŸãšããŠç®¡çããããšãã§ããŸãïŒè©³ããã¯å ¬åŒããã¥ã¡ã³ããèªãã§ã¿ãŸãããïŒ
次ã«ããã·ã¥ããŒãã«ã°ã©ããé 眮ããŠãããŸãïŒ
ç»é¢å³äžã«ããã¡ãã¥ãŒãããAdd Widgetããã¯ãªãã¯ããŸãïŒãããšãAdd Widgetããšããã¢ãŒãã«ã衚瀺ãããããïŒä»¥äžã®èšå®ãç¹°ãè¿ãè¡ããŸãããïŒã¬ã€ã¢ãŠãã¯èªç±ã«å€æŽããããšãã§ããŸãïŒ
- 1åç®
- Visualization
åœã®äžèŠ§
- Choose Visualization
Table
- Visualization
- 2åç®
- Visualization
åœã®ä»¶æ°
- Choose Visualization
åœã®ä»¶æ°ïŒ+ ç®æšå€ïŒ
- Visualization
- 3åç®
- Visualization
éœåžã®ä»¶æ°
- Choose Visualization
éœåžã®ä»¶æ°
- Visualization
- 4åç®
- Visualization
éœåžã®ä»¶æ°
- Choose Visualization
éœåžã®ä»¶æ°ïŒæ£ã°ã©ãïŒ
- Visualization
ãVisualizationãã«ã¯ãšãªã衚瀺ãããªãå Žåã¯ïŒãã®ã¯ãšãªãå ¬éãããŠããªãããšãèããããŸãïŒ
ããããŒã®ãQueriesã㧠Unpublished
ç¶æ
ã«ãªã£ãŠããã¯ãšãªããã£ããïŒãã®ã¯ãšãªãå
¬éãïŒå床ããã·ã¥ããŒãã«ã°ã©ããè¿œå ããŠã¿ãŸãããïŒ
æåŸã«ç»é¢å³äžã«ãããApply Changesããã¯ãªãã¯ãïŒç¶ããŠãPublishããã¯ãªãã¯ããŸãããïŒã¯ãšãªåæ§ã«ããã·ã¥ããŒããä»ã®ãŠãŒã¶ãŒã«å ±æããããšãã§ããŸãïŒ
Redash ã§ã¯ã¯ãšãªã ãã§ã¯ãªãïŒããã·ã¥ããŒãã«å¯ŸããŠãããæ°ã«å ¥ãç»é²ããšãã¿ã°ç»é²ãããµããŒããããŠããŸãïŒ
ãŸãïŒããã·ã¥ããŒãåã®å·Šã«ããæã¢ã€ã³ã³ãã¯ãªãã¯ãïŒãæ°ã«å ¥ãç»é²ãããŠã¿ãŸãããïŒæ¬¡ã«ïŒããã·ã¥ããŒãåã®å³ã«ãããAdd tagããã¿ã³ãã¯ãªãã¯ãïŒã¿ã°ãåæããŒã ããç»é²ããŠã¿ãŸãããïŒ
次ã¯ã¯ãšãªã«ãã©ã¡ãŒã¿ãä»ããŠã¿ãŸãããïŒ
Redash ã§ã¯ïŒã¯ãšãªã« {{}}
ãå«ãããšïŒãã®éšåããã©ã¡ãŒã¿ã«ãªããŸãïŒä»¥äžã®æ°èŠã¯ãšãªãäœããŸãããïŒãªãïŒã¯ãšãªãå
¥åããåŸã«ã¯ãšãªã®äžã«ãã2çªç®ã®ã¢ã€ã³ã³ãFormat Queryããã¯ãªãã¯ãããšïŒèªåçã«ã¯ãšãªããã©ãŒãããããããšãã§ããŸãïŒ
SELECT * FROM city WHERE CountryCode = '{{CountryCode}}' ORDER BY Population DESC;
ãããšïŒç»é¢å·Šäžã«ãCountryCodeãããã©ã¡ãŒã¿ãšããŠå ¥åããããã¹ããšãªã¢ã衚瀺ãããŸãïŒ
ããã«ãJPNããå ¥åãïŒã¯ãšãªãå®è¡ãããšïŒæ¥æ¬ã®éœåžã人å£ã®å€ãé ã«ååŸããããšãã§ããŸãïŒã¯ãšãªã¿ã€ãã«ããéœåžã®æ€çŽ¢ãã«ããŠä¿åããŠãããŸãããïŒ
ãã©ã¡ãŒã¿ãšããŠå ¥åã§ãã UI ã¯ããã¹ããã£ãŒã«ã以å€ã«ããããŸãïŒååã®éãïŒäŸãã°ãDateããéžæãããšïŒæ¥ä»ããã«ãŒïŒã«ã¬ã³ããŒïŒããæ¥ä»ãéžæããããšãã§ããŸãïŒ
- Text
- Number
- Dropdown List
- Query Based Dropdown List
- Date
- Date and Time
- Date and Time (with seconds)
- Date Range
- Date and Time Range
- Date and Time Range (with seconds)
ä»åã¯äŸ¿å©ãªãDropdown Listããè©ŠããŸãããïŒ
ãã©ã¡ãŒã¿ã®æšªã«ãããã°ã«ãã¯ãªãã¯ãïŒãTypeãã Dropdown List
ã«ããŸãïŒããã« Dropdown List Values (newline delimited)
ã«ä»¥äžã®ãªã¹ããèšå®ããŸãïŒ
JPN
USA
ãããšïŒéžæè¢ããéžã¹ãããã«ãªãããïŒå ¥åãã¹ã軜æžã§ããããã«ãªããŸãïŒ
Redash ã§ã¯ïŒã¯ãšãªã®ã«ã©ã åã ã«ã©ã å::filter
ããã㯠ã«ã©ã å::multi-filter
ãšããåœåèŠåã«ãããšïŒã¯ãšãªçµæããã£ã«ã¿ã§ããããã«ãªããŸãïŒãã£ããè©ŠããŠã¿ãŸãããïŒ
以äžã®æ°èŠã¯ãšãªãäœæãïŒå®è¡ãããšïŒã¯ãšãªçµæããCountryCodeãã§èªç±ã«ãã£ã«ã¿ã§ããããã«ãªããŸãïŒãããããã£ã«ã¿æ©èœãã§ãïŒ
SELECT *, CountryCode AS 'CountryCode::filter' FROM city ORDER BY Population DESC;
次ã«ããã«ããã£ã«ã¿æ©èœããè©ŠããŸãããïŒã¯ãšãªã以äžã®ããã«å€æŽãããšïŒä»åºŠã¯è€æ°ã®ãCountryCodeãã§ãã£ã«ã¿ã§ããããã«ãªããŸãïŒãªãïŒä»åããFormat Queryããå®è¡ããŠãããŸãããïŒ
SELECT *, CountryCode AS 'CountryCode::multi-filter' FROM city ORDER BY Population DESC;
ãã£ã«ã¿æ©èœã¯éåžžã«äŸ¿å©ã§ãïŒè©³ããã¯å ¬åŒããã¥ã¡ã³ããèªãã§ã¿ãŸãããïŒ
ã¯ãšãªã¿ã€ãã«ããéœåžã®ãã£ã«ã¿ãã«ããŠä¿åããŠãããŸãããïŒ
Redash ã§ã¯ïŒãã䜿ãã¯ãšãªïŒãããã¯ã¯ãšãªã®äžéšïŒãã¯ãšãªã¹ãããããšããŠç»é²ããæ©èœããããŸãïŒ
ç»é¢å³äžã«ãã Settings ã¢ã€ã³ã³ãã¯ãªãã¯ãïŒãQuery Snippetsãã¿ããã¯ãªãã¯ããŸãïŒ
次ã«ãNew Snippetããã¿ã³ãã¯ãªãã¯ãããšç»é²ç»é¢ã衚瀺ãããŸãïŒä»¥äžã®èšå®ãããããSaveããã¿ã³ãæŒããŸãããïŒ
- Trigger
_country_code
- Description
åœã³ãŒãæ€çŽ¢
- Snippet
WHERE CountryCode = '{{CountryCode}}'
æ°èŠã¯ãšãªãäœæãïŒä»¥äžã®ã¯ãšãªãå
¥åããŸãããïŒã¯ãšãªã¹ããããã«ç»é²ãããTriggerãã«éšåäžèŽãããšåè£ãšããŠè¡šç€ºããããã _
ãšå
¥åãããšã¯ãšãªã¹ãããããåŒã³åºãããšãã§ããŸãïŒ
SELECT * FROM city _
ã¯ãšãªã¹ããããã«ãã¬ãŒã¹ãã«ããèšå®ããããšãã§ããŸãïŒ
以äžã®ããã« ${1:table}
ãšèšå®ãããšïŒããŒãã«åã®ãã¬ãŒã¹ãã«ãã«ãªããŸãïŒæ¯éè©ŠããŠã¿ãŸãããïŒä»åã¯ã¯ãšãªã¹ããããã®åäœç¢ºèªãç®çã§ãã®ã§ïŒã¯ãšãªã¯ä¿åããªããŠå€§äžå€«ã§ãïŒ
- Trigger
_record_count
- Description
ã¬ã³ãŒã件æ°
- Snippet
SELECT COUNT(*) FROM ${1:table};
Redash ã§ã¯ïŒã¯ãšãªçµæã« HTML ãåã蟌ãããšãã§ããŸãïŒãã£ãã以äžã®æ°èŠã¯ãšãªãäœæããŠã¿ãŸãããïŒ
SELECT Code,
Name,
Population,
CASE
WHEN Population > 1000000000 THEN '<div class="bg-success p-30 text-center">AAA</div>'
WHEN Population > 140000000 THEN '<div class="bg-warning p-20 text-center">BBB</div>'
ELSE '<div class="bg-danger p-10 text-center">CCC</div>'
END AS Color
FROM country
ORDER BY Population DESC;
ãPopulationãã®å€ã«ãã£ãŠãç·é»èµ€ããšè²ãå€ããŠããŸãïŒããã«çžŠãµã€ãºãå€ããŠããŸãïŒãã®ããã«æŽ»çšãããšïŒããã¯ãšãªçµæã䟿å©ã«äœ¿ãããšãã§ããŸãïŒ
ã¯ãšãªã¿ã€ãã«ããåœã®äžèŠ§ïŒè²ä»ãïŒãã«ããŠä¿åããŠãããŸãããïŒä»ã«ãå©çšå¯èœãªããŒã¯ã¢ãããããïŒå ¬åŒããã¥ã¡ã³ãã«èŒã£ãŠããŸãïŒ
ããã·ã¥ããŒãã«è€æ°ã®ã°ã©ããé 眮ããå ŽåïŒé¢é£ãã URL ãªã©ãèŒããŠãããšäŸ¿å©ãªå ŽåããããŸãïŒ
ããã·ã¥ããŒãã«ããªãŒããã¹ããå ¥åããæ¹æ³ããããŸããïŒRedash ã§ã¯ïŒã¯ãšãªçµæã« HTML ãåã蟌ãããšãã§ããããïŒç°¡åã«ãªã³ã¯ãäœæããããšãã§ããŸãïŒ
以äžã®æ°èŠã¯ãšãªãäœæãïŒã¯ãšãªã¿ã€ãã«ãããªã³ã¯éãã«ããŠä¿åããŠãããŸãããïŒ
SELECT '<a href="https://www.google.co.jp/" target="_blank">Google</a>' AS name
UNION
SELECT '<a href="https://www.yahoo.co.jp/" target="_blank">Yahoo!</a>'
UNION
SELECT '<a href="https://www.bing.com/" target="_blank">Bing</a>';
Redash ã§ã¯ïŒã¯ãšãªçµæãããŠã³ããŒãããããšãã§ããŸãïŒçŸç¶ãµããŒããããŠããããŒã¿åœ¢åŒã¯ CSV ãš Excel ã§ãïŒ
ããããŒã®ãQueriesããã¯ãªãã¯ãïŒæ¢ã«äœã£ãã¯ãšãªãåœã®äžèŠ§ããéããŸãããïŒ
ç»é¢äžã«ãããDownload Datasetããã¿ã³ãæŒããšïŒä»¥äžã®ã¡ãã¥ãŒã衚瀺ãããŸãïŒã¯ãšãªçµæãããŠã³ããŒãããŠã¿ãŸãããïŒ
- Download as CSV File
- Download as Excel File
ä»åã¯ãã³ãºãªã³ãšã㊠Redash ã1人ã§äœ¿ã£ãŠããŸããïŒäžè¬çã«ã¯ããŒã ã§äœ¿ãããšãå€ããšæããŸãïŒ
ããŒã ã§äœ¿ã£ãŠãããšãã¡ã³ããŒãäœã£ãã¯ãšãªãå°ãã«ã¹ã¿ãã€ãºãããããšæããå Žé¢ããããŸãïŒãã®ããã« Redash ã«ã¯ããã©ãŒã¯æ©èœãããããŸãïŒ
æ¢ã«äœã£ãã¯ãšãªãåœã®äžèŠ§ããéãïŒç»é¢å³äžã«ãããã«ããŠã³ãããForkããã¿ã³ãã¯ãªãã¯ããŸãããïŒãããšïŒèªåçã«æ°èŠã¯ãšãªãäœæãããŸãïŒã¯ãšãªã¿ã€ãã«ããCopy of (#1) åœã®äžèŠ§ããããåœã®äžèŠ§ïŒã«ã¹ã¿ãã€ãºïŒãã«å€æŽããŸãããïŒ
ã¯ãšãªãèªç±ã«å€æŽã§ããããïŒä»¥äžã®ã¯ãšãªãå ¥åãïŒå®è¡ããŸãããïŒè¡šç€ºããã«ã©ã ããåœã³ãŒãããšãååããšã人å£ãã«ã«ã¹ã¿ãã€ãºã§ããŸããïŒãªãïŒä»åããFormat Queryããå®è¡ããŠãããŸãããïŒ
SELECT Code, Name, Population FROM country;
Redash ã®æ©èœã¯å¯èŠåã ãã§ã¯ãããŸããïŒç¹å®ã®å€ãéŸå€ãè¶ ããå Žåã«ã¢ã©ãŒããéç¥ããæ©èœããããŸãïŒéç¥å ã¯ä»¥äžããéžã¶ããšãã§ããŸãïŒ
- ChatWork
- Slack
- Webhook
- HipChat
- Mattermost
Slack ã« Webhook çµç±ã§ã¢ã©ãŒããéç¥ããŠã¿ãŸãããïŒä»åã¯ïŒèªç±ã«äœ¿ãã Slack ã¢ã«ãŠã³ããããåæã§é²ããŸãïŒ
ãŸãïŒSlack 㧠Incoming WebHooks ãäœæããŸãïŒãã®ãŸãŸã§ã䜿ããŸããïŒãCustomize Nameãã« Redash Alerts
ïŒãCustomize Iconãã« Redash ã®ããŽç»åãªã©ãèšå®ããŠãããšäŸ¿å©ã§ãïŒãWebhook URLãã®å€ã¯æ¬¡ã«äœ¿ããŸãïŒ
ç»é¢å³äžã«ãã Settings ã¢ã€ã³ã³ãã¯ãªãã¯ãïŒãAlert Destinationsãã¿ãã«ãããNew Alert Destinationããã¿ã³ãã¯ãªãã¯ããŸãããïŒæ¬¡ã«ãSlackããã¯ãªãã¯ãïŒç»é²ç»é¢ã§ä»¥äžãèšå®ããŸãïŒ
- Name
Slack
- Slack Webhook URL
Webhook URL
ã¢ã©ãŒããèšå®ããåã«ïŒããå°ãæºåãããŠããå¿ èŠããããŸãïŒ
æ¢ã«äœæããããåœã®ä»¶æ°ãã¯ãšãªãéãïŒãRefresh Scheduleããæå¹ã«ããå¿
èŠããããŸãïŒä»å㯠Every 1 minute
ã«ããŸãããïŒ
ä»åã®äŸã§ã¯ïŒåœã®ä»¶æ°ã«å€åã¯ãããŸãããïŒå®æçã«ã¯ãšãªã®å®è¡ãããæ©èœã§ãïŒã¢ã©ãŒãã®èšå®ãããã¯ãšãªã«ã¯ãRefresh Scheduleãã®èšå®ãå¿ èŠã§ãïŒ
æåŸã¯ã¢ã©ãŒãã®èšå®ã§ãïŒããããŒãããCreate â Alertããã¯ãªãã¯ãïŒãNew Alertãã®ç»é¢ãéããŸãïŒä»¥äžã®ãšã©ãŒãåºãå ŽåããããŸããïŒåé¡ãããŸããïŒ
It looks like your mail server isn't configured. Make sure to configure it for the alert emails to work.
ç»é²ç»é¢ã§ä»¥äžãèšå®ããŸãïŒãRearm secondsãã¯ïŒç°åžžå€ãç¶ãå Žåã«ã¢ã©ãŒããåéç¥ããééïŒç§æ°ïŒã§ãïŒ
- Query
åœã®ä»¶æ°
- Name
åœã®ä»¶æ°ã200件ãè¶ ããå Žå
- Value column
COUNT
- Op
greater than
- Reference
200
- Rearm seconds
60
ãSaveããã¯ãªãã¯ãããšïŒå³åŽã«ãNotificationsãã®ã¡ãã¥ãŒã衚瀺ãããããïŒãSlackãããAddããïŒããäžåºŠãSaveããã¯ãªãã¯ããŸãïŒ
ãããšïŒSlack ã«ã¢ã©ãŒããéç¥ãããŸãïŒç¢ºèªãã§ããããRearm secondsãããã©ã³ã¯ã«ããŠãSaveããã¯ãªãã¯ããŠãããŸãããïŒ
次ã«ïŒRedash 管çè ãšã㊠Redash ãŠãŒã¶ãŒãè¿œå ïŒç¡å¹åããéçšæé ãè©ŠããŠã¿ãŸãããïŒ
ãŸãïŒç»é¢å³äžã®ã¡ãã¥ãŒãããUsersããã¯ãªãã¯ãïŒæ¬¡ã«ãNew Userããã¿ã³ãã¯ãªãã¯ããŸãïŒãªãïŒç»é²ç»é¢ã«ä»¥äžã®ãšã©ãŒãåºãå ŽåããããŸããïŒåé¡ãããŸããïŒ
It looks like your mail server isn't configured. Make sure to configure it for the alert emails to work.
以äžã®éãã«ïŒRedash ãŠãŒã¶ãŒã2åç»é²ããŸãïŒãªãïŒ2åç®ãç»é²ããéã¯ïŒã¿ãã®ãUsersããã¯ãªãã¯ããå¿ èŠããããŸãïŒç»é²ãçµãã£ããïŒãã1床ã¿ãã®ãUsersããã¯ãªãã¯ãïŒãŠãŒã¶ãŒäžèŠ§ã§ç¢ºèªãããŸãããïŒ
- New User
- Name
RedashUser1
- Name
RedashUser2
- Name
ã¡ã³ããŒã®éè·ãªã©ïŒRedash ãŠãŒã¶ãŒãåé€ããå Žåã¯ã©ããããè¯ãã®ã§ãããïŒ
Redash ã«ã¯ãŠãŒã¶ãŒãåé€ããæ©èœã¯ãããŸãããïŒãŠãŒã¶ãŒãç¡å¹åããæé ããããŸãïŒãŠãŒã¶ãŒäžèŠ§ã§ãRedashUser2ãã®ãDisableããã¿ã³ãæŒããŠã¿ãŸãããïŒãããšïŒç»é¢ããæ¶ãïŒé£ã®ãDisabled Usersãã¿ãã«ç§»åããããšã確èªã§ããŸãïŒç¡å¹åã解é€ããå Žåã¯ãEnableããã¿ã³ãã¯ãªãã¯ããŸãïŒ