Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Why Cookpad Is Choosing Redshift as Our Data Pl...

Why Cookpad Is Choosing Redshift as Our Data Platform

Data Engineering Study #7「Redshift最新アップデートと活用事例」での発表資料です。
https://forkwell.connpass.com/event/203403/

Minero Aoki

April 06, 2021
Tweet

More Decks by Minero Aoki

Other Decks in Technology

Transcript

  1. ࣗݾ঺հ ‣ ੨໦ๆ࿠ʢ͓͖͋ΈͶΖ͏ʣ ‣ ݩ3VCZίϛολʔ ‣ લ৬ฒྻ3%#.4ϕϯμʔ ‣ ฒྻσʔλϕʔεͱग़ձ͏ ‣

    ݱ৬ΫοΫύου ‣ ෼ੳαʔϏεʮͨ΂ΈΔʯͷ։ൃ ‣ σʔλ׆༻ج൫ͷߏங ‣ ϨγϐαʔϏεͷϦΞʔΩςΫνϟ
  2. ΫοΫύουͷσʔλج൫ͷ֓ཁ 3FETIJGUSBYMBSHFº 5# OPEFTMJDF όϧΫΤΫεϙʔτ 12 +%#$ .Z42- 1PTUHSF42- %ZOBNP%#

    qVFOUE Ϛελʔ ϩά +40/ 4 ଞγεςϜ 42-DMJFOU CEBTI 5BCMFBV ؅ཧը໘ 8PSLEBZ 4BMFTGPSDF ;FOEFTL τϥϯβ Ϋγϣϯ ςʔϒϧఔ౓ ຊऑ ຊऑ ϩά αϚϦʔ αϚϦʔ 42-όον໿ຊ 12 +%#$ ఆܕΫΤϦʔ 2VFVFSZ ඇఆܕΫΤϦʔ
  3. 3FETIJGU 4 w 1SJTNʢ಺੡ʣʹΑΔϩάͷετϦʔϛϯάϩʔυ w 1BSRVFUͷϚʔδͱɺ೚ҙλΠϜκʔϯͰͷύʔςΟγϣχϯά͕Մೳ w 1SJTNৄࡉIUUQTUFDIMJGFDPPLQBEDPNFOUSZ 1SJTNʹΑΔϩάϩʔυ ֎෦

    ςʔϒϧ +40/ +40/ +40/ 1SJTN4USFBN 1BSRVFU 1BSRVFU MJWFPCKFDUT 1BSRVFU 1SJTN .FSHF 1BSRVFU NFSHFEPCKFDUT ౸ண͍ͩ͠ॲཧ ໿࣌ؒ ͝ͱ (MVFΧλϩά Ͱ੾Γସ͑
  4. ϚελʔςʔϒϧͷऔΓࠐΈ %#λΠϓ ςʔϒϧ਺ γεςϜ ִؒ ํࣜ .Z42-  1JQFMJOFE.JHSBUPSʢ಺੡ʣ ೔࣍

    શߦચ͍ସ͑ 1PTUHSF42-  3FETIJGU'FEFSBUFE2VFSZ "84%BUBCBTF.JHSBUJPO4FSWJDF ೔࣍ શߦચ͍ସ͑ %ZOBNP%#  %ZOBNP%#4USFBNTˠ1SJTN ৗ࣌ ࠩ෼ߋ৽
  5. σʔλج൫͸ΞϓϦέʔγϣϯͷͨΊʹ αʔϏε σʔλج൫ αʔϏε αʔϏε Ϛελʔɺ ϩά վળ ϑΟʔυ όοΫ

    ,1*μογϡϘʔυ΋ΞυϗοΫΫΤϦʔ΋σʔλΤΫεϙʔτ΋ ݁ہͷͱ͜ΖαʔϏεͷύϑΥʔϚϯεΛվળ͢ΔͨΊʹ͋Δɻ લऀͭ͸ਓؒܦ༝ͰϑΟʔυόοΫ͞Εɺޙऀ͸ϓϩάϥϜ͔Β௚઀ϑΟʔυόοΫ͞ΕΔɻ
  6. ਓؾॱݕࡧͷΞʔΩςΫνϟ ‣ γϯϓϧͳ42-όονͰਓؾॱϥϯΫΛܭࢉ͠ɺ"UIFOBͰ࠷ऴυ ΩϡϝϯτΛੜ੒ͯ͠4PMSʹಥͬࠐΉ ‣ ͢΂ͯ3VCZͰॻ͔Ε͍ͯͨόονΛҠ২ͨͨ͠Ί·ͩແବ͕ଟ͍ 3FETIJGU 4 17ϩά Ϛελʔ

    ਓؾॱ ϥϯΫ DPPLQBE ͦͷଞͷ Πϯσο Ϋε ਓؾॱ ϥϯΫ ͦͷଞͷ Πϯσο Ϋε 4PMS υΩϡ ϝϯτ "UIFOBͰ݁߹ 6/-0"% 42- όον 4PMS΁