Your team is working with transactional data from Google Sheets, a MySQL database, and CSV files in Cloud Storage. The data needs cleaning, transformation, and normalization, with duplicate removal before ingestion into BigQuery. Which approach best prepares this data for BigQuery ingestion?