Hi Everyone,We have created a schema which contains an array type node and in this array there are columns such as SKU, price, productname, quantity etc. We will have to ingest data into this dataset via query service. So we have created multiple CTEs to get what we needed: This is how we form the n...

Hi All,This is a follow up to my previous post . During the insert from query service, I realized there are some ill-formatted emails in my source data. This is causing a failure of the whole batch and nothing gets inserted. Using the source/direct file upload into a dataset, we can handle such scen...

I think I did the incorrect way.Right one:INSERT INTO purchase_line_item_testWith combined_result AS (SELECT "Order Number" , valid_profiles.email_address as "Email" , "Product Hierarchy Code" , "Product Name" , "Quantity" , "Price" , "SKU" FROM purchases)SELECT "Order Number", "Email, "Product Hier...

There is a python based library aepp, this might be helpful in your case(I think you are looking to fetch all the datasets). This library parses all the records and passes the final result. See if this helps you:Github: https://github.com/adobe/aepp/blob/main/aepp/catalog.py

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