æåã«BigQueryã¨Snowflakeã®æ¦è¦ã¨ãç»å ´ã®èæ¯ã説æãã¾ãã ãã®å¾ãã¦ã¼ã¶ã«ã¨ã£ã¦ã®ä½¿ãåæã¨ã管çè ã«ã¨ã£ã¦ã®ä½¿ãåæãããã³ãã¼ããªã¼ãªç«å ´ã§ãããããã¾ãã æå¾ã«ãBigQueryã¨Snowflakeã©ã£ã¡ãéãã®ãï¼ã¨ãã£ãçåã«å¯¾ãã¦ãã¢ã¼ããã¯ãã£ããã¨ã«èå¯ãã¾ãã
ããæè¿ãSnowflakeã¨Treasure Dataã®éããæãã¦ã»ããã ã¨ãã£ã質åãé ããã¨ãå¢ãã¦ãã¾ãã ã©ã¡ããã¯ã©ã¦ãDWH(ãã¼ã¿ã¦ã§ã¢ãã¦ã¹)ãã ã¯ã©ã¦ããã¼ã¿ãã©ãããã©ã¼ã ã¨å¼ã°ããããã«ã競åãããããã¯ãã§ããã ã¯ã©ã¦ãã®ã¹ã±ã¼ã«ã¡ãªãããæ´»ããã¦ããç¹ã ã¦ã¼ã¶ããªãã£ã®é«ãGUIãç¨æããã¦ããç¹ãªã©ãå ±éç¹ãå¤ãã§ãã 2011å¹´ã«ç±³å½ã§æ¥æ¬äººãåµæ¥ãã 2013å¹´ããä»æ¥ã«è³ãã¾ã§æ¥æ¬å½å ã§ã®æ®åãçå®ã«é²ãã¦ãã£ãTreasure Dataã 2012å¹´ã«ç±³å½ã§å Oracleåºèº«è ãåµæ¥ãã ã°ãã¼ãã«ã§ã®è©ä¾¡ã確åºãããã®ã¨ãã æºãæãã¦2019å¹´ã«æ¥æ¬æ³äººãè¨ç«ããSnowflakeã ã°ãã¼ãã«ã§ã®ç¥å度ã¯å§åçã«Snowflakeã®æ¹ãé«ãã®ã§ãã æ¥æ¬å½å ã§ã®æ´å²ã¯ã¾ã æµ ãã å½å ã«ããã¦ã¯Treasure Dataã®æ¹ãç¥å度ãé«ã
2021å¹´10æã« Redash ã®ææ°ãã¼ã¸ã§ã³ãRedash v10.0.0ãããªãªã¼ã¹ãããï¼ããã¦ç¾å¨ã¯ãRedash v10.1.0ãã¾ã§åºã¦ããï¼ã¾ã Redash çéã§ã¯ããç¥ããããæ£å¼ãªãªã¼ã¹ã¾ã§å°éããªãã£ã v9.0.0ãã¨ãã話ãããï¼å®ã«2å¹´æ¯ãã®æ£å¼ãªãªã¼ã¹ã¨ãªãï¼Redash ã使ã£ã¦ããä¼ç¤¾ã ã¨ã§ã¯ãv8 â v10ãã«ã¢ãããã¼ãããæ©ä¼ãå¤ãã¨æãï¼ ãã¼ã¸ã§ã³ ãªãªã¼ã¹æ¥ v9.0.0-beta 2020-06-11 ãªãªã¼ã¹ v10.0.0-beta 2021-06-16 ãªãªã¼ã¹ v10.0.0 2021-10-01 ãªãªã¼ã¹ v10.1.0 2021-11-23 ãªãªã¼ã¹ ä»å㯠Change Log ã確èªãã¤ã¤ï¼ãå人çã«æ°ã«ãªã£ã Redash v10.1.0 æ°æ©è½ã¨æ©è½æ¹åãããè¨5ç¹ãç´¹ä»ããï¼å ¨ã¦ã®å¤æ´ç¹ã¯ä»¥ä¸ã«è¼ã£ã¦ããï¼ gi
ãRedash Meetup v8.0.0ãã®è³æä¸è¦§ã§ãã
4æ27æ¥ãã6æ30æ¥ã«éå¬ããããã¼ã¿ãµã¤ã¨ã³ã¹ã³ã³ããã£ã·ã§ã³ãAIã¨ãã¸ã³ã³ãã¹ãï¼å¤é¨ãµã¤ãï¼ãã§ãJR西æ¥æ¬ã®è¥æ社å¡äºäººãåªåãåã¡åã£ããJR西æ¥æ¬ã¯ã2017å¹´ããæ¬æ ¼çã«ãã¼ã¿ãµã¤ã¨ã³ã¹ã®åãçµã¿ãéå§ã2020å¹´ã«ã¯ããã¼ã¿ã½ãªã¥ã¼ã·ã§ã³å®¤ããè¨ç«ãããã¼ã¿åæãAIãç¨ããæ¥åå¤é©ãé²ãã¦ããã ãªããJR西æ¥æ¬ã¯åªåã§ããã®ãï¼åªåãåã¡åã£ãJR西æ¥æ¬ãã¼ã¿ã½ãªã¥ã¼ã·ã§ã³å®¤ã®æ¾ç°ç¯¤å²ãããå ç庸平ããã®ãäºäººã«è©±ãèããã å æ°å¹¹ç·ã®é転士ãé§ æ©æ¢°è¨åã®ã¨ã³ã¸ãã¢ã ã£ãäºäººå çããã¨æ¾ç°ããã¯ãã¨ãã«äºæ¥é¨ã®åºèº«ã ã å çãããæ°åã§æåã«é å±ãããå ã¯ãç·åè»ä¸¡æã¨ããè»ä¸¡æ¤æ»ãè¡ãé¨ç½²ããã®å¾ãå±±é½ã»åé¸æ°å¹¹ç·ã®é転士ãåããå¾ãæ令æã¨å¼ã°ãããæ°å¹¹ç·ã®éè¡ç®¡çãè¡ãé¨ç½²ã«ç°åããã
ã°ã«ã¼ããä½ãã°ãç¡æã§èª°ã§ãã¤ãã³ããã¼ã¸ãä½æã§ãã¾ããæ å ±çºä¿¡ã交æµã®ããã®ã¤ãã³ããTECH PLAY ã§å ¬éãã¦ã¿ã¾ãããï¼
ãç¥ãã èª ã«æ®å¿µã§ãããEmbulk & Digdag Meetup 2020ã®éå¬ã®å»¶æããå ±åãããã¾ãã æ°åã³ããã¦ã¤ã«ã¹ææç(COVID-19)ã®è¢«å®³æ¡ã®ç¶æ³ä¸ã«ããã¦ãä»åã®ãã¼ãã¢ããéå¬ã¯æã¾ãããªãã¨å¤æãã延æããã¦ããã ããã¨ã¨ãªãã¾ããã 4æ以éã«ç¶æ³ãéã¿ãå度ãã¼ãã¢ããã®ä¼ç»ããã¦ããã ãã¾ãã®ã§ã楽ãã¿ã«ãå¾ ã¡ãã ããã æ¦è¦ Treasure Dataãä¸å¿ã¨ãªã£ã¦éçºã»æä¾ããã¦ããOSSãããã¯ãã§ããEmbulkã¨Digdagã®Meetupã2020å¹´åéå¬ãã¾ãï¼ Embulk/Digdagã®ãªãªã¸ãã«éçºè ã§ããå¤æ©(@frsyuki)ãç¾å¨ã®ã³ã¢éçºãã¼ã ãåå ãã¦ãEmbulkã¨Digdagããããã®ä»å¾ã®ãã¼ããããã«ã¤ãã¦çºè¡¨ãã¾ãã ããã«ãEmbulkã¨Digdagããããã¯ã·ã§ã³ç°å¢ã§å©ç¨ãã¦ããZOZO Technologi
ã¤ã¾ããªã«ããã®ï¼ Dockerã使ã£ã¦ããã¨ãã¤ã®éã«ãDockerã®ã¤ã¡ã¼ã¸ã¨ãããªã¥ã¼ã ã§è¥å¤§åãã¦ããã®ã§ã使ããªããªã£ããã®ã¯æ¨ã¦ããã ã©ããã便å©ãªdocker system pruneã¨ããã³ãã³ãããããããã®ã§ä½¿ã£ã¦ã¿ãã docs.docker.com pruningã£ã¦åªå®ã£ã¦æå³ã§ã使ã£ã¦ããªãã³ã³ããã¨ããåªå®ãã¦ãããçãªæå³ã ã£ãã ãããã«ã¼ã³ã®èæ¨ãã¿ãããªã®ãæãåºãã¦ãããã§åªå®ãå ¨ç¶åºã¦ããªãã£ãã ç°å¢ã«ã¤ã㦠ãã§ã«ã¤ã³ã¹ãã¼ã«æ¸ã¨ããã docs.docker.com 以éã®ç°å¢ã¯ Docker CE Version 18.06.0-ce-mac70 (26399) Engine: 18.06.0-ce Compose: 1.22.0 Machine: 0.15.0 Notary: 0.6.1 Credential Helper: 0.6.0
ããã«ã¡ã¯ã次ä¸ä»£ã·ã¹ãã ç 究室ã®S.Iã§ãã ä»åãæ å½ãã¦ããã·ã¹ãã ã®Redashç°å¢ãã6.0.0ãããã8.0.0ãã«ãã¼ã¸ã§ã³ã¢ãããã¾ããããã®ä¸ã§å®éã«ä½¿ã£ã¦ããæ©è½ãæ°ã«ãªã£ãå¤æ´ç¹ï¼â»ver 7.0.0å«ãï¼ã¨ãã¼ã¿åæãå¯è¦åã®éã«ããå©ç¨ããSQLã®Tipsãç´¹ä»ãã¾ãã Redash 8.0.0追å æ©è½ã®ç´¹ä» Datasourceã®è¿½å 以ä¸ã®ãã¼ã¿ã½ã¼ã¹ã追å ããã¾ããã Azure Data Explorer (Kusto) Cassandra Couchbase Dgraph JSON Phoenix Uptycs Apache Drill SQLã®é¸æå®è¡ 以ä¸ã®ããã«é¸æããç¯å²ã®ã¯ã¨ãªã®ã¿å®è¡ã§ããããã«ï¼ä½¿ãè¾¼ãã»ã©ã¯ã¨ãªã¯è¤éã«ãªããããã®ã§ãä½æ¥ããªããã®ç¢ºèªãå¹ççã«ã§ããããã«ãªãã¾ããã ãããããã¦ã³ã®ãã«ãé¸æãµãã¼ã ä½æãããããã
å°å£²ã«ã¯ã³ãããæªããå å ¥è¦³ãç¾å ´ä¸»ç¾©ããã¶ã£å£ãï¼ããã¼ã¿ããªãã³ãªã°ããã¤ä¸ä»£ç®ç¤¾é·ã¯ãä½ã¨æ¦ã£ã¦ããã®ãï¼é·è°·å·ç§æ¨¹ã®ãITé å ´æ¾æµªè¨ãï¼1/4 ãã¼ã¸ï¼ ã¡ã«ã«ãªã®CIOãéä»»ããããããã§ãã·ã§ãã«CDOã®éãåãã²ããï¼ãã¨å®£è¨ããé·è°·å·ç§æ¨¹æ°ããé ãé ã¿äº¤ãããªããèªãåãæ¬å¯¾è«ãä»åã¯ãä½ãé£ã¹ã¦ãããããåå¤ã«ãã£ã¦ã¾ããã¾ããã ã²ã¹ãã¯ãåé¨ä¹å·ã»å±±å£ãä¸å¿ã«ãã¼ã ã»ã³ã¿ã¼65åºèãéå¶ãããã°ããã¤ãã®ä¸ä»£ç®ç¤¾é· æ³ç¬éå¿ãããç¬å¦ã§çµ±è¨åæãã¼ã«ã®Rããããã°ã©ãã³ã°è¨èªã®Pythonãç¿å¾ãã社å¡ã¨ã¨ãã«ãã¼ã¿ããªãã³ãªçµå¶ãç®æãã¦ãã¾ãã POSãã¼ã¿ã¯ãéå»ã¯åããããããæªæ¥ã¯æãã¦ãããªããââããããªå°å£²æ¥ã®å®èª¬ã«ããããããªãã¨å調ãã¦ããæ±æ¥ãã³ãºæ代ã®é·è°·å·æ°ã«ã¨ã£ã¦ãæ³ç¬æ°ã¨ã®åºä¼ãã¯è¡æçã ã£ãããã§â¦â¦ ãã¼ã¿ããªãã³ãªä¸ä»£ç®ç¤¾é·ã¯ããã
ãã®è¨äºã¯Tech KAYAC Advent Calendar 2019 Update/MigrationTrack 3æ¥ç®ã®è¨äºã§ãã æ¨å¹´ã®Advent Calendarã§éã®redash ã®è¨äºãæ¸ãã¦ããã²ã¼ã ã³ãã¥ããã£(Lobi)äºæ¥é¨ã®èªç§°ãã¼ã¿ã¨ã³ã¸ãã¢ã®æ± ç°ã§ããä»åããredashã«ã¤ãã¦è¨äºãæ¸ãã¦ããããã¨æãã¾ãã redashã¯æ§ã ãªç¨®é¡ã®ãã¼ã¿ã½ã¼ã¹ã«ã¢ã¯ã»ã¹ã§ãããOSSã®ç´ æ´ãããããã·ã¥ãã¼ããã¼ã«ã§ãã 2017-01-31ã«v1.0.0-rc.1ã®ãªãªã¼ã¹ããã¦ä»¥æ¥éçºãç¶ãããã¦ããããã®åã®2019-10-27ã«v8.0.0 ããªãªã¼ã¹ããã¾ããã ä»å¾ããã¸ãã¹ã¤ã³ããªã¸ã§ã³ã¹ã®ç¾å ´ã§ã®ããã·ã¥ãã¼ããã¼ã«ã®é¸æè¢ã¨ãã¦å©ç¨ããç¶ãããã¨ã§ãããã ã²ã¼ã ã³ãã¥ããã£äºæ¥é¨ã§ã®Redashã®èª²é¡ ç§ã®æå±ããã²ã¼ã ã³ãã¥ããã£äºæ¥é¨ã§ãã以åæ¬
ã¿ã¤ãã«éãã§æ¬å½ããã ããªã®ã§ããv8ã§ãå é±ãããç´è¿7æ¥ããªã©ç¸å¯¾çãªæ¥ä»ãã©ã¡ã¼ã¿ãè¨å®ã§ããããã«ãªãã¾ãã å人çã«ã¨ã¦ãè¯ã! Redashãå ¥ãã¦ããããªäººã«ä½¿ã£ã¦ãããã ãã¨ã»ã¼è¨ãããã§ããã ãæéæå®ã§ä»é±ã¨ãä»æã¨ãã£ã¦ã§ããªãã®?ãã¨ããæãã®ã㤠v8以åã¯å¯¾å¿ãã¦ãªãã£ãã®ã§ãã¯ã¼ãã¬ã¤ã§é å¼µãã¨ããæ¹æ³ããããã®ã® SQLã§é å¼µã ããã©ã«ãå¤ã§ãã©ã¡ã¼ã¿ãåãåã£ã¦ããªãå ´åã«ãç´è¿âæ¥ãã¨ãããããªã¯ã¨ãªãæ¸ã ã¯ã¨ãªIDæå®ã§å®æçã«SQLã§ä¸æ¸ãï¼self-hostedã®å ´åã«éãï¼ queries.optionsã®ä¸èº«ãæ¯æ¥cronã§æ´æ°ãã ãªã©ã®æ¹æ³ãåããã«ã¯ã¨ãã¾ãã ã©ããããã¼ãâ¦ãã¨ãã£ãæãã§ãã ç»é¢ é©ç¨ãããã®ã¯æ¥ä»ç³»ã®æå®ãã¹ã¦ æå®å¯è½ãªãã©ã¡ã¼ã¿ã®å ´åInputã®æ¨ªã«é·ã®ãã¼ã¯ã表示ããã¯ãªãã¯ããã¨ãªã¹ããåºã¦ããã®
2019å¹´10ææ«ã« Redash ã®ææ°ãã¼ã¸ã§ã³ãRedash v8.0.0ãããªãªã¼ã¹ãããï¼Change Log ãèªãã¨æ©è½æ¹åãå¤ãããï¼ä»åã¯ãå人çã«æ°ã«ãªã£ã Redash v8 æ°æ©è½ã¨æ©è½æ¹åãããè¨10ç¹ãç´¹ä»ãããã¨æãï¼Change Log ã¯ä»¥ä¸ã® CHANGELOG.md ã§ç¢ºèªã§ããï¼ redash/CHANGELOG.md at master · getredash/redash · GitHub ç®æ¬¡ ãããããã¦ã³ã§è¤æ°å¤ãé¸æã§ããããã«ãªã£ã ã¯ã¨ãªåãæ¥æ¬èªã§æ£ããæ¤ç´¢ã§ããããã«ãªã£ã ããã·ã¥ãã¼ããã°ãªãã表示ã«ãªã£ã ãã¼ã¿ã½ã¼ã¹è¿½å ï¼åé¤ ãã¼ã¿ã½ã¼ã¹è¨å®ç»é¢ã® UI æ¹å ã¯ã¨ãªç»é¢ã«ãã¼ã¿ã½ã¼ã¹ã®ã¢ã¤ã³ã³ã表示ãããããã«ãªã£ã ã«ã¹ã¿ã ã¢ã©ã¼ãæ©è½ Query API Key ãä½ãç´ããããã«ãªã£ã ã¢ã©ã¼ãéä¿¡å ãã Hip
redash ã®ãã¼ã¿ãã¼ã¹ã«æ¥ç¶ãã次ã®ã³ãã³ãã§æ¥ç¶ãã¾ãã sudo -u redash psql -d redash æ¥ç¶ãåãã¨ãã«ã¯æ¬¡ã®ã³ãã³ãã \q redash ã®ãã¼ã¿ãã¼ã¹å®¹éã確èªããselect t1.datname AS db_name, pg_size_pretty(pg_database_size(t1.datname)) as db_size from pg_database t1 where t1.datname = 'redash' ãµã¼ãã¼ã®ãã£ã¹ã¯ç©ºã容éã確èªããããã¯ã¢ãããããåã«ãµã¼ãã¼ã®ãã£ã¹ã¯ã®ç©ºã容éã確èªãã¾ãã df -hT ãã¼ã¿ãã¼ã¹ã®ããã¯ã¢ããã³ãã³ãããã¯ã¢ããããã¾ãã sudo -u redash pg_dump redash | gzip > redash_backup.gz ããã¯ã¢ããã³ãã³ã
Salesforce.comãBIãã¼ã«ãã³ãTableauãè²·åããããã¾ã§ã«ãªãã»ã©Salesforceã®åææ©è½ã¯å¼·åãããã Salesforce.comã¯Tableauï¼ã¿ããã¼ï¼ãè²·åãããã¨ã§ä¸¡ç¤¾ãåæãããã¨ãçºè¡¨ãã¾ããã Salesforce signs definitive agreement to acquire @Tableau! https://t.co/uHB021s35e Important: https://t.co/HMTWhHPxQa pic.twitter.com/0aA7L0myVt â Salesforce (@salesforce) 2019å¹´6æ10æ¥ Salesforce.comã¯é¡§å®¢ç®¡çãå¶æ¥æ¯æ´ããã¼ã±ãã£ã³ã°æ¯æ´ããã«ããã¹ã¯ãªã©ãã¾ãã¾ãªãµã¼ãã¹ãæä¾ããã¯ã©ã¦ãä¼æ¥ãè²·åãããTableauã¯æåãªBIãã¼ã«ãã³ãã¨ãã¦ç¥ããã¦ã
2019å¹´3ææ«ã« Redash ã®ææ°ãã¼ã¸ã§ã³ãRedash v7.0.0ãããªãªã¼ã¹ãããï¼Change Log ãèªãã¨æ©è½è¿½å ãå¤ãããï¼ä»åã¯ãå人çã«æ°ã«ãªã£ã Redash v7 æ°æ©è½ï¼ããã㯠UI å¤æ´ï¼ããã9ç¹ãç´¹ä»ãããã¨æãï¼ redash/CHANGELOG.md at master · getredash/redash · GitHub ããæ¢åç°å¢ã Redash v7 ã«ã¢ãããã¼ãããã®ã§ããã°ï¼GitHub ã«å ¬éããã¦ãã docker-compose.yml ã¨ä»¥ä¸ã®ããã¥ã¡ã³ãã確èªãã¦ãããã¨ï¼ããã¯ã¢ãããå¿ããã«ï¼ redash.io 1. Version è¡¨è¨ ç´°ã㪠UI å¤æ´ã§ã¯ãããã©ï¼Redash v6 ã¾ã§ããã¿ã¼ã«ãã£ã Version 表è¨ã Redash v7 ã§ã¯ã¡ãã¥ã¼ãã¼ã«ç§»åãã¦ããï¼å人çã«ã¯ããã¿ã¼ãã¹ãã
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}