Connector Improvement: S3 Amazon Connector - Delimited file use case read in
If I have a summary level file from a vendor that looks something like as follows:
Data Through Date: <timestamp here>
File Created Date: <timestamp here>
FILE1: <record count integer>
FILE2: 234
FILE3: 32
Ideally I'd like to be able to call it a headerless delimited file with ':' as the delimiter and have it read in so I can make use of this data (column_0 and column_1) along with the metadata fivetran wraps around it. Unfortunately this behavior isn't supported. I'm not sure if the spaces in front of FILE1 and so forth mess up the algorithm behind the scenes or what is occurring. I didn't see any options for leading or trailing space handling either.
-
Official comment
HI John,
This sounds like something we should be able to support already. Can you give it a try and then open a support for any issues you encounter.
Thank you
Alison
-
Hi Alison,
I did give it a try. It does error out. I don't know when I'll have a chance to test this again.
John
Please sign in to leave a comment.
Comments
2 comments