Seems not to be used commonly. User site role ID is unique key correspondent to site_role_id from users table. A unique, immutable identifier for the column asset. Primary key for the permission set class record. This could be NULL if the matching record in the groups table was deleted since this record was created. This table stores onboarding information for tableau features based on system user ids. Data roles are stored in table `data_roles`. Foreign key/Primary key relation from resource_holder_type on this table to id on table. The a shorter version of the domain_name of the system_user linked to the user record. provided here for those customers who want to query it for information about their Tableau Server usage. Setting for enabling/disabling Viz in Tooltip on a site, Lifetime for native connections, in minutes, Setting for enabling/disabling commenting mentions on a site, Setting for enabling/disabling mixed content on a site, Setting for enabling/disabling site invite notification on a site. For example, "Project" or "Site". See flow_output_step_runs for per-output-step run history. Defines what customized view a user should see for a given view, by default. Higher value means higher precedence. This table is used to track how many times each user has accessed different views. The name of the system_user who owns this project. Foreign key/Primary key relation from flow_output_step_run_id on this table to id on table. This value will not change is the workbook containing this view is later republished. Boolean that represents whether to attach a PDF to a subscription background_job. A foreign key reference to the tds datasource model to where the field exisits. Instance identifier for legacy identity store. Each record corresponds to a directory that contains one or more extract files associated with either a workbook or datasource. Array of DatasourceRefreshSchedule objects in JSON format. Be aware that permissions is a complex topic and that this table does not contain all relevant information about permissions. Foreign key/Primary key relation from project_id on this table to id on table. Records define a schedule according to which certain regular tasks may be performed (see tasks table). Used to implement "optimistic locking."

Otherwise, one is randomly generated. The mechanism type of how the schedule is created, e.g. $Version number of the datasource. Records the most useful information about a site that was relevant at the time of the event (see sites table). Determines if the field is hidden or not. To interpret it, convert the integer to binary.

When this checksum entry expires and became eligible for cleanup by background task. It contains the id of the item to which this entry refers. This table lists trusted tickets that have been created.

The last time at which the the subscription was sent. Can be used to indicate percent complete for the job, but in most cases simply gets set to 100 when the job is completed. Foreign key/Primary key relation from system_user_id on this table to id on table, Secret portion of token thats been hashed, Reference to system user that requested the token. Each record represents a workbook that exists on the server. This column is no longer used and will be deleted once it will no longer be breaking an upgrade scenario, When this token becomes expired. Tickets that are never redeemed become invalid after the time given by "expires_at" and are eventually deleted from the table automatically. Whether the queries to this data source may be proxied via a remote agent. The contact type (user or group) for this database. The time at which the last extract refresh occurred. Unique ID used to identify the datasource data. One of either "Workbook" or "Datasource". The capacities that this remote agent exhibits, e.g. Indicates if this group was created by Tableau itself, or if it was created by user action. Foreign key reference to the site which contains this remote agent. Records the most useful information about a database that was relevant at the time of the event (see database_assets table). An attribute bag that will match the embedded keychain connection this connection is associated with. Each row represents an event affecting a flow. OAuth2 user info URI if using a custom provider. This looks a bit odd because it comes from a serialized symbol. Records the number of times a datasource was viewed in the given time interval. The name of the site that this group belongs in. Must be unique across all instances of the same installations of client applications. Will be true for success, and false for failure. The name of the domain that this group is linked to. Table which stores referenced extensions information calculated from across the workbooks. Uniquely identifies a view. The trigger type of this flow run, currently 0 for scheduled run, 1 for ad-hoc run. Proof Key for Credential Exchange (RFC 7636) short-lived storage. Describes the type of thing for which permissions are being specified. This could be NULL if the matching record in the flows table was deleted since this record was created. This name must be unique for a specific site/user. Records what month of the year the analytics are aggregated over. Free space state of the disk. Keeps track of most recent time a user has been enrolled for a mobile device. May not be implemented across all events. 0: device type is default, 1: device type is desktop, 2: device type is tablet, 3: device type is phone. Foreign key/Primary key relation from mru_list_id on this table to id on table. The port on which the request was received. Revision of the workbook whose id is the workbook_id column. The luid which uniquely identifies the site. Defines the SAML IdP associated with a site. The permission set this item is a part of. Foreign key/Primary key relation from schedule_id on this table to id on table. Indicates how many pixels were horizontally cropped off of the generated image. Datetime user was unassigned from a creator role to a non-creator role -- triggered from the users table.

The name of the domain that the user belongs to. views built from them may break. serialized_materialized_view_connection_attributes. The next time the subscription should be sent. Foreign key/Primary key relation from hist_licensing_role_id on this table to id on table. Integer values in between are also valid. The user id of the owner/publisher of the data role. A foreign key reference to the user who owns the view. Foreign key/Primary key relation from domain_id on this table to id on table. The linkage between a system_user and their allowed sites is defined through the "users" table. Each record represents an individual specification about how a Tableau Prep flow should be run. Contains a variety of preferences for the various system users. User who published this version. Records the user sessions authenticated by the SiteSAML service. Higher priority jobs should be processed earlier. 2 = Publisher More or less composed of workbook and sheet names, but not totally obviously, especially in the presence of non-ASCII characters. Primary key id for view associated with the viz snapshot. Integer that represents the number of failed attempts since the last successful login. Defaults to "Always", but can also be "DataPresent", "Constant", "Band", etc. User license role rank for the purpose of licensing users with the correct priority when the number of available licenses is less that users. Machine consumable name for identity store instance. Number of times this task has run since we created this column. ID of the database source, if this database is embedded. workbook). Each record represents a request received by Tableau Server. A foreign key reference to the view that was accessed. Currently 0 for scheduled run (task), 1 for ad-hoc run. It is The optional folder name if this field is in a folder. This table is used to link various workbooks to the subscriptions in which those workbooks must have views generated and emailed. geocoding database. Foreign key for type of identity store instance. The locale ID the pdf was generated with. They also indicate the next time at which the schedule will be triggered. This (or the id) is how the capability is referred to by code. Each record represents a table asset that exists on Tableau Server. Each record represents a partial aggregation of analytics for a given datasource in a given time interval. The site in which the tagged object exists (likewise the user, etc.). The domain_name of the system_user linked to the user record. Foreign key/Primary key relation from data_role_id on this table to id on table. The luid which uniquely identifies the extensions safe list row. Records are used to flag a particular record in the asset_key_meta_data table. The database name associated with the linked data_connection record. Unique numeric id of the type. database of the Tableau Server repository. ID (foreign key from materialized view connection table) of the connection that stores the materialized view. A reference to the primary key id column for the record in the hist_users table of the user who was the target of the event. Primary key for the pending search update item. Foreign key/Primary key relation from capability_id on this table to id on table. Uniquely identifies a view. For each event, a record is created on this table. Used to implement "optimistic locking" by JPA/Hibernate. Datetime user was unassigned a creator role. True means the data was supplied in the form of a Tableau data extract, though the original source of the data may be known to reside elsewhere. Identifies the workbook for which this checksum applies. This could be NULL if the matching record in the sites table was deleted since this record was created. The id of the site associated with the flow where this input step exists. Records the most useful information about a comment that was relevant at the time of the event (see comments table). The time of the most recent access of the specified view by the specified user. The connection class of the connection to which the token will belong. The time at which the underlying views record was created. This id is same as the id (primary key) of the public.sites table. This could be NULL if the matching record in the comments table was deleted since this record was created.

Records what year the analytics are aggregated over. Type of resource being monitored. This table contains records corresponding to various classifications of users. Identifier for a given run from the flow processing system. Ascending order corresponds to increasing precedence. Not useful for customers. True means password is embedded in owner (see owner_type and owner_id fields). Records the most useful information about a project that was relevant at the time of the event (see projects table). The email of the system_user associated with this customized view. Note these links go to other hist* tables, which allows the event to refer to things that might have since been deleted from the regular tables. The name is either "local" or the name of some Active Directory group. 8 = Unlicensed