https://community.databricks.com/t5/data-engineering/autoloader-schema-inference-date-column/m-p/26401#M18464 <P>I have hire_date and term_dates in the "MM/dd/YYYY" format in underneath csv files. Schema hint "cloudFiles.schemaHints" : "Hire_Date Date,Term_Date Date" - push data into _rescued_data column due to conversion failure. I am looking out solution to cast the data types properly into bronze tables itself. possible to use to_date functions / generic expressions in schema hints to cast to date or it has to be done outside of autoloader coludfile options?</P> Fri, 04 Mar 2022 14:10:40 GMT shrikant_kulkar 2022-03-04T14:10:40Z https://community.databricks.com/t5/data-engineering/autoloader-schema-inference-date-column/m-p/26401#M18464 <P>I have hire_date and term_dates in the "MM/dd/YYYY" format in underneath csv files. Schema hint "cloudFiles.schemaHints" : "Hire_Date Date,Term_Date Date" - push data into _rescued_data column due to conversion failure. I am looking out solution to cast the data types properly into bronze tables itself. possible to use to_date functions / generic expressions in schema hints to cast to date or it has to be done outside of autoloader coludfile options?</P> Fri, 04 Mar 2022 14:10:40 GMT https://community.databricks.com/t5/data-engineering/autoloader-schema-inference-date-column/m-p/26401#M18464 shrikant_kulkar 2022-03-04T14:10:40Z