Slide 21
Slide 21 text
Copyright © ZOZO Technologies, Inc. All Rights Reserved.
Copyright © ZOZO Technologies, Inc. All Rights Reserved.
σʔλϚʔτͷࠩߋ৽Λႈʹ
wΓ͍ͨ͜ͱ
ूܭΫΤϦͷ࣮ߦ݁ՌΛಛఆͷςʔϒϧʹ࣍Ͱग़ྗͯ͠ੵΈ্͛ςʔϒϧʹ
w❌ႈͰͳ͍ྫ
# INSERT INTO SELECTのBigQuery版
query("集計クエリ", destination_table: 'table_name', write: 'append')
w⭕ႈͳྫ
table_yesterday = table('table_name_20181201')
table_yesterday.copy('table_name_20181202')
table_today = table('table_name_20181202')
query("集計クエリ", destination_table: 'table_name_20181202', write: 'append')
table_today.copy('table_name')
UBCMF@OBNF@ UBCMF@OBNF@ UBCMF@OBNF
ᶃDPQZ ᶅDPQZ
ᶄBQQFOE