This is a dedicated watch page for a single video.
You are processing structured JSON logs from Cloud Storage and need to ingest them into BigQuery. Some columns must be converted to a consistent data type (e.g., UTC timestamps), and unnecessary columns should be filtered out to optimize storage and processing. Which tool and configuration would be most efficient for preparing this data before ingestion?