DROP TABLE IF EXISTS ${td.database}.${td.tbl_aaa};
CREATE TABLE ${td.database}.${td.tbl_aaa} AS
SELECT
time, site, td_client_id, td_global_id, td_ssc_id
FROM
( VALUES
(TD_TIME_PARSE('2023/01/05'),'aaa.jp','aaa_001','3rd_001','ssc_001')
,(TD_TIME_PARSE('2023/01/15'),'aaa.jp','aaa_001','3rd_002','ssc_001')
,(TD_TIME_PARSE('2023/01/25'),'aaa.jp','aaa_001','3rd_003','ssc_001')
,(TD_TIME_PARSE('2023/02/05'),'aaa.jp','aaa_001','3rd_004','ssc_001')
,(TD_TIME_PARSE('2023/02/15'),'aaa.jp',NULL,NULL,NULL)
,(TD_TIME_PARSE('2023/02/25'),'aaa.jp',NULL,NULL,NULL)
,(TD_TIME_PARSE('2023/03/05'),'aaa.jp',NULL,NULL,NULL)
,(TD_TIME_PARSE('2023/03/15'),'aaa.jp',NULL,NULL,NULL)
,(TD_TIME_PARSE('2023/03/25'),'aaa.jp','aaa_002','3rd_009','ssc_002')
,(TD_TIME_PARSE('2023/04/05'),'aaa.jp','aaa_002','3rd_010','ssc_002')
,(TD_TIME_PARSE('2023/04/15'),'aaa.jp',NULL,NULL,NULL)
,(TD_TIME_PARSE('2023/04/25'),'aaa.jp',NULL,NULL,NULL)
,(TD_TIME_PARSE('2023/05/05'),'aaa.jp','aaa_003','3rd_013','ssc_003')
,(TD_TIME_PARSE('2023/05/15'),'aaa.jp','aaa_003','3rd_014','ssc_003')
,(TD_TIME_PARSE('2023/05/25'),'aaa.jp','aaa_003','3rd_015','ssc_004')
,(TD_TIME_PARSE('2023/06/05'),'aaa.jp','aaa_003','3rd_016','ssc_004')
,(TD_TIME_PARSE('2023/06/15'),'aaa.jp',NULL,NULL,NULL)
,(TD_TIME_PARSE('2023/06/25'),'aaa.jp',NULL,NULL,NULL)
) AS t(time, site, td_client_id, td_global_id, td_ssc_id);
DROP TABLE IF EXISTS ${td.database}.${td.tbl_xxx};
CREATE TABLE ${td.database}.${td.tbl_xxx} AS
SELECT
time, site, td_ssc_id, td_global_id
FROM
( VALUES
(TD_TIME_PARSE('2023/01/05'),'xxx.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/01/15'),'xxx.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/01/25'),'xxx.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/02/05'),'xxx.jp','ssc_001','3rd_004')
,(TD_TIME_PARSE('2023/02/15'),'xxx.jp','ssc_001','3rd_005')
,(TD_TIME_PARSE('2023/02/25'),'xxx.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/03/05'),'xxx.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/03/15'),'xxx.jp','ssc_001','3rd_008')
,(TD_TIME_PARSE('2023/03/25'),'xxx.jp','ssc_001','3rd_009')
,(TD_TIME_PARSE('2023/04/05'),'xxx.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/04/15'),'xxx.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/04/25'),'xxx.jp','ssc_002','3rd_010')
,(TD_TIME_PARSE('2023/05/05'),'xxx.jp','ssc_002','3rd_013')
,(TD_TIME_PARSE('2023/05/15'),'xxx.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/05/25'),'xxx.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/06/05'),'xxx.jp','ssc_003','3rd_016')
,(TD_TIME_PARSE('2023/06/15'),'xxx.jp','ssc_003','3rd_017')
,(TD_TIME_PARSE('2023/06/25'),'xxx.jp',NULL,NULL)
) AS t(time, site, td_ssc_id, td_global_id);
DROP TABLE IF EXISTS ${td.database}.${td.tbl_yyy};
CREATE TABLE ${td.database}.${td.tbl_yyy} AS
SELECT
time, site, email, td_ssc_id
FROM
( VALUES
(TD_TIME_PARSE('2023/01/05'),'yyy.jp','a@ex.com','ssc_001')
,(TD_TIME_PARSE('2023/01/15'),'yyy.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/01/25'),'yyy.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/02/05'),'yyy.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/02/15'),'yyy.jp','a@ex.com','ssc_001')
,(TD_TIME_PARSE('2023/02/25'),'yyy.jp','a@ex.com','ssc_001')
,(TD_TIME_PARSE('2023/03/05'),'yyy.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/03/15'),'yyy.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/03/25'),'yyy.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/04/05'),'yyy.jp','b@ex.com','ssc_003')
,(TD_TIME_PARSE('2023/04/15'),'yyy.jp','b@ex.com','ssc_003')
,(TD_TIME_PARSE('2023/04/25'),'yyy.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/05/05'),'yyy.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/05/15'),'yyy.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/05/25'),'yyy.jp','c@ex.com','ssc_003')
,(TD_TIME_PARSE('2023/06/05'),'yyy.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/06/15'),'yyy.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/06/25'),'yyy.jp','c@ex.com','ssc_004')
) AS t(time, site, email, td_ssc_id);
DROP TABLE IF EXISTS ${td.database}.${td.tbl_zzz};
CREATE TABLE ${td.database}.${td.tbl_zzz} AS
SELECT
time, site, td_client_id, email
FROM
( VALUES
(TD_TIME_PARSE('2023/01/05'),'zzz.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/01/15'),'zzz.jp','zzz_001','a@ex.com')
,(TD_TIME_PARSE('2023/01/25'),'zzz.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/02/05'),'zzz.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/02/15'),'zzz.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/02/25'),'zzz.jp','zzz_003','a@ex.com')
,(TD_TIME_PARSE('2023/03/05'),'zzz.jp','zzz_003','a@ex.com')
,(TD_TIME_PARSE('2023/03/15'),'zzz.jp','zzz_003','a@ex.com')
,(TD_TIME_PARSE('2023/03/25'),'zzz.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/04/05'),'zzz.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/04/15'),'zzz.jp','zzz_004','b@ex.com')
,(TD_TIME_PARSE('2023/04/25'),'zzz.jp','zzz_004','c@ex.com')
,(TD_TIME_PARSE('2023/05/05'),'zzz.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/05/15'),'zzz.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/05/25'),'zzz.jp','zzz_005','c@ex.com')
,(TD_TIME_PARSE('2023/06/05'),'zzz.jp',NULL,NULL)
,(TD_TIME_PARSE('2023/06/15'),'zzz.jp','zzz_005','c@ex.com')
,(TD_TIME_PARSE('2023/06/25'),'zzz.jp','zzz_005','c@ex.com')
) AS t(time, site, td_client_id, email);