Export Dataset without PII Data | Community
Skip to main content
T
trojan_horse
Level 3
March 21, 2025
Question

Export Dataset without PII Data

  • March 21, 2025
  • 4 replies
  • 940 views

Hi,

 

I have an urgent request and would appreciate a quick response.

 

I'm trying to export a dataset from AEP to a third-party system (Azure Blob/S3/SFTP). The records in these datasets contain PII data, and I cannot select which fields to activate for the destination, as that option is not available in AEP. How can I export the datasets and all the records while skipping the activation of the PII fields?

 

I understand I can label the fields and create a governance policy to restrict activation, but will that restrict the activation of the entire record or just the specific field?

 

Thanks!

4 replies

NickMannion
Community Advisor
NickMannionCommunity Advisor
Community Advisor
March 24, 2025

Have you tried us Access and data usage labels in a development environment and then generating an output file and seeing if the PII attributes are populating in that file?

    T
    trojan_horseAuthor
    Level 3
    March 27, 2025

    Yeah I tried it, and the output file does contain the PII fields

    GigiCotruta
    GigiCotruta
    Level 4
    April 7, 2025

    I suggest you the following thing: 

    1. Create a new dataset
    2. Use query services and copy from your original DS all the info you want to export to the destination. Make sure to use the same schema for this newly created dataset.
    3. Export the newly created dataset.
      GigiCotruta
      GigiCotruta
      Level 4
      April 7, 2025

      If you need to export on a daily basis for example, you can schedule the query to run 1 hour before the export so it will always have the updated data.

        T
        trojan_horseAuthor
        Level 3
        April 7, 2025

        Don't we need data distiller for this? We don't have license for data distiller

        kautuk_sahni
        Community Manager
        kautuk_sahniCommunity Manager
        Community Manager
        April 8, 2025

        @trojan_horse Did you find the suggestions helpful? Please let us know if you need more information. If a response worked, kindly mark it as correct for posterity; alternatively, if you found a solution yourself, we’d appreciate it if you could share it with the community. Thank you!

        Kautuk Sahni
        kautuk_sahni
        Community Manager
        kautuk_sahniCommunity Manager
        Community Manager
        July 2, 2025

        @trojan_horse Just checking in — were you able to resolve your issue?
        We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

        Kautuk Sahni
        Terms & ConditionsAccessibility statement

        Loading footer...