Insert into dataset based on CTE

[supratim320]

Hi Team,

We are working on a particular usecase where a query using "WITH" clause need to be inserted into a dataset which will be used at a later point in time. I have run the "select" clause successfully, however, the "Insert" command is not working in the script. Has anyone tried any such usecase? Curious to know your take on this!

Thank you!

[brekrut]

you should be able to insert into a dataSet but you need to follow the struct syntax of the schema which you are inserting data into.

Please refer to the following page as reference:

https://experienceleague.adobe.com/en/docs/experience-platform/query/sql/syntax#insert-into

what is the error message is your getting?