Have hit a snag when trying to setup a Ozzie workflow with combination of CTE and Insert Statement, not sure why, please help me look at the code, thanks.
insert into table A partition(date)
with test as
(select col1 as name1 , col2 as name2, col3 as name3 from table B),
select * from test