Creating a Virtual Event

When you create a new virtual event, on the Attributes page you have the option to choose which type of schema you want to use (a new one or an existing one, which was created through another virtual event). If you want to create the virtual event with an existing schema, then you can select the schema via the dropdown.
Only the published virtual event schemas will be visible in the list.
The following pictures show the corresponding images depending on the selected option.
Virtual Event Schema Selection
When selecting an existing virtual event schema you are able to add new attributes to that schema through the virtual event which will be also visible in the other virtual events which share this schema.
New attribute on existing event schema

The following picture shows how the attributes affect the structure of the virtual event in the dataset builder.
You do not need to create attributes for metadata. Metadata attributes are created automatically. For more information on metadata see here.
Note that you can only assign columns with an identical data type to attributes.
Put some thought into the design of the attributes, after saving the attributes can not be deleted.

As a data source, you can use either a dataset or a script.

If you select a dataset you can add some filters. The "thing" selection is applied like the global thing filter on dashboards. Every additional filter is simply applied to the selected column. If you do not add any filters, the filters defined in the dataset stay as they are.

If you select a script you can add filters which are applied to the script results ( + Add Filter) and filters which are applied to the datasets used in the script ( + Add Dataset Filter). The "thing" selection is applied like the global thing filter on dashboards on all datasets used in the script. If you do not add any filters, the filters defined in the dataset stay as they are.
The row limit of the datasets used in the script is applied in the same manner as if it would be used elsewhere. If you have a script which needs to import a lot of data because it considers data of many machines you can use the "run per thing" feature.

To enable the "run per thing" option you need to select script as your data source type.
If you activate "run per thing" the script will be executed once for every selected thing (if you do not select a thing it will run the script for all the things seperately), with the global thing filter set to this thing. Therefore you can import up to 1.000.000 rows of your dataset into your script per thing (depending on the row limit settings in your script).

With the data mapping you define which column gets mapped onto which attribute of your virtual event (data types need to match). You do not need to assign a column to every attribute, it is only mandatory for the metadata thing and timestamp. But for those you have the additional option to assign Virtual Thing and the Execution Timestamp. Virtual Thing will simply write "virtual_thing" into every row of your virtual event. Execution Timestamp will assign the timestamp of the execution to the timestamp column.
You can map any string column onto the metadata thing attribute. The entries will be registered as virtual things.

The idea behind the virtual things is that not all data generated by virtual events will be associated to only one thing. E.g. you can have benchmarking values of a specific type of machine. You do not want to assign this values to a specific thing, but to a new virtual thing representing the machine type. See how to handle access to virtual things here.

Since virtual events are meant to save values that summarize long time frames the highest execution frequency is once per hour. The scheduling defines when and how often the defined action is executed.
Note that the execution time and the scheduled time might differ slightly. Especially if multiple virtual events are scheduled for the same time. Also pay attention to the timestamp filters you selected, since the filter will be applied at the execution time. E.g. if you schedule something to execute daily at 23:59 with a "today" filter applied, depending on the traffic on your platform the virtual event can execute on different days.
For details on the different scheduling options see.

On the schedule page, there is a possibility to execute a virtual event at demand by pressing the "Execute" button. Once the user clicks the button, a confirmation dialog arises to let the user know data is going to be written in the database.
Schedule page with "Execute" button
Execute option is visible only if the user has virtual event write permissions. Virtual event execution might take a while, especially when executing a virtual event containing a lot of data. Once the user triggers the execution, the actual execution of the virtual event can still be running in the background for some time.
Copy link
On this page
Attributes
Set Data Source
Dataset as a Data Source
Script as a Data Source
Data Mapping
Schedule