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 NameColumn TypeDescription
DateStringThe date on which the row was generated (as defined by the LastModifiedTime column value). This is the partitioning column.
OwnerStringThe entry's owner.
NameStringThe entry's name.
IdStringA system-assigned identifier that uniquely identifies this entry.
VersionintThe version of this entry.
DataTypeStringThe system-assigned data type for the saved data such as Dashboard or Workspace.
DataStringThe saved data.
StatusStringThe status, which indicates whether the entry is active or deleted.
AdminGroupsString[]The groups which are allowed to administer this entry.
ViewerGroupsString[]The groups which are allowed to view this entry.
LastModifiedByAuthenticatedStringThe authenticated user who created this row.
LastModifiedByEffectiveStringThe effective user who created this row.
LastModifiedTimeDateTimeThe date and time when this row was created.