Add Ability to Alter Column Names in Data Warehouse Export

Jeremy_Brugger

15-09-2016

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

1 Comment (1 New)
1 Comment

jeff_bloomer

22-08-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.