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