Workflow datasets for Snowflake
Learn about the workflow dataset for the JSON-based schema.
This table holds data for workflow. Use these datasets to view your workflow metadata.
| Field | Description | Data type/Mode |
|---|---|---|
| Uri | The universal resource identifier. It is in the format <ObjectTypeSpecifier>/Id. | Data type: STRING Mode: NULLABLE |
| timestamp | The timestamp when the workflow was created. | Data type: TIMESTAMP Mode: NULLABLE |
| environmentName | The name of the environment. | Data type: STRING Mode: NULLABLE |
| tenantID | The tenant ID. | Data type: STRING Mode: NULLABLE |
| objectURIs | The URI of the object. | Data type: STRING Mode: NULLABLE |
| resourceURIs | The URI of the resource. | Data type: STRING Mode: NULLABLE |
| processInstanceId | The ID of the process instance. | Data type: STRING Mode: NULLABLE |
| taskID | The task ID. | Data type: STRING Mode: NULLABLE |
| processType | The process definition type. | Data type: STRING Mode: NULLABLE |
| taskType | The type of task. | Data type: STRING Mode: NULLABLE |
| processInstanceCreateTime | The timestamp when the process instance was created. | Data type: TIMESTAMP Mode: NULLABLE |
| taskCreateTime | The timestamp when the task was created. | Data type: TIMESTAMP Mode: NULLABLE |
| username | The username of the user who created the task. | Data type: STRING Mode: NULLABLE |
| assignee | The name of the user who is assigned the task. | Data type: STRING Mode: NULLABLE |
| processInstanceDueDate | The timestamp when the process instance is due. | Data type: TIMESTAMP Mode: NULLABLE |
| decision | The decision. | Data type: STRING Mode: NULLABLE |
| userActivityTime | The user activitytime. | Data type: TIMESTAMP Mode: NULLABLE |
| processInstanceComplete | Indicates if the process instance is completed. | Data type: BOOLEAN Mode: NULLABLE |
| processInstanceCompletionTime | The timestamp when the process instance was completed. | Data type: TIMESTAMP Mode: NULLABLE |
| processSuspended | Indicates if the process was suspended. | Data type: BOOLEAN Mode: NULLABLE |
| comment | The comments provided by users for a task workflow process. A new row is added to the table for each comment added by the user. | Data type: STRING Mode:NULLABLE |