A company needs to load a dataset with historical gcp video
data-practitioner video for a company needs to load a dataset with historical dates formatted as MM/DD/YYYY into BigQuery, but BigQuery's standard SQL uses
Question 1
Be Honest
Answer
Full Certification Question
A company needs to load a dataset with historical dates formatted as MM/DD/YYYY into BigQuery, but BigQuery's standard SQL uses YYYY-MM-DD format. Which approach is most efficient?