Trigger tableΒΆ
This table stores the information about a trigger. It is related with a TriggerTemplate and it contains the parameters to resolve the placeholders used in it.
| Column | Description | Format | Required |
|---|---|---|---|
| Id | Trigger identifier | int | Yes |
| ItemId | The global identifier of the trigger. It is unique within all the triggers in all the Sidra installations | uniqueidentifier | Yes |
| IdTemplate | Identifier of the TriggerTemplate | int | Yes |
| Name | Name of the Trigger, e.g. "Core Storage Blob Created" | varchar(80) | Yes |
| Description | Description of the Trigger, e.g. "Trigger to extract daily content from external data sources" | nvarchar(512) | |
| Parameters | Values used to resolve the TriggerTemplate placeholders | nvarchar(max) | |
| IdDataFactory | Identifier of the Data Factory where the trigger will be created | int | Yes |
| IsRemoved | Identifies if the trigger should be created or not | bit | Yes |
| LastUpdated | Date of the last time that the trigger was updated | datetime2(0) | Yes |
| LasDeployed | Date of the last time that the trigger was created in the Data Factory | datetime2(0) | |
| IdDataStorageUnit | DSU related Id | int | Yes |
| IdTriggerPlatform | Reference to the Trigger Platform that holds the deployment of this trigger | tinyint | Yes |