WorkspaceData
The WorkspaceData
table contains saved user details from the web interface, including information on each change made to a user's web interface. For example, entries are generated when users change their:
- Workspaces
- Dashboards
- Draft Persistent Queries
- Command history
The WorkspaceData
table is updated automatically when a user performs many web GUI actions and normally will not need to be queried directly. The latest row for a changed item such as a workspace or dashboard indicates its current state.
Caution
Since the web server uses this table to retrieve details on user state, take regular workspace data snapshots to minimize the WorkspaceData
dates that need to be scanned.
You cannot delete this or else user data will be lost; even if snapshots are created, the historical entries may be useful. It is strongly recommended to make regular backups of this table.
Columns
Column Name | Column Type | Description |
---|---|---|
Date | String | The date on which the row was generated (as defined by the LastModifiedTime column value). This is the partitioning column. |
Owner | String | The entry's owner. |
Name | String | The entry's name. |
Id | String | A system-assigned identifier that uniquely identifies this entry. |
Version | int | The version of this entry. |
DataType | String | The system-assigned data type for the saved data such as Dashboard or Workspace . |
Data | String | The saved data. |
Status | String | The status, which indicates whether the entry is active or deleted. |
AdminGroups | String[] | The groups which are allowed to administer this entry. |
ViewerGroups | String[] | The groups which are allowed to view this entry. |
LastModifiedByAuthenticated | String | The authenticated user who created this row. |
LastModifiedByEffective | String | The effective user who created this row. |
LastModifiedTime | DateTime | The date and time when this row was created. |
Related documentation
- Internal tables overview
AuditEventLog
PersistentQueryConfigurationLog
PersistentQueryStateLog
ProcessEventLogIndex
ProcessEventLog
ProcessInfo
ProcessMetrics
QueryOperationPerformanceLogCoreV2Index
QueryOperationPerformanceLogCoreV2
QueryPerformanceLogCoreV2
QueryUserAssignmentLog
ResourceUtilization
ServerStateLogIndex
ServerStateLog
UpdatePerformanceLogCoreV2Index
UpdatePerformanceLogCoreV2
WorkspaceDataSnapshot