title: Getting an external table's location and file name?
body: <p>I'm processing multiple files as part of an external table. Is there any way I can get the file name being processed in external tables and place it in the table? </p>
  
  <p>At the moment the only solution I can find is appending the file name to every record in the flat file which isn't ideal from an efficiency standpoint and involves modifying the original data.  Surely external tables know what file is being processed at any time? </p>