Export Segment membership to SFTP

[SantoshRa5]

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

[AnkitJasani29]

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

[SantoshRa5]

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

[AnkitJasani29]

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

[AmarapuramMahesh · Accepted solution]

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_* ))