but I can't seem to leverage that along with the TEXTTABLE function to provide a usable query... any other thoughts?

add encoding as "UTF-8-BOM" in the file translator override property -------------------------------------------------------------------- Key: TEIID-4340 URL: https://issues.jboss.org/browse/TEIID-4340 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Affects Versions: 8.7.8.6_2 Reporter: Debbie Steigner Priority: Trivial Fix For: Open To Community it will be good if teiid supports Encoding to "UTF-8-BOM" since other middleware technologies supports similar to this and also even editor such as Notepad++ supports to convert / save file as "UTF-8-BOM". Currently we have added Translator override for File to include "Encoding Property to UTF-8" so similarly we should be able to set it to "UTF-8-BOM" , instead of writing code manually to add BOM to generate a file.