Insert Into Multiple Partitions with one Query 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';
