· 8 years ago · Jul 24, 2018, 03:24 AM
1CREATE TABLE IF NOT EXISTS dataset.table
2PARTITION BY DATE(timestamp) AS
3with load as (SELECT *, _TABLE_SUFFIX as tableId
4 FROM `project.dataset.table_*`
5 WHERE _TABLE_SUFFIX BETWEEN '1' AND '1531835999999'
6 ),................
7 ...................