I have the scenario where I need to load set of files(similar schema) from S3 bucket to snowflake table. I am trying to use tDBOutputBulkExec for this. The destination table should have two fields like File_Name (Varchar), Content (Varchar). I do I get the file name which I am processing using tDBOutputBulkExec to snowflake table?
