Resource location

The URI should be used to specify a CSV resource location. Set the URI property to specify one of the following sources:

• An empty value automatically assigns the URI to a reference to the current directory, "./". The explicit path to the CSV folders depends on the environment of the running application.
• A path to a folder.
• A path to a file or stream - in this case you can query the file by executing SELECT * FROM streamedtable.

Modeling tables

Set the following properties to control how the provider models CSV as tables:

• IncludeColumnHeaders: Set this to get column names from the first line of the specified files (the default). Otherwise, the column names are the column numbers.
• FMT: Set this to the format to be used to parse the text files: CsvDelimited (the default) or TabDelimited.
• IncludeFiles: Set this to a comma-separated list of file extensions to include into the set of files modelled as tables. (By default, .txt, .tab, and .csv files are modelled.)
• RowScanDepth: Set this to automatically determine data types by scanning rows up to the specified depth.