Skip to main content
SantoshRa5
Level 3
Sep 16, 2025 5:26 PM UTC
Solved

Export Segment membership to SFTP

Hi Community,

I want to export segment name to SFTP. I find segment name in union schema 

as  "xdm:timeSeriesEvents.segmentList.segmentName".. When I export I get null. Please suggest how can i get multiple segment name for same profile.
 
Thanks in advance
Regards
 
 
 
AmarapuramMahesh
AmarapuramMaheshAccepted solution
Level 2
Sep 22, 2025 4:04 PM UTC

Hi,
As I understand, you can create a CTAS (Create Table As Select) statement by referencing the profile snapshot table and applying the required conditions. Please update the identity value as needed for your specific use case. This approach will provide all segment IDs associated with each profile. If you also need the segment names, you can join this table with the segment definition snapshot table.
The following query extracts the email address and associated segment IDs from the profile snapshot table:
select email, key from(

SELECT workEmail.address as email ,EXPLODE(segmentMembership.ups)
FROM profile_snapshot_export_* ))

View in thread

7 replies

AnkitJasani29
AnkitJasani29
Level 6
Sep 17, 2025 5:32 AM UTC

Hi @santoshra5 ,

You can export ids and map to names outside AEP or via Query Service you can ingest segment definition metadata into a dataset and export it to SFTP.

Thanks,

Ankit

 

Translate
    SantoshRa5Author
    Level 3
    Sep 17, 2025 9:38 AM UTC

    Hi Ankit,

    Thanks for reply.

    I am exporting other profile attributes as well with segment defemination, and want it iin attribute mapping. Cant I get this while mapping.

    Approach you suggesting is to create a temp table, extract segment name from "profilesnapshot" table, ingest into temp.and refresh it. please confirm.. 

     

    Thanks in advance.

    Regards,

    Santosh

    Translate
    AnkitJasani29
    AnkitJasani29
    Level 6
    Sep 17, 2025 1:40 PM UTC

    Hi @santoshra5 ,
    As far as I know, you cannot fetch segmentName directly through attribute mapping. To achieve this, you need to enrich the data (Example: using Query Service) by joining segmentMembership IDs with the segment definition metadata, and then export the enriched dataset.

    Thanks,

    Ankit

    Translate
      AmarapuramMahesh
      AmarapuramMaheshAccepted solution
      Level 2
      Sep 22, 2025 4:04 PM UTC

      Hi,
      As I understand, you can create a CTAS (Create Table As Select) statement by referencing the profile snapshot table and applying the required conditions. Please update the identity value as needed for your specific use case. This approach will provide all segment IDs associated with each profile. If you also need the segment names, you can join this table with the segment definition snapshot table.
      The following query extracts the email address and associated segment IDs from the profile snapshot table:
      select email, key from(

      SELECT workEmail.address as email ,EXPLODE(segmentMembership.ups)
      FROM profile_snapshot_export_* ))

      Translate
      SantoshRa5Author
      Level 3
      Oct 14, 2025 8:01 AM UTC

      Hi @amarapurammahesh @community 

      I am exporting segment membership data like segment id and segment status. 

      below query work for segment id.

       

      SELECT workEmail.address as email ,EXPLODE(segmentMembership.ups)
      FROM profile_snapshot_export_* ))

       

      Can I fetch both segment id and segment status like "realized", "exited" and "existing" from profile snapshot ?

      As segmember ship is a map, it's structure is below witj segment id and status.

       

      "[1fa554b4-927c-4f99-8fe3-475e21aa4 ->
      ""(NULL,realized,2025-07-17 00:13:27.0)"",
      47e09883-5044-4095-8240-04c83652e ->
      ""(NULL,exited,2025-08-05 01:05:32.0)"",
      052a30a0-5963-4f78-b1c3-ca51318b1 ->
      ""(NULL,existing,2025-07-17 00:13:27.0)]"
       
       
      Translate
      brekrut
      Adobe Employee
      brekrutAdobe Employee
      Adobe Employee
      Oct 14, 2025 12:50 PM UTC

      When exporting segment membership to a batch destination you will need to enter the following text:

       

      • segmentMembership.seg_namespace.seg_id.status
      • segmentMembership.seg_namespace.seg_id.lastQualificationTime

      Please refer to the following article

      https://experienceleague.adobe.com/en/docs/experience-platform/destinations/ui/activate/activate-batch-profile-destinations#known-limitations

      Translate
      SantoshRa5Author
      Level 3
      Oct 14, 2025 1:15 PM UTC

      Hi Brekrut,

      Thanks for the response.

      I have already tired this and always got blank values. I am creating a scheduled query to fetch segementid , segmentName and segment status from profilesnapshot and segmentsnapshot and storing it in profile and upsert enabled dataset.

      I am struggling to fetch segment status only which is inside a "segmentMembership.ups" map object. Could you please suggest how to get segment status. ?

      Regards,

      Santosh.

       

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...