добрый день! Подскажите, пожалуйста, как данные запрос можно сохранить в виде таблицы в BigQuery


select
ifnull(t1.date, t2.date) as date,
ifnull(t1.regionName, t2.regionName) as regionName,
ifnull(t1.mrf, t2.mrf) as mrf,
ifnull(t1.host, t2.host) as host,
ifnull(t1.channelGrouping, t2.channelGrouping) as channelGrouping,
ifnull(t1.source, t2.source) as source,
ifnull(t1.medium, t2.medium) as medium,
ifnull(t1.campaign, t2.campaign) as campaign,
ifnull(t1.page, t2.page) as page,
ifnull(t1.device, t2.device) as device,
ifnull(t1.sessions, 0) as sessions,
ifnull(t2.orders,0) orders

from `new_sessions_2022` t1

FULL OUTER join (select date, regionName, mrf, host, channelGrouping, source, medium, campaign, page, device, sum(orders) orders
from `new_orders_2022`
group by 1, 2, 3, 4, 5, 6, 7, 8, 9, 10) t2
USING (date,regionName,mrf,host,channelGrouping,source,medium,campaign,page,device)

group by 1,2,3,4,5,6,7,8,9,10,11,12