Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
arpan-garg
arpan-gargAccepted solution
Community Advisor
Jan 26, 2024 1:06 PM UTC

I know it is silly doubt, but 
Where will I get source_namespace and segmentMembership



Hi @arun_97  - You don't need to get source_namespace and segmentMembership. Just enter the query on the query canvas by replacing the correct dataset name and then you can see the results.

 

Adding a screenshot for your reference. Notice the query, i didn't change source_namespace and segmentMembership

 

Thanks,

Arpan

 

View in thread

9 replies

arpan-garg
Community Advisor
arpan-gargCommunity Advisor
Community Advisor
Jan 24, 2024 3:59 PM UTC

Hello, @arun_97 ,

A profile snapshot is system generated dataset which is generated daily in AEP, providing information about the unified profile. To access it, navigate to the list of datasets in AEP, where you'll find the profile snapshot. I've attached a screenshot for your reference.

 

 

 

Thanks!

 
 
 
Translate
    arun_97Author
    Level 2
    Jan 25, 2024 3:17 AM UTC

    Thanks!, @arpan-garg 

    Could you please tell me source_namespace and audiencemembership in AEP.

    Translate
    arpan-garg
    Community Advisor
    arpan-gargCommunity Advisor
    Community Advisor
    Jan 25, 2024 7:48 AM UTC

    Hello@arun_97 ,

     

    The document contains some errors because audience membership is no longer relevant. Instead, you should use segment membership. The key column, as explained in the query, is source_namespace, present in the table.

    The corrected query is as follows:


    SELECT
    CONCAT_WS('-', key, source_namespace) AS audience_id,
    COUNT(1) AS count_of_profiles
    FROM
    (
    SELECT
    UPPER(key) AS source_namespace,
    EXPLODE(value)
    FROM
    (
    SELECT
    EXPLODE(segmentMembership)
    FROM
    <correct_dataset_name>
    )
    )
    GROUP BY
    audience_id;

    Please replace `<correct_dataset_name>` with the actual name of the dataset.

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...