Ultimate access to all questions.
You are planning to migrate your on-premises data to BigQuery on Google Cloud, with the flexibility to either stream or batch-load data as per your needs. Additionally, you need to obfuscate certain sensitive data before the transfer. Your objective is to achieve this programmatically while keeping costs to a minimum. What is the most efficient and cost-effective approach to accomplish this task?