Ultimate access to all questions.
A data engineer has implemented a data pipeline to ingest data from a JSON source utilizing Auto Loader. However, the pipeline lacks type inference or schema hints. Upon inspection of the ingested data, the data engineer observed that all columns in the resulting target table are of the string data type, even though some fields actually contain only float or boolean values. What is the reason that Auto Loader has inferred all columns as string types?