Creating custom events from a table
You can create custom events from a table in your source systems, saving you from manually recreating them. This approach streamlines event modeling by automatically generating the SQL transformations that map event types and relationships to the data. It also enables bulk event creation and configuring event-to-object relationships.
Using the import wizard, an event will follow the raw data if it fits one of the three supported structures:
A column(s) of the table represent an event(s).
A row in the table represents an event (as an event log).
A row in the table represents an event (change table with old value / new value).
For the video overview:
To import your objects and events, the data source must be accessible via a data connection in your data pool.
To share data between your data pools, see: Sharing data between data pools.
To import custom event types from a table:
Click Events.
Click Create - Import from table.
Select your data source, then select the target tables to import.
Select an event storage structure:
Events for columns:Each timestamped column represents one event type (create multiple).
Events from rows, with a column specifying activities: Each row is an activity. All unique activities are aggregated into one event (create single).
Events from rows, with columns including old and new values: Each row is a change. All changes are aggregated into one event (create single).
Click Next.
The imported events are displayed in edit mode.
Select the table to review the events generated from it.
Optionally configure the following:
Columns: Check or uncheck columns to include or exclude them.
Add attributes: Click Add attribute to create additional attributes populated from data outside the selected table.
Rename attributes: Rename existing attributes (defaults to the column name).
Tags and descriptions: Apply existing Celonis tags or create custom tags (up to 41 characters) for filtering and reuse.
Click Next to move on to the optional Relationships step.
Relationships describe how objects and events are connected. To learn more, see: Objects, events, and relationships.
Click Next, review the events that you're creating, and then click Create.
The system creates the events and displays them in your dashboard.
We recommend reviewing transformations now. To do this later or edit event types, click Go to events.