Slide 37
Slide 37 text
37
差分確認はSQL で実施
WITH
table1 as (
SELECT col1, col2, col3 FROM foo.bar1
),
table2 as (
SELECT col1, col2, col3 FROM foo.bar2
),
except_table as (
SELECT “comp_dist”, * FROM (SELECT * FROM table1 EXCEPT
DISTINCT SELECT * FROM table2)
UNION ALL
SELECT “comp_source”,* FROM (SELECT * FROM table2 EXCEPT
DISTINCT SELECT * FROM table1)
)
SELECT * FROM except_table
差分が一目瞭然
オンプレテーブル
クラウドテーブル