You’re importing CSV files from Cloud Storage into BigQuery. These files have known data quality issues, such as mixed data types in the same column (e.g., STRING and INT64) and inconsistent formatting (like varying address and phone number formats). What’s the most effective way to design a pipeline that cleans, transforms, and enforces data quality?