Add Ability to Alter Column Names in Data Warehouse Export | Community
Skip to main content
J
Jeremy_Brugger
Level 2
September 15, 2016
New

Add Ability to Alter Column Names in Data Warehouse Export

  • September 15, 2016
  • 3 replies
  • 2082 views

We have third-parties that need to ingest Analytics data with specific column names. It would be ideal if we could overwrite column names in the exports.

 

Example:

- Need to send transaction IDs, Orders, Revenue to an FTP

- However, the vendor has strict requirements that these be called ordr_id, ordr_cnt, rv_amt

    3 replies

    jeff_bloomer
    Community Advisor and Adobe Champion
    jeff_bloomerCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    August 22, 2018

    Making some general assumptions here, but I’m surprised the customer doesn’t have a more robust ETL process to facilitate the ingestion of an FTP file, regardless of column names, renaming them to whatever they need and then updating their tables accordingly.  In my mind, I would expect that to be an out-of-the-box process for a number of data management systems.  Nice idea, but it makes me wonder about the abilities, or lack thereof, the said system provides.

    jantzen_b
    Adobe Employee
    jantzen_bAdobe Employee
    Adobe Employee
    October 27, 2020
    No text available
    L
    Community Manager
    lakshaysCommunity Manager
    Community Manager
    October 5, 2022
    No text available
    Terms & ConditionsAccessibility statement

    Loading footer...