Slide 1

Slide 1 text

(PͰ#JH2VFSZΛૢ࡞͢Δ࣌ʹ 4USVDUΛ࢖͏͔೰ΜͰΔ࿩ ʲ)3#SBJOYίωώτ߹ಉ։࠵ʳ-FUT(P5BML ӬҪউҰ࿠

Slide 2

Slide 2 text

ࣗݾ঺հ ओͳ׆ಈ 
 ίωώτΤϯδχΞϒϩάIUUQTUFDIDPOOFIJUPDPNBSDIJWFBVUIPSOBHBJT աڈͷొஃࢿྉɹɹɹɹɹIUUQTTQFBLFSEFDLDPNTIPJDIJSPO ίωώτגࣜձࣾ ։ൃ෦௕/EM @shnagai ӬҪউҰ࿠

Slide 3

Slide 3 text

(PͰ$-*πʔϧΛ࡞Δͱ͖ʹ 4USVDUΛ࢖͏΂͖͔೰ΜͩͷͰ ࠓճ͸ΧδϡΞϧʹޠΓ·͢

Slide 4

Slide 4 text

࡞ͬͨ$-*πʔϧͷཁ݅ w #JH2VFSZʹ͋ΔσʔλΛ4ʹΞοϓϩʔυ͢Δ w #JH2VFSZʹ42-ൃߦͯ݁͠Ռऔಘ w ݁ՌΛϑΝΠϧʹग़ྗ w ϑΝΠϧΛ4ͷಛఆόέοτʹΞοϓϩʔυ

Slide 5

Slide 5 text

1ZUIPOͰQBOEBT࢖͏ͱ͜Μͳ؆୯ʹ

Slide 6

Slide 6 text

8IZ(P w -FU`T(Pͱ͍͏ઓུΛςοΫϏδϣϯͰܝ͓͛ͯΓɺ 
 ձࣾͱͯ͠(Pͷར༻Λਪਐ͍ͯ͠Δ w Ұൠతͳ(Pͷར఺ w ϫϯόΠφϦϙϯͷັྗ w Ұൠతʹ͸ΫϩεϓϥοτϑΥʔϜରԠ

Slide 7

Slide 7 text

࢖͏ύοέʔδ w DMPVEHPPHMFDPNHPCJHRVFSZΛ࢖͑͹#2ૢ࡞͸༰қ w ϑΝΠϧૢ࡞΍$47ॻ͖ࠐΈ͸ඪ४ύοέʔδͰ

Slide 8

Slide 8 text

ࠓճͷςʔϚͱͳΔ΋͏Ұͭͷ৚݅ w ύλʔϯͷҟͳΔσʔλΛѻ͏ඞཁ͕͋Δ w ΧϥϜ͕ͦΕͧΕҟͳΔ ઃܭʜ w σʔλϚʔτͱͯ͠#JH2VFSZͷϏϡʔʹϩδοΫ͸࣮૷ w ݩʑखಈͰσʔλऔಘ͍ͯͨ͠ͷͰϏϡʔʹϩδοΫΛ͍࣋ͨͤͯͨ w ෳࡶͳ42-͸ෆཁͰɺϏϡʔͷσʔλΛ͢΂ͯ࣋ͬͯ͘Ε͹0, 
 TFMFDUͰ0, w 42-ͷ݁ՌΛ4USVDUʹ٧ΊࠐΉ͔೰Μͩ

Slide 9

Slide 9 text

࣮૷ύλʔϯ

Slide 10

Slide 10 text

<>CJHRVFSZ7BMVFΛ࢖͏ w ͭͷߦͷ֤ྻͷ஋Λॱ൪ʹ֨ೲ͢ΔͨΊͷεϥΠε w ֤஋͸ɺ#JH2VFSZͷσʔλܕʹԠͯ͡ద੾ͳ(PͷجຊܕʢJOUɺGMPBUɺTUSJOHͳ Ͳʣʹม׵͞ΕΔɻ εϥΠεͷi൪໨ͷཁૉʹ ߦͷi൪໨ͷྻΛૠೖ ΫΤϦ݁ՌΛߦ୯ҐͰऔಘ͢Δ ϙΠϯλܕ https://pkg.go.dev/cloud.google.com/go/bigquery#Value https://pkg.go.dev/cloud.google.com/go/bigquery#RowIterator

Slide 11

Slide 11 text

4USVDUͰಠࣗσʔλܕΛఆٛ BigQueryͷΧϥϜ໊ʹ ରԠ͢ΔܗͰϑΟʔϧυ໊Λఆٛ εΩʔϚͷ֤ྻ͸ɺେจࣈখจࣈΛແࢹ͠ ͯɺಉ໊͡લΛ࣋ͭߏ଄ମͷΤΫεϙʔτ ͞ΕͨϑΟʔϧυͱর߹͞ΕΔ

Slide 12

Slide 12 text

ͲͪΒ͕͍͍ͷ͔ॻ͖ͳ͕Β໎ͬͨ w ίʔυͷՄಡੑ͸4USVDU࢖͏ύλʔϯ͕ѹ౗తʹߴ͍ w ͨͩ͠ύλʔϯఆٛͯ͠ࠓޙ૿͍͑ͯ͘͜ͱߟ͑ΔͱͦΕͰ͍͍ͷ͔ w ൚༻తͳπʔϧͱͯ͠࡞ΔͳΒ<>CJHRVFSZ7BMVFͰܕม׵͢Δܗ͕ ศརͦ͏ w 42-ΛҾ਺Ͱ౉͢ͱTʹΞοϓϩʔυͯ͘͠ΕΔπʔϧతͳΠϝʔδ w ѻͬͯΔσʔλͷਖ਼͠͞͸ίʔυ্͔Β͸Θ͔Βͳ͍͕ɺͦͷ੹຿͸#JH2VFSZͷ Ϗϡʔʹ͋Δ͔Β໰୊ͳ͍ͷͰ͸ w $-*πʔϧͱͯ͠͸ͬͪ͜ͷ࡞Γͷ΄͏͕͍͚ͯΔΑͶ

Slide 13

Slide 13 text

ͲͪΒ͕͍͍ͷ͔ॻ͖ͳ͕Β໎ͬͨ w ੩తܕ෇͚ݴޠͷಛੑ׆͔͢ͳΒ4USVDU࢖͏ͷ͕CFUUFS ͔ w 4USVDUΛ࢖͍ෳ਺ͷϝιουΛ࡞Δͱ͔Ͱ͋Ε͹Ըܙ͋ Δ͕ɺࠓճ͸DTWग़ྗͷΈ͕ٻΊΒΕΔ͔ΒΦʔόʔ͔΋

Slide 14

Slide 14 text

ࠓͷͱ͜Ζͷࣗ෼ͷ݁࿦ w ࠓճͷέʔεͰ͸4USVDU͸࢖Θͳ͍൑அΛͨ͠ w σʔλૢ࡞͕ܾ·͍ͬͯΔɺ͔ͭ$-*πʔϧͱͯ͠ͷ֦ு ੑ͕ͳ͘ͳΔ఺͕ܾΊख w อकੑ΍Մಡੑ͸4USVDU࢖͏ύλʔϯͷ΄͏͕ߴ͍ͱײ ͍ͯ͡ΔͷͰຖ౓೰·͞Εͦ͏Ͱ͸͋Δ

Slide 15

Slide 15 text

ͲͪΒ͕ਖ਼ղ͔ ΋ͬͱ͍͍ํ๏͋Δͷ͔͸ ·ͩ౴͕͑ग़ͣͳͷͰ ͥͻ࠙਌ձͰ͓࿩͠·͠ΐ͏