We have 3 regional intake tables partitioned by date and a client-view table partioned by date and region. is there a way to populate the client-view table with data from the 3 source tables in one atomic transaction instead of three separate insert commands: currently we do multiple insert statement like: insert into client_view_tbl
(
col, col2, col3...
)partition(cobdate='20240915', region='region1')
select col2, col2, col3... from region1_table where cobdate='20240915';
insert into client_view_tbl
(
col, col2, col3...
)partition(cobdate='20240915', region='region2')
select col2, col2, col3... from region2_table where cobdate='20240915';
insert into client_view_tbl
(
col, col2, col3...
)partition(cobdate='20240915', region='region3')
select col2, col2, col3... from region3_table where cobdate='20240915';
... View more
