


Hi Team,
Can someone please help me with the SQL query to retrieve all the profile ID's for a specific segment?
By using the query below, I can target my specific segment but not retrieve details from it.
SELECT * from TableName
where segmentName = "segment name";
Solved! Go to Solution.
Views
Replies
Sign in to like this content
Total Likes
Hi @anuhya-tad , @Anil_Umachigi ,
There is a profile-snapshot-export dataset for each merge policies created within the environment (including the default one). To understand which merge policy a profile-snapshot-export dataset refers to, There is a mapping dataset that associates all the existing merge policies to the each profile-snapshot-export dataset called ”adwh_dim_merge_policies”.
You can query "select * from adwh_dim_merge_policies" and get the details of snapshot data sets.
Thanks
Amit
@shubham10 are you looking to get all profiles part of a certain AEP segment created? if yes you have two ways to get this info
AEP segments are not in a dataset and do not store profile id's, they do not behave like a dataset used to store xdm data.
Hope this helps
Anil
Views
Replies
Sign in to like this content
Total Likes
@shubham10 Try this query
select * from profile_snapshot_export_XXXXX where segmentmembership['ups']['195329af-1df-49f0-993a-4d3495132e6'].status IN ('realized', 'existing','exited')
Note: replace profile_snapshot_export dataset name, segment id in the query as per the system you are using.profile_snapshot_export dataset is system generated one, you can find these by enabling show system datasets from UI.
Hey @anuhya-tad Is this dataset created by default? i.e a snapshot of profile into a dataset or a manual creation?
Does the data get updated every day on schedule?
Thank you for sharing this.
anil
Views
Replies
Sign in to like this content
Total Likes
@Anil_Umachigi PFB answers
Q)Is this dataset created by default?
A)yes, system generated . snapshot of profile into a dataset .
Q)Does the data get updated every day on schedule?
A)Yes, once per day
Perfect thank you! is there any documentation link which lists details of all the system generated dataset? I cannot find any 😞
Thank you again sharing here 🙂
Views
Replies
Sign in to like this content
Total Likes
Gained above knowledge from Adobe support team when interacted on an issue.
right ok! Thanks again 🙂
Views
Replies
Sign in to like this content
Total Likes
Hi @anuhya-tad , @Anil_Umachigi ,
There is a profile-snapshot-export dataset for each merge policies created within the environment (including the default one). To understand which merge policy a profile-snapshot-export dataset refers to, There is a mapping dataset that associates all the existing merge policies to the each profile-snapshot-export dataset called ”adwh_dim_merge_policies”.
You can query "select * from adwh_dim_merge_policies" and get the details of snapshot data sets.
Thanks
Amit
This is great info! Thank you for sharing @AmitRaghuwanshi
Views
Replies
Sign in to like this content
Total Likes