Fine-Tuning Data Access
Fine Tuning Data Access
You can use the following properties to gain greater control over Azure Cosmos DB API features and the strategies the connector uses to surface them:
- RowScanDepth: This property determines the number of rows that will be scanned to detect column data types when generating table metadata.
- TypeDetectionScheme: This property allows more control over the strategy implemented by the RowScanDepth property.
-
GenerateSchemaFiles: This property enables you to persist table metadata in static schema files that are easy to customize, to persist your changes to column data types, for example.
You can set this property to "OnStart" to generate schema files for all tables in your database at connection. Or, you can generate schemas as you execute SELECT queries to tables.
The resulting schemas are based on the connection properties you use to configure Automatic Schema Discovery
To use the resulting schema files, set the Location property to the folder containing the schemas.