Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Add Ability to Alter Column Names in Data Warehouse Export

Avatar

Avatar
Validate 1
Level 2
Jeremy_Brugger
Level 2

Likes

5 likes

Total Posts

25 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
Jeremy_Brugger
Level 2

Likes

5 likes

Total Posts

25 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
Jeremy_Brugger
Level 2

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

2 Comments

Avatar

Avatar
Springboard
Level 6
jeff_bloomer
Level 6

Likes

137 likes

Total Posts

218 posts

Correct Reply

14 solutions
Top badges earned
Springboard
Validate 10
Validate 1
Contributor
Shape 1
View profile

Avatar
Springboard
Level 6
jeff_bloomer
Level 6

Likes

137 likes

Total Posts

218 posts

Correct Reply

14 solutions
Top badges earned
Springboard
Validate 10
Validate 1
Contributor
Shape 1
View profile
jeff_bloomer
Level 6

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.

Avatar

Avatar
Springboard
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

331 likes

Total Posts

2,247 posts

Correct Reply

811 solutions
Top badges earned
Springboard
Validate 500
Validate 250
Validate 100
Validate 50
View profile

Avatar
Springboard
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

331 likes

Total Posts

2,247 posts

Correct Reply

811 solutions
Top badges earned
Springboard
Validate 500
Validate 250
Validate 100
Validate 50
View profile
jantzen_belliston-Adobe
Community Manager

27-10-2020

 
Status changed to: Archived