Expand my Community achievements bar.

SOLVED

Regarding AEP Queries features.

Avatar

Level 1

Can we use queries to fetch segment's all attributes in AEP ?.

and I also find some auto suggested table name in Queries like (segment_ingestion_dataset, segment_export_dataset)

where does it come from as there is no such dataset present with this names.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@InfyAshu : These are system generated datasets, you can find these by enabling show system datasets from UI. 

Capture.PNG

 

Could you please elaborate  below question, what are you looking exactly. 

"Can we use queries to fetch segment's all attributes in AEP ?"

View solution in original post

5 Replies

Avatar

Correct answer by
Community Advisor

@InfyAshu : These are system generated datasets, you can find these by enabling show system datasets from UI. 

Capture.PNG

 

Could you please elaborate  below question, what are you looking exactly. 

"Can we use queries to fetch segment's all attributes in AEP ?"

Avatar

Level 1

Using API, I want to do below

  1. Get the list of profiles qualified in a segment.

  2. Delete a specific profile from this list.

  3. Fetch the record details of the profile.

 

Avatar

Community Advisor

@InfyAshu  check out below details.

 

Get the list of profiles qualified in a segment.

Note: replace profile_snapshot_export dataset name, segment id in the query as per the system you are using

Delete a specific profile from this list.

Fetch the record details of the profile.

Note:replace profile_snapshot_export dataset name, column name in the query as per the system you are using

 

 

Avatar

Level 1

On your third note of above reply i.e.

Fetch the record details of the profile.

 

I am able to fetch the details of single profile using select query but when I try to delete a profile using delete query

It is throwing an error (ErrorCode: 42601 Syntax error encountered. Reason: [Invalid command!])

 

InfyAshu_0-1668054582699.png

 

Avatar

Community Advisor

deleting single profile is not possible but using Profile system jobs endpoint, data from profiles can be deleted which are part of a batch, checkout  https://experienceleague.adobe.com/docs/experience-platform/profile/api/profile-system-jobs.html?lan...