A company needs to regularly move large datasets from an on-premises SQL database to BigQuery and transform the data to meet reporting requirements. They want the transformation to occur in BigQuery to leverage its scalability for complex analytics. Which approach should they use for this data pipeline?