Code is describing how to transfer data from from csv file to Time Series Insight.
The scenario is as follows:
- User has data in csv format stored in blob
- User has access to that blob with SAS token
- Application downloads csv blob, translates it to JSON format
- Application sends JSON data to EventHub.
- EventHub is connected to Time Series Insight as event source.
- Data finaly lands in Time Series Insight.
Before executing this code user should have Time Series Insight environment set up together with EventHub connected to that TSI.
Useful links about creating and configuring Time Series Insight and EventHub
- https://docs.microsoft.com/en-us/azure/time-series-insights/time-series-insights-get-started
- https://docs.microsoft.com/en-us/azure/event-hubs/event-hubs-create
- https://docs.microsoft.com/en-us/azure/time-series-insights/time-series-insights-how-to-add-an-event-source-eventhub
This code is based on Microsoft tutorial:
NuGet packages used in solution:
In Program.cs, Main method fill proper values in below code:
var eventHubUrl = "< your endpoint url goes here >";
var sasUrl = "< sas url goes here >";
var blobName = "< csv blob name goes here >";eventHubUrl is an Url taken from EventHub settings in Azure Portal
sasUrl is an Url with access token to container where CSV blob is stored
blobName is a name of CSV file together with extension
Downloading of content of CSV file is provided by below code
var container = new CloudBlobContainer(new Uri(sasUrl));
var blockBlob = container.GetBlockBlobReference(blobName);
var csvString = blockBlob.DownloadText();Translation from CSV to JSON is made with external ChoETL library available as NuGet package.
try
{
string jsonResult;
using (var p = new ChoCSVReader(new StringReader(csvContent)).WithFirstLineHeader().WithDelimiter(delimeter))
{
using (var stringWriter = new StringWriter())
{
using (var w = new ChoJSONWriter(stringWriter))
{
w.Write(p);
}
jsonResult = stringWriter.ToString();
}
}
return jsonResult;
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}Sending to EventHub part is provided by external library WindowsAzure.ServiceBus wrapped here in separate class.
private readonly EventHubClient _eventHubClient;
public EventHubManager(string eventHubConnectionString)
{
_eventHubClient = EventHubClient.CreateFromConnectionString(eventHubConnectionString);
}
/// <summary>
/// Sends json string to event hub.
/// </summary>
/// <param name="json">string json</param>
public void SendJson(string json)
{
using (var ms = new MemoryStream())
using (var sw = new StreamWriter(ms))
{
sw.Write(json);
sw.Flush();
ms.Position = 0;
var eventData = new EventData(ms);
_eventHubClient.Send(eventData);
}
}