Thanks @anuhya-tad. The structure worked.

I am partially able to update objects that are 1 level below the tenant but still 2nd level nested objects unable to update as well as individual fields under the objects. Here is the working query for objects update except for nested 'address' object INSERT INTO final_dataset select struct ( Profil...

Not sure why but always get a job aborted error when I try nested struct. ErrorCode: 58000 Batch query execution gets : [failed reason ErrorCode: 58000 Batch query execution gets : [Failed to get results of query Reason: [Job aborted.]]]

Not working as dot(.) not allowed while defining struct ( "_Tenant.customerID"). Error : Column names can only contain alphanumeric or underscore characters]]]

I tried this already but it did not work. Receiving the error in QS " [Errors(Some(INGEST-1207-400),Some(List()),Some(A required field _Tenant.Identity of type: object is missing from the input data. Add the required field and try again.))]" At the dataset level. I see the below errors. A required f...

I need to work on a query that will fetch results of join between two temp datasets that are not profile enabled then use that resultset to insert into profile enabled dataset. There is minimal mention in the documentation which doesn't show nested objects. E.g. Query I tried below did not work Path...

Yes but this workaround is only for a particular use-case & can not be used as a foolproof solution.

We want to personalize timeseries attributes in a Marketing campaign. The above will work only in case of events I believe.

Yes. Just saw the documentation. we can not use events in personalization.Here is the linkhttps://experienceleague.adobe.com/docs/journey-optimizer/using/personalization/personalize.html?lang=en#:~:text=The%20XDM%20Individual%20Profile%20schema%20is%20the%20only%20schema%20you%20can%20use%20to%20per...

At the moment, there is no Out of the box "Control Group" functionality present in AJO. You can create a new Experience event schema (profile enabled) & insert the data using custom action. Use the condition activity to split audience & send this data to custom action The tool lacks the capability t...