File Formats for Reading
You can read a variety of file types. The Extensible Common Data framework parses these into rows in a stream or table.
Column names are used to derive the format of all column set types in the Extensible Common Data Adapter. Data formats are always derived from column names. You always declare columns in the foreign stream and those columns are always available to queries.
If you do not have information about the file format to be read, or need help filling in foreign stream or agent properties for a file format, you can use the Discovery parser to determine information about a file's format. This parser reads a sample of the file and returns information on file format options. Currently, the Discovery parser works for CSV, XML, and JSON files.
Currently supported file types are: