ADO.NET provider for JSON / Schema Discovery / Getting started with automatic schema discovery
Getting started with automatic schema discovery

Automatic schema discovery is a useful feature that allows for accurate data type assignment to individual columns within a dataset, especially when the data source is a local file.

When a provider uses a local file as its data source and doesn't have a manual API_config for column data types, each column is treated as a string data type by default. This approach is used because it can accommodate all data types and allows for flexibility in casting the data to preferred types at a later stage.

 

To enable automatic schema discovery, it is important to configure two essential connection string parameters:

1. DetectionScheme

2. RowsToScan