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 ?