An online retailer needs to load and transform transactional data from their e-commerce platform to perform near real-time analytics on customer purchasing patterns in BigQuery. Which data pipeline approach is most appropriate to meet these requirements?