BigQuery의 모든 것(기획자, 마케터, 신입 데이터 분석가를 위한) 입문편

#JH2VFSZ੄ݽٚѪ ӝദ੗ ݃ாఠ नੑؘ੉ఠ࠙ࢳоܳਤೠ ੑޙಞ <॑஠ؘ੉ఠӒܛ ఋ׮ؘ੉ఠ౱߸ࢿਮ> ੉੗ܐח֙ਘੌীٜ݅঻ਵݴ
दр੉૑աݶղਊ੉׳ۄ૕ࣻ੓णפ׮

ݾର #JH2VFSZ 42-੉೧ೞӝ पण ؘ੉ఠदпച पण
#JH2VFSZबച૑ध पण झாે௪ܻ 5BCMFࢤࢿೞӝ ௪ܻѾҗ׮਍۽٘ೞӝ %.-2VFSZ 'JSFCBTF-PH %BUB1JQFMJOF 1ZUIPOীࢲ#JH2VFSZࢎਊೞӝ ؘ੉ఠࣇҕਬೞӝ ੿ܻ ୨ଃ

ઁрױೠࣗѐ ↟ ੋೞ؀҃৔೟җ ↟ ݃ா౴ҟҊҕӝসହসؘ੉ఠࣽࢲ۽ழܻয੹ജ઺ ↟ അ૒੢॑஠ؘ੉ఠӒܛఋ׮ؘ੉ఠ౱  ఋ׮ҙ۲সޖبೞҊ ࢎղؘ੉ఠޙചઑࢿ ౱ਗࢿ੢١
↟ ੹૒੢ۨ౟ܻ஠ ؘ੉ఠ࠙ࢳо۽ੑࢎ೮חؘؘ੉ఠূ૑פযبदఇ   ֙ࠗఠ#JH2VFSZࢎਊ ↟ ѐߊ࠶۽ӒIUUQT[[T[BHJUIVCJP ↟ ਬౚ࠳%FFQ/PM IUUQTXXXZPVUVCFDPNDIBOOFM6$E-;.T:4INR'H0:$#$X ߸ࢿਮ

#JH2VFSZ

%# 42- .:42- #JH2VFSZ %#ؘ੉ఠܳࠁҙೞח੢ࣗ पࢲ࠺झؘ੉ఠ੷੢ࣗীࢲޖ঱о݆ܳ੉ೡ҃਋ पࢲ࠺झীޙઁотࣻ੓ӝٸޙী׮নೠ੹ۚਸࢎਊ ࠂઁࠄਸٜ݅যࢲѢӝࢲ௪ܻܳզܽ׮Ѣա
ೲաࢎۈ੉݆ই૕ࣻ۾ҙܻ೧ঠغחࠗ࠙੉݆ই૑ӝٸޙী ই৘t࠙ࢳਊؘ੉ఠ੷੢ࣗuٜܳ݅ҊѢӝীؘ੉ఠܳ੷੢ೞח҃਋بઓ੤

%# 42- .:42- #JH2VFSZ ؘ੉ఠ੷੢ࣗ%BUBCBTFۄҊࠗܰҊ  .:42- .442- #JH2VFSZ١׮নೠઙܨо੓਺ ӒܻҊ#JH2VFSZחؘ੉ఠ࠙ࢳೡٸ݆਷੢੼੉੓חؘ੉ఠ੷੢ࣗ 42-਷3%#.4ীࢲؘ੉ఠܳ୶୹ೡٸࢎਊೞחޙߨ
5.*/P42-ب੓חؘੌױ੉೧ܳਤ೧ֈযхפ׮

#JH2VFSZۆ (PPHMF$MPVE1MBUGPSN੄%BUB8BSFIPVTF ؘ੉ఠହҊ 42-ਸా೧ؘ੉ఠܳ୶୹ೡࣻ੓חҕр

#JH2VFSZ੄੢੼ դ੉ب 42-ӝ߈ਵ۽ؘ੉ఠܳ୶୹оמ ௏٬੉ইצӒա݃рױೠ42-۽ؘ੉ఠ୶୹оמ ࣘب ׮ؘܲ੉ఠ߬੉झח*OEFYژחࢲߡ੄ࢿמীٮۄࣘبоוܻ૑݅ #JH2VFSZח*OEFYѐ֛੉হਵ޲۽न҃ॳ૑ঋইبؽ 'JSFCBTFܳࢎਊೡ҃਋জؘ੉ఠܳऔѱദٙоמ ࢎਊӝӝ
ਤ஖ दױਤө૑಴അ 04ߡ੹ ੉߮౟೯زദٙоמ উ٘۽੉٘੄҃਋BQQ@SFNPWFө૑ഛੋоמ ࢲߡܳٮ۽ҳ୷ೡ೙ਃহ਺ҙܻо೙ਃহ਺  "843FETIJGUחੋझఢझܳڸ਋Ҋҙܻ೧ঠ

#JH2VFSZۆ #JH2VFSZ੄о૑ޙߨ୓҅ -FHBDZ42- җѢী઱۽ࢎਊೞ؍ޙߨ 4UBOEBSE42- ୭Ӕী઱۽ࢎਊೞחޙߨ ੿ܻ4UBOEBSE42-ਸࢎਊ೧઱ࣁਃ 5JQ #JH2VFSZѨ࢝द#JH2VFSZ4UBOEBSE42- Ѩ࢝য੉۠धਵ۽

#JH2VFSZ#FUB #JH2VFSZী#FUBӝמ੉ݒ਋݆਺ #FUBח߄Չоמࢿب੓Ҋޙࢲо੉࢚ೞѱ੘ࢿغয੓ח҃਋ب੓਺ ೦࢚न҃ਸ

#JH2VFSZ੄࠺ਊ 3FHJPO݃׮Әঘ੉׮ܴ ৘੹ূউӒۗחؘ IUUQTDMPVEHPPHMFDPNCJHRVFSZQSJDJOH

#JH2VFSZܳযڌѱࢎਊೡө ӝദ݃ா౴नࢎস١׮নೠ౱ীࢲݽف ؘ੉ఠীӝ߈ೠ੄ࢎѾ੿ਸ૓೯ п੗౱ীࢲझझ۽௪ܻܳզ۰ؘ੉ఠܳ୶୹ оࢸਸࢸ੿ೠറ ؘ੉ఠܳా೧оࢸ੉૓૞ݏח૑ഛੋ ݠन۞׬ਊ'FBUVSFࢤࢿ

ؘ੉ఠ੉೧ೞӝ അ੤#JH2VFSZীযڃؘ੉ఠоऺ੉Ҋ੓ח૑੼Ѩ জ۽Ӓؘ੉ఠ ਬ੷оজীٜয৬ࢲഥਗоੑಕ੉૑ഛੋ ஶబஎഛੋ١١੄ؘ੉ఠ җ੿ਸঌࣻ੓חؘ੉ఠ 'JSFCBTFীࢲ#JH2VFSZ۽ؘ੉ఠ੸੤ Ѿઁؘ੉ఠ Ѿઁо੓חࢲ࠺झۄݶ୭ઙѾઁӘঘؘ੉ఠ ਬ੷ؘ੉ఠ
ਬ੷੄੿ࠁ ࢿ߹ ো۸؀١ ҕҕؘ੉ఠ զॿ ઝ಴١

#JH2VFSZ 42- ੉೧ೞӝ 42-4USVDUVSFE2VFSZ-BOHBVHF 3%#.4੄ؘ੉ఠܳҙܻೞӝਤ೧ࢸ҅ػౠࣻݾ੸੄೐۽Ӓې߁঱য

#JH2VFSZ 42- ੉೧ೞӝ 42-4USVDUVSFE2VFSZ-BOHBVHF 3%#.4੄ؘ੉ఠܳҙܻೞӝਤ೧ࢸ҅ػౠࣻݾ੸੄೐۽Ӓې߁঱য 3%#.4 ؘ੉ఠܳҙ҅۽಴അ ݽؘٚ੉ఠܳରਗ੄಴അ ݃஖ুࣄҗਬࢎ

#JH2VFSZ$POTPMF /FX6* IUUQTDPOTPMFDMPVEHPPHMFDPNCJHRVFSZ

#JH2VFSZ$POTPMF TUBOEBSE42- 4&-&$5 '30.AUBCMFA -*.*5 -FHBDZ6* IUUQTCJHRVFSZDMPVEHPPHMFDPN ৈӟ%FGBVMUоMFHBDZ42- TUBOEBSEࢎਊೞҊरਵݶইې୊ۢ

#JH2VFSZ$POTPMF ௪ܻӝ۾ 2VFSZIJTUPSZ ௪ܻӝ۾ ѐੋӝ۾೐۽ં౟ӝ۾

#JH2VFSZ$POTPMF ௪ܻ௿ܼೞݶ௪ܻӝ۾੉աఋթ

#JH2VFSZ$POTPMF ੷੢ػ௪ܻ 4BWFERVFSJFT ѐੋ௪ܻ೐۽ં౟௪ܻ ౱ՙܻ௪ܻҕਬ

#JH2VFSZ$POTPMF ੷੢ػ௪ܻ 4BWFERVFSJFT ௪ܻ௿ܼद௪ܻ࢚ࣁ੿ࠁܳࠅࣻ੓਺

#JH2VFSZ$POTPMF ੘সӝ۾ +PCIJTUPSZ ؘ੉ఠ۽٘ ؘ੉ఠ୶୹ IUUQTDMPVEHPPHMFDPNCJHRVFSZEPDTKPCTPWFSWJFX

#JH2VFSZ$POTPMF ௿ܼೞݶ࢚ࣁ੿ࠁࠁ੐

#JH2VFSZ$POTPMF җѢ੘সਸ߈ࠂೡࣻ੓਺ప੉࠶ٜ݅ӝח਋ࢶ1BTT

#JH2VFSZ$POTPMF ੹࣠ 5SBOTGFS ؘ੉ఠܳ׮ܲҔীࢲ#JH2VFSZ۽৤ӣ ৘ডػ௪ܻ 4DIFEVMFERVFSJFT ౠ੿दр؀ী߈ࠂ੸ਵ۽௪ܻप೯ #*&OHJOFؘ੉ఠदпച೧઱חبҳ ৈӝࢶੌױ੉ѱޥ૑੿ب݅ঌҊֈযцद׮

#JH2VFSZ$POTPMF ؘ੉ఠࣇҗప੉࠶ <ؘ੉ఠࣇ> <ప੉࠶> <ؘ੉ఠࣇ௿ܼदաয়חࠗ࠙ ؘ੉ఠࣇ੿ࠁ >

#JH2VFSZ$POTPMF ప੉࠶ҙ۲੿ࠁ <ప੉࠶झః݃>

#JH2VFSZ$POTPMF <ప੉࠶ࣁࠗ੿ࠁ> ప੉࠶ҙ۲੿ࠁ

#JH2VFSZ$POTPMF ప੉࠶ҙ۲੿ࠁ4&-&$5 ೞ૑݈Ҋ޷ܻࠁӝഝਊ <ప੉࠶ؘ੉ఠ޷ܻࠁӝ>

#JH2VFSZ$POTPMF ప੉࠶௪ܻ௿ܼद௪ܻನݘࢤࢿ

42-੉೧ೞӝ

#JH2VFSZ 42- ੉೧ೞӝ 42-4USVDUVSFE2VFSZ-BOHBVHF 3%#.4੄ؘ੉ఠܳҙܻೞӝਤ೧ࢸ҅ػౠࣻݾ੸੄೐۽Ӓې߁঱য ؘ੉ఠࢶఖ4&-&$5 ؘ੉ఠઑ੘ %.-%BUB.BOJQVMBUJPO-BOHVBHF */4&35
61%"5& %&-&5& ؘ੉ఠ੿੄ %%-%BUB%FGJOJUJPO-BOHVBHF $3&"5& "-5&3 %301 ؘ੉ఠઁয %$-%BUB$POUSPM-BOHVBHF ੉Ѧࠁदח࠙਷؀ࠗ࠙4&-&$5݅ೞपѢীਃ #JH2VFSZূহ਺ 5.*ࠁా%.-ী4&-&$5оࣘೞחؘ   #JH2VFSZীࢶ%.-ী*/4&35 61%"5& %&-&5&݅ನೣ೤פ׮

4&-&$5੄௾ҳઑ Column 1 Column 2 Column 3 Row 1 Row
2 Row 3 Row 4 ೯۳ 3PX $PMVNO

4&-&$5੄௾ҳઑ 4&-&$5<ஸۢ੉ܴ> '30.<ప੉࠶੉ܴ> աח<ప੉࠶੉ܴ>ীࢲ <ஸۢ੉ܴ>ਸࢶఖೠ׮

4&-&$5੄௾ҳઑ 4&-&$5<ஸۢ੉ܴ> '30.<ప੉࠶੉ܴ> 8)&3&<ઑѤ> աח<ప੉࠶੉ܴ>ীࢲ <ઑѤ>ਸо૑ח <ஸۢ੉ܴ>ਸࢶఖೠ׮

4&-&$5੄௾ҳઑ 4&-&$5<ஸۢ੉ܴ> '30.<ప੉࠶੉ܴ> 8)&3&<ઑѤ> (3061#:<Ӓܛചೡஸۢ> աח<ప੉࠶੉ܴ>ীࢲ <ઑѤ>ਸо૑חѪٜ઺ <Ӓܛചೡஸۢ>ਵ۽ݽইࢲ Ӓܛച೧ࢲ
<ஸۢ੉ܴ>ਸࢶఖೠ׮

4&-&$5੄௾ҳઑ 4&-&$5<ஸۢ੉ܴ> '30.<ప੉࠶੉ܴ> 8)&3&<ઑѤ> (3061#:<Ӓܛചೡஸۢ> )"7*/(<Ӓܛചೠٍஸۢ> -*.*5<ઁೠೡѐࣻ> աח<ప੉࠶੉ܴ>ীࢲ <ઑѤ>ਸо૑חѪٜ઺ <Ӓܛചೡஸۢ>ਵ۽ݽ਷റ
Ӓܛച೧ࢲ <Ӓܛചೠٍஸۢ>ઑѤਸо૑ח <ઁೠೡѐࣻ>݅ࢶఖ <ஸۢ੉ܴ>ਸࢶఖೠ׮

4&-&$5_'30. о੢઺ब੉غחਃࣗ 4&-&$5ٍীח଺Ҋर਷؀࢚ਸ $PMVNO ਸաৌೞҊ '30.ٍীח଺ਸ؀࢚੉੓חҕр 5BCMF ਸ੘ࢿೞݶؾפ׮ ৘दࢲۉী੓חো೙ਸ଺Ҋर਷҃਋
4&-&$5ো೙ '30.ࢲۉ ݽٚஸۢਸࠁҊर׮ݶ ࢎਊ

8)&3& ઑѤਸ઱Ҋर਷҃਋8)&3&ٍী੘ࢿ ৘दࢲۉী੓חো೙઺ӡ੉оDN੉࢚ੋো೙ਸ଺Ҋर਷҃਋ 4&-&$5ো೙ '30.ࢲۉ 8)&3&ӡ੉DN

8)&3& ઑѤਸೞա؊઱Ҋर਷҃਋"/%ٍী੘ࢿ ৘दࢲۉী੓חো೙઺ӡ੉оDN੉࢚੉Ҋ࢚࢝੉ࡈр࢝ੋ  ো೙ਸ଺Ҋर਷҃਋ 4&-&$5ো೙ '30.ࢲۉ 8)&3&ӡ੉DN"/%࢚࢝tࡈр࢝u

8)&3& ౠ੿ஸۢীৈ۞ઑѤਸ૑੿ೞҊर਷҃਋03ࢎਊ ৘दࢲۉী੓חো೙઺ӡ੉оDN੉࢚੉Ҋ࢚࢝੉ࡈр࢝੉Ѣա౵ۆ࢝ੋ  ো೙ਸ଺Ҋर਷҃਋ 4&-&$5ো೙ '30.ࢲۉ 8)&3&ӡ੉DN"/% ࢚࢝tࡈр࢝u03࢚࢝t౵ۆ࢝u

8)&3& ౠ੿ஸۢীৈ۞ઑѤਸ૑੿ೞҊर਷҃਋*/ࢎਊ ৘दࢲۉী੓חো೙઺ӡ੉оDN੉࢚੉Ҋ࢚࢝੉ࡈр࢝੉Ѣա౵ۆ࢝ੋ  ো೙ਸ଺Ҋर਷҃਋ 4&-&$5ো೙ '30.ࢲۉ 8)&3&ӡ੉DN"/% ࢚࢝tࡈр࢝u03࢚࢝t౵ۆ࢝u ࢚࢝*/
tࡈр࢝u t౵ۆ࢝u

.JOJ2VJ[ user_id(int) event(string) event_date(string) 1 login_facebook 2019-05-14 1 write_posting 2019-05-14
1 write_comment 2019-05-14 1 view_posting 2019-05-14 1 view_posintg 2019-05-14 2 login_facebook 2019-05-14 2 view_posting 2019-05-14 2 view_posting 2019-05-14 2 write_comment 2019-05-14 2 logout 2019-05-14 2 login_facebook 2019-05-15 3 login_google 2019-05-15 3 write_posting 2019-05-15 3 view_posting 2019-05-15 3 purchase_item 2019-05-18 3 write_comment 2019-05-17 1 view_posting 2019-05-17 4 view_posintg 2019-05-17 5 purchase_item 2019-05-16 VTFS@MPH5BCMF

.JOJ2VJ[ ߣਬ੷੄ݽٚ੉߮౟۽Ӓܳഛੋೞח௪ܻ $PMVNO਷ޖ঺ੋоਃ 5BCMF਷ޖ঺ੋоਃ 8)&3&ઑѤ਷ޖ঺ੋоਃ

.JOJ2VJ[ ߣਬ੷੄ݽٚ੉߮౟۽Ӓܳഛੋೞח௪ܻ $PMVNO਷ޖ঺ੋоਃ 5BCMF਷ޖ঺ੋоਃ 8)&3&ઑѤ਷ޖ঺ੋоਃ 4&-&$5VTFS@JE FWFOU
FWFOU@EBUF '30.VTFS@MPH 8)&3&VTFS@JE user_id event event_date 1 login_facebook 2019-05-14 1 write_posting 2019-05-14 1 write_comment 2019-05-14 1 view_posting 2019-05-14 1 view_posintg 2019-05-14 <Ѿҗ>

.JOJ2VJ[ ߣਬ੷੄ݽٚ੉߮౟۽Ӓܳഛੋೞח௪ܻ $PMVNO਷ޖ঺ੋоਃ 5BCMF਷ޖ঺ੋоਃ 8)&3&ઑѤ਷ޖ঺ੋоਃ 4&-&$5VTFS@JE FWFOU
FWFOU@EBUF '30.VTFS@MPH 8)&3&VTFS@JE user_id event event_date 1 login_facebook 2019-05-14 1 write_posting 2019-05-14 1 write_comment 2019-05-14 1 view_posting 2019-05-14 1 view_posintg 2019-05-14 <Ѿҗ> ߣਬ੷оী ੉߮౟ٜਸݻߣ೮ח૑ҾӘೞ׮ݶ э਷ৌ੉߈ࠂ

৘द ؘ੉ఠ (3061#: (3061#:<ஸۢ੉ܴ>ਵ۽ࢎਊ ઱۽૘҅ೣࣻ ো࢑ 46. $06/5 ৬э੉ॳ੐

(3061#: ߣਬ੷੄ੌ੗߹੉߮౟പࣻܳҳೞח௪ܻ $PMVNO਷ޖ঺ੋоਃ 5BCMF਷ޖ঺ੋоਃ 8)&3&ઑѤ਷ޖ঺ੋоਃ

(3061#: ߣਬ੷੄ੌ੗߹੉߮౟പࣻܳҳೞח௪ܻ $PMVNO਷ޖ঺ੋоਃ 5BCMF਷ޖ঺ੋоਃ 8)&3&ઑѤ਷ޖ঺ੋоਃ 4&-&$5VTFS@JE FWFOU
FWFOU@EBUF $06/5 %*45*/$5VTFS@JE "4VOJRVF $06/5 VTFS@JE "4UPUBM '30.VTFS@MPH 8)&3&VTFS@JE (3061#:VTFS@JE FWFOU FWFOU@EBUF

(3061#: ߣਬ੷੄ੌ੗߹੉߮౟പࣻܳҳೞח௪ܻ $PMVNO਷ޖ঺ੋоਃ 5BCMF਷ޖ঺ੋоਃ 8)&3&ઑѤ਷ޖ঺ੋоਃ 4&-&$5VTFS@JE FWFOU
FWFOU@EBUF $06/5 %*45*/$5VTFS@JE "4VOJRVF $06/5 VTFS@JE "4UPUBM '30.VTFS@MPH 8)&3&VTFS@JE (3061#:VTFS@JE FWFOU FWFOU@EBUF ૘҅ೣࣻ $06/5 46. ੹੄ஸۢ਷ (3061#:ٍীԙ੓যঠೣ ӒېঠӒখ੄чਵ۽$06/5

$06/5 %*45*/$5_ 4&-&$5VTFS@JE FWFOU FWFOU@EBUF $06/5 %*45*/$5VTFS@JE "4VOJRVF
$06/5 VTFS@JE "4UPUBM '30.VTFS@MPH 8)&3&VTFS@JE (3061#:VTFS@JE FWFOU FWFOU@EBUF $06/5ѐࣻܳ஠਍౟ೞחೣࣻ $06/5 ѐࣻܳࣄஸۢ %*45*/$5Ҋਬೠч $06/5 %*45*/$5VTFS@JE ҊਬೠVTFS@JEܳࣃ׮ "4VOJRVFࣃറ੉ܴਸVOJRVF۽ೠ׮

03%&3#: 4&-&$5VTFS@JE FWFOU FWFOU@EBUF $06/5 %*45*/$5VTFS@JE "4VOJRVF $06/5
VTFS@JE "4UPUBM '30.VTFS@MPH 8)&3&VTFS@JE (3061#:VTFS@JE FWFOU FWFOU@EBUF 03%&3#:FWFOU@EBUF 03%&3#:<ஸۢ>ஸۢӝળਵ۽য়ܴରࣽ ੘਷ч௾ч ݅ডղܿରࣽਸೞ۰ݶ03%&3#:<ஸۢ>%&4$

)"7*/( ݅ড੉࢚కীࢲߣ੉࢚ೠ೯زਸঌҊर׮ݶ IJOUUPUBM user_id event event_date unique total 1
login_facebook 2019-05-14 1 1 1 write_posting 2019-05-14 1 1 1 write_comment 2019-05-14 1 1 1 view_posting 2019-05-14 1 2 <Ѿҗ>

)"7*/( user_id event event_date unique total 1 login_facebook 2019-05-14 1
1 1 write_posting 2019-05-14 1 1 1 write_comment 2019-05-14 1 1 1 view_posting 2019-05-14 1 2 <Ѿҗ> 4&-&$5VTFS@JE FWFOU FWFOU@EBUF $06/5 %*45*/$5VTFS@JE "4VOJRVF $06/5 VTFS@JE "4UPUBM '30.VTFS@MPH 8)&3&VTFS@JE (3061#:VTFS@JE FWFOU FWFOU@EBUF )"7*/(UPUBM 03%&3#:FWFOU@EBUF ݅ড੉࢚కীࢲߣ੉࢚ೠ೯زਸঌҊर׮ݶ IJOUUPUBM )"7*/(<Ӓܛചೠ੉റஸۢ੄ઑѤ>

ૣ਷੿ܻ׮दࠁӝ 4&-&$5<ஸۢ੉ܴ> '30.<ప੉࠶੉ܴ> 8)&3&<ઑѤ> (3061#:<Ӓܛചೡஸۢ> )"7*/(<Ӓܛചೠٍஸۢ> -*.*5<ઁೠೡѐࣻ> աח<ప੉࠶੉ܴ>ীࢲ <ઑѤ>ਸо૑חѪٜ઺ <Ӓܛചೡஸۢ>ਵ۽ݽ਷റ
Ӓܛച೧ࢲ <Ӓܛചೠٍஸۢ>ઑѤਸо૑ח <ઁೠೡѐࣻ>݅ࢶఖ <ஸۢ੉ܴ>ਸࢶఖೠ׮

૘೤୊ۢࢤп೧ࠁӝ 4&-&$5FWFOU FWFOU@EBUF '30." 8)&3&FWFOU@EBUFrs

௪ܻܳযڌѱ૞ঠೡөਃ ࠁҊर਷૑಴оޖ঺ੋ૑Ҋ޹ೠ׮ ࠁҊर਷૑಴ܳҳ୓ചೠ׮ FYਬ੷о঴݃ա"ઁಿਸҳੑೞחо ࢎղী੉޷೧׼૑಴ܳҳೞח௪ܻо੓ח૑଺ইࠄ׮੓ਵݶ߄۽௪ܻݍࠁӝ ࠁҊर਷૑಴о੓חؘ੉ఠо੓ח5BCMF଺ӝ ৈ۞5BCMFੌࣻ੓਺ ೞա੄5BCMFীࢲݽؘٚ੉ఠоաৢѪэ਷҃਋߄۽௪ܻܳૠ׮
ৈ۞5BCMFীࢲؘ੉ఠܳোѾ೧ঠೡѪэ਷҃਋যڌѱোѾೡ૑Ҋ޹ೠ׮ ҳೠѾҗч੉੿݈ݏח૑ഛੋೠ׮ ؘ੉ఠ੿೤ࢿ୓௼   ਗࠄؘ੉ఠܳೞաঀ࠺Ү೧ࠁחߑߨب੓Ҋ׮নೠߑߨ੉ઓ੤ ௪ܻܳ؊જѱٜ݅ߑߨਸҊ޹ೠ׮ ௪ܻࣘب оةࢿ١

ࠁҊर਷૑಴оޖ঺ੋ૑Ҋ޹ೠ׮ ࠁҊर਷૑಴ܳҳ୓ചೠ׮ FYਬ੷о঴݃ա"ઁಿਸҳੑೞחо ࢎղী੉޷೧׼૑಴ܳҳೞח௪ܻо੓ח૑଺ইࠄ׮੓ਵݶ߄۽௪ܻݍࠁӝ ࠁҊर਷૑಴о੓חؘ੉ఠо੓ח5BCMF଺ӝ ৈ۞5BCMFੌࣻ੓਺ ೞա੄5BCMFীࢲݽؘٚ੉ఠоաৢѪэ਷҃਋߄۽௪ܻܳૠ׮ ৈ۞5BCMFীࢲؘ੉ఠܳোѾ೧ঠೡѪэ਷҃਋যڌѱোѾೡ૑Ҋ޹ೠ׮
ҳೠѾҗч੉੿݈ݏח૑ഛੋೠ׮ ؘ੉ఠ੿೤ࢿ୓௼   ਗࠄؘ੉ఠܳೞաঀ࠺Ү೧ࠁחߑߨب੓Ҋ׮নೠߑߨ੉ઓ੤ ௪ܻܳ؊જѱٜ݅ߑߨਸҊ޹ೠ׮ ௪ܻࣘب оةࢿ١ ௪ܻܳযڌѱ૞ঠೡөਃ +0*/

पण

+0*/ೞӝ੹ীपण <ҕѐؘ੉ఠࣇ>

+0*/ೞӝ੹ীपण <׮নೠҕѐؘ੉ఠо੓਺>

+0*/ೞӝ੹ীपण <CJLFѨ࢝റইޖѢա௿ܼ>

+0*/ೞӝ੹ীपण <7*&8%"5"4&5௿ܼ>

+0*/ೞӝ੹ীपण <CJHRVFSZQVCMJDEBUBоࢤӣ>

+0*/ೞӝ੹ীपण ؘ੉ఠࢸݺCJLFTIBSFUSJQEBUB CJLFTIBSF@TUBUJPOT5BCMF

+0*/ೞӝ੹ীपण ؘ੉ఠࢸݺCJLFTIBSFUSJQEBUB CJLFTIBSF@USJQT5BCMF ૑Ә਷੉Ѣ݅ࢎਊ೧ਃ

+0*/ೞӝ੹ীपण ୨USJQ੄ѐࣻܳҳ೧઱ࣁਃ ੌ੗߹USJQ੄ѐࣻܳҳ೧઱ࣁਃ IJOU%"5& ೣࣻ TVCTDSJCFS@UZQF߹USJQѐࣻܳҳ೧઱ࣁਃ द੘TUBUJPOҗب଱TUBUJPO߹ѐࣻܳҳ೧઱ࣁਃ ઁੌ݆਷ҳр਷

+0*/ೞӝ੹ীपण ୨USJQ੄ѐࣻܳҳ೧઱ࣁਃ 4&-&$5DPVOU USJQ@JE '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA ޙઁ୹ઁ੄ب$06/5 DPMVNO੉ܴ ਵ۽ѐࣻܳ$06/5ೡࣻ੓਺

+0*/ೞӝ੹ীपण ੌ੗߹USJQ੄ѐࣻܳҳ೧઱ࣁਃ IJOU%"5& ೣࣻ 4&-&$5%"5& TUBSU@UJNF BTEBUF
DPVOU USJQ@JE BTDPVOU '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA (3061#:EBUF PSEFSCZEBUF ޙઁ୹ઁ੄ب%"5& 5*.&45".1ੋTUBSU@EBUF ܳೞݶEBUFܳࡳਸࣻ੓਺

+0*/ೞӝ੹ীपण TVCTDSJCFS@UZQF߹USJQѐࣻܳҳ೧઱ࣁਃ 4&-&$5TVCTDSJCFS@UZQF DPVOU USJQ@JE BTDPVOU '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA (3061#:TVCTDSJCFS@UZQF
PSEFSCZDPVOUEFTD

+0*/ೞӝ੹ীपण द੘TUBUJPOҗب଱TUBUJPO߹ѐࣻܳҳ೧઱ࣁਃ ઁੌ݆਷ҳр਷ 4&-&$5TUBSU@TUBUJPO@JE FOE@TUBUJPO@JE DPVOU USJQ@JE BTUSJQ@DOU
'30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA (3061#:TUBSU@TUBUJPO@JE FOE@TUBUJPO@JE PSEFSCZUSJQ@DOUEFTD ޙઁ୹ઁ੄بо૑੉࢚(3061#:

+0*/ +0*/ؘ੉ఠՙܻtোѾu ѐ੉࢚੄5BCMFਸઑ೤೧࢜۽਍5BCMFਸ݅ٞ ুࣄ੄WMPPLVQҗਬࢎ ઙܨ ੉޷૑ ࢸݺ *//&3+0*/ ف૘೤੄Ү૘೤ $3044+0*/
ف૘೤੄ғ૘೤ ਃࣗՙܻғೣ '6--<065&3>+0*/ নଃݽفؘ੉ఠܳࠢ੐ -&'5<065&3>+0*/ ৽ଃӝળਵ۽ࠢ੐ 3*()5<065&3>+0*/ য়ܲଃӝળਵ۽ࠢ੐

+0*/ ݅ড42-੉୊਺੉दݶ *//&3+0*/ -&'5+0*/݅ࢎਊೞद׮о ੼੼ഛ੢୶ୌ ઙܨ ੉޷૑ ࢸݺ *//&3+0*/ ف૘೤੄Ү૘೤
$3044+0*/ ف૘೤੄ғ૘೤ ਃࣗՙܻғೣ '6--<065&3>+0*/ নଃݽفؘ੉ఠܳࠢ੐ -&'5<065&3>+0*/ ৽ଃӝળਵ۽ࠢ੐ 3*()5<065&3>+0*/ য়ܲଃӝળਵ۽ࠢ੐

+0*/৘द BVTUJO@CJLFTIBSFؘ੉ఠࣇীࢲ ୹ߊ૑ TUBSU@TUBUJPO@JE ৬ب଱૑ FOE@TUBUJPO@JE ੄ ઝ಴ܳࠢ੉Ҋर਷҃਋

+0*/৘द 4&-&$5 MFGU@TJEF NJEEMF@TJEFMBUJUVEFBTTUBSU@MBU NJEEMF@TJEFMPOHJUVEFBTTUBSU@MOH '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA"4MFGU@TJEF -&'5+0*/ 4&-&$5
'30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@TUBUJPOTA BT NJEEMF@TJEF 0/MFGU@TJEFTUBSU@TUBUJPO@JENJEEMF@TJEFTUBUJPO@JE BVTUJO@CJLFTIBSFؘ੉ఠࣇীࢲ ୹ߊ૑ TUBSU@TUBUJPO@JE ৬ب଱૑ FOE@TUBUJPO@JE ੄ ઝ಴ܳࠢ੉Ҋर਷҃਋ <୹ߊ૑੿ࠁ୶о>

+0*/৘द 4&-&$5 MFGU@TJEF NJEEMF@TJEFMBUJUVEFBTTUBSU@MBU NJEEMF@TJEFMPOHJUVEFBTTUBSU@MOH SJHIU@TJEFMBUJUVEFBTFOE@MBU SJHIU@TJEFMPOHJUVEFBTFOE@MOH '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA"4MFGU@TJEF
-&'5+0*/ 4&-&$5 '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@TUBUJPOTA BT NJEEMF@TJEF 0/MFGU@TJEFTUBSU@TUBUJPO@JENJEEMF@TJEFTUBUJPO@JE -&'5+0*/ 4&-&$5 '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@TUBUJPOTA BT SJHIU@TJEF 0/MFGU@TJEFFOE@TUBUJPO@JESJHIU@TJEFTUBUJPO@JE BVTUJO@CJLFTIBSFؘ੉ఠࣇীࢲ ୹ߊ૑ TUBSU@TUBUJPO@JE ৬ب଱૑ FOE@TUBUJPO@JE ੄ ઝ಴ܳࠢ੉Ҋर਷҃਋ ୹ߊ૑੿ࠁ୶о <ب଱૑੿ࠁ୶о>

+0*/৘द 4&-&$5 MFGU@TJEF NJEEMF@TJEFMBUJUVEFBTTUBSU@MBU NJEEMF@TJEFMPOHJUVEFBTTUBSU@MOH SJHIU@TJEFMBUJUVEFBTFOE@MBU SJHIU@TJEFMPOHJUVEFBTFOE@MOH '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA"4MFGU@TJEF
-&'5+0*/ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@TUBUJPOTA BT NJEEMF@TJEF 0/MFGU@TJEFTUBSU@TUBUJPO@JENJEEMF@TJEFTUBUJPO@JE -&'5+0*/ ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@TUBUJPOTA BTSJHIU@TJEF 0/MFGU@TJEFFOE@TUBUJPO@JESJHIU@TJEFTUBUJPO@JE <খ௪ܻ৬زੌೣ> খ௪ܻח+0*/ٍী 4&-&$5_'30. ೡࣻ੓חѪਸࠁৈ઱۰Ҋࢎਊ

दрؘ੉ఠ׮ܖӝ %"5&%BUF݅಴दೞחؘ੉ఠ %"5&5*.&%BUF৬5*.&ө૑಴दೞחؘ੉ఠ Ӓ৻ী5*.&45".1 5*.&ب੓਺ ؘ੉ఠ੄UJNF[POFਸԙഛੋೡѪ 65$ੋ૑ ݅ড׮ܲदр؀ۄݶ߸҃ೡٸr"TJB4FPVMsਸࢎਊ೧ঠೣ

दрؘ੉ఠ׮ܖӝ $633&/5@%"5& <UJNF@[POF> അ੤զ૞ &Y $633&/5@%"5& r"TJB4FPVMs &953"$5
QBSU'30.EBUF@FYQSFTTJPO %"5&ীࢲч ੌ੗ ਃੌ ઱ର ਘ ࠙ӝ োب١ ୶୹ &Y &953"$5 :&"3'30.EBUFUZQFDPMVNO tোبu୶୹ SELECT EXTRACT(DAY FROM DATE '2019-12-25') as the_day; +---------+ | the_day | +---------+ | 25 | +---------+ <%"5&> IUUQTDMPVEHPPHMFDPNCJHRVFSZEPDTSFGFSFODFTUBOEBSETRMEBUF@GVODUJPOT

दрؘ੉ఠ׮ܖӝ %"5&@"%% EBUF@FYQSFTTJPO */5&37"-*/5EBUF@QBSU %BUFীࢲ*/5рѺ݅ఀ؊ೣ %": 8&&, .0/5) 26"5&3
:&"3١ &Y %"5&@"%% EBUFUZQFDPMVNO */5&37"-%": ੌٍզ૞ SELECT DATE_ADD(DATE “2019-03-25", INTERVAL 5 DAY) as five_days_later; +--------------------+ | five_days_later | +--------------------+ | 2019-03-30 | +--------------------+ %"5&@%*'' EBUF@FYQSFTTJPO@B EBUF@FYQSFTTJPO@C EBUF@QBSU BCEBUFEJGG SELECT DATE_DIFF(DATE '2010-07-07', DATE '2008-12-25', DAY) as days_diff; +-----------+ | days_diff | +-----------+ | 559 | +-----------+ <%"5&> IUUQTDMPVEHPPHMFDPNCJHRVFSZEPDTSFGFSFODFTUBOEBSETRMEBUF@GVODUJPOT

दрؘ੉ఠ׮ܖӝ %"5&@536/$ EBUF@FYQSFTTJPO EBUF@QBSU զ૞ܳ૑੿ೠױਤ۽੗ܴ SELECT DATE_TRUNC(DATE '2008-12-25', MONTH)
as month; +------------+ | month | +------------+ | 2008-12-01 | +------------+ <%"5&> IUUQTDMPVEHPPHMFDPNCJHRVFSZEPDTSFGFSFODFTUBOEBSETRMEBUF@GVODUJPOT

दрؘ੉ఠ׮ܖӝ '03."5@%"5& GPSNBU@TUSJOH EBUF@FYQS EBUF@FYQSܳGPSNBU@TUSJOH୊ۢ߸҃ Ѿҗח4USJOH SELECT FORMAT_DATE("%x", DATE
"2019-12-25") as US_format; +------------+ | US_format | +------------+ | 12/25/19 | +------------+ 1"34&@%"5& GPSNBU@TUSJOH EBUF@TUSJOH TUSJOHਸGPSNBU@TUSJOH୊ۢ߸҃ Ѿҗח%BUF SELECT PARSE_DATE("%x", "12/25/19") as parsed; +------------+ | parsed | +------------+ | 2019-12-25 | +------------+ <%"5&> IUUQTDMPVEHPPHMFDPNCJHRVFSZEPDTSFGFSFODFTUBOEBSETRMEBUF@GVODUJPOT

दрؘ੉ఠ׮ܖӝ '03."5@453*/(ઙܨ <%"5&>

दрؘ੉ఠ׮ܖӝ %"5&یѢ੄࠺त೤פ׮ 5*.&ਸ؊ࠁৈળ׮੿ب੄ର੉ ҕधޙࢲূ%"5&5*.&ೣࣻࢸݺী&953"$5оহ૑݅ࢎਊоמ 4&-&$5&953"$5 )063'30.$"45 "4%"5&5*.& BTB <%"5&5*.&>

दрؘ੉ఠ׮ܖӝ $633&/5@%"5&5*.& <UJNF@[POF> അ੤զ૞ &Y $633&/5@%"5& r"TJB4FPVMs &953"$5
QBSU'30.EBUFUJNF@FYQSFTTJPO %"5&5*.&ীࢲч ੌ੗ ਃੌ ઱ର ਘ ࠙ӝ োب दр١ ୶୹ &Y &953"$5 :&"3'30.EBUFUJNFUZQFDPMVNO tোبu୶୹ SELECT EXTRACT(HOUR FROM CAST(‘2019-12-25 14:00:00’ AS DATETIME) as hour; +---------+ | hour | +---------+ | 14 | +---------+ IUUQTDMPVEHPPHMFDPNCJHRVFSZEPDTSFGFSFODFTUBOEBSETRMEBUFUJNF@GVODUJPOT <%"5&5*.&>

दрؘ੉ఠ׮ܖӝ %"5&5*.&@"%% EBUFUJNF@FYQSFTTJPO */5&37"-*/5QBSU %"5&5*.&@%*'' EBUFUJNF@FYQSFTTJPO@B EBUFUJNF@FYQSFTTJPO@C QBSU
%"5&5*.&@536/$ EBUFUJNF@FYQSFTTJPO QBSU दр੗ܰӝ  &Y ਸ)063۽੗ܰݶ '03."5@%"5&5*.& GPSNBU@TUSJOH EBUFUJNF@FYQSFTTJPO 1"34&@%"5&5*.& GPSNBU@TUSJOH TUSJOH IUUQTDMPVEHPPHMFDPNCJHRVFSZEPDTSFGFSFODFTUBOEBSETRMEBUFUJNF@GVODUJPOT <%"5&5*.&>

&9$&15 4&-&$5ೡஸۢ઺ٯѐ݅ઁ৻ೞҊर਷҃਋ +0*/ೞҊౠ੿ஸۢਸઁ৻ೞҊ4&-&$5ೞҊर਷҃਋ 4&-&$5 &9$&15 B C D '30.5"#-&
4&-&$5 " &9$&15 DPMVNOB # &9$&15 DPMVNOC '30.5"#-&BT" -&'5+0*/5"#-&BT# 0/"JE#JE ਷Ӕ൤ಞ೧ਃ

ؘ੉ఠदпച

दпചೞח׮নೠߑߨ ௪ܻܳզܽറ झ೐ۨ٘द౟۽੷੢ೠറझ೐ۨ٘द౟۽दпച 5BCMFBVী#JH2VFSZܳোѾ೧ࢲदпച ௪ܻܳզܽറ ؘ੉ఠܳղஹೊఠী੷੢೧ࢲ1ZUIPOਵ۽दпച  .BUQMPUMJC 4FBCPSO 1MPUMZ١
%BUB4UVEJPܳࢎਊ೧ࢲदпച ١١׮নೠߑߨ੉ઓ੤

दпചೞח׮নೠߑߨ ௪ܻܳզܽറ झ೐ۨ٘द౟۽੷੢ೠറझ೐ۨ٘द౟۽दпച ুࣄҗਬࢎ೧ಞೞҊ ҕਬبए਑ױ दпചоইऔҊ ೯ө૑оמ 5BCMFBVী#JH2VFSZܳোѾ೧ࢲदпച दпചܳ੿݈औѱೡࣻ੓਺ױ ਬܐ
௪ܻܳզܽറ ؘ੉ఠܳղஹೊఠী੷੢೧ࢲ1ZUIPOਵ۽दпച  .BUQMPUMJC 4FBCPSO 1MPUMZ١ ౵੉ॆ दпചۄ੉࠳۞ܻীמࣼ೧ঠೣ %BUB4UVEJPܳࢎਊ೧ࢲदпച ௪ܻѾҗীࢲ௿ܼೠߣೞҊ૓೯оמझ೐ۨ٘द౟࢚ਤഐജ <ߑߨٜ੄੢ױ੼>

दпചೞח׮নೠߑߨ <௪ܻܳզܽറ Ѿҗ੷੢(PPHMFझ೐ۨ٘द౟> <झ೐ۨ٘द౟>

दпചೞח׮নೠߑߨ <झ೐ۨ٘द౟ܳৌҊ EBUFӝળਵ۽੿۳ೠറ ࢗੑର౟> <झ೐ۨ٘द౟>

दпചೞח׮নೠߑߨ <झ೐ۨ٘द౟> <झ೐ۨ٘द౟ܳৌҊ EBUFӝળਵ۽੿۳ೠറ ࢗੑର౟>

दпചೞח׮নೠߑߨ <5BCMFBVীࢲ(PPHMF#JH2VFSZ௿ܼೠറ ࠳ۄ਋੷ীࢲഛੋ௿ܼ> <5BCMFBV>

दпചೞח׮নೠߑߨ <೐۽ં౟ ؘ੉ఠࣇࢶఖ> <5BCMFBV>

दпചೞח׮নೠߑߨ <ؘ੉ఠࣇࢶఖೠറ ప੉࠶ࢶఖژח42-௪ܻܳզܾࣻ੓਺> <5BCMFBV>

दпചೞח׮নೠߑߨ <ؘ੉ఠܳࢶఖೠറ द౟ਸׂ۞੉ز> <5BCMFBV>

दпചೞח׮নೠߑߨ <௿ܼߣ݅ীदпചೠ੗ܐ> <5BCMFBV>

दпചೞח׮নೠߑߨ ੉ߣߊ಴о5BCMFBVо઱ઁחইפ૑݅ ୶ୌ੗ܐ ӣ޹૑ש੄:PVUVCF 5BCMFBVஶಌ۠झ:PVUVCF :PVUVCFীtUBCMFBVXFCJOBSu۽Ѩ࢝ೞݶ׮নೠ੗ܐоઓ੤ <5BCMFBV>

दпചೞח׮নೠߑߨ <QESFBE@HCRژחQBOEBT@HCRࢎਊ೧ࢲؘ੉ఠ୶୹> QSJWBUF@LFZীKTPOLFZࢸ੿ژח(00(-&@"11-*$"5*0/@$3&%&/5*"-4١۾ ଵҊ݂௼ ੋૐद੘ೞӝ <1ZUIPO>

दпചೞח׮নೠߑߨ Pythonীࢲ ؘ੉ఠ दпചೞח ׮নೠ ߑߨ IUUQT[[T[BHJUIVCJPEFWFMPQNFOUEBUBWJTVBMJ[BUJPOJOQZUIPO QBOEBTHCRীࢲੋૐ "VUIFOUJDBUJPO ࢸ੿ೞӝ
(00(-&@"11-*$"5*0/@$3&%&/5*"-4١۾੉ӈଳਸ҃਋ ࠳ۄ਋੷۽Ӓੋਸా೧ӂೠദٙоמ IUUQT[[T[BHJUIVCJPHDQQBOEBTHCRBVUI <1ZUIPO>

दпചೞח׮নೠߑߨ <ؘ੉ఠझౚ٣য়ীࢲ࢓ಝࠁӝ௿ܼ> <ؘ੉ఠझౚ٣য়>

पण

पण ؘ੉ఠࢸݺCJLFTIBSFUSJQEBUB CJLFTIBSF@USJQT5BCMF ૑Ә਷੉Ѣ݅ࢎਊ೧ਃ

पण ݻदীUSJQद੘ೞחࢎਊ੗о݆ਸөਃ IPVS݅୶୹೧ࢲ$06/5ೞח௪ܻ EBUFUJNFীࢲदрө૑݅੗ܰҊ$06/5ೞח௪ܻ ֙ਘੌࠗఠदр؀߹୶ࣁܳҳೞח௪ܻ ޖटਃੌীઁੌࢎਊ੗о݆ਸөਃ ਃੌ߹दр؀ಁఢ੉׮ܳөਃ
ਃੌ݃׮ઁੌDPVOUо݆਷दр؀חযڌѱҳ೧ঠೡөਃ ઁੌ݆੉਍೯ೠCJLFJEחޖ঺ੌөਃ ઁੌয়ېৈ೯ೠৈ೯੄USJQ@JEח ઁੌয়ېৈ೯ೠৈ೯਷ݻदрৈ೯೮աਃ

पण ݻदীUSJQद੘ೞחࢎਊ੗о݆ਸөਃ IPVS݅୶୹೧ࢲ$06/5ೞח௪ܻ EBUFUJNFীࢲदрө૑݅੗ܰҊ$06/5ೞח௪ܻ ֙ਘੌࠗఠदр؀߹୶ࣁܳҳೞח௪ܻ 4&-&$5TUBSU@IPVS DPVOU USJQ@JE
BTDPVOU '30. 4&-&$5&953"$5 IPVS'30.TUBSU@UJNF BTTUBSU@IPVS '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA HSPVQCZTUBSU@IPVS PSEFSCZDPVOUEFTD ޙઁ୹ઁ੄ب&953"$5 IPVS'30._ ܳࢎਊ೧IPVSܳ୶୹

BTDPVOU '30. 4&-&$5%"5&5*.&@536/$ %"5&5*.& TUBSU@UJNF IPVS BTTUBSU@IPVS '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA HSPVQCZTUBSU@IPVS PSEFSCZDPVOUEFTD ޙઁ୹ઁ੄ب%"5&5*.&@536/$ $PMVNO IPVS ܳࢎਊ೧IPVSܳ୶୹ җର੉ח%BUFUJNFө૑୶оػѪ  חੌ੗߹दр؀߹୶ࣁܳࠅٸࢎਊೞҊ਷ױࣽदр؀੄чਸঌࣻ੓਺

BTDPVOU '30. 4&-&$5%"5&5*.&@536/$ %"5&5*.& TUBSU@UJNF IPVS BTTUBSU@IPVS '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA XIFSFEBUF TUBSU@UJNF HSPVQCZTUBSU@IPVS PSEFSCZTUBSU@IPVS ޙઁ୹ઁ੄ب8)&3&ઑѤਸѦযࠄ׮

पण ޖटਃੌীઁੌࢎਊ੗о݆ਸөਃ ਃੌ߹दр؀ಁఢ੉׮ܳөਃ ਃੌ݃׮ઁੌDPVOUо݆਷दр؀חযڌѱҳ೧ঠೡөਃ 4&-&$5XFFLEBZ DPVOU
USJQ@JE BTDPVOU '30. 4&-&$5%"5&5*.&@536/$ %"5&5*.& TUBSU@UJNF IPVS BTTUBSU@IPVS '03."5@%"5&5*.& V %"5&5*.& TUBSU@UJNF "4XFFLEBZ '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA HSPVQCZXFFLEBZ PSEFSCZDPVOUEFTD ޙઁ୹ઁ੄ب'03."5@%"5&5*.& V$PMVNO ਵ۽ਃੌਸ୶୹

पण ޖटਃੌীઁੌࢎਊ੗о݆ਸөਃ ਃੌ߹दр؀ಁఢ੉׮ܳөਃ ਃੌ݃׮ઁੌDPVOUо݆਷दр؀חযڌѱҳ೧ঠೡөਃ 4&-&$5XFFLEBZ TUBSU@IPVS
DPVOU USJQ@JE BTDPVOU '30. 4&-&$5&953"$5 IPVSGSPNTUBSU@UJNF BTTUBSU@IPVS '03."5@%"5&5*.& V %"5&5*.& TUBSU@UJNF "4XFFLEBZ '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA HSPVQCZXFFLEBZ TUBSU@IPVS PSEFSCZDPVOUEFTD ޙઁ୹ઁ੄بখ੄௪ܻীTUBSU@IPVS݅୶о૕ޙ੉୶࢚੸ਵ۽઱য૕ٸ যڌѱ௪ܻܳզܻח૑ࢤп೧ࠅࣻ੓ب۾୹ઁೣ

पण ઁੌ݆੉਍೯ೠCJLFJEחޖ঺ੌөਃ 4&-&$5CJLFJE DPVOU USJQ@JE BTDPVOU '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA (3061#:CJLFJE
03%&3#:%&4$ -*.*5 ޙઁ୹ઁ੄ب03%&3#:ߣ૩ஸۢੋDPVOUۄחѪਸঌ۰ܻ٘ӝਤ೧ ୹ઁ

पण ઁੌয়ېৈ೯ೠৈ೯੄USJQ@JEח 4&-&$5."9 EVSBUJPO@NJOVUFT "4NBY@EVSBUJPO@NJOVUFT '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA 4&-&$5
'30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA XIFSFEVSBUJPO@NJOVUFT ޙઁ୹ઁ੄بয়ېৈ೯ೠ੉ۆઑѤ੄чਸࡳӝਤ೧যڌѱ೧ঠೞח૑ Ҋ޹ਸਤೣ ੉۠҃਋ূٍীաয়ח"OBMZUJDT'VODUJPO੉ਬਊ

पण ઁੌয়ېৈ೯ೠৈ೯੄USJQ@JEח ׮ܲಽ੉ 4&-&$5 '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA 03%&3#:EVSBUJPO@NJOVUFT%&4$
-*.*5 ޙઁ୹ઁ੄بӒր03%&3#:ܳੜॳݶೠߑীؼࣻب੓׮ח੼ਸ ੹׳ೞӝਤ೧

पण ઁੌয়ېৈ೯ೠৈ೯਷ݻदрৈ೯೮աਃ '-0"5*/5 4&-&$5 $"45 EVSBUJPO@NJOVUFT "4*/5 BTEVSBUJPO@IPVS '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA
03%&3#:EVSBUJPO@NJOVUFT%&4$ -*.*5 ޙઁ୹ઁ੄ب*/5۽߸ജೞݶࣗࣻ੼੉ࢎۄ૑חѪਸঌ۰઱ӝਤ೧

पण ઁੌয়ېৈ೯ೠৈ೯਷ݻदрৈ೯೮աਃ 306/% 4&-&$5 306/% EVSBUJPO@NJOVUFT BTEVSBUJPO@IPVS '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA 03%&3#:EVSBUJPO@NJOVUFT%&4$
-*.*5 ޙઁ୹ઁ੄ب306/%۽߈ৢܿ੉оמೠѪਸঌ۰ܻ٘ӝਤ೧

#JH2VFSZबച૑ध

੗ܐഋ ؘ੉ఠਬഋ ੗ܐഋ 5ZQF ঌইঠೞח੉ਬ җ਷׮ܴ ৬%"5&৬׮ܴ ߓৌ "33":
җҳઑ୓ 4536$5 ܳੜ੉೧ೞݶࢎप࢚#JH2VFSZѢ੄݃झఠ https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types

੗ܐഋ ं੗ഋ */5੿ࣻ FY ࠗزࣗࣻ੼ '-0"5ࣗࣻ੼ FY ࠗ਎ਬഋ
#00-ଵ Ѣ૙ FY 536& '"-4& ޙ੗ৌ 453*/( ૑ܻ (&0(3"1): https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types զ૞ %"5& զ૞दр %"5&5*.& दр 5*.&दр ఋ੐झఙ೐ 5*.&45".1݃੉௼۽ୡױਤ੿޻بܳыח੺؀द੼ ߓৌ "33":ٍীࢲ҅ࣘ ҳઑ୓ 4536$5ٍীࢲ҅ࣘ

੗ܐഋ ߓৌ਷ೞա੄߸ࣻীৈ۞чٜਸ੷੢ೞח੗ܐഋ ׮নೠѐߊ঱যীࢲߓৌ੉ઓ੤ೞݴ ೞա੄чীৈ۞чਸ֍ਸࣻ੓ח੢੼ ޙߨ Қഐܳࢎਊ FY < >
ౠ੿ؘ੉ఠਬഋਸࢶ঱ೡ҃਋ԃ࣭Қഐࢎਊ FY "33":*/5< > 4&-&$5 < >BTOVNCFST "33":*/5< >BTOVNCFST https://cloud.google.com/bigquery/docs/reference/standard-sql/arrays <ߓৌ "33": >

੗ܐഋ (&/&3"5&@%"5&@"33": %BUFч૘೤ਸࢤࢿೡࣻ੓਺ 4&-&$5 (&/&3"5&@%"5&@"33": */5&37"-8&&, "4EBUF@BSSBZ
]EBUF@BSSBZ] ]< >] <ߓৌ "33": ੄ೣࣻ> https://cloud.google.com/bigquery/docs/reference/standard-sql/arrays

੗ܐഋ "33":@-&/(5) "33":উী੓חਃࣗDPVOU 4&-&$5TPNF@OVNCFST "33":@-&/(5) TPNF@OVNCFST "4MFO '30. 4&-&$5<
>"4TPNF@OVNCFST ]TPNF@OVNCFST]MFO] ]< >]] <ߓৌ "33": ੄ೣࣻ> https://cloud.google.com/bigquery/docs/reference/standard-sql/arrays#arrays-and-aggregation

੗ܐഋ 6//&45 8*5)0''4&5য়೐ࣇ ࣽࢲ ա১ 4&-&$5 '30.6//&45 <GPP CBS
CB[ RVY DPSHF HBSQMZ XBMEP GSFE> "4FMFNFOU 8*5)0''4&5"4PGGTFU 03%&3#:PGGTFU ]FMFNFOU]PGGTFU] ]GPP]] ]CBS]] ]CB[]] ]RVY]] ]DPSHF]] ]HBSQMZ]] ]XBMEP]] ]GSFE]] <ߓৌ "33": ੄ೣࣻ> https://cloud.google.com/bigquery/docs/reference/standard-sql/arrays#arrays-and-aggregation

੗ܐഋ "33":<0''4&5 / >"33":ীࢲ/ߣ૩ਃࣗ ࠗఠद੘ 4&-&$5 <BQQMF QFBS PSBOHF>"4GSVJU
<BQQMF QFBS IJ><0''4&5 >"4POF "33":<03%*/"- / >"33":ীࢲ/ߣ૩ਃࣗ ࠗఠद੘ 4&-&$5 <BQQMF QFBS PSBOHF>"4GSVJU <BQQMF QFBS IJ><03%*/"- >"4POF 8*5)TFRVFODFT"4 4&-&$5< >"4TPNF@OVNCFST 6/*0/"--4&-&$5< >"4TPNF@OVNCFST 6/*0/"--4&-&$5< >"4TPNF@OVNCFST 4&-&$5TPNF@OVNCFST TPNF@OVNCFST<0''4&5 >"4PGGTFU@ TPNF@OVNCFST<03%*/"- >"4PSEJOBM@ '30.TFRVFODFT <ߓৌ "33": ੄ೣࣻ> https://cloud.google.com/bigquery/docs/reference/standard-sql/arrays#arrays-and-aggregation <Ӓ৻ೣٜࣻ਷ইې݂௼ଵҊ>

੗ܐഋ 6//&45 "33":উী੓חਃࣗܳಟ஖Ҋर਷҃਋ 4&-&$5 '30.6//&45 <GPP CBS CB[ RVY
DPSHF HBSQMZ XBMEP GSFE> "4FMFNFOU <ߓৌ "33": ੄ೣࣻ> https://cloud.google.com/bigquery/docs/reference/standard-sql/arrays ࠺Үܳਤ೧ইې௪ܻܳप೯೧ࠁࣁਃ 4&-&$5<GPP CBS CB[ RVY DPSHF HBSQMZ XBMEP GSFE>

੗ܐഋ 6//&45 "33":উী੓חਃࣗܳಟ஖Ҋर਷҃਋ 4&-&$5 '30.6//&45 <GPP CBS CB[ RVY
DPSHF HBSQMZ XBMEP GSFE> "4FMFNFOU <ߓৌ "33": ੄ೣࣻ> https://cloud.google.com/bigquery/docs/reference/standard-sql/arrays ࠺Үܳਤ೧ইې௪ܻܳप೯೧ࠁࣁਃ 4&-&$5<GPP CBS CB[ RVY DPSHF HBSQMZ XBMEP GSFE> ઝஏ਷п೯݃׮ч੉੓חഋక ਋ஏ਷ೞա੄೯ীৈ۞ч੉੓חഋక

੗ܐഋ 4536$5 ࣽࢲо੓Ҋ੉ܴਵ۽ ࢶఖ ೙٘ী੽Ӕೡࣻ੓חஶప੉ց $POUBJOFSPGPSEFSFEGJFMETFBDIXJUIBUZQF SFRVJSFE BOEGJFMEOBNF PQUJPOBM
"33":৬੗઱ॳ੐ ԃ࣭Қഐܳࢎਊ೧੿੄ 4536$5*/5 453*/(೙٘੉ܴ੉হח҃਋ 4536$5JE*/5 OBNF453*/(೙٘੉ܴ੉੓ח҃਋ "33":ח੉ܴਵ۽੽Ӕೞ૑ঋҊ0''4&5 ࣽࢲ ۽੽Ӕ "33":<PGGTFU > 1ZUIPO੄-JTU৬ਬࢎ <4536$5 դ੉ب୭࢚ > https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types#struct-type

੗ܐഋ 4536$5 ࣽࢲо੓Ҋ੉ܴਵ۽ ࢶఖ ೙٘ী੽Ӕೡࣻ੓חஶప੉ց 4536$5*/5 453*/(೙٘੉ܴ੉হח҃਋ 4536$5JE*/5 OBNF453*/(೙٘੉ܴ੉੓ח҃਋ 8*5)MPDBUJPOT"4
4&-&$54536$5 4FBUUMF"4DJUZ 8BTIJOHUPO"4TUBUF "4MPDBUJPO 6/*0/"-- 4&-&$54536$5 1IPFOJY"4DJUZ "SJ[POB"4TUBUF "4MPDBUJPO 4&-&$5MMPDBUJPO '30.MPDBUJPOTBTM <4536$5 դ੉ب୭࢚ > https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types#struct-type

੗ܐഋ 4536$5 ࣽࢲо੓Ҋ੉ܴਵ۽ ࢶఖ ೙٘ী੽Ӕೡࣻ੓חஶప੉ց 4536$5*/5 453*/(೙٘੉ܴ੉হח҃਋ 4536$5JE*/5 OBNF453*/(೙٘੉ܴ੉੓ח҃਋ 4&-&$5
TUSVDU@WBMVF '30.6//&45 "33":4536$5Y*/5 Z453*/(< GPP CBS > "4TUSVDU@WBMVF <4536$5 դ੉ب୭࢚ > 4536$5*/5 ੉ܴ੉হח*/5੿ࣻ೙٘оೞա੓חױࣽ4536$5 4536$5Y4536$5Z*/5 [*/5 উীYۄח੉ܴ੄઺୏ػ4536$5о੓ח4536$5  4536$5YীחZ৬[ فѐ੄೙٘о੓Ҋ ف೙٘ݽف*/5 4536$5JOOFS@BSSBZ"33":*/5 ࠺౟੿ࣻਃࣗܳыחJOOFS@BSSBZۄח"33":оನೣػ4536$5 https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types#struct-type

੗ܐഋ߄Բӝ $"45 DPMVNO"4UZQF DPMVNOਸ5ZQFਵ۽߸҃ <$"45>

8*5) ইөࠌ؍௪ܻ 4&-&$5TPNF@OVNCFST "33":@-&/(5) TPNF@OVNCFST "4MFO '30. 4&-&$5<
>"4TPNF@OVNCFST https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#with_clause

8*5) ইөࠌ؍௪ܻ ௪ܻ੄оةࢿૐо OVNCFSTܳৈ۞ߣࢎਊೡࣻب੓਺ 4&-&$5TPNF@OVNCFST "33":@-&/(5) TPNF@OVNCFST "4MFO '30.
4&-&$5< >"4TPNF@OVNCFST 8*5)OVNCFST"4 4&-&$5< >"4TPNF@OVNCFST 4&-&$5TPNF@OVNCFST "33":@-&/(5) TPNF@OVNCFST "4MFO '30.OVNCFST https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#with_clause

7*&8 7*&8ח42-௪ܻ۽੿੄ೞחо࢚ప੉࠶ ੗઱ࢎਊೞח௪ܻҳޙమ೒݁੉੓ਵݶ7*&8۽੷੢೧ഝਊоמ ࣘبоוܽಞ https://cloud.google.com/bigquery/docs/views-intro

7*&8 https://cloud.google.com/bigquery/docs/views-intro <ࠁӝ 7JFX ੷੢>

7*&8 https://cloud.google.com/bigquery/docs/views-intro <7JFXࢤࢿ>

7*&8 https://cloud.google.com/bigquery/docs/views-intro <7JFXࣁࠗ੿ࠁীࢲ௪ܻഛੋоמ ௪ܻࣻ੿بоמ>

"OBMZUJD'VODUJPO 8JOEPX'VODUJPO "HHSFHBUJPO'VODUJPO ૘҅ೣࣻ ח೯Ӓܛী؀೧ױੌ૘҅чਸ߈ജ ೯Ӓܛ(SPVQCZೠஸۢ ߈ݶ"OBMZUJD'VODUJPO਷п೯݃׮ױੌчਸ߈ജ п೯݃׮ч߈ജ
ઙܨ ఐ࢝ೣࣻ-&"% -"( '*345@7"-6& -"45@7"-6& ߣഐ૑੿ೣࣻ3"/, %&/4&@3"/, 1&3$&/5@3"/, $6.&@%*45 /5*-& ૘҅࠙ࢳೣࣻ૘҅ೣٜࣻ "7( $06/5 46. ."9 .*/ https://cloud.google.com/bigquery/docs/reference/standard-sql/analytic-function-concepts <"OBMZUJD'VODUJPOۆ >

"OBMZUJD'VODUJPO 8JOEPX'VODUJPO ؘ੉ఠ࠙ࢳೞ׮ҾӘ೧૑חѪٜ "ۄחਬ੷੄੹઱ޙࣻ۝਷঴݃աؼө #ۄחਬ੷оޛѤҳੑೞӝ੹ীݻߣ੉ա࢚ࣁࠁӝܳ೮ਸө Ҋё੄ҳݒद੼ী୨־੸ҳݒപࣻח $ۄחਬ੷੄੉੹׮਺জ੽ࣘदр੉যڌѱؼө
ۘఊ ־੸೤ਸঌҊर׮ https://cloud.google.com/bigquery/docs/reference/standard-sql/analytic-function-concepts ੉۠҃਋ݽف"OBMZUJD'VODUJPOਸࢎਊೞݶ࢕੉ਮఖ

<-&"%> -&"%റࣘ೯੄ч߈ജ "OBMZUJD'VODUJPO 8JOEPX'VODUJPO user_id visit_month 1004 1 1004 3
1004 7 1004 8 2112 3 2112 6 2112 7 3912 4

<-&"%> <OFYU@WJTJU@NPOUIܳҳೞҊर׮ݶ > "OBMZUJD'VODUJPO 8JOEPX'VODUJPO user_id visit_month next_visit_month 1004 1
1004 3 1004 7 1004 8 2112 3 2112 6 2112 7 3912 4

<-&"%> <৘࢚0VUQVU> "OBMZUJD'VODUJPO 8JOEPX'VODUJPO user_id visit_month next_visit_month 1004 1 3
1004 3 7 1004 7 8 1004 8 null 2112 3 6 2112 6 7 2112 7 null 3912 4 null

4&-&$5 VTFS@JE WJTJU@NPOUI -&"% WJTJU@NPOUI 07&3 1"35*5*0/#:VTFS@JE "4OFYU@WJTJU@NPOUI
'30.AUBCMFA <-&"%> <2VFSZ> "OBMZUJD'VODUJPO 8JOEPX'VODUJPO <VTFS@JE۽౵౭࣌> <׮਺ч>

<-&"%> "OBMZUJD'VODUJPO 8JOEPX'VODUJPO user_id visit_month 1004 1 1004 3 1004
7 1004 8 2112 3 2112 6 2112 7 3912 4 <1BSUJUJPOCZVTFS@JE> user_id visit_month 1004 1 1004 3 1004 7 1004 8 user_id visit_month 2112 3 2112 6 2112 7 user_id visit_month 3912 4

7 1004 8 2112 3 2112 6 2112 7 3912 4 <1BSUJUJPOCZVTFS@JE> user_id visit_month 1004 1 1004 3 1004 7 1004 8 user_id visit_month 2112 3 2112 6 2112 7 user_id visit_month 3912 4 <OFYU@WJTJU@NPOUI҅࢑>

7 1004 8 2112 3 2112 6 2112 7 3912 4 <1BSUJUJPOCZVTFS@JE> user_id visit_month 1004 1 1004 3 1004 7 1004 8 user_id visit_month 2112 3 2112 6 2112 7 user_id visit_month next_visit_month 1004 1 3 1004 3 7 1004 7 8 1004 8 null 2112 3 6 2112 6 7 2112 7 null 3912 4 null user_id visit_month 3912 4 <OFYU@WJTJU@NPOUI҅࢑>

<-&"%> <OFYU@UXP@WJTJU@NPOUIܳঌҊर׮ݶ > "OBMZUJD'VODUJPO 8JOEPX'VODUJPO user_id visit_month next_visit_month next_two_  visit_month
1004 1 3 7 1004 3 7 8 1004 7 8 null 1004 8 null null 2112 3 6 7 2112 6 7 null 2112 7 null null 3912 4 null null

4&-&$5 VTFS@JE WJTJU@NPOUI -&"% WJTJU@NPOUI 07&3 1"35*5*0/#:VTFS@JE
"4OFYU@UXP@WJTJU@NPOUI '30.AUBCMFA <-&"%> <2VFSZ> "OBMZUJD'VODUJPO 8JOEPX'VODUJPO <ߣ૩ٍч>

<-"(> "OBMZUJD'VODUJPO 8JOEPX'VODUJPO -"(੹೯੄ч߈ജ user_id visit_month 1004 1 1004 3
1004 7 1004 8 2112 3 2112 6 2112 7 3912 4

<-"(> "OBMZUJD'VODUJPO 8JOEPX'VODUJPO user_id visit_month CFGPSF@WJTJU@NPOUI 1004 1 1004 3
1004 7 1004 8 2112 3 2112 6 2112 7 3912 4 <CFGPSF@WJTJU@NPOUIܳҳೞҊर׮ݶ >

<-"(> "OBMZUJD'VODUJPO 8JOEPX'VODUJPO user_id visit_month CFGPSF@WJTJU@NPOUI 1004 1 null 1004
3 1 1004 7 3 1004 8 7 2112 3 null 2112 6 3 2112 7 6 3912 4 null <CFGPSF@WJTJU@NPOUIܳҳೞҊर׮ݶ >

4&-&$5 VTFS@JE WJTJU@NPOUI -"( WJTJU@NPOUI 07&3 1"35*5*0/#:VTFS@JE "4CFGPSF@WJTJU@NPOUI
'30.AUBCMFA <-"(> <2VFSZ> "OBMZUJD'VODUJPO 8JOEPX'VODUJPO <VTFS@JE۽౵౭࣌> <੉੹ч>

<3"/,> ࠙ӝ߹ ౱߹ ௪ܻࣻۘఊਤ 8*5)UFNQ"4 4&-&$5࠙ӝ"4RVBSUFS ؘ੉ఠ౱BTUFBN LZMFBTVTFS@OBNF BTRVFSZ@DPVOU
6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ؘ੉ఠ౱BTUFBN LZMFBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ݠन۞׬౱BTUFBN NBUUIFXBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ݠन۞׬౱BTUFBN NBUUIFXBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ؘ੉ఠ౱BTUFBN TUBSLBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ݃ா౴౱BTUFBN UIPSBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ؘ੉ఠ౱BTUFBN UIPSBTVTFS@OBNF BTRVFSZ@DPVOU 4&-&$5 '30.UFNQ "OBMZUJD'VODUJPO 8JOEPX'VODUJPO

<3"/,> "OBMZUJD'VODUJPO 8JOEPX'VODUJPO <௪ఠ߹౱߹௪ܻ݆ܳ੉զܽࢎۈ਷ > <৘࢚0VUQVU>

6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ؘ੉ఠ౱BTUFBN LZMFBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ݠन۞׬౱BTUFBN NBUUIFXBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ݠन۞׬౱BTUFBN NBUUIFXBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ؘ੉ఠ౱BTUFBN TUBSLBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ݃ா౴౱BTUFBN UIPSBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ؘ੉ఠ౱BTUFBN UIPSBTVTFS@OBNF BTRVFSZ@DPVOU 4&-&$5 RVBSUFS UFBN VTFS@OBNF RVFSZ@DPVOU 3"/, 07&3 1"35*5*0/#:RVBSUFS UFBN03%&3#:RVFSZ@DPVOU%&4$ BTRVBSUFS@SBOL '30.UFNQ "OBMZUJD'VODUJPO 8JOEPX'VODUJPO <௪ఠ߹౱߹௪ܻ݆ܳ੉զܽࢎۈ਷ >

<3"/,> "OBMZUJD'VODUJPO 8JOEPX'VODUJPO <ӝр࢚ҙহ੉௪ܻۘఊ਷ > <৘࢚0VUQVU>

6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ؘ੉ఠ౱BTUFBN LZMFBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ݠन۞׬౱BTUFBN NBUUIFXBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ݠन۞׬౱BTUFBN NBUUIFXBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ؘ੉ఠ౱BTUFBN TUBSLBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ݃ா౴౱BTUFBN UIPSBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ؘ੉ఠ౱BTUFBN UIPSBTVTFS@OBNF BTRVFSZ@DPVOU 4&-&$5 RVBSUFS UFBN VTFS@OBNF RVFSZ@DPVOU 3"/, 07&3 1"35*5*0/#:RVBSUFS UFBN03%&3#:RVFSZ@DPVOU%&4$ BTRVBSUFS@SBOL 3"/, 07&3 03%&3#:RVFSZ@DPVOU%&4$ BTUPUBM@SBOL '30.UFNQ "OBMZUJD'VODUJPO 8JOEPX'VODUJPO <ӝр࢚ҙহ੉௪ܻۘఊ਷ >

<308@/6.#&3> "OBMZUJD'VODUJPO 8JOEPX'VODUJPO 308@/6.#&3 ೯੄ࣽࢲܳ୹۱ 3"/,৬ର੉ח

<308@/6.#&3> "OBMZUJD'VODUJPO 8JOEPX'VODUJPO ࠙ӝ߹ ౱߹ ௪ܻࣻۘఊਤ 8*5)UFNQ"4 4&-&$5࠙ӝ"4RVBSUFS ؘ੉ఠ౱BTUFBN
LZMFBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ؘ੉ఠ౱BTUFBN LZMFBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ݠन۞׬౱BTUFBN NBUUIFXBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ݠन۞׬౱BTUFBN NBUUIFXBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ؘ੉ఠ౱BTUFBN TUBSLBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ݃ா౴౱BTUFBN UIPSBTVTFS@OBNF BTRVFSZ@DPVOU 6/*0/"-- 4&-&$5࠙ӝ"4RVBSUFS ؘ੉ఠ౱BTUFBN UIPSBTVTFS@OBNF BTRVFSZ@DPVOU 4&-&$5 RVBSUFS UFBN VTFS@OBNF RVFSZ@DPVOU 3"/, 07&3 03%&3#:RVFSZ@DPVOU%&4$ BTUPUBM@SBOL 308@/6.#&3 07&3 03%&3#:RVFSZ@DPVOU%&4$ BTSPX@OVNCFS '30.UFNQ 308@/6.#&3 ೯੄ࣽࢲܳ୹۱ 3"/,৬ର੉ח

<308@/6.#&3> "OBMZUJD'VODUJPO 8JOEPX'VODUJPO 3"/,חэਸ҃਋tҕزਤu੉۠धਵ۽಴അ 308@/6.#&3חӒր೯ࣽࢲ

<#PVOEBSZ> "OBMZUJDT'VODUJPOীࢲ8JOEPX੄CPVOEBSZܳ૑੿ೞҊरਸ҃਋ 6/#06/%&%13&$&%*/( 6/#06/%&%'0--08*/( $633&/5308١ਸࢎਊ "OBMZUJD'VODUJPO 8JOEPX'VODUJPO https://cloud.google.com/bigquery/docs/reference/standard-sql/analytic-function-concepts

<#PVOEBSZ> EBUFUJNF߹NPWJOH@BWFSBHF ੉زಣӐ ਸҳೞҊर਷҃਋ ೯੄খ੄दр੹җदрറ੄ࢎਊ೧ಣӐ "OBMZUJD'VODUJPO 8JOEPX'VODUJPO datetime demand NPWJOH@BWFSBHF
2019-05-15 14:00:00 13 15 2019-05-15 15:00:00 16 16 2019-05-15 16:00:00 20 20 2019-05-15 17:00:00 25 29 2019-05-15 18:00:00 41 32 2019-05-15 19:00:00 31 34 2019-05-15 20:00:00 29 30

<#PVOEBSZ> <4BNQMF2VFSZ> "OBMZUJD'VODUJPO 8JOEPX'VODUJPO 4&-&$5 Y "7( Y 07&3
03%&3#:Y3084#&58&&/13&$&%*/("/%$633&/5308 "4BWH@DVSSFOU "7( Y 07&3 03%&3#:Y3084#&58&&/13&$&%*/("/%'0--08*/( "4BWH@GPMMPXJOH '30.6//&45 < > "4Y

<੿ܻ> <4BNQMF2VFSZ> "OBMZUJD'VODUJPO 8JOEPX'VODUJPO 4&-&$5 46. BNPVOU 07&3
BTBNPVOU@UPUBM 46. BNPVOU 07&3 PSEFSCZPSEFS@JESPXTCFUXFFOVOCPVOEFEQSFDFEJOHBOEDVSSFOUSPX BTSVOOJOH@TVN 46. BNPVOU 07&3 QBSUJUJPOCZDVTUPNFS@JEPSEFSCZEBUFUJNFSPXTCFUXFFOVOCPVOEFEQSFDFEJOHBOEDVSSFOUSPX BT SVOOJOH@TVN@CZ@DVTUPNFS BWH BNPVOU PWFS PSEFSCZEBUFUJNFSPXTCFUXFFOQSFDFEJOHBOEDVSSFOUSPX BTUSBJMJOH@BWH '30.PSEFST 03%&3#: <ਗࠄؘ੉ఠ> https://blog.statsbot.co/sql-window-functions-tutorial-b5075b87d129

<੿ܻ> <4BNQMF2VFSZ> "OBMZUJD'VODUJPO 8JOEPX'VODUJPO 4&-&$5 46. BNPVOU 07&3
BTBNPVOU@UPUBM 46. BNPVOU 07&3 PSEFSCZPSEFS@JESPXTCFUXFFOVOCPVOEFEQSFDFEJOHBOEDVSSFOUSPX BTSVOOJOH@TVN 46. BNPVOU 07&3 QBSUJUJPOCZDVTUPNFS@JEPSEFSCZEBUFUJNFSPXTCFUXFFOVOCPVOEFEQSFDFEJOHBOEDVSSFOUSPX BT SVOOJOH@TVN@CZ@DVTUPNFS BWH BNPVOU PWFS PSEFSCZEBUFUJNFSPXTCFUXFFOQSFDFEJOHBOEDVSSFOUSPX BTUSBJMJOH@BWH '30.PSEFST 03%&3#: <0VUQVU> https://blog.statsbot.co/sql-window-functions-tutorial-b5075b87d129

+40/@&953"$5 оՔ#JH2VFSZೠ7BMVFী+40/౵ੌਸ֍ח҃਋о੓਺ ইې௪ܻ۽೙ਃೠ+40/୶୹ 4&-&$5+40/@&953"$5 KTPO@UFYU DMBTT<TUVEFOUT> "4TUVEFOU@OBNFT '30.6//&45 < \DMBTT\TUVEFOUT<\OBNF+BOF^>^^
\DMBTT\TUVEFOUT<>^^ \DMBTT\TUVEFOUT<\OBNF+PIO^ \OBNF+BNJF^>^^ > "4KTPO@UFYU ]TUVEFOU@OBNFT] ]<\OBNF+BOF^>] ]<>] ]<\OBNF+PIO^ \OBNF+BNJF^>] https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions

+40/@&953"$5@4$"-"3 оՔ#JH2VFSZೠ7BMVFী+40/౵ੌਸ֍ח҃਋о੓਺ ইې௪ܻ۽೙ਃೠч݅୶୹ 4&-&$5+40/@&953"$5@4$"-"3 \BC\DXPSME^^ <BC>D BTIFMMP ]IFMMP]
]XPSME] https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions

6%' 6%'6TFS%FGJOFE'VODUJPO ࢎਊ੗о੿੄ೠೣࣻ ࢎਊೞח੉ਬ  #JH2VFSZীࢲহחೣࣻܳࢎਊೞҊर਷҃਋ ௪ܻ۽୊ܻೞחؘ߈ࠂ೧ࢲࢎਊೡ҃਋ ৻ࠗۄ੉࠳۞ܻܳഝਊ೧ঠೡ҃਋  о૑঱য۽ٜ݅ࣻ੓਺ 42- ੗߄झ௼݀౟
+BWB4DSJQU ױ 7*&8ীࢲࢎਊࠛоמ https://cloud.google.com/bigquery/docs/reference/standard-sql/user-deﬁned-functions

6%' <42-> https://cloud.google.com/bigquery/docs/reference/standard-sql/user-deﬁned-functions#sql-udf-structure $3&"5&5&.1'6/$5*0/BEE@GPVS@BOE@EJWJEF Y*/5 Z*/5 "4 Y
Z 4&-&$5WBM BEE@GPVS@BOE@EJWJEF WBM "4SFTVMU '30. 4&-&$5BTWBM 6/*0/"-- 4&-&$5BTWBM 6/*0/"-- 4&-&$5BTWBM 6/*0/"-- 4&-&$5BTWBM <੿੄> <ੋ੗> <ೣࣻ੉ܴ> <ো࢑ 42-಴അध>

6%' <+BWB4DSJQU> https://cloud.google.com/bigquery/docs/reference/standard-sql/user-deﬁned-functions#supported-external-udf-languages $3&"5&5&.1'6/$5*0/DVTUPN(SFFUJOH B453*/( 3&563/4453*/( -"/(6"(&KT"4 WBSEOFX%BUF
JG EHFU)PVST \ SFUVSO(PPE.PSOJOH B ^FMTF\ SFUVSO(PPE&WFOJOH B ^ 4&-&$5DVTUPN(SFFUJOH OBNFT BTFWFSZPOF '30.6//&45 <)BOOBI .BY +BLPC> "4OBNFT <੿੄> <ੋ੗> <ೣࣻ੉ܴ> <ো࢑ ੗߄झ௼݀౟>

6%' <+BWB4DSJQU> https://cloud.google.com/bigquery/docs/reference/standard-sql/user-deﬁned-functions#including-external-libraries $3&"5&5&.1'6/$5*0/NZ'VOD B'-0"5 C453*/( 3&563/4453*/( -"/(6"(&KT"4
"TTVNFTEP*OUFSFTUJOH4UVGGJTEFGJOFEJOPOFPGUIFMJCSBSZGJMFT SFUVSOEP*OUFSFTUJOH4UVGG B C 015*0/4 MJCSBSZHTNZCVDLFUQBUIUPMJCKT MJCSBSZ<HTNZCVDLFUQBUIUPMJCKT HTNZCVDLFUQBUIUPMJCKT> 4&-&$5NZ'VOD GPP <৻ࠗۄ੉࠳۞ܻࢎਊоמ (PPHMF4UPSBHFীস۽٘೧ࢲࢎਊ>

6%' ੗઱ࢎਊೞח6%'ח(JUIVC3FQPীٮ۽ҙܻೞחѪبજ਺ ইऔѱب%FGBVMU6%'ࢎਊ੉۠ӝמ੉হणפ׮

1"35*5*0/ #JH2VFSZח2VFSZীࢲఐ࢝ೞחؘ੉ఠ੄ࣻо݆ਸࣻ۾࠺ਊ੉ࠗҗؽ ٮۄࢲ౵౭࣌ਸࢸ੿೧௪ܻࢿמب֫੉Ҋ࠺ਊبઁযೣ 5BCMF੉ܴীզ૞4VGGJYܳ୶о &Y 'JSFCBTF"QQ%BUB  AEBUBTFUFWFOUT@AAEBUBTFUFWFOUT@\EBUF^A 5BCMFীࢲ5*.&45".1ژח%"5&ৌਸ౵౭࣌ਵ۽୶о ਢ6*ীࢶࠛоמೞҊ$-*ա$3&"5&5"#-&௪ܻ۽ࢤࢿ https://cloud.google.com/bigquery/docs/partitioned-tables

1"35*5*0/ 5BCMF੉ܴীզ૞4VGGJYܳ୶оೡ҃਋2VFSZ@5"#-&@46''*9ࢎਊ &Y 'JSFCBTF"QQ%BUB  AEBUBTFUFWFOUT@AAEBUBTFUFWFOUT@\EBUF^A 5BCMFࢤࢿೡٸTVGGJYਸ੉۠ഋక۽੷੢ 4&-&$5 $06/5 VTFS@JE "4DPVOU
'30. AGJSFCBTF@EBUBFWFOUT@ A 8)&3& @5"#-&@46''*9#&58&&/r"/%rs https://cloud.google.com/bigquery/docs/querying-wildcard-tables

1"35*5*0/ 5BCMFীࢲ5*.&45".1ژח%"5&ৌਸ౵౭࣌ਵ۽୶о ਢ6*ীࢶࠛоמೞҊ$-*ա$3&"5&5"#-&௪ܻ۽ࢤࢿ $3&"5&5"#-&NZEBUBTFUOFXUBCMF USBOTBDUJPO@JE*/5 USBOTBDUJPO@EBUF%"5& 1"35*5*0/#:USBOTBDUJPO@EBUF 015*0/4
QBSUJUJPO@FYQJSBUJPO@EBZT EFTDSJQUJPOBUBCMFQBSUJUJPOFECZUSBOTBDUJPO@EBUF $-*ীࢲ CRMPDBUJPO<-0$"5*0/>RVFSZEFTUJOBUJPO@UBCMF<130+&$5@*%><%"5"4&5><5"#-&> UJNF@QBSUJUJPOJOH@GJFME<$0-6./>VTF@MFHBDZ@TRMGBMTF<26&3:> https://cloud.google.com/bigquery/docs/creating-column-partitions

1"35*5*0/ 5BCMFীࢲ5*.&45".1ژח%"5&ৌਸ౵౭࣌ਵ۽୶оೡ҃਋2VFSZ @1"35*5*0/5*.& @1"35*5*0/%"5&ࢎਊ 5*.&45".1ࢎਊद 4&-&$5 <$0-6./> '30. <%"5"4&5><5"#-&> 8)&3&
@1"35*5*0/5*.&#&58&&/5*.&45".1 "/%5*.&45".1 r %"5&ࢎਊद 4&-&$5 <$0-6./> '30. <%"5"4&5><5"#-&> 8)&3& @1"35*5*0/%"5&#&58&&/"/% https://cloud.google.com/bigquery/docs/querying-partitioned-tables

1"35*5*0/ 5BCMFীࢲ5*.&45".1ژח%"5&ৌਸ౵౭࣌ਵ۽୶оೡ҃਋2VFSZ @1"35*5*0/5*.& @1"35*5*0/%"5&ࢎਊ 4&-&$5 @1"35*5*0/5*.&BTQU   '03."5@5*.&45".1 :NE @1"35*5*0/5*.&
BTQBSUJUJPO@JE '30.A130+&$5@*%%"5"4&5@*%5"#-&@*%A (3061#:@1"35*5*0/5*.& 03%&3#:@1"35*5*0/5*.& https://cloud.google.com/bigquery/docs/querying-partitioned-tables

पण

पण ؘ੉ఠࢸݺCJLFTIBSFUSJQEBUB CJLFTIBSF@USJQT5BCMF ૑Ә਷੉Ѣ݅ࢎਊ೧ਃ

पण USJQ߹਍೯दр੄UPUBMਸ"OBMZUJDT'VODUJPOਵ۽಴അ CJLF߹਍೯दрUPUBM "OBMZUJDT'VODUJPO CJLF߹਍೯പࣻ ಣӐө૑୶о "OBMZUJDT'VODUJPO
TUBSU@TUBUJPOFOE@TUBUJPO߹UPUBM പࣻ ಣӐ "OBMZUJDT'VODUJPO TUBSU@TUBUJPO@JE CJLFJE߹%VSBUJPO@NJOVUFT݆਷ࣽ ."9ч݅оઉয়ӝ TUBSU@TUBUJPO@JE߹੹റEVSBUJPO@NJOVUFT

पण USJQ߹਍೯दр੄UPUBMਸ"OBMZUJDT'VODUJPOਵ۽಴അ 4&-&$5 46. EVSBUJPO@NJOVUFT 07&3 1"35*5*0/#:USJQ@JE03%&3#:TUBSU@UJNF SVOOJOH@UPUBM
'30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA ޙઁ୹ઁ੄ب"OBMZUJDT'VODUJPOݍࠁӝ   ਗࠄؘ੉ఠী੓חEVSBUJPO@NJOVUFTஸۢҗղ׹੉ݏח૑ഛੋ

CJLF߹਍೯दрUPUBM "OBMZUJDT'VODUJPOࢎਊ೧ࢲ 4&-&$5EJTUJODUCJLFJE 46. EVSBUJPO@NJOVUFT 07&3 1"35*5*0/#:CJLFJE "4CJLF@SVOOJOH@UPUBM
'30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA XIFSFCJLFJEJTOPUOVMM PSEFSCZEFTD ޙઁ୹ઁ੄ب/VMMч୊ܻ CJLFJEJTOPUOVMM EJTUJODUܳݔখীفݶ઺ࠂਸઁѢೠ റաఋթ EJTUJODUࡐҊ೧ࠁࣁਃ पण

CJLF߹਍೯दрUPUBM "OBMZUJDT'VODUJPOࢎਊ೧ࢲ 4&-&$5EJTUJODUCJLFJE 46. EVSBUJPO@NJOVUFT 07&3 1"35*5*0/#:CJLFJE "4CJLF@SVOOJOH@UPUBM
'30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA XIFSFCJLFJEJTOPUOVMM PSEFSCZEFTD زੌೠѾҗоաয়ח௪ܻ 4&-&$5CJLFJE TVN EVSBUJPO@NJOVUFT BTCJLF@SVOOJOH@UPUBM '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA XIFSFCJLFJEJTOPUOVMM (3061#:CJLFJE PSEFSCZEFTD पण

CJLF߹਍೯പࣻ ಣӐө૑୶о "OBMZUJDT'VODUJPO 4&-&$5EJTUJODUCJLFJE 46. EVSBUJPO@NJOVUFT 07&3 1"35*5*0/#:CJLFJE03%&3#:TUBSU@UJNF
"4 CJLF@SVOOJOH@UPUBM $06/5 EVSBUJPO@NJOVUFT 07&3 1"35*5*0/#:CJLFJE03%&3#:TUBSU@UJNF "4 CJLF@SVOOJOH@DPVOU "7( EVSBUJPO@NJOVUFT 07&3 1"35*5*0/#:CJLFJE03%&3#:TUBSU@UJNF "4 CJLF@SVOOJOH@BWH '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA XIFSFCJLFJEJTOPUOVMM पण

TUBSU@TUBUJPOFOE@TUBUJPO߹UPUBM പࣻ ಣӐ "OBMZUJDT'VODUJPO 4&-&$5EJTUJODUTUBSU@TUBUJPO@JE FOE@TUBUJPO@JE 46. EVSBUJPO@NJOVUFT
07&3 1"35*5*0/#:TUBSU@TUBUJPO@JE FOE@TUBUJPO@JE "4 TUBSU@FOE@SVOOJOH@UPUBM $06/5 EVSBUJPO@NJOVUFT 07&3 1"35*5*0/#:TUBSU@TUBUJPO@JE FOE@TUBUJPO@JE "4TUBSU@FOE@SVOOJOH@DPVOU "7( EVSBUJPO@NJOVUFT 07&3 1"35*5*0/#:TUBSU@TUBUJPO@JE FOE@TUBUJPO@JE "4 TUBSU@FOE@SVOOJOH@BWH '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA XIFSFTUBSU@TUBUJPO@JEJTOPUOVMMBOEFOE@TUBUJPO@JEJTOPUOVMM पण

TUBSU@TUBUJPO@JE CJLFJE߹%VSBUJPO@NJOVUFT݆਷ࣽ 4&-&$5TUBSU@TUBUJPO@JE CJLFJE EVSBUJPO@NJOVUFT 308@/6.#&3 07&3 1"35*5*0/#:TUBSU@TUBUJPO@JE CJLFJE03%&3#:
EVSBUJPO@NJOVUFT%&4$ "4SPX@OVNCFS '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA XIFSFTUBSU@TUBUJPO@JEJTOPUOVMMBOECJLFJEJTOPUOVMM पण

."9ч݅оઉয়ӝ 4&-&$5 '30. 4&-&$5TUBSU@TUBUJPO@JE CJLFJE EVSBUJPO@NJOVUFT 308@/6.#&3
07&3 1"35*5*0/#:TUBSU@TUBUJPO@JE CJLFJE03%&3#: EVSBUJPO@NJOVUFT%&4$ "4SPX@OVNCFS '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA XIFSFTUBSU@TUBUJPO@JEJTOPUOVMMBOECJLFJEJTOPUOVMM 8)&3&SPX@OVNCFS पण

TUBSU@TUBUJPO@JE߹੹റEVSBUJPO@NJOVUFT 4&-&$5TUBSU@TUBUJPO@JE TUBSU@UJNF EVSBUJPO@NJOVUFT -"( EVSBUJPO@NJOVUFT 07&3 1"35*5*0/#:TUBSU@TUBUJPO@JE03%&3#:
TUBSU@UJNF "4MBH -&"% EVSBUJPO@NJOVUFT 07&3 1"35*5*0/#:TUBSU@TUBUJPO@JE03%&3#: TUBSU@UJNF "4MFBE '30.ACJHRVFSZQVCMJDEBUBBVTUJO@CJLFTIBSFCJLFTIBSF@USJQTA XIFSFTUBSU@TUBUJPO@JEJTOPUOVMMBOECJLFJEJTOPUOVMM पण

झாે௪ܻ

झாે௪ܻ ౠ੿௪ܻܳݒੌౠ੿दрীج۰ঠೡ҃਋ ৘द%BJMZݒ୹ਸ௪ܻ۽҅࢑ೞҊݽפఠ݂೧ঠೞח҃਋ ѐߊ੗ ੋझఢझܳೞաࢤࢿೞҊDSPOUBC١۾ "84-BNCEB $MPVE8BUDI&WFOU ઁ҃਋
"JSGMPXੋझఢझڸ਋Ҋҙܻ ӝദ੗ژח݃ாఠۄݶ

झாે௪ܻ ౠ੿௪ܻܳݒੌౠ੿दрীج۰ঠೡ҃਋ ৘द%BJMZݒ୹ਸ௪ܻ۽҅࢑ೞҊݽפఠ݂೧ঠೞח҃਋ ѐߊ੗ ੋझఢझܳೞաࢤࢿೞҊDSPOUBC١۾ "84-BNCEB $MPVE8BUDI&WFOU ઁ҃਋
"JSGMPXੋझఢझڸ਋Ҋҙܻ ӝദ੗ژח݃ாఠۄݶ рױ൤झாે௪ܻࢎਊ 5.*അ੤߬ఋ

झாે௪ܻ #JH2VFSZ%BUB5SBOTGFS4FSWJDFࢎਊࢸ੿ IUUQTDPOTPMFDMPVEHPPHMFDPNBQJTMJCSBSZCJHRVFSZEBUBUSBOTGFSHPPHMFBQJTDPN

झாે௪ܻ ӂೠࢸ੿

झாે௪ܻ ӂೠࢸ੿ 3PMFী୶о೧ࢲҙܻೞחѪ୶ୌ 3PMFT$3&"5&30-& https://cloud.google.com/bigquery/docs/scheduling-queries

झாે௪ܻ ӂೠ୶о *".ਬ੷୓௼റࣻ੿ https://cloud.google.com/bigquery/docs/scheduling-queries

झாે௪ܻ https://cloud.google.com/bigquery/docs/scheduling-queries ӂೠ୶о ৉ೡ୶оറ੷੢ #JH2VFSZҙܻ੗ "ENJO بࢸ੿೧઻ঠࢎਊоמҙ੼ীٮۄ੉गઓ੤ೡࣻ੓਺

झாે௪ܻ https://cloud.google.com/bigquery/docs/scheduling-queries

झாે௪ܻ https://cloud.google.com/bigquery/docs/scheduling-queries 4BNQMF2VFSZ 4&-&$5!SVO@UJNF"4UJNF UJUMF BVUIPS UFYU
'30.ACJHRVFSZQVCMJDEBUBIBDLFS@OFXTTUPSJFTA -*.*5

झாે௪ܻ https://cloud.google.com/bigquery/docs/scheduling-queries ௪ܻѾҗ੄؀࢚ਤ஖ప੉࠶ী NZUBCMF@\SVO@UJNF]:NE^੉۠ഋधਸࢎਊ೧੷੢ೡࣻ੓਺

झாે௪ܻ ݅ডউغݶҗѢ6*ীࢲ೧ࠁदחѪ୶ୌ IUUQTCJHRVFSZDMPVEHPPHMFDPN

5BCMFࢤࢿೞӝ ؘ੉ఠࠛ۞য়ӝ

5BCMFࢤࢿೞӝ <5BCMFࢤࢿೞחߑߨ> ࠼ప੉࠶ (PPHMF$MPVE4UPSBHF স۽٘ ҳӖ٘ۄ੉࠳ (PPHMF$MPVE#JHUBCMF

5BCMFࢤࢿೞӝ <۽ஸস۽٘> ਋ܻоࢤпೞחߑधਵ۽স۽٘ ױ ۽ஸস۽٘ ਢ ח.#۽ઁೠ

5BCMFࢤࢿೞӝ <$-*স۽٘> ਢਸాೞ૑ঋҊ$-*CRݺ۸য۽5BCMFࢤࢿоמ CRMPDBUJPO64MPBEBVUPEFUFDUTPVSDF@GPSNBU$47UFTU@EBUBCVJMEJOHCVJMEJOH@DTW CRݺ۸যܳࢎਊೞӝਤ೧ࢶHDMPVEࢸ஖೙ࣻ

5BCMFࢤࢿೞӝ <(PPHMF$MPVE4UPSBHF> ઁੌ݆੉ࢎਊೞחߑߨ ইې੉޷૑ח[[T[B@EBUBߡ௄ীHSFFO@USJQEBUB@DTW੷੢ HT[[T[B@EBUBHSFFO@USJQEBUB@DTW

5BCMFࢤࢿೞӝ <(PPHMF$MPVE4UPSBHF> [ GS URL ] [ Table ] [
झః݃ ੗زх૑(୓௼ উೞҊ ૑੿೧઻ب ؽ ] [ ౵౭࣌ ࢸ੿, दрਸ ౵౭࣌ ӝળਵ۽ ࢸ੿ оמ ] [ ౵ੌ ഋध ]

5BCMFࢤࢿೞӝ <(PPHMF$MPVE4UPSBHF> Ҋә২࣌

5BCMFࢤࢿೞӝ <(PPHMF%SJWF झ೐ۨ٘द౟> IUUQTESJWFHPPHMFDPNPQFO JE<GJMF@JE> IUUQTEPDTHPPHMFDPNTQSFBETIFFUTE<GJMF@JE> (PPHMFझ೐ۨ٘द౟ (PPHMF٘ۄ੉࠳౵ੌ݃਋झয়ܲଃߡౡ௿ܼ ҕਬоמೠ݂௼оઉয়ӝ

௪ܻѾҗ׮਍۽٘ೞӝ ؘ੉ఠ୶୹ೞӝ

௪ܻѾҗ੷੢ೞӝ <௪ܻզܽറ Ѿҗ੷੢> ೯੉ղੌ҃਋Ã$47 ۽ஸ౵ੌ (PPHMFझ೐ۨ٘द౟ (#੉ೞੌ҃਋ ೯࢚ҙহ਺ Ã$47
(PPHMF٘ۄ੉࠳ +40/ (PPHMF٘ۄ੉࠳ (#ୡҗژח ೯ୡҗÃ#JH2VFSZప੉࠶۽੷੢ೠറÃ(PPHMF4UPSBHF੷੢ ౵੉ॆਸࢎਊೡࣻ੓ਸ҃਋ÃQESFBE@HCR۽௪ܻѾҗݫݽܻী੷੢

௪ܻѾҗ੷੢ೞӝ <௪ܻզܽറ Ѿҗ੷੢> (#ୡҗژח ೯ୡҗ#JH2VFSZప੉࠶۽੷੢ೠറÃ(PPHMF4UPSBHF੷੢

௪ܻѾҗ੷੢ೞӝ <௪ܻզܽറ Ѿҗ੷੢> (#ୡҗژח ೯ୡҗ#JH2VFSZప੉࠶۽੷੢ೠറÃ(PPHMF4UPSBHF੷੢ ੷੢റ IUUQTDPOTPMFDMPVEHPPHMFDPNTUPSBHFCSPXTFS۽੉ز೧ࢲ౵ੌഛੋ

௪ܻѾҗ੷੢ೞӝ <௪ܻզܽറ Ѿҗ੷੢> ౵੉ॆਸࢎਊೡࣻ੓ਸ҃਋QESFBE@HCR۽௪ܻѾҗݫݽܻী੷੢

%.-2VFSZ

%.-2VFSZ <؀ࠗ࠙ࢎਊೞ૑ঋਸоמࢿ੉௾ӝמ> #JH2VFSZ5BCMFীؘ੉ఠܳসؘ੉౟ ࢗੑ ࢏ઁೡࣻ੓חӝמ */4&35 ୶о 61%"5& সؘ੉౟ %&-&5&
࢏ઁ

%.-2VFSZ <*/4&35> ݺद੸чਸ૑੿೧*/4&35 */4&35EBUBTFU/FX"SSJWBMT QSPEVDU RVBOUJUZ XBSFIPVTF   7"-6&4 UPQMPBEXBTIFS
XBSFIPVTF ESZFS XBSFIPVTF rPWFO XBSFIPVTFs <%FTUJOBUJPO5BCMF੉ܴ> <%FTUJOBUJPO5BCMFஸۢ> <*/4&35ೡؘ੉ఠ>

%.-2VFSZ <*/4&35> 4&-&$5Ѿҗܳ*/4&35 */4&35EBUBTFU8BSFIPVTF XBSFIPVTF TUBUF 4&-&$5 '30.6//&45
< XBSFIPVTF 8" XBSFIPVTF $" XBSFIPVTF 8" > <%FTUJOBUJPO5BCMF੉ܴ> <%FTUJOBUJPO5BCMFஸۢ> <*/4&35ೡؘ੉ఠ>

%.-2VFSZ <*/4&35> ӝઓప੉࠶ীؘ੉ఠоহਸ҃਋݅*/4&35 */4&35AFYJTUJOHUBCMFA EBUF IPVS HV EFNBOE 4&-&$5CEBUF
CIPVS CHV CEFNBOE '30.AUFNQUBCMFA"4C 8)&3&/05&9*454 4&-&$5'30.AFYJTUJOHUBCMFA"4B  8)&3&BEBUFCEBUF"/%BIPVSCIPVS"/%BHVCHV <ӝઓী੓ח૑হח૑୓௼ೞח௪ܻ>

%.-2VFSZ <61%"5&> ౠ੿ઑѤਸ݅઒ೞחчਸ61%"5& 61%"5&EBUBTFU*OWFOUPSZ 4&5RVBOUJUZRVBOUJUZ 8)&3&QSPEVDUMJLFXBTIFS <%FTUJOBUJPO5BCMF੉ܴ> <61%"5&ܳ੉ۧѱ೧ۄ> <ౠ੿ઑѤ>

%.-2VFSZ <61%"5&> ӝઓ5BCMFীౠ੿ઑѤ੉݅઒ೡ҃਋ী61%"5& 61%"5&AFYJTUJOHUBCMFA"4B 4&5BEFNBOECEFNBOE '30. 4&-&$5 '30.AUFNQUBCMFA "4C
8)&3&BEBUFCEBUF"/%BIPVSCIPVS"/%BHVCHV <ౠ੿ઑѤ> <61%"5&ܳ੉ۧѱ೧ۄ>

%.-2VFSZ <%&-&5&> 5BCMF੄ݽٚ೯%&-&5& %&-&5&EBUBTFU%FUBJMFE*OWFOUPSZ 8)&3&USVF <ݽف׮> <4PVSDF5BCMF੉ܴ>

%.-2VFSZ <%&-&5&> 5BCMF੄ౠ੿ઑѤਸ݅઒ೞח೯%&-&5& %&-&5&EBUBTFU*OWFOUPSZ 8)&3&RVBOUJUZ <ౠ੿ઑѤ> <4PVSDF5BCMF੉ܴ>

'JSFCBTF-PH

'JSFCBTF <'JSFCBTFজؘ੉ఠ੄ࢤӣ࢜> ੉ଃ੉୊਺ࠅٸ੉೧оੜউؽ ৈӝח5BCMFഋకۄ੉೧оए਍ಞ

'JSFCBTF <ױࣽ&WFOU$PVOUחऔѱоמ> FWFOU@EJNOBNF݅4&-&$5ೞݶఐ࢝ೞחؘ੉ఠо੸਺ 4&-&$5 $06/5 %*45*/$5VTFS@JE "4TBWF@OBNF@VOJRVF '30. A:063@5"#-&FWFOUT@ A
8)&3& FWFOU@OBNFr4BWF@/BNFs ਗೞחӝрਵ۽߸҃ "/%@5"#-&@46''*9#&58&&/"/%r

'JSFCBTF <ೞ૑݅ࢎۈٜ੄ҾӘૐ਷ > যڃ੉ܴਸ঴݃ա੷੢೮ਸө Ã౵ۄ޷ఠө૑ࠊঠೣ

'JSFCBTF <'JSFCBTFؘ੉ఠࢤӣ࢜ 'JFMEOBNF਷׮ܳࣻ੓਺ ٣పੌ਷ইې݂௼ଵҊ> https://support.google.com/ﬁrebase/answer/7029846

'JSFCBTF <'JSFCBTFؘ੉ఠࢤӣ࢜ 'JFMEOBNF਷׮ܳࣻ੓਺ ٣పੌ਷ইې݂௼ଵҊ> https://support.google.com/ﬁrebase/answer/7029846 ૒੹&WFOUUJNFTUBNQନযષ

'JSFCBTF <ѐߊ੗о੿੄ೞ૑ঋইب੗زਵ۽ߊࢤೞח'JSFCBTF&WFOU٣పੌ਷݂௼ଵҊ> https://support.google.com/ﬁrebase/answer/6317485 ಴दೠѤઁо઱۽ࠁ؍੉߮౟ জ݃׮੗઱ࠅ੉߮౟о׮ܴ

'JSFCBTF <ѐߊ੗о੿੄ೞ૑ঋইب੗زਵ۽ߊࢤೞח'JSFCBTF&WFOU٣పੌ਷݂௼ଵҊ> https://support.google.com/ﬁrebase/answer/6317485 ੉੉߮౟ٜ਷੿݈݆੉ନ൨੹୊ܻೡٸחઁ৻೧ࢲࠁӝبೣ

'JSFCBTF <ѱ੐SPVOE৮ܐೠ੉߮౟> <*OQVU ਗࠄؘ੉ఠ > <਋ܻо৘࢚ೞח0VUQVU>

'JSFCBTF <ࢠ೒௪ܻա઺ীࢎਊೞӝऔب۾6%'۽ઁҕ> 6%'GPSFWFOUQBSBNFUFST $3&"5&5&.1'6/$5*0/QBSBN7BMVF#Z,FZ L453*/( QBSBNT"33":4536$5LFZ453*/( WBMVF4536$5TUSJOH@WBMVF 453*/( JOU@WBMVF*/5 GMPBU@WBMVF'-0"5
EPVCMF@WBMVF'-0"5 "4 4&-&$5YWBMVF'30.6//&45 QBSBNT Y8)&3&YLFZL 6%'GPSVTFSQSPQFSUJFT $3&"5&5&.1'6/$5*0/QSPQFSUZ7BMVF#Z,FZ L453*/( QSPQFSUJFT"33":4536$5LFZ453*/( WBMVF 4536$5TUSJOH@WBMVF453*/( JOU@WBMVF*/5 GMPBU@WBMVF'-0"5 EPVCMF@WBMVF'-0"5 TFU@UJNFTUBNQ@NJDSPT*/5 "4 4&-&$5YWBMVF'30.6//&45 QSPQFSUJFT Y8)&3&YLFZL 2VFSZBQJ@WFSTJPO SPVOE rUZQF@PG@HBNF 4&-&$5 VTFS@JE FWFOU@OBNF FWFOU@UJNFTUBNQ QSPQFSUZ7BMVF#Z,FZ BQJ@WFSTJPO VTFS@QSPQFSUJFT TUSJOH@WBMVF"4BQJ@WFSTJPO QBSBN7BMVF#Z,FZ rSPVOE FWFOU@QBSBNT TUSJOH@WBMVF"4SPVOE QBSBN7BMVF#Z,FZ UZQF@PG@HBNF FWFOU@QBSBNT TUSJOH@WBMVFBTUZQF@PG@HBNF GSPNAEBUBTFUUBCMFA -*.*5

'JSFCBTF <ࢠ೒௪ܻࢲ࠳௪ܻࢎਊ> খ௪ܻ৬زੌೠѾҗ 4&-&$5 VTFS@JE FWFOU@OBNF FWFOU@UJNFTUBNQ
4&-&$5QSPQFSUJFTWBMVFTUSJOH@WBMVF'30.6//&45 VTFS@QSPQFSUJFT "4QSPQFSUJFTXIFSFQSPQFSUJFTLFZBQJ@WFSTJPO "4BQJ@WFSTJPO 4&-&$5QBSBNTWBMVFTUSJOH@WBMVF'30.6//&45 FWFOU@QBSBNT "4QBSBNT8)&3&QBSBNTLFZSPVOE "4SPVOE 4&-&$5QBSBNTWBMVFTUSJOH@WBMVF'30.6//&45 FWFOU@QBSBNT "4QBSBNT8)&3&QBSBNTLFZUZQF@PG@HBNF "4 UZQF@PG@HBNF GSPNAEBUBTFUUBCMFA -*.*5

'JSFCBTF <$3044+0*/6//&45दпച> https://medium.com/ﬁrebase-developers/using-the-unnest-function-in-bigquery-to-analyze-event-parameters-in- analytics-fb828f890b42

'JSFCBTF <6//&45दпച> https://medium.com/ﬁrebase-developers/using-the-unnest-function-in-bigquery-to-analyze-event-parameters-in- analytics-fb828f890b42

'JSFCBTF <ৈ۞࠙য۰਋दભ > 'JSFCBTFؘ੉ఠী߄۽௪ܻܳզܻחѪ਷ইې৬э਷੉ग 6//&45 ࢲ࠳௪ܻ١ਸ੉೧೧ঠ೧ࢲୡब੗ীѲয۰਎ࣻ੓਺ 'JSFCBTFীࢲ౵ۄ޷ఠਸನೣೠ௪ܻܳզܻח҃਋࠺ਊ੉ఀ

'JSFCBTF <ৈ۞࠙য۰਋दભ > 'JSFCBTFؘ੉ఠী߄۽௪ܻܳզܻחѪ਷ইې৬э਷੉ग 6//&45 ࢲ࠳௪ܻ١ਸ੉೧೧ঠ೧ࢲୡब੗ীѲয۰਎ࣻ੓਺ 'JSFCBTFীࢲ౵ۄ޷ఠਸನೣೠ௪ܻܳզܻח҃਋࠺ਊ੉ఀ ؘ੉ఠ׸׼੗о'MBUUFO೧ࢲݒੌ੷੢ೞҊ "33":ѐ֛হ੉5BCMFഋక۽੷੢
  ׮ٜܲ࠙਷੷੢ೠప੉࠶݅ࢎਊೞݶ೧Ѿ ࠺ਊҗդ੉ب١ীࢲ੉੼ҙܻ੄DPTUо੓૑݅ೠݺ݅Ҋࢤೞݶ

%BUB1JQFMJOF

౵੉೐ۄੋ৘द <౵੉೐ۄੋ਷ഥࢎ݃׮׮ܰѱҳࢿоמ> ೞ૑݅'JSFCBTFজؘ੉ఠחԙоҕ೧ࢲࢎਊೞחѪਸ୶ୌ ࠺ਊ੉ग IUUQTXXXTMJEFTIBSFOFU[[T[BMJUUMFCJHEBUB

ۨ౟ܻ஠ੑࢎ׼दؘ੉ఠ౵੉೐ۄੋ 3BXؘ੉ఠ ઱ਃ૑಴ 'JSFCBTFؘ੉ఠ #JH2VFSZ %BJMZ 8FFLMZ .POUIMZ Y$PMVNO .Z42-
௪ܻ࠺ਊਵ۽ਘ ׳۞աৡ੸੓਺ ؘ੉ఠ࠙ࢳਸਤೠ௪ܻ૒੽զܿ

ۨ౟ܻ஠ীࢲѐࢶೠؘ੉ఠ౵੉೐ۄੋ 3BXؘ੉ఠ 'MBUUFO5BCMF ୫৔5BCMF ઱ਃ૑಴ $PIPSU5BCMF 4PDJBM5BCMF #JH2VFSZ #JH2VFSZ #JH2VFSZ
#JH2VFSZ .Z42- 3BXؘ੉ఠ؀࠺5BCMF4J[F੉ೞ۽хࣗ 'MBUUFO5BCMF 3BXؘ੉ఠীࢲ'MBUUFOೞח௪ܻ%BJMZ+PC "JSGMPXࢎਊ աݠ૑ࢎۈٜ਷'MBUUFO5BCMFژחӒ੉ೞ5BCMFীࢲ௪ܻ ਊ۝੉੘ӝٸޙী֙஖௪ܻզ۰ب࠺ਊ੉गо੸਺ 'JSFCBTFؘ੉ఠ #JH2VFSZ <ࢎղؘ੉ఠ࠙ࢳо> <ؘ੉ఠূ૑פয>

౵੉೐ۄੋ৘द ࢲߡ۽Ӓ "844 (PPHMF4UPSBHF ($45SBOTGFS #JH2VFSZ ցޖਊ۝੉݆ਵݶ"UIFOBীࢲ௪ܻզܽറ੷੢

౵੉೐ۄੋ৘द <1VC4VC %BUBGMPX>

౵੉೐ۄੋ৘द https://www.slideshare.net/lynnlangit/google-cloud-and-data-pipeline-patterns <4USFBNJOH #BUDI>

౵੉೐ۄੋ৘द https://medium.com/teads-engineering/give-meaning-to-100-billion-analytics-events-a-day-d6ba09aa8f44 <,BGLB %BUBGMPX>

౵੉೐ۄੋ৘द https://wecode.wepay.com/posts/bigquery-wepay <"JSGMPX>

੿ܻ ೨ब਷࠙ࢳೡؘ੉ఠܳݽف#JH2VFSZীݽইفחѪ ୊਺ࠗఠച۰ೠ&5-ਸҳࢿೡ೙ਃহҊ അ੤ܻࣗझীࢲрױ൤ೡࣻ੓חѪࠗఠٜ݅Ҋ ೞաঀѐࢶ 'JSFCBTF੉߮౟۽Ӓ੿ܻ ؘ੉ఠझః݃੿ܻ
ؘ੉ఠӝ߈ਵ۽؀ചೞחޙച

1ZUIPOীࢲ#JH2VFSZࢎਊೞӝ

1ZUIPOীࢲ#JH2VFSZࢎਊೞӝ <4FSWJDF,FZࢎਊೞחߑߨ> JNQPSUQBOEBTBTQE RVFSZ4&-&$5 '30.AEBUBTFUUBCMFA EGQESFBE@HCR RVFSZRVFSZ QSPKFDU@JEQSPKFDU@JE   EJBMFDUTUBOEBSE
QSJWBUF@LFZZPVSKTPOLFZQBUI

1ZUIPOীࢲ#JH2VFSZࢎਊೞӝ <ࢲ࠺झఃহ੉64&3@"$$06/5۽ੋૐ೧ࢲࢎਊ> ੢੼4FSWJDF,FZߊә೧ࢲӂೠ઱חੌਸ($1*".ਵ۽ҙܻоמ QJQJOTUBMMQZEBUB@HPPHMF@BVUI JNQPSUQBOEBTBTQE JNQPSUQZEBUB@HPPHMF@BVUI 4$01&4< IUUQTXXXHPPHMFBQJTDPNBVUIDMPVEQMBUGPSN IUUQTXXXHPPHMFBQJTDPNBVUIESJWF
IUUQTXXXHPPHMFBQJTDPNBVUICJHRVFSZ > DSFEFOUJBMTQZEBUB@HPPHMF@BVUIHFU@VTFS@DSFEFOUJBMT 4$01&4 BVUI@MPDBM@XFCTFSWFS5SVF RVFSZ4&-&$5 '30.AEBUBTFUUBCMFA EGQESFBE@HCR RVFSZRVFSZ QSPKFDU@JEQSPKFDU@JE DSFEFOUJBMTDSFEFOUJBMT

1ZUIPOীࢲ#JH2VFSZࢎਊೞӝ < ѐੋ੸ੋ ݠन۞׬'MPX> #JH2VFSZ੄੹୊ܻಌನݢझ1ZUIPO੹୊ܻಌನݢझ #JH2VFSZীࢲ୊ܻೞӝয۰਍Ѫٜ਷1ZUIPOীࢲ <&%" ؘ੉ఠఐ࢝ >Ã Ã<1ZUIPOীࢲٜ݅ӝए਍'FBUVSF>
<#JH2VFSZীࢲٜ݅ӝए਍'FBUVSF>Ã FYPOFIPUFODPEJOH FYҗѢ੉ਊപࣻ NFBOFODPEJOH١ <QESFBE@HCR۽ؘ੉ఠ୶୹> Ã<ݽ؛݂>

ؘ੉ఠࣇҕਬೞӝ

ؘ੉ఠࣇҕਬೞӝ <ؘ੉ఠࣇਸҕਬೞҊर਷҃਋>

ؘ੉ఠࣇҕਬೞӝ <ؘ੉ఠ࠭য۽ࢸ੿ೞݶؘ੉ఠࣇইېݽٚప੉࠶੉ࠁ੐> ׮ؘܲ੉ఠࣇ਷ৈ੹൤উࠁ੐

؊ঌݶજਸղਊٜ ఃਕ٘ਤ઱ #JH2VFSZ.- 42-۽ݠन۞׬ਸೡࣻ੓਺ അ੤ ӝળ -JOFBSSFHSFTTJPO -PHJTUJD3FHSFTTJPO ,NFBOT IUUQTDMPVEHPPHMFDPNCJHRVFSZEPDTCJHRVFSZNM
IMLP #JH2VFSZ(*4 ઝ಴ؘ੉ఠܳ୊ܻೡٸਬਊ ҕҕؘ੉ఠীࢲHFPKTPO TIQ౵ੌ١ਸҳ೧ࢲప੉࠶ী֍Ҋઝ಴઱ࣗ߸ജоמ IUUQTDMPVEHPPHMFDPNCJHRVFSZEPDTHJT IMLP #JH2VFSZ%BUB5SBOTGFS (PPHMF"E.BOBHFS :PV5VCFؘ੉ఠܳ੿ӝ੸ਵ۽۽٘ IUUQTDMPVEHPPHMFDPNCJHRVFSZEPDTEUT IMLP 0QUJNJ[JOHRVFSZQFSGPSNBODF ௪ܻܳযڌѱ૞וջীٮۄؘ੉ఠоաয়חࣘبоѾ੿ IUUQTDMPVEHPPHMFDPNCJHRVFSZEPDTCFTUQSBDUJDFTQFSGPSNBODFPWFSWJFX

؊ঌݶજਸղਊٜ ఃਕ٘ਤ઱ (PPHMF$MPVE1MBUGPSN%BUBGMPX ؘ੉ఠ੹୊ܻदਬਊ4QBSLب੓૑݅%BUBGMPXبಞೣ IUUQTDMPVEHPPHMFDPNEBUBGMPX IMLP #JH2VFSZ2VPUB ೡ׼۝߂ೠب୓௼ IUUQTDMPVEHPPHMFDPNCJHRVFSZRVPUBT IMLP
4UBDLESJWFSܳࢎਊೠ#JH2VFSZݽפఠ݂ ࢎղীࢲ־о#JH2VFSZ݆ܳ੉ࢎਊೞҊ੓ח૑ഛੋ IUUQTDMPVEHPPHMFDPNCJHRVFSZEPDTNPOJUPSJOH IMLP #JH2VFSZ"DDFTT$POUSPM 3PMFীٮۄযڃ1FSNJTTJPOੋ૑ഛੋ *".җبোҙ IUUQTDMPVEHPPHMFDPNCJHRVFSZEPDTBDDFTTDPOUSPM ܾܻૉ֢౟ #JH2VFSZসؘ੉౟оݒ਋ࡅܰѱ૓೯غҊ੓਺ IUUQTDMPVEHPPHMFDPNCJHRVFSZEPDTSFMFBTFOPUFT "JSGMPX झாે݂جܾٸݒ਋જ਺($1یഐജ੉ݒ਋જ਺

୶ୌبࢲ դ੉ب੓਺ ೞ૑݅੉଼ী੓חղਊ݃झఠೞݶ  ੉ઁ׼׼൤ա42-ੜ೧ۄҊೞ࣊بؾפ׮ #JH2VFSZب੓਺ ؘ੉ఠ࠙ࢳਸ ؊֤ܻ੸ਵ۽ੜೞӝਤ೧ ੍ਵݶજ਷଼ٜ <42-ੑޙبࢲ> <42-बചبࢲ>

୶ୌ੗ܐ ߔ੿࢚ש۽Ӓӝӭաѱੜ٣੗ੋೞחߨ IUUQTXXXTMJEFTIBSFOFUKFPOHTBOHCBFLTT

୶ୌ੗ܐ ੉੤ҟש؀ਊ۝۽Ӓ࠙ࢳ #JH2VFSZ۽рױ൤ࢎਊೞӝ IUUQTXXXTMJEFTIBSFOFUPQFOTUBDLTCJHRVFSZU

੿ܻ <2VFSZ୨੿ܻ> https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#sql-syntax

੿ܻ <ৈ۞ٜ࠙੉੉۠ࢤпਸೞदݶࢿҕೠߊ಴> ੉ઁ਋ؘܻ੉ఠযڌѱࢤ҂ח૑ഛੋ೧ঠ૑ۄҊࢤп 'JSFCBTFؘ੉ఠܳ઱ӝ੸ਵ۽'MBUUFO೧ঠ૑ ੗઱ॳח௪ܻח/PUJPOীҕਬ೧ঠ૑ ؘ੉ఠূ૑פয݂ଃਸѐࢶ೧ঠ૑ ಣࣗੌೞݴҾӘೠղਊਸ௪ܻ۽૒੽૞ࠊঠ૑ ࢤࣗ೧ࢲয۵૑݅Ӓېبষ୒য۵૓ঋ਷Ѫэ׮ ؘ੉ఠӝ߈ਵ۽੉ঠӝೞחޙചٜ݅যঠ૑

੿ܻ 42-੗୓חդ੉بоए਍ಞੑפ׮ ݆੉௪ܻզܻदݶप۱੉࢚थ೤פ׮ ઺ਃೠѪ਷ ؘ੉ఠ۽؀ചೞחޙച ؘ੉ఠܳಞೞѱࠅࣻ੓חؘ੉ఠੋ೐ۄ

੿ܻ хࢎ೤פ׮

੿ܻ ॑஠7$/$ীࢲੋ੤঱ઁա଻ਊ೤פ׮ ؘ੉ఠ࠙ࢳ ؘ੉ఠূ૑פয ݠन۞׬ূ૑פয ௿ۄ੉঱౟ѐߊ੗ ࢲߡѐߊ੗١ݽف ࢚׸ਗೞदݶLZMF!TPDBSLS۽ݫੌਸ

5IBOLTUP ߊ಴੗ܐೖ٘ߔ઱न 8JSF#BSMFZೲ૓ೠש ॑஠ؘ੉ఠӒܛ੉޹਋ש

BigQuery의 모든 것(기획자, 마케터, 신입 데이터 분석가를 위한) 입문편

BigQuery의 모든 것(기획자, 마케터, 신입 데이터 분석가를 위한) 입문편

Other Decks in Technology

Featured

Transcript