Activity log datasets for Snowflake
Learn about the activity log datasets for Snowflake.
| Field | Description | Data type/Mode |
|---|---|---|
| activityID | The unique ID associated with each activity. | Data type: STRING Mode: NULLABLE |
| activityUser | The User ID or mail address of the user. | Data type: STRING Mode: NULLABLE |
| activityMethod | The API method user. For example, PUT, GET, POST. |
Data type: STRING Mode: NULLABLE |
| activityURL | The API used to do the activity. |
Data type: STRING Mode: NULLABLE |
| activityClientType | The type, Reltio UI or API, used to complete the activity. |
Data type: STRING Mode: NULLABLE |
| activityLabel | The labeling client interactions. For example, USERSEARCH, USERPROFILEVIEW, USERLOGIN. |
Data type: STRING Mode: NULLABLE |
| activityDescription | The description of the activity. |
Data type: STRING Mode: NULLABLE |
| activityTimestamp | The timestamp of the activity. |
Data type: TIMESTAMP Mode: NULLABLE |
| activitySource | The source of the activity. |
Data type: STRING Mode: NULLABLE |
| items |
Data type: RECORD Mode: REPEATED |
| Field | Description | Data type/mode |
|---|---|---|
| id | The id of the item. |
Data type: STRING Mode: NULLABLE |
| objectUri | The URI of the entity object. For example, entities/3e7lElG. | Data type: STRING Mode: NULLABLE |
| objectType | The type of the object. For example, configuration/entityTypes/Location. |
Data type: STRING Mode: NULLABLE |
| objectLabel | The mapping objects with label. |
Data type: STRING Mode: NULLABLE |
| objectValue | The value of the object. |
Data type: STRING Mode:NULLABLE |
| startObjectUri | The uri of the start object. |
Data type: STRING Mode:NULLABLE |
| startObjectLabel | Mapping of objects with label. |
Data type: STRING Mode:NULLABLE |
| endObjectUri | The uri of the end object. |
Data type: STRING Mode:NULLABLE |
| endObjectLabel | Mapping of objects with label. |
Data type: STRING Mode:NULLABLE |
| eventId | The ID associated with each event. |
Data type: STRING Mode:NULLABLE |
| eventType | The type of event. For example, ENTITY_CREATED, ENTITY_CHANGED, or ENTITY_REMOVED. |
Data type: STRING Mode:NULLABLE |
| tags | The tags associated with the event. |
Data type: STRING Mode:REPEATED |
| nonFiltering | The list of fields of the event, which cannot be filtered. This is a compressed JSON object mapping that contains all fields of the item that don't have a separate column. |
Data type: STRING Mode:NULLABLE |
| deltaAttributeTypes | The attribute type. This is created only if the indexActivityDelta parameter in the tenant storage configuration is set to true. |
Data type: STRING Mode:REPEATED |
| deltaSources | The source of the event. This is created only if the indexActivityDelta parameter in the tenant storage configuration is set to true. |
Data type: STRING Mode:REPEATED |
| deltaNewValues | The new values.This is created only if the indexActivityDelta parameter in the tenant storage configuration is set to true. |
Data type: STRING Mode:REPEATED |
| deltaOldValues | The old values.This is created only if the indexActivityDelta parameter in the tenant storage configuration is set to true. |
Data type: STRING Mode:NULLABLE |
| _uris | The list of URIs for GDPR filtering. |
Data type: STRING Mode:NULLABLE |