2024-10-23 - Prototype flow for non yyyy-mm-dd dates¶
Problem¶
When prototype files are dropped into AgileData, quite often then contain date and timestamp formats that aren’t supported by BigQuery.
Solution¶
We now check every prototype file and if dd/mm/yyyy dates are detected we notify the user with a sample of the data and the fields that wont meet the data contract for ongoing production loads.
Leverage the Magic¶
We leverage the existing file_header_parser and include a check for invalid date formats (only for prorotype loads)
ADI¶
Now thats magical !
Last Refreshed¶
Doc Refreshed: 2024-11-21