Schema
This section provides a complete list of the Schema properties you can configure in the connection settings for this provider.
| Property | Description |
| Location | A path to the directory that contains the schema files defining tables, views, and stored procedures. |
| BrowsableSchemas | This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC. |
| Tables | This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC. |
| Views | Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC. |
| TypeDetectionScheme | Determines how to determine the data types of columns. |
| Header | Indicates whether or not the first row should be used as a column header. |
| PrimaryKeyIdentifier | Set this property to control the name of the primary key. |
| DefineTables | Define the tables within the Google Spreadsheet. |
| Orientation | Indicates whether the data in the sheet is laid out horizontally or vertically. |