is now Sisense for Cloud Data TeamsSign In

Usage Data Dictionary

Usage Data is a data repository containing all metadata for a Sisense for Cloud Data Teams site. Below is a list of all tables and columns included in the repository, including the column types and descriptions. General information on the feature can be found on our main Usage Data page.


Charts

The charts table lists all charts that have been created on a Sisense for Cloud Data Teams site as well as the attributes associated with those charts.

Field NameData TypeDefinition
idIntegerUnique chart ID
nameStringChart name
sqlStringComplete chart SQL query text
created_atTimestampChart created timestamp
created_byIntegerChart creator user ID
updated_atTimestampLast chart modification timestamp made by either a user or the system. This column can be used to show how recently the chart has been modified.
deleted_atTimestampChart deleted timestamp
dashboard_idIntegerDashboard ID for the dashboard the chart is located on
space_idIntegerSpace ID for the space that the chart is located on
database_nameStringName of the database selected in the chart editor dropdown list
csv_url_tokenStringThe unique token for the public CSV URL for a chart. This column can be used to idenfity the source of a public CSV URL.
last_modified_byIntegerUser ID of the last user to modify the chart. This includes changing the position of the chart on the Dashboard.
dataset_typeString(For visuals created with the Data Discovery UI) the dataset origin
dataset_idIntegerView ID or CSV ID corresponding to the dataset used to create the Discovery chart
code_languageStringLanguage used in the code editor - python3.6, python2.7 or r3.2
codeStringPython or R code in the deep analysis editor
explore_configJSONJSON blob containing the field parameters for Discovery charts
Back to top

Views

The Views table lists all views that have been created on a Sisense for Cloud Data Teams site as well as the attributes associated with those views. This also includes Datasets.

Field NameData TypeDefinition
idIntegerUnique view ID
nameStringView name
sqlStringComplete view SQL query text
code_languageStringLanguage used in the code editor - python3.6, python2.7 or r3.2
codeStringComplete view code text
created_atTimestampView created timestamp
created_byIntegerView creator user ID
updated_atTimestampLast saved view modification timestamp
deleted_atTimestampView deleted timestamp
owner_idIntegerView owner user ID
space_idIntegerSpace ID for the space that the view is located on
last_modified_byIntegerUser ID of the last user to modify the view
last_refreshed_atTimestampTimestamp of the last view cache refresh
last_used_atTimestampTimestamp of the last time a view was used
archived_atTimestampTimestamp of when a view was archived
will_archive_atTimestampTimestamp of when a view will archive
Back to top

CSVs

The CSVs table lists all CSVs that have been created on a Sisense for Cloud Data Teams site as well as the attributes associated with those CSVs.

Field NameData TypeDefinition
idIntegerUnique CSV ID
nameStringCSV name
file_nameStringName of the uploaded CSV file
created_atTimestampCSV creation timestamp
created_byIntegerCSV creator user ID
updated_atTimestampLast saved CSV modification timestamp
deleted_atTimestampCSV deleted timestamp
owner_idIntegerCSV owner user ID
space_idIntegerSpace ID for the space that the CSV is located on
last_used_atTimestampTimestamp of the last use
archived_atTimestampTimestamp of when a CSV was archived
will_archive_atTimestampTimestamp of when a CSV will archive
Back to top

Filters

The filters table lists all filters that have been created on a Sisense for Cloud Data Teams site as well as the attributes associated with those filters.

Field NameData TypeDefinition
idIntegerUnique filter ID
nameStringFilter name
sqlStringComplete filter SQL query text - only if the filter is populated using a query
created_atTimestampFilter creation timestamp
created_byIntegerFilter creator user ID
updated_atTimestampLast saved filter modification timestamp
deleted_atTimestampFilter deleted timestamp
space_idIntegerSpace ID for the space that the filter is located on
databaseStringName of the database selected in the dropdown list of the edit filter menu
last_modified_byIntegerUser ID of the last user to modify the filter
Back to top

SQL_Snippets

The SQL Snippets table lists all SQL Snippets that have been created on a Sisense for Cloud Data Teams site as well as the attributes associated with those SQL Snippets.

Field NameData TypeDefinition
idIntegerUnique SQL snippet ID
nameStringSQL snippet Name
owner_idIntegerSQL snippet owner user ID
sqlStringComplete SQL snippet text
created_atTimestampSQL snippet creation timestamp
created_byIntegerSQL snippet creator user ID
updated_atTimestampLast saved SQL snippet modification timestamp
deleted_atTimestampSQL snippet deleted timestamp
space_idIntegerSpace ID for the space that the SQL snippet is located on
Back to top

SQL_Alerts

The SQL alerts table lists all alerts that have been created on a Sisense for Cloud Data Teams site as well as the attributes associated with those alerts.

Field NameData TypeDefinition
idIntegerUnique SQL alert ID
nameStringSQL alert Name
owner_idIntegerSQL alert owner user ID
sqlStringComplete SQL alert SQL query text
created_atTimestampSQL alert creation timestamp
updated_atTimestampLast saved SQL alert modification timestamp
deleted_atTimestampSQL snippet deleted timestamp
space_idIntegerSpace ID for the space that the SQL snippet is located on
Back to top

Dashboards

The Dashboards table lists all dashboards that have been created on a Sisense for Cloud Data Teams site as well as the attributes associated with those dashboards.

Field NameData TypeDefinition
idIntegerUnique dashboard ID
nameStringDashboard Name
created_atTimestampDashboard created timestamp
created_byIntegerDashboard creator user ID
deleted_atTimestampDashboard deleted timestamp
owner_idIntegerUser ID of the dashboard owner
space_idIntegerSpace ID for the space that the dashboard is located on
last_used_atTimestampTimestamp of the last time a dashboard was used
archived_atTimestampTimestamp of when a dashboard was archived
will_archive_atTimestampTimestamp of when a dashboard will archive

Back to top

Query_Logs

The query_logs table contains a records for each chart query that was executed on a Sisense for Cloud Data Teams site. This includes chart queries that are initiated by a user as well as chart background refreshes. These logs start from the month Usage Data was enabled from the settings page.

Field NameData TypeDefinition
started_atTimestampQuery started to run on the database timestamp
created_atTimestampTimestamp of log record creation, when the query has completed
user_idIntegerUser ID for the user that triggered the query
space_idIntegerSpace that the source of the query is located on
item_typeStringItem type of query source - Chart, View, SQL Alert
item_idIntegerID for query source item - Chart, View, SQL Alert
runtime_msIntegerQuery runtime on the database in milliseconds
database_nameStringName of the database that the query was executed on
destinationStringDestination of the query - Cache or origin database
hash_keyStringUnique identifier of a query based on its current state (including filters)
Back to top

Time_on_Site_Logs

The time_on_site_logs table tracks the duration of time in seconds for which a user is active on a given dashboard. This data is aggregated on an hourly basis. These logs start from the month Usage Data was enabled from the settings page.

Field NameData TypeDefinition
space_idIntegerSpace ID
created_atTimestampAggregated hourly timestamp
user_idIntegerUser ID of the user with logged time on the dashboard
secondsIntegerDuration of time in seconds
focused_tabBooleanBoolean value which defines whether the dashboard browser tab is focused or not
dashboard_idIntegerDashboard ID
Back to top

Users

The users table contains all current users on a Sisense for Cloud Data Teams site as well as the attributes associated with that user.

Field NameData TypeDefinition
idIntegerUnique user ID
first_nameStringUser first name
last_nameStringUser last name
email_addressStringUser email address
Back to top

User_Group_Memberships

The user_group_memberships table contains a record for every user/group combination on a Sisense for Cloud Data Teams site. This table can be used to determine which users are assigned to each user group.

Field NameData TypeDefinition
user_idIntegerUser ID
space_idIntegerSpace ID
group_idIntegerGroup ID
created_atTimestampGroup created timestamp
deleted_atTimestampGroup membership deleted timestamp
Back to top

Groups

The groups table contains all groups on a Sisense for Cloud Data Teams site as well as the attributes associated with that group.

Field NameData TypeDefinition
idIntegerUnique group ID
nameStringGroup name
group_typeStringType of group - admin, all_user, or custom
can_editBooleanBoolean value which defines whether the group has edit access
space_idIntegerSpace ID for the space that the group is exists on
created_atTimestampGroup created timestamp
created_byIntegerGroup creator user ID
deleted_atTimestampGroup deleted timestamp
Back to top

Group_Dashboard_Permissions

The group_dashboard_permissions contains a record for every dashboard/group combination on a Sisense for Cloud Data Teams site. This table can be used to determine which groups have access to each dashboard.

Field NameData TypeDefinition
group_idIntegerGroup ID
dashboard_idIntegerDashboard ID
accessStringLevel of access that the group has to a dashboard - view or edit
created_atTimestampTimestamp that the group permissions were added for a given dashboard
updated_atTimestampTimestamp of the last modification to the group permissions to the dashboard
deleted_atTimestampTimestamp that the group permissions were removed from the dashboard

Back to top

Roles

The roles table contains all roles on a Sisense for Cloud Data Teams site as well as the attributes associated with that roles. This table should be used for sites that have Role-Based Access Control.

Field NameData TypeDefinition
idStringUnique Role ID
nameStringRole name
descriptionStringDescription of role
is_customBooleanBoolean value which defines whether the role is custom
created_atTimestampRole created at timestamp
updated_atTimestampRole updated timestamp
Back to top

User_Roles

The user_roles table contains a record for every user/role combination on a Sisense for Cloud Data Teams site. This table can be used to determine which users are assigned to each user role. This table should be used for sites that have Role-Based Access Control.

Field NameData TypeDefinition
idStringUnique User Role ID
updated_atTimestampUser Role updated timestamp
role_idStringRole ID
user_idStringUser ID
space_idStringSpace ID
Back to top

Role_Privileges

The roles privileges table contains all roles on a Sisense for Cloud Data Teams site as well as the privileges associated with that role. This table should be used for sites that have Role-Based Access Control.

Field NameData TypeDefinition
idIntegerUnique role ID
role_idStringRole ID
Permission_object_typeStringDashboard or Topic
Permission_nameStringName of permission
is_grantedBooleanBoolean value which defines whether the role is granted the permission
space_idStringSpace ID for the space that the role exists on
created_atTimestampRole created timestamp
updated_atTimestampRole deleted timestamp

Back to top

Role_Object_Permissions

The Role_Object_Permissions contains a record for every dashboard/role and topic/role combination on a Sisense for Cloud Data Teams site. This table can be used to determine which roles have access to each dashboard and topic. This table should be used for sites that have Role-Based Access Control.

Field NameData TypeDefinition
idStringUnique Role Object ID
created_atTimestampTimestamp that the role object permissions were added for a given dashboard
is_grantedBooleanBoolean value which defines whether the role is granted the permission
permission_idStringPermission ID
permissioned_object_idStringPermissioned Object ID
permissioned_object_typeStringDashboard or Topic
role_idStringRole ID
space_idStringSpace ID
updated_atTimestampTimestamp of the last modification to the group permissions to the dashboard

Back to top

Spaces

The spaces table contains all spaces on a Sisense for Cloud Data Teams site as well as the attributes associated with that space.

Field NameData TypeDefinition
idIntegerUnique space ID
nameStringSpace name
created_atTimestampTimestamp of space creation
created_byIntegerUser ID of the user that created the space
deleted_atTimestampTimestamp of space deletion
Back to top

Table_Cache_Logs

The table_cache_logs table contains a history of when tables cached, duration, and cache strategy. This includes tables that successfully cached as well as tables that failed. Unusually short cache cycle times - the difference between cache_started_at and cache_completed_at - likely indicate an incremental update that did not identify any new rows to be added.

Field NameData TypeDefinition
space_idIntegerSpace ID of the space that the table is cached on
database_nameStringName of the cached origin database of the cached table
schema_nameStringName of the scheme on the origin database of the cached table
table_nameStringName of the cached table
cache_strategystringChosen caching strategy - Bounded, Incremental, Bounded, Null
cache_started_atTimestampTimestamp of the cache query beginning
cache_completed_atTimestampTime of the cache process completing
errorBooleanBoolean that defines whether the cache process returned an error

Back to top

View_Cache_Logs

The view_cache_logs table contains a history of when views materialized as well as their duration. Views that successfully materialized as well as views that failed to cache are included.

Field NameData TypeDefinition
space_idIntegerSpace ID of the space that the view exists on
database_nameStringDatabase selected in the database dropdown of the schema browser in the view editor
view_idIntegerView ID
cache_started_atTimestampTimestamp of the materialization query beginning
cache_completed_atTimestampTime of the materialization process completing
errorbooleanBoolean that defines whether the materialization process returned an error
created_atTimestampTimestamp at which the most recent materialization process ends
Back to top

Urls

The urls table contains a list of urls for all chart and dashboard items on a Sisense for Cloud Data Teams site.

Field NameData TypeDefinition
item_idStringID of the Periscope Item. This corresponds to the charts.id column for chart items and dashboards.id for dashboard items
item_typeStringDefines the item type - dashboard, chart
urlStringURL to the in-app item. Access to the URL does require Periscope login credentials.
Back to top

Deprecated Tables

The below tables are deprecated. They will continue to be populated as normal to avoid disrupting charts that use them, however the specified matching tables should be used going forward.

SQL_Views

This table is the old version of the Views table listed above. The SQL_Views table lists all views that have been created on a Sisense for Cloud Data Teams site as well as the attributes associated with those views. This also includes Datasets.

Field NameData TypeDefinition
idIntegerUnique view ID
nameStringView name
sqlStringComplete view SQL query text
created_atTimestampView created timestamp
created_byIntegerView creator user ID
updated_atTimestampLast saved view modification timestamp
deleted_atTimestampView deleted timestamp
owner_idIntegerView owner user ID
space_idIntegerSpace ID for the space that the view is located on
last_modified_byIntegerUser ID of the last user to modify the view
last_refreshed_atTimestampTimestamp of the last view cache refresh
last_used_atTimestampTimestamp of the last time a view was used
archived_atTimestampTimestamp of when a view was archived
will_archive_atTimestampTimestamp of when a view will archive
Back to top

SQL_View_Cache_Logs

This table is the old version of the View_Cache_Logs table listed above. The SQL_View_Cache_Logs table contains a history of when views materialized as well as their duration. Views that successfully materialized as well as views that failed to cache are included.

Field NameData TypeDefinition
space_idIntegerSpace ID of the space that the view exists on
databaseStringDatabase selected in the database dropdown of the schema browser in the view editor
sql_view_idIntegerView ID
cache_started_atTimestampTimestamp of the materialization query beginning
cache_completed_atTimestampTime of the materialization process completing
errorbooleanBoolean that defines whether the materialization process returned an error
Back to top

Made in Webflow