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

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 + Add data in the top-right corner of the page.

   

3. On the Sample scenarios page, select Connect on the Bicycle rentals tile.

4. On the Connect data source 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

Once the eventstream source is created, you can open the eventstream and add more settings.

1. Once the eventstream is created, 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. Select the pencil icon in the Manage fields pane, and 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