Real-Time Intelligence tutorial part 2: Get data in the Real-Time hub

Note

This tutorial is part of a series. For the previous section, see: Tutorial part 1: Set up Eventhouse.

In this part of the tutorial, you browse the Real-Time hub, create an eventstream, transform events, and create a destination to send the transformed events to a KQL database.

Create an eventstream

1. Select Real-Time on the left navigation bar.

2. Select + Connect data source in the top-right corner of the page.

   

3. On the Data sources page, select Sample scenarios category, and then select Connect on the Bicycle rentals tile.

4. On the Connect page, for Source name, enter TutorialSource.

5. In the Stream details section, select the pencil button, and change the name of the eventstream to TutorialEventstream, and then select Next.

6. On the Review + connect page, review settings, and select Connect.

Transform events - add a timestamp

1. On the Review + connect page, select Open Eventstream.

   

   You can also browse to the eventstream from the My data streams by selecting the stream and then by selecting Open Eventstream.

2. From the menu ribbon, select Edit. The authoring canvas, which is the center section, turns yellow and becomes active for changes.

   

3. In the eventstream authoring canvas, select the down arrow on the Transform events or add destination tile, and then select Manage fields. The tile is renamed to ManageFields.

4. Hover over the left edge of the Manage fields tile. Click and drag the connector to the right side the TutorialEventstream tile. You have now connected the eventstream to a new transformation tile.

5. In the Manage fields pane, do the following actions:

   1. In Operation name, enter TutorialTransform.

   2. Select Add all fields

      

   3. Select + Add field.

   4. From the Field dropdown, select Built-in Date Time Function > SYSTEM.Timestamp()

      

   5. In Name, enter Timestamp.

   6. Select Add.

   7. Confirm that Timestamp is added to the field list, and select Save. The TutorialTransform tile now displays but with an error, because the destination isn't configured yet.

Create a destination for the timestamp transformation

1. Hover over the right edge of the TutorialTransform tile and select the green plus icon.

2. Select Destinations > Eventhouse. A new tile is created entitled Eventhouse.

3. Select the pencil icon on the Eventhouse tile.

   

4. Enter the following information in the Eventhouse pane:

   Field	Value
   Data ingestion mode	Event processing before ingestion
   Destination name	TutorialDestination
   Workspace	Select the workspace in which you created your resources.
   Eventhouse	Tutorial
   KQL Database	Tutorial
   Destination table	Create new - enter RawData as table name
   Input data format	Json

5. Ensure that the box Activate ingestion after adding the data is checked.

6. Select Save.

7. From the menu ribbon, select Publish.

   The eventstream is now set up to transform events and send them to a KQL database.

Related content

For more information about tasks performed in this tutorial, see:

• Create and manage an eventstream
• Add a sample data as a source
• Add a KQL database as a destination

Next step

Real-Time Intelligence tutorial part 3: Transform data in a KQL database