If you are building a sequential logic in audience, you will drag and drop the attributes in the screen to build your logic. However, there will be cases when you need to make a complex logic. In terms of sql, there will be times when you want to incorporate say group by, having, sub-queries etc on ...

To add one more option (nnakirikanti might have already hinted though), you can use scheduled sql job by using:Ranking by using: ROW_NUMBER() OVER (PARTITION BY ... ORDER BY ..)Limiting to 10k records: LIMIT BY 10000

This particular error code seem to be a little tricky and the message is only what you can rely upon (Solved: Re: Error code meaning --> ACTBTC-1000-400 - Adobe Experience League Community - 592453) The error says: missing data snapshot.So I would request you to check the snapshot tables and profile...

In our case, it is scheduled at weekly because the campaign is setup weekly. On top of it, the audience is used to filter out only the high value purchases, so the query can work with small and relevant records only.

paths (list) variable will give you all the attributes in the audience: # here is your audience idaudienceId = ''myseg_obj = aepp.segmentation.Segmentation()paths = myseg_obj.extractPaths(audience=audienceId, recursive=True)paths

I do not think "each attribute/ event" for an audience can be retrieved via query. You can get the segment names and people in an audience via query job.Adobe has a python package aepp (or OOB Rest API). Using aepp, you can retrieve the attribute/ events and join them together 

We have been recently working along the same line. Your options sum up the situation very correctly. My 2 cents on your proposed options Option 1: these are surely event data and TTL can be set up at dataset level (reference: Solved: Re: Setting Time to Live (TTL) for Customer Profil... - Adobe Expe...

Looks a strange issue. I do not think there is a union schema view available (except snapshot tables) - so your screenshot is something I do not understand. Please ensure that the schema/ dataset is enabled for profile prior to data ingestion. And sometimes same field names are used across field gro...

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