This is a dedicated watch page for a single video.
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?