Hello @Sam,
welcome to this moderated Azure community forum.
Any IoT solution generated fast amounts of 'time-related facts'.
To store these immutable telemetry messages and query them the fastest way available, check out Azure Data Explorer.
This is a great Time-Series database, capable of both storing almost infinite amount of data and query it using a powerful query language.
If you have worked with eg. Azure monitoring, you probably have used it already. This is because all Azure resource logging and security events are stored in Azure Data Explorer.
You can start for free with Azure Data Explorer. check out this blog post about getting a free database to start with and start ingesting telemetry.
This post is part of a complete series guiding you through Azure Data Explorer.
The full Azure Data Explorer is a scalable cluster but perhaps you want to try it out first. Extra free learning material is also found in the first part of the series.
If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.