A retail company collects sales data from various sources, including CSV files, databases, and APIs. The company wants to load this data into BigQuery, transform it to meet reporting requirements, and keep it accessible for analytics. Which data processing approach should they use in this scenario?