Pulling set of offers that have a specific custom attribute value (Treatment_type is the name of the custom attribute)

[MohanaLa]

Hi Team,

We want your insights to obtain list of offers that are having a similar value for the custom attribute column in AJO/AEP

Thanks,

Mohana.R

[Mayank_Gandhi]

@MohanaLa  you can try something like this with PQL

SELECT *
FROM decision_object_repository_personalized_offers    -- replace with actual dataset name
WHERE characteristics['customAttribute'] = 'YourValue'

 https://experienceleague.adobe.com/en/docs/experience-platform/segmentation/pql/overview

[MohanaLa]

Hi @Mayank_Gandhi ,

Thanks for replying 

I tried to query the table, but got the below error

2:14:04 AM > Query failed in 0.602 seconds

2:14:05 AM > ErrorCode: 08P01 queryId: 52db0238-21e5-4df2-bee2-a0e594e63e85 Unknown error encountered. Reason: [Table not provisioned for dataset: 666025f90a4b0d2c3208eb32 at abfss://gen1@datalakegjlipb4f078afjaf.dfs.core.windows.net/platform/666025f90a4b0d2c3208eb32. To prevent this error either add data to the dataset or specify withAutoProvisionTableEnabled(true) when calling this operation]

COuld you please help on why i am seeing this error

[Mayank_Gandhi · Accepted solution]

@MohanaLa Go to the AEP UI and check Datasets > 666025f90a4b0d2c3208eb32.If the dataset is empty (no records ingested), ingest at least one record.
Adobe Experience Platform does not create a physical table until some data is loaded.