Hi @brekrut , this table I am going to use in my accelarated datstore, hence there is no particular dataset/schema I have, rather the table that I have created: CREATE TABLE purchase_line_item_test ASSELECT cast(null as string) order_number,cast(null as string) email,cast(null as string) product_hie...

Hi @brekrut , Below is a snippet of the query:The error I am getting says: no viable input 'With...' (it gives the whole query)I have tried with the "Insert" command at the beginning as well, yielding: combined_result not visibleThe resulting dataset (purchase_line_item_test) is correct and I am abl...

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?...

As I understand: "Test" was the name of the dataset as well as the underlying table and when you made the dataset changes ("Test2") the underlying table did not change. I do not see any "Alter Table" command to rename the table in Adobe Query service document(and I have not tried it myself), but you...

Thank you, the user management works for me. However, I had to retrieve all the users and then do the matching as there is no API endpoint to get a single user based on the id parameter

Hi Everyone,I am working on a requirement where it is needed to export the audience details along with a few parameters which are not available on the UI. Hence I am working on the audience export REST API as detailed here. However, the data I am seeing in postman is not getting the createdBy and mo...

It did the trick for me!

Hi All,We have created a profile-enabled profile schema (with email as primary identity) and another profile-enabled web event schema (with ENDUSERIDS._EXPERIENCE.MCID.ID as ECID : primary and ENDUSERIDS._EXPERIENCE.EMAILID.ID as email address: secondary identity).However, when ingestion occurs, the...

Hi team,We are working on a solution to extract all the audience metadata (name, description, tags, creation date etc) from AEP and share a list to the client. However, we are not able to find any REST API which shares the total number of profiles in every audience. Could you please share how we can...

Hi Team,I am looking for an understanding of using custom action vs enabling AEP destination using Experience platform in terms of analyzing a use case. If my use case is to sending out sms/push/whatsapp/twitter/facebook post, I can use custom action in AJO. However, for twitter/facebook etc there i...