S3 Connector file ingest without header row
CS Rules & Permissions
The field mapping for an S3 Connector file ingest currently requires the first row of the csv to be a header row with the column name for mapping. It would be great if there was an option to uncheck header row and just map on column number.
Use Case: From our data warehouse we have to write custom SQL for every unload to S3 in order to add this header row. Our BI tool allows for scheduling report output to S3 but does not include a header row. Maintenance would be drastically reduced if had this functionality from Gainsight so that we could manage data pushes from a report instead of custom SQL.
Use Case: From our data warehouse we have to write custom SQL for every unload to S3 in order to add this header row. Our BI tool allows for scheduling report output to S3 but does not include a header row. Maintenance would be drastically reduced if had this functionality from Gainsight so that we could manage data pushes from a report instead of custom SQL.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Thanks for posting your idea on this!!
We did receive same request a few months ago and at that time, we did not consider this flexibility because data Integration mapping is tightly bound to the order of the columns in the file. While generating the file in your DW, if the order of the column is changed, It is hard to diagnose the data quality issues!
While I can't give you an ETA, we will certainly revisit this flexibility (may be with some caveats like order + data type match ) as part of our S3 connector V2, which is in our roadmap.
S3 file ingest without a header row is on our roadmap items list
where we would have to options:
a)File has headers
b)File does not have headers(order of columns will be considered)
Will keep you posted on the ETA and try to deliver this in spring
Thanks and Regards,
Lakshmi
Spring release--it would mean a world of difference for my organization. Please keep me updated.
Sure! Will keep you updated on the progress
Thanks and Regards,
Lakshmi