database-engineer-pro video for you are a Database Engineer working on a project that requires data synchronization between a Firestore database and a BigQuery
You are a Database Engineer working on a project that requires data synchronization between a Firestore database and a BigQuery dataset. The synchronization should be performed in real-time, and the data should be transformed into a denormalized format before being inserted into BigQuery. Which of the following options is the most appropriate solution to achieve this goal?