Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
Register Here

Add Ability to Alter Column Names in Data Warehouse Export

Avatar

Jeremy_Brugger
Level 2

9/15/16

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 Comments

Avatar

jeff_bloomer
Community Advisor

8/22/18

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.

Reply