Azure

Process Event Hubs data to a SQL DW using Event Grid and Azure Functions

Microsoft Azure event grid integration overview

Event Hubs Capture is the easiest way to automatically deliver streamed data in Event Hubs to an Azure Blob storage or Azure Data Lake store. You can subsequently process and deliver the data to any other storage destinations of your choice, such as SQL Data Warehouse or Cosmos DB. In this tutorial, you learn how you to capture data from your event hub into a SQL data warehouse by using an Azure function triggered by an event grid.

  • First, you create an event hub with the Capture feature enabled and set an Azure blob storage as the destination. Data generated by WindTurbineGenerator is streamed into the event hub and is automatically captured into Azure Storage as Avro files.
  • Next, you create an Azure Event Grid subscription with the Event Hubs namespace as its source and the Azure Function endpoint as its destination.
  • Whenever a new Avro file is delivered to the Azure Storage blob by the Event Hubs Capture feature, Event Grid notifies the Azure Function with the blob URI. The Function then migrates data from the blob to a SQL data warehouse.

In this tutorial, you do the following actions:

  • Deploy the infrastructure
  • Publish code to a Functions App
  • Create an Event Grid subscription from the Functions app
  • Stream sample data into Event Hub.
  • Verify captured data in SQL Data Warehouse

 

https://docs.microsoft.com/en-us/azure/event-hubs/store-captured-data-data-warehouse

Tagged , , , ,

Leave a Reply