Supervisoråž‹ã®æ—§Redash(v4)ã‚’Dockeråž‹ã®æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³(v8)ã¸ã‚¢ãƒƒãƒ—グレードã™ã‚‹ | DevelopersIO
ã“ã‚“ã«ã¡ã¯ã€‚DA事æ¥æœ¬éƒ¨ã®æ˜¥ç”°ã§ã™ã€‚ Supervisoråž‹ã®æ—§ç‰ˆRedashサーãƒãƒ¼ã‚’ホストã—ã¦ã„ã‚‹æ–¹ã¯ãã‚Œãªã‚Šã«ã„らã£ã—ゃるã‹ã¨æ€ã„ã¾ã™ãŒã€version8以é™ã‹ã‚‰ bin/upgrade ã®ã‚µãƒãƒ¼ãƒˆãŒå»ƒæ¢ã•ã‚Œã¦ã„ã‚‹ã®ã¯ã”å˜çŸ¥ã§ã™ã‹ï¼Ÿï¼ˆ download_url ãŒã‚ã‚Šã¾ã›ã‚“ï¼ï¼‰ $ curl https://version.redash.io/api/releases | jq [ { "id": 39, "version": "8.0.0", "channel": "stable", "download_url": "", "backward_compatible": false, "released_at": "2019-10-27T00:00:00.000Z", "description": "See [CHANGELOG](https://github.com/getreda
redashã®å°Žå…¥ã€é‹ç”¨ã§å¾—ãŸçŸ¥è¦‹ã€æ”¹å–„ã¾ã¨ã‚ | @19840209 T&T
ã¯ã˜ã‚ã« redashã¯åŽ»å¹´ã®å¹´æœ«é ƒVersion 4ãŒå‡ºã¦ã€å¤ã«Version 5ã€ãã—ã¦Version 6ãŒè¿‘日リリースã¨ã„ã†ã‚¹ãƒ”ードã§ã€ã©ã‚“ã©ã‚“メジャーãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã‚’ç¹°ã‚Šè¿”ã—ã€æ©Ÿèƒ½ãŒæ‹¡å……ã•ã‚Œã¦ã„ã¾ã™ã€‚ レアジョブã§ã¯Docker版 redash Version 1.03ã§åˆã‚ã¦redashã‚’å°Žå…¥ã—ã€ä½•åº¦ã‚‚Version UPã‚’ç¹°ã‚Šè¿”ã—ç¾åœ¨ã¯æœ€æ–°ç‰ˆ(5.02)を使ã£ã¦ã„ã¾ã™ã€‚ ãã“ã§å¾—ãŸçŸ¥è¦‹ã«ã¤ã„ã¦ã¯ãƒ¡ãƒ¢ã‚’書ã„ã¦ã„ã¾ã—ãŸãŒã€( https://tsukada.sumito.jp/category/tech/redash/ ) ã‚ãã¾ã§ã‚‚メモベースãªã®ã§ã€ã“れを機ã«ã¡ã‚ƒã‚“ã¨ãƒ–ãƒã‚°ã¨ã—ã¦ã¾ã¨ã‚ãŸã„ã¨ãŠã‚‚ã„ã¾ã™ã€‚ 弊社ã§ã®åˆ©ç”¨è€… アルãƒã‚¤ãƒˆã‹ã‚‰å½¹å“¡ã¾ã§ã€æ§˜ã€…ãªãƒãƒ¼ãƒ«ã‚’æŒã£ã¦ã‚‹äººãŒä½¿ã£ã¦ã¾ã™ã€‚ Botã‚‚å‹•ã„ã¦ãŠã‚Šã€ä¸€éƒ¨APIを使ã„ã€Chatã«é€šçŸ¥ã™ã‚‹ä»•çµ„ã¿ã‚‚å–り入れã¦ã„ã¾ã™ã€‚ SQLを書ã‘
社内PCã§ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã•ã‚Œã¦ã„ãŸRedashã‚’Fargateã«ç§»è¡Œã—ã¦ã¿ãŸ - ZOZO Technologies TECH BLOG
ã“ã‚“ã«ã¡ã¯ã€æœ€è¿‘æ°—ã«ãªã£ã¦ã„る哺乳類ã¯ã‚ªãƒªãƒ³ã‚®ãƒ¼ãƒˆãªã€é–‹ç™ºéƒ¨ã®å¡©å´Žã§ã™ã€‚ ç§ã®æ‰€å±žã—ã¦ã„ã‚‹MarketingAutomationãƒãƒ¼ãƒ ã§ã¯RealtimeMarketingシステムã®é–‹ç™ºé‹ç”¨ã‚’è¡Œã£ã¦ãŠã‚Šã¾ã™ã€‚ ã“ã®ã‚·ã‚¹ãƒ†ãƒ ã¯ZOZOTOWNã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«å¯¾ã—ã¦ãƒ¡ãƒ¼ãƒ«ã‚„LINEãªã©ã®ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒãƒ£ãƒ³ãƒãƒ«ã‚’使ã„æƒ…å ±ã®é…ä¿¡ã‚’è¡Œã†ã‚‚ã®ã§ã™ã€‚ メルマガã®é…ä¿¡æ•°ã‚„é–‹å°æ•°ãªã©ã®æ•°å€¤ã¯è‡ªå‹•çš„ã«é›†è¨ˆã•ã‚Œã€BIツールã§ã‚ã‚‹Redashã«ã‚ˆã£ã¦ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®Redashã¯ç¤¾å†…PCã«ã‚ˆã£ã¦ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã•ã‚Œã¦ã„ã¾ã—ãŸãŒã€é‹ç”¨é¢ã§è¾›ã„部分ãŒå¤šã€…ã‚ã£ãŸãŸã‚パブリッククラウドã«ç§»è¡Œã—ã¾ã—ãŸã€‚ 移行先ã®ã‚¯ãƒ©ã‚¦ãƒ‰ã¯awsã‚’é¸æŠžã—ã€Redashをホスティングã™ã‚‹ãŸã‚ã®ã‚µãƒ¼ãƒ“スã¯ECS/Fargateã‚’é¸æŠžã—ã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã§ã¯awsã«æ§‹ç¯‰ã—ãŸç’°å¢ƒã‚„ã€ç§»è¡Œä½œæ¥ãªã©ã‚’紹介ã—ã¾ã™ã€‚ 移行å‰ã®Redash 移
Redash v5 アップデートピックアップ / Redash v5 Update Pick Up - Speaker Deck
Redash Meetup 4.0.0 ã®ç™ºè¡¨è³‡æ–™
redashé‹ç”¨ã‚¢ãƒ³ãƒãƒ‘ターン - Speaker Deck
2018/10/17 redasm meetup 4.0.0ã®LTã§ç™ºè¡¨ã—ãŸè³‡æ–™ã§ã™ã€‚
Redash ã®è¤‡æ•°å°æ§‹æˆåŒ–ãã®2(Redis を別インスタンスã«ã™ã‚‹) - ariarijp’s blog
以下ã®è¨˜äº‹ã®ç¶šãã§ã™ã€‚ ariarijp.hatenablog.com å‰ç½®ã å‰ã®è¨˜äº‹ã§ Redash 㨠PostgreSQL を別インスタンスã§å‹•ä½œã•ã›ã‚‹ç’°å¢ƒãŒã§ãã¦ã„ã‚‹ã“ã¨ã‚’å‰æã¨ã—ã¾ã™ã€‚ Redis を別インスタンスã«ã™ã‚‹ PostgreSQL ã«æ¯”ã¹ã€Redis を別インスタンスã«ã™ã‚‹ã“ã¨ã¯æ€§èƒ½ã«å¤§ãã影響を与ãˆã‚‹ã‚‚ã®ã§ã¯ãªã„ã¨æ€ã„ã¾ã™ãŒã€Redash ã«å…¨éƒ¨å…¥ã‚ŠçŠ¶æ…‹ã«ãªã£ã¦ã„るミドルウェアã‹ã‚‰åˆ¥ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã«åˆ‡ã‚Šå‡ºã—ã‚„ã™ã„ã“ã¨ã‚‚ã‚ã‚Šã€ã“ã®è¨˜äº‹ã§ã¯ Redis を別インスタンスã«ã™ã‚‹æ–¹æ³•ã‚’紹介ã—ã¾ã™ã€‚ Redis ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ Redash インスタンスã‹ã‚‰å‚ç…§ã§ãã‚‹ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯å†…ã«é…ç½®ã—ã€Redash ã®è¨å®šã‚’変ãˆã¦ã„ãã¾ã™ã€‚ Redis インスタンスã®è¨å®šã¯å‰²æ„›ã—ã¾ã™ãŒã€Redash インスタンスã‹ã‚‰ã‚¢ã‚¯ã‚»ã‚¹ã§ãるよã†ã«ãªã£ã¦ã„ã‚‹ã“ã¨ã‚’å‰æã¨ã—ã¾ã™ã€‚ プライベート IP
Celery を試ã—ã¦ã¿ã‚‹ - ariarijp’s blog
Redash を介ã—ã¦ãŠä¸–話ã«ãªã‚‹ã“ã¨ã¯ã‚ã‚Œã©ã€å˜ä½“ã§ä½¿ã£ãŸã“ã¨ãŒãªã‹ã£ãŸã®ã§æ”¹ã‚㦠Celery を試ã—ã¦ã¿ã‚‹ã€‚ Homepage | Celery: Distributed Task Queue Python ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 3.6.5。Celery ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 4.1.1 を使用ã—ãŸã€‚ Celery ã¨ã¯ Celery: Distributed Task Queue 分散タスクã‚ュー。ã¨ã®ã“ã¨ã€‚ Celery ã§ä½¿ãˆã‚‹ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãƒ–ãƒãƒ¼ã‚« Brokers — Celery 4.1.0 documentation RabbitMQ, Redis, Amazon SQS ã‚ãŸã‚ŠãŒä½¿ãˆã‚‹ã¨ã®ã“ã¨ã€‚今回㯠Redash ã®ç†è§£ã‚’æ·±ã‚ã‚‹ã“ã¨ã‚‚目的ã®ã²ã¨ã¤ãªã®ã§ã€Redis を使ã†ã“ã¨ã«ã™ã‚‹ã€‚ çµæžœã‚’å–å¾—ã™ã‚‹ãŸã‚ã® Result Backend First Steps with Celery
Conditional Formatting & General Text Formatting
This site is in read only mode. Please continue to browse, but replying, likes, and other actions are disabled for now. While Redash doesn’t naturally support conditional formatting, this can be bypassed with some html tags. CASE WHEN cat.color IN ('short_hair', 'semi_short_hair') AND cat_count > 1000 THEN '<div class="bg-success p-10 text-center">' || count(cat) || '</div>' OR cat_count > 200 THE
Cohort Query Example
This site is in read only mode. Please continue to browse, but replying, likes, and other actions are disabled for now. Cohorts are a good tool to review retention of users over a defined period of time. To create your own cohort report, you’ll need to define your cohort time frame, population, and activeness of users. Here is an example of a cohort query in PostgreSQL, step by step: We used the W
Flow/Sequence Queries - Sankey and Sunburst Visualizations
This site is in read only mode. Please continue to browse, but replying, likes, and other actions are disabled for now. Sankey and Sunburst visualizations are awesome for understanding behavioral flows and sequences. To create such a chain of events you’ll need to define the actions/event you want to examine, define how many events are in a sequence (max number of events) and assign chronological
redash checkbox sort value - by shigemk2
redash checkbox sort value ã“ã‚Œã¯Y軸をソートã™ã‚‹ã‚‚ã®ã§ã¯ãªãã€X軸をソートã—ã¦ã„ã‚‹ã®ã§ã€order byã—ã¦ã„ã‚‹ã‚‚ã®ã§sort valueã™ã‚‹ã¨ãŠã‹ã—ãªã“ã¨ã«ãªã‚‹ã€‚ 実際ã«ãƒ‡ãƒ¼ã‚¿ã‚’ソートã—ã¦ã„る箇所 underscoreã®sortByを利用ã—ã¦ã„る。ã“ã“ã§ã¯X軸をソートã—ã¦ã„る。ソートã®ä¸èº«ã¯underscoreã®sortByã«å§”ãられる。 redash/utils.js at master · getredash/redash · GitHub
memo redash issue - by shigemk2
memo redash issue Sign in to GitHub · GitHub ã§ã™ã£ã¦ ã¯ã„。 redash/ISSUE_TEMPLATE.md at master · getredash/redash · GitHub Future Requestを出ã™ã¨ãã¯ã€trelloã‚’ã¿ã¦ã€ http://bit.ly/redash-roadmap ãªã‹ã£ãŸã‚‰discussionã—ã‚ã£ã¦ã• https://discuss.redash.io/c/feature-requests
Redashã«ã¤ã„ã¦ã„ã‚ã„ã‚調ã¹ã‚‹ã¨ãã«é ã®ãªã‹ã§ã‚¤ãƒ¡ãƒ¼ã‚¸ã—ã¦ã„る図 - ariarijp’s blog
draw.ioを試ã—ã¦ã¿ãŸã‹ã£ãŸã®ã§ã€è©¦ã—ã¦ã¿ãŸã¤ã„ã§ã«ãƒ¡ãƒ¢ã€‚ Flowchart Maker & Online Diagram Software 構æˆå›³ é–“é•ã£ã¦ã„ã‚‹ã¨ã“ã‚ã‚‚ã‚ã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã‘ã©ã€ã“ã‚“ãªå›³ã‚’イメージã—ã¦ã„る。 備考 図ã«ã¯æ›¸ã„ã¦ãªã„ã‘ã©Redash Serverã¯Flaskã€Redash Workerã¯Celery上ã§å‹•ã。ã“ã®ã‚ãŸã‚Šã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ãƒ¡ãƒ¢ã—ãŸã€‚ ariarijp.hatenablog.com 基本的ã«Workerã—ã‹ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã«è§¦ã‚‰ãªã„。 ãŸã ã—ã€ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹è¨å®šç”»é¢ã§Test Connectionã—ãŸæ™‚ã¯Serverã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€‚
ランã‚ング
ランã‚ング
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Writing a New Query Runner
データドリブンãªæ„æ€æ±ºå®š 〜鳥ã®ç›®ã¨è™«ã®ç›®ã§ã‚°ãƒãƒ¼ã‚¹ã•ã›ã‚‹ãƒ‡ã‚£ãƒ¬ã‚¯ã‚¿ãƒ¼ã®ãƒ‡ãƒ¼ã‚¿æ´»ç”¨äº‹ä¾‹ã€œ / Data-driven decision making with bird's-eye view - Speaker Deck
redash userã®ç®¡ç†ã«ã¤ã„ã¦
Redashã®"Visualization"ã®å¼·ã¿ - Redash Meetup 4.0.0
GitHub - toritori0318/redash-dynamic-query: A tool for executing dynamic query of redash.
一æ©è¸ã¿è¾¼ã‚€ Redash
redash å°Žå…¥ã§è€ƒãˆã‚‹ãƒ‡ãƒ¼ã‚¿åˆ†æžã¨æ´»ç”¨
{{#tags}}- {{label}}
{{/tags}}