autoloader schema inference date column
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-04-2022 06:10 AM
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?
Labels:
- Labels:
-
Autoloader
-
Data Column
-
Schema
0 REPLIES 0