Real-Time Insights: Building a Medallion Architecture for Formula 1 Telemetry with Azure Data Explorer
Here is the medallion architecture for the telemetry data:
- Forza Mortorsport - Xbox or PC (included with XBox Game Pass)
- .NET 8
- Forza-Telemetry-Bridge (https://github.com/clemensv/forza-telemetry-bridge)
- I added some additional telemetry channels, so demo is based on my fork (https://github.com/calloncampbell/forza-telemetry-bridge)
- Azure Subscription (sign up for free)
- Azure Data Explorer (get a free personal cluster)
- Download the Forza-Telemetry-Bridge and follow its installation and configuration.
- Configurat Forza Mortorsport and go into Settings and enable the UDP Telemetry.
- Create a free Azure Data Explorer Cluster and create a new database.
- Run the KQL scripts from this repository to create the tables, functions and materialized views.
- Create an Azure Data Explorer Dashboard. There is a dashboard file in this repository, just import it and update the data source accordingly.
- Run the Forza-Telemetry-Bridge console application.
- Start a race.
- Analyze your results.
Here is a video I published for one of my racing sessions and then displaying the results in a real-time dashboard: https://youtu.be/3URkoaY6ogc