Event SQL Filter
Event filter that filters based on an SQL query expression.
EventSqlFilter​
info
EventSqlFilter is defined beneath the following ancestor nodes in the YAML structure:
Below are the properties for the EventSqlFilter. Each property links to the specific details section further down in this page.
| Property | Default | Type | Required | Description |
|---|---|---|---|---|
| types | array[string] | Yes | List of event types. | |
| sql_filter | string | Yes | SQL query expression used to filter Events from the Event stream. |
Property Details​
Automation​
An Automation defines a set of Actions to be performed when defined Sensor or Event triggers occur.
| Property | Default | Type | Required | Description |
|---|---|---|---|---|
| automation | Yes | Automation configuration options. |
AutomationOptions​
Configuration options for an Automation.
| Property | Default | Type | Required | Description |
|---|---|---|---|---|
| description | string | No | Brief description of what the model does. | |
| metadata | No | Meta information of a resource. In most cases it doesn't affect the system behavior but may be helpful to analyze project resources. | ||
| name | string | Yes | The name of the model | |
| enabled | boolean | No | Boolean flag indicating whether the Automation is enabled. Defaults to True. | |
| actions | array[Any of: (string)] | No | List of Actions that the Automation performs when triggered. | |
| triggers | EventTrigger | No | List of Automation triggers. |
EventTrigger​
A pre-defined set of conditions within an Automation that activates in response to specific Events. When a trigger is fired, it initiates the execution of corresponding actions for that Automation.
| Property | Default | Type | Required | Description |
|---|---|---|---|---|
| events | array[One of: (EventSqlFilter, EventPythonFilter, EventTypeFilter)] | No | List of Event filters used to identify Events that trigger the Automation. | |
| sensors | array[Any of: (string)] | No | List of Sensors that trigger the Automation. |