Edit

Share via

Quickstart: Create a Stream Analytics job by using the Azure portal

  • Article

In this quickstart, you create a Stream Analytics job in the Azure portal. You define a Stream Analytics job that reads real-time streaming data and filters messages with a temperature greater than 27. The Stream Analytics job reads data from IoT Hub, transforms the data, and writes the output data to a container in an Azure blob storage. The input data used in this quickstart is generated by a Raspberry Pi online simulator.

Prerequisites

If you don't have an Azure subscription, create a free account.

Prepare the input data

Before defining the Stream Analytics job, you should prepare the input data. The real-time sensor data is ingested to IoT Hub, which later configured as the job input. To prepare the input data required by the job, complete the following steps:

  1. Sign in to the Azure portal.

  2. Select Create a resource. On the Create a resource page, select Internet of Things > IoT Hub.

    Screenshot showing the IoT Hub menu on the Create a resource page.

  3. On IoT Hub page, follow these steps:

    1. For Subscription, select your Azure subscription.
    2. For Resource group, select an existing resource group or create a new resource group.
    3. For IoT hub name, enter a name for your IoT hub.
    4. For Region, select the region that's closest to you.
    5. for Tier, select Free, if it's still available on your subscription. For more information, see IoT Hub pricing.
    6. For Daily message limit, keep the default value.
    7. Select Next: Networking at the bottom of the page.

    Screenshot showing the IoT Hub page for creation.

  4. Select Review + create. Review your IoT Hub information and select Create. Your IoT Hub might take a few minutes to create. You can monitor the progress in the Notifications pane.

  5. After the resource (IoT hub) is created, select Go to resource to navigate to the IoT Hub page.

  6. On the IoT Hub page, select Devices on the left menu, and then select + Add device.

    Screenshot showing the Add device button on the Devices page.

  7. Enter a Device ID and select Save.

    Screenshot showing the Create a device page.

  8. Once the device is created, you should see the device from the IoT devices list. Select Refresh button on the page if you don't see it.

    Screenshot showing the list of devices.

  9. Select your device from the list.

  10. On the device page, select the copy button next to Primary Connection String, and save it to a notepad to use later.

    Screenshot showing the copy button next to device connection string.

Run the IoT simulator

  1. Open the Raspberry Pi Azure IoT Online Simulator.

  2. Replace the placeholder in Line 15 with the Azure IoT Hub device connection string you saved in a previous section.

  3. Select Run. The output should show the sensor data and messages that are being sent to your IoT Hub.

    Screenshot showing the **Raspberry Pi Azure IoT Online Simulator** page with the sample query.

Create blob storage

  1. From the upper left-hand corner of the Azure portal, select Create a resource. Select Storage under Categories on the left menu, and then select Storage account.

  2. In the Create storage account pane, enter a storage account name, location, and resource group. Choose the same location and resource group as the IoT Hub you created. Then select Review at the bottom of the page.

    Screenshot showing the Create a storage account page.

  3. On the Review page, review your settings, and select Create to create the account.

  4. After the resource is created, select Go to resource to navigate to the Storage account page.

  5. On the Storage account page, select Containers on the left menu, and then select + Container.

    Screenshot showing the Add container menu on the Containers page.

  6. On the New container page, provide a name for your container, such as container1, and select Create.

    Screenshot showing the **Add container** page.

Create a Stream Analytics job

  1. On a separate tab of the same browser window or in a separate browser window, sign in to the Azure portal.

  2. Select All services on the left menu. Select Analytics under Categories. Hover the mouse over Stream Analytics jobs, and select + or Select + Create in the pop-up window.

    Screenshot that shows the Stream Analytics job menu.

  3. On the New Stream Analytics job page, follow these steps:

    1. For Subscription, select your Azure subscription.

    2. For Resource group, select the same resource that you used earlier in this quickstart.

    3. For Name, enter a name for the job. Stream Analytics job name can contain alphanumeric characters, hyphens, and underscores only and it must be between 3 and 63 characters long.

    4. For Hosting environment, confirm that Cloud is selected. Stream Analytics jobs can be deployed to cloud or edge. Cloud allows you to deploy to Azure cloud, and the Edge option allows you to deploy to an IoT Edge device.

    5. For Stream units, select 1. Streaming units represent the computing resources that are required to execute a job. To learn about scaling streaming units, refer to understanding and adjusting streaming units article.

    6. Select Review + create at the bottom of the page.

      Screenshot showing the **New Stream Analytics job** page.

  4. On the Review + create page, review settings, and select Create to create a Stream Analytics page.

  5. On the deployment page, select Go to resource to navigate to the Stream Analytics job page.

Configure job input

In this section, you configure an IoT Hub device input to the Stream Analytics job. Use the IoT Hub you created in the previous section of the quickstart.

  1. On the Stream Analytics job page, select Inputs under Job topology on the left menu.

  2. On the Inputs page, select Add input > IoT Hub.

    Screenshot showing the **Inputs** page with **Add stream input** > **IoT Hub** menu selected.**.

  3. On the IoT Hub page, follow these steps:

    1. For Input alias, enter IoTHubInput.

    2. For Subscription, select the subscription that has the IoT hub you created earlier. This quickstart assumes that you've created the IoT hub in the same subscription.

    3. For IoT Hub, select your IoT hub.

    4. Select Save to save the input settings for the Stream Analytics job.

      Screenshot showing the New input page to enter input IoT hub information.

Configure job output

  1. Now, select Outputs under Job topology on the left menu.

  2. On the Outputs page, select Add output > Blob storage/ADLS Gen2.

    Screenshot showing the **Outputs** page with **Add** -> **Blob storage** option selected on the menu.

  3. On the New output page for Blob storage/ADLS Gen2, follow these steps:

    1. For Output alias, enter BlobOutput.

    2. For Subscription, select the subscription that has the Azure storage account you created earlier. This quickstart assumes that you've created the Storage account in the same subscription.

    3. For Storage account, select your Storage account.

    4. For Container, select your blob container if it isn't already selected.

    5. For Authentication mode, select Connection string.

    6. Select Save at the bottom of the page to save the output settings.

      Screenshot showing the **New output** page to enter input Azure storage account information.

Define the transformation query

  1. Now, select Query under Job topology on the left menu.

  2. Enter the following query into the query window. In this example, the query reads the data from IoT Hub and copies it to a new file in the blob.

    SELECT *
INTO BlobOutput
FROM IoTHubInput
WHERE Temperature > 27

  3. Select Save query on the toolbar.

    Screenshot showing the **Query** page with the sample query.

Start the Stream Analytics job and check the output

  1. Return to the job overview page in the Azure portal, and select Start job.

    Screenshot showing the **Overview** page with **Start** button selected.

  2. On the Start job page, confirm that Now is selected for Job output start time, and then select Start at the bottom of the page.

    Screenshot showing the **Start job** page.

  3. After few minutes, in the portal, find the storage account & the container that you've configured as output for the job. You can now see the output file in the container. The job takes a few minutes to start for the first time, after it's started, it will continue to run as the data arrives.

    Screenshot showing the **Container** page with the sample output file.

  4. Select the file, and then on the Blob page, select Edit to view contents in the file.

    Screenshot showing the sample output file.

Clean up resources

When no longer needed, delete the resource group, the Stream Analytics job, and all related resources. Deleting the job avoids billing the streaming units consumed by the job. If you're planning to use the job in future, you can stop it and restart it later when you need. If you aren't going to continue to use this job, delete all resources created by this quickstart by using the following steps:

  1. From the left-hand menu in the Azure portal, select Resource groups and then select the name of the resource you created.
  2. On your resource group page, select Delete, type the name of the resource to delete in the text box, and then select Delete.
  3. On the Raspberry Pi Azure IoT Online Simulator app, select Reset next to Run in the bottom pane to the right.

Next step

To learn about configuring other input sources and performing real-time detection, continue to the following article:

Real-time fraud detection using Azure Stream Analytics