Schema
This section provides a complete list of the Schema properties you can configure in the connection string 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 . |
| BrowsableCatalogs | Optional setting that restricts the catalogs reported to a subset of all available catalogs. For example, BrowsableCatalogs=CatalogA,CatalogB,CatalogC . |
| 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 . |
| RefreshViewSchemas | Specifies whether the provider should automatically refresh view schemas by querying the views directly. |
| ShowTableDescriptions | Specifies whether table descriptions are returned through platform metadata APIs and system views like sys_tables and sys_views. |
| PrimaryKeyIdentifiers | Specifies rules for assigning primary keys to tables. |
| AllowedTableTypes | Specifies which types of tables are visible when listing tables in the dataset. |
| FlattenObjects | Specifies whether STRUCT fields in Google BigQuery are flattened into individual top-level columns. |