Hi @DiegoMo5 ,A profile schema must have a 1-M relationship with account. Please see the below screenshot of data relationship in a B2B schema relations: urlIdeally, you should be able to see it as relationship in your profile schema(s) under "personalComponents" array node, and it should also be ma...

Hi @DavidSlaw1 ,If I understand it correctly: you are attempting the whole dataset creation and insert records into the new dataset all in a single go.In that case: I will do it in 2 steps:Create dataset based on the schema: so I know the dataset/ table name beforehandIn query service, I will write ...

Hi @BReyes17 ,"productListItems" is an array object and handling null check to be checked in that fashion. I have not tried such data manipulation, however, if I may suggest to handle it in the source system itself. I know query service can handle your requirement, but not sure on the data prep side...

Hi @RS195 Query service within browser has this weird behavior among a few others. I suppose, you are better off with using Dbvisualizer or Notebook

If you try the data hygiene, it will delete from from both Profile store and identity graph along with others

Hi @SalamDa ,I have observed that "order" is a keyword in AEP, so that might cause a trouble here. Can you rename the columns in your file for e.g.- rename "commerce.order._myNameSpace.customerDetails" to "customerDetails" and then try running json_to_object. Let me know how if that works!

Hopefully this is what you are looking for! 

Hi @Pradeep-Jaiswal ,Instead of sql, try this: Look up a dataset: urlIn the query parameter `properties` use the value as: "observableSchema" - it will retrieve all the fields and their data types in nested format. Hope it helps!

Hi @gautham_madala,Normally I use python to connect with query service or I have seen some using DbvisualizerCould you please give it a try here instead of the query window inside AEP. It worked for me. Hope this resolves!

Hi @edgar_herrera At this point, I do not think it is there for Http API and encrypted ingestion is possible for only cloud storage batch sources.Hope this answers your query!