Schema
This section provides a complete list of the Schema properties you can configure in the connection settings for this provider.
| Property | Description |
| Location | Specifies the location of a directory containing schema files that define tables, views, and stored procedures. Depending on your service's requirements, this may be expressed as either an absolute path or a relative path. |
| BrowsableSchemas | Optional setting that restricts the schemas reported to a subset of all available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC . |
| Tables | Optional setting that restricts the tables reported to a subset of all available tables. For example, Tables=TableA,TableB,TableC . |
| Views | Optional setting that restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC . |
| SchemaIniLocation | Specifies the path to the folder that contains the Schema.ini file. |
| AggregateFiles | Specifies whether the provider aggregates all files with the same schema in the specified folder into a single table called AggregatedFiles . |
| MetadataDiscoveryURI | Specifies the file that the provider uses to determine the schema when aggregating multiple files into a single result set. |
| TypeDetectionScheme | Specifies how the provider determines column data types when reading text files. |
| ColumnCount | Specifies the number of columns that the provider detects when dynamically determining table columns. |
| RowScanDepth | Specifies the number of rows that the provider scans when dynamically determining table columns. |