Analyze csv files with Time Series Insights

Michael Shparber 21 Reputation points
2021-11-19T21:11:22.443+00:00

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.

Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
556 questions
Azure Time Series Insights
Azure Time Series Insights
An Azure internet of things (IoT) analytics platform to monitor, analyze, and visualize industrial IoT analytics data at scale.
75 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sander van de Velde 28,236 Reputation points MVP
    2021-11-20T15:29:40.89+00:00

    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.