You are in the process of migrating your existing on-premises data into BigQuery on Google Cloud. Depending on the specific use case, you are considering either streaming or batch-loading methods for data transfer. It is also essential to mask some sensitive data before loading it into BigQuery to ensure data security and compliance. You require a cost-effective, programmatic solution to achieve these objectives. What steps should you take?