Watch this video on YouTube
A data engineer needs to ingest a CSV file containing product data into BigQuery, but the file has inconsistent date formats (some dates are MM/DD/YYYY, others are DD-MM-YYYY). What is the most efficient way to handle this during ingestion?