Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

S3 Object Prefix (File extension issue)

I have a staging table - Account and I am trying to load a text file (Delimited by Pipe) from S3.
This is a text file (.TXT)
But I do not see it on the screen. It's name is Account. But when you right click it and see properties, you will it's .TXT extension.

Whenever I try to enter Account.txt in S3 Object Prefix, the job failes with an error saying the file does not exist in specified location.

But when I enter only Account in S3 Object Prefix, the job run successfully.

Is there a way to get around this issue or is it a standard response from the tool ?

1 Community Answers

Matillion Agent  

Ian Funnell —

Hi Nachiket,

You be able to browse for a .txt file using the S3 Load Generator even if it’s really a pipe-delimited CSV. The S3 Load Generator does not check the suffix.

I’ve emailed you an example Matillion job which does this, along with the sample file used in the job.

Best regards,

Post Your Community Answer

To add an answer please login