Analyze csv files with Time Series Insights

Question

I have several csv files I've downloaded from BugFender.
I would like to upload them to the Azure Time Series Insights.
How do I do this?
I understand I need either Event or IoT hub.
I've created one, but how do I upload there my data?
I am a BI guy, I don't really need real-time streaming, I don't have an experience in event catching.
I just want to analyze several existing csv files which are too big for a regular BI systems.
Please help, I need step-by-step guidance.

Answer 1

Hello @Michael Shparber ,

yes, TimeSeriesInsights is designed to ingest telemetry messages from stream sources.

If you only want to analyze static information, perhaps PowerBI or Azure DataBricks is a better option.

Still, it's quite simple to send CSV data to Azure Time Series Insights, even if you take the timestamps between the messages into account (sending them at the same pace as they were created).

I did exactly this during the Tech Days Flight into IoT event for a practice simulation.

Check out this C# code project where I ingest a CSV file and send each line at the right moment to an IoT Hub.

I have a description of how I have set up the environment here.

If you only want to use an EventHub, you can take a look at this code example. But, unlike the IoTHub, you have to define the TimeSeries ID yourself!

The event is available for you to watch here.