Hi This seems like a pretty stupid question, but I am stumped.I am writing some queries in Adobe Experience Platform, and I want to use a string literal in a SELECT, which includes a semicolon. Something like this: select 'Test with a semicolon;' I get this error:[Code: 0, SQL State: 42601] ERROR: l...

Thanks, if you can share the postman scripts it would save me a lot of digging. Really appreciate.

Hi NN, thanks for your answer, but I am not sure I understand what you suggest. 1. I cannot use CSV here because I have arrays, which don't load well through CSV (or at least I haven't managed to load them correctly).2. The JSON - it seems this is not true: "data flow setup through UI with "add data...

Yes, thank you, that is what I am looking for. I played around a bit since I posted the question and I think it will work, exactly as you mentioned.

I am trying to load some data to populate String[] arrays in and AEP dataset.Here is my schema with 3 array String fields like below: I prepped a JSON file to load some data in a dataset based on this schema. For the same customer ID - one, two or all three of these fields might be populated. Most o...

Hi,I have a filed in one of the field groups defined as an array of objects, like shows in the image below. The field group was added to a schema, which was enabled for profile.I would like to use the above field in an audience rule, something like below:where da_for_touchpoints contains at least on...

Yes, it worked with "add". Kind of counter-intuitive, because I am not trying to "Add" but to modify, but I'll take it!

I noticed that the profile snapshot dataset profile_snapshot_export_% is refreshed once a day, approximately at the same time.My understanding is that it happens on a schedule which names looks similar: Profile-Snapshot-Export-Schedule%. I would like to modify the time when this schedule runs and be...

Sorry for the question, I am a beginner with AEP and AJO:  "Ensure this action targets your custom dataset's streaming URL." - what is the "custom dataset's streaming URL"? How can it be determined?