The primary key for the underlying workbook record. Whether to allow users to attach PDFs to subscription emails. When the flow processing system completed publishing the output of this output step. This is how the system identifies what code to execute when this task is to be run. Allows site filtering to work on Admin Views. Links to the user who created this record, or is NULL. Used as a means of passing parameters about the background job. Records the most useful information about a tag that was relevant at the time of the event (see tags table). The id of the site associated with the flow which the entire flow run spec is about. Boolean that represents whether to attach a PDF to a subscription background_job. A reference to an entry in the repository_data table, which, in turn references the PostgreSQL large object that contains the sheet image for this entry. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. The user id of the owner/publisher of the data role. Datetime user was unassigned from a creator role to a non-creator role -- triggered from the users table. backgrounder jobs, as shown in the following example. Describes various data sources that are included in either workbooks or datasources. Indicates if the domain is active or not. Be aware pg_largeobject is not accessible by the "tableau" or "readonly" users. 5 : site admin, 0 : not site admin. Primary key for the datasource field record. Friendly name for the data source field that is seen in Tableau. unsigned 64 bit hash of the materialized logical query. Type of data connection (ie mysql, postgres, sqlproxy etc). Entry must be one of "User" or "Group". Uniquely identifies device. True if subscriptions are allowed for this site, otherwise false. The name or IP address of the worker where the event occurred. A foreign key reference to the comment that the attachments is attached to. The friendly_name of the system_user that corresponds to the user. The user tableauhas access to several database views that can be used to analyze the server activity. Each record represents a site. A string that uniquly represents the object to be translated. Each record represents a partial aggregation of analytics for a given metric in a given time interval. The time at which the event that triggered this notification occurred. Holds a relatively short list of capabilities. The name is either "local" or the name of some Active Directory group. Whether this datasource is using remote query agent. The FK to flows for the flow which this run error is about. Holds most recently used list entries. A URL-like identifier for the item referred to by this entry. This could be NULL if the matching record in the sites table was deleted since this record was created. Unique identifier for this data_connection. Indicates what user id is the creator of the task. The types of historical events which can be recorded. Foreign key/Primary key relation from published_connection_id on this table to id on table, Generated Id for published_connection_revisions table primary key, Site where published connection revision created at, Published connection name, should be unique for combination (site_id, name, revision), Revision number indicating revision history. The type of event is indicated through historical_event_type_id, which links to the historical_event_types table. When the flow processing system began executing the execution plan associated with this output step. This table tracks site role creator changes for each given user on a given site. Links to the site that contains the view. The user to be used when generating the thumbnail image. ID of the Site from which this content was deleted. A user can be allowed certain capabilities either through being some sort of admin, or through owning something like a workbook or a project, or via entries in the next_gen_permissions table. Date that represents the last time the user had an unsuccessful login. Defines the SAML IdP associated with a site. Foreign key/Primary key relation from flow_output_step_id on this table to id on table. When the job finished execution. Extract encryption mode: whether it is disabled (null or 0), enabled (1), or enforced (2). A unique, immutable identifier for the flow run spec. America/Los_angeles. The name of the project that this workbook is part of. A string, derived from the name of the migration file, which serves to identify a particular migration that has been applied. The number of objects that reference a viz snapshot. The user who last modified and published this datasource to server or saved the datasource during web edit. Foreign key/Primary key relation from schedule_id on this table to id on table. Reference to entry in sites table. Owner of the original item. The integer precedence is internal to the stored procedures. Optional external identifier for identity. Whether or not this datasource is certified. Primary key for the underlying customized_views record. A foreign key reference to an entry in the schedules table. A descriptive phrase constructed for the worksheet, based on the workbook definition. The site in which this datasource exists. This is not an exhaustive description of all tables and fields in the database, but is provided here for those customers who want to query it for information about their Tableau Server usage. For . A URL string that describes the view to be delivered, when the subscription is for a view. The name of the user, under whose authority, the ticket is created. The name of the database associated with the published datasource. Tableau Server Repository PostgreSQL Answer Purchase the Data management add on and enable it using the command tsm maintenance metadata-services enable Additional Information Discuss this article. Otherwise NULL. A foreign key reference to an entry in the workbooks table. A given tag can be associated with many taggable items in a site. Name of the preconfigured provider, which must be defined in SiteSAML application.yml file. The localization resources for the extension. For each event, a record is created on this table. The capacities that this remote agent exhibits, e.g. Indicates if the job was triggered by run now, Indicates what user id is the creator of the job. Locator for the full image of the viz snapshot. date-time when the user activated this product from this device for this site for the first time. Feedback Forum Did this article resolve the issue? Higher value means higher precedence. The type of data condition that will cause this subscription to be sent out. What is data dictionary used for? Forbidden Action. If the extracts are associated with a datasource, then this is a foreign key link to that datasource, otherwise it is NULL. Each tag is a string value. This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository. Setting for enabling/disabling version history on a site, Setting for enabling/disabling system notification such as email notification on a site, Maximum number of versions to retain for each content type : workbooks ,datasources, Setting for enabling/disabling the subscribe others functionality on a site, Setting for enabling/disabling guest account per site, Setting for enabling/disabling access to a Tableau Online site by a Tableau support user. Tableau data dictionary provides information about the information stored in tables and views in the "workgroup" PostgreSQL database of the Tableau Server repository. Unique ID used to identify the datasource data. When a user creates a customized view, the data that supports that goes in the customized_views table, and is reflected in this view. The name of the system_user who will receive the subscription. The effective permission reason is returned to callers. A reference to the primary key id column for a record in the hist_data_connections table. updated on each publish. Used in the perm_users_*_capabilities functions. Workbook, Datasource, Flow. An identifier for the sheet. 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. Null unless specified. Foreign key/Primary key relation from user_id on this table to id on table, Artificial auto-incrementing integer that serves as the primary key. Whether or not the capability is allowed. Foreign key/Primary key relation from table_id on this table to id on table. If set to false, this means that the task is inactive, implying it won't be run when the schedule triggers. Foreign key/Primary key relation from parent_project_id on this table to id on table. A foreign key reference to the customized.view.id. Contains a variety of preferences for the various system users. A unique, immutable identifier within a site. The time at which this record was created. True if sheet image API is enabled for this site, otherwise false. A reference to the primary key id column for a record in the hist_datasources table. Object metadata in JSON, used to restore the object. This is not generally the same as created_at, because it may take some time before a backgrounder "notices" the newly created record and begins to process it. Unique ID used to identify the reduced datasource data. Looking for Tableau Server on Linux? </p>. The name of the system_user linked to the user whose session this is. Time is the recorded server time. You may use, copy, and/or distribute copies of the data dictionary, free of charge, provided that you should always include this readme file with the data dictionary. User who published this version. If set to false, this means that the subscription is inactive. A timestamp without timezone indicating how long ago the session was created. Many-to-many mapping table between authorizables and permission sets. 1 on create, monotonically increasing with each update of the webhook. The ID of the semantics service node that is currently processing the events. When 0, the aggregation is for the year as designated by year_index. workbook). The site to which the workbook was published. The meaning of the values is: 1: grant to group, 2: deny to group, 3: grant to user, 4: deny to user. Unique ID used to identify the thumbnail. When true admins receive notification about suspended alerts, When true, users will see mark animations on sheets. Indicates which view will be shown by default. Foreign key/Primary key relation from data_alert_id on this table to id on table. An integer where 0 is the highest priority and 10 is the default priority. This database provides persistent storage for Tableau Server and is primarily intended to support that application. Each record represents a Tableau Desktop usage report. This must be unique when taken together with the customized view creator and the view. A reference to the primary key id column for a record in the hist_remote_agents table. Whether the extracts in the workbook can be refreshed. Records represent either an Active Directory domain or an authenticate system. The ID of the customized view the metric was created on. Array of DatasourceRefreshSchedule objects in JSON format. The database name associated with the linked data_connection record. Primary key for the record in the underlying schedules table. If this datasource was published using a release of the software where connecting to datasources through the Data Server was supported (post 7.0). A foreign key reference to the tds datasource model to where the field exisits. The visibility of Autohidden fields are not under user control. This information can be used to build custom views and custom reporting that can provide additional monitoring data, and build your own analysis of server activity. A possibly useful string that is mostly here to make it easier to debug. If part of the site pool to handle shared work. A single system_user may potentially be able to login to multiple sites. Primary key for the record of the output step. Stores the last data source event processed by semantics service. Primary key for the pending search update item. Expiration date of active key. The number of bytes it took to describe the changes from the base view to the customized view. The count of extensions in views of a given workbook. For more information about the Data Dictionary and how it is being used by other customers, see the Tableau Community. Tells the user whose session this is. The name of the system_user who is the owner. Defines what customized view a user should see for a given view, by default. Foreign key/Primary key relation from type_id on this table to id on table. Can be null if the image was not generated as any user in particular. Version of the flow file, increments on each publish. Foreign key/Primary key relation from task_id on this table to id on table. The value of remote_agents.name at the time of the event. Used in constructing help links, so that help can be presented in the appropriate language. What workbooks or views are they looking at? The time of the most recent access of the specified view by the specified user. If set to false, this means that the schedule is inactive, meaning that no tasks will be performed when the schedules triggers. The days of the week correspond to Sunday : 1, Monday : 10, Tuesday : 100, Wednesday : 1000, Thursday : 10000, Friday : 100000, Saturday : 1000000. A foreign key reference to the site that the user belongs to. Determines whether the permission template applies to workbooks or datasource. Records the most useful information about a remote agent that was relevant at the time of the event. Foreign key to the flow_output_steps table. A foreign key reference to the view that was accessed. The luid which uniquely identifies the workbook. The name of the view, workbook, or datasource that is being tagged. Each site holds its own workbooks, datasources, users, etc. Used to store database_asset events stream. This table is used to link various workbooks to the subscriptions in which those workbooks must have views generated and emailed. Used track amount of execution attempts remaining for the job. Foreign key/Primary key relation from content_datasource_id on this table to id on table. The connection subclass of the connection to which the token will belong. id of the directory in sos that contains the queries that are materialized. The database name to which the particular connection is linked. Refers to the type of the authorizable (e.g. A combination of the site name and the customized_view name. Records the most useful information about a column that was relevant at the time of the event (see column_assets table). The algorithm used in conjunction with this key. Two jobs with the same serial_collection_id cannot be processed simultaneously. Records the most useful information about a capability that was relevant at the time of the event (see capabilities table). The name of the input step, pulled from TFL. The number of records associated with the interval. Chuyn Tr v Gim au. The information is encoded in the given integer. Foreign key/Primary key relation from resource_type on this table to id on table. Type of the resource, e.g. If not null, id of the flow encryption key (KEK) with which data in this flow is encrypted. Foreign key/Primary key relation from id on this table to id on table. Holds whatever text object is desired. One of 1 (Normal), 2 (Warning), 3 (Critical). It is running in background on Identifies the content-type which is associated with the data_role. Human readable name for the webhook, defaults to the value Unnamed Webhook. Each row in the table corresponds to a cached pdf file. Unique identifier with which to associate to the refresh token series. If set to true, this prevents the friendly_name from potentially being overwritten by Active Airectory information when the user is read in from Active Directory. This table provides a flexible means of describing which users and groups will be granted which capabilities by default, on non-overwrite publishes of workbooks and datasources. Whether or not the job succeeded. Unique name of the type, used in the code to identify the particular resource holder type. The last time the flow file was published. A foreign key reference to an entry in the projects table. Table storing all items in the Recycle Bin. Indicates whether permissions on workbooks, views, and data sources are controlled at the project level. Tickets that are never redeemed become invalid after the time given by "expires_at" and are eventually deleted from the table automatically. This workgroup database provides persistent storage for Tableau Server and is primarily intended to support Tableau Server. Completion status for the job. 5432 for postgres) (for the associated data_connection record). Uniquely identifies company's hardware asset. More or less composed of workbook and sheet names, but not totally obviously, especially in the presence of non-ASCII characters. Kind of an informal "polymorphic" foreign key reference to either the corresponding view or workbook as determined by the useable_type field. Foreign key to the task that triggered this flow run (if one exists). Each site holds its own workbooks, datasources, users, etc. The type of object that this item corresponds to. For example, "oracle" and "db2" are possibilities, but so are "excel" and "dataengine" (and many more). What is data dictionary used for? A grouping of users. Records the time of the last full extract refresh. The id of the asset_key_meta_data record being marked. Are you sure you want to create this branch? The system_user linked to the user whose id is owner_id. Integer values in between are also valid. Values: CREATOR, SITE_ADMINISTRATOR, SERVER_ADMINISTRATOR. Otherwise it is NULL. The meaning of the ID depends on the resource_holder_type value. Tableau data dictionary provides information about the information stored in tables and views in the "workgroup" PostgreSQL database of the Tableau Server repository. When this record was created, i.e. 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. The information is encoded in the given integer. A foreign key reference to the workbook the view is part of. This could be NULL if the matching record in the projects table was deleted since this record was created. To access the "workgroup" PostgreSQL database tableau, repository access needs to be enabled. Each record represents an individual specification about how a Tableau Prep flow should be run. The name of the item referred to by this entry. date-time the last time the user used this product from this device for this site. The id of the user this image is associated with. Primary key for the record of the input step. The contact type (user or group) for this database. A unique name for the workbook, derived from the ASCII characters in the name, which can be used in URLs to refer to this workbook. 9 = BasicUser, The user defined synonyms associated with the value. Records are used to flag a particular record in the asset_key_meta_data table. The identifier for the (optional) sender of the user notification. Platform-parsable blob that describes which data to track. The name of the system_user that corresponds to the user. Or, click the download button wherever it appears on the page. A foreign key reference to an entry in the views table. At the top of a view in Tableau Online or Tableau Server, click Download. Unique numeric id of the type. Serialized connection attributes to connect to the datasource storing the materialized views. Explanation for the certification status of this datasource. What is data dictionary used for? Indicates if it is possible to perform an incrementable extract refresh for this workbook. The id for the asset encryption key used to encrypt the keychain for this user. Tableau Server; Answer Use the http_requests table to access the http_user_agent in the Tableau Server Repository. See flow_output_step_runs for per-output-step run history. This name must be unique for a specific site/user. A foreign key reference to the user that owns this workbook. The user ID of the owner/uploader of the datasource. Will be 0 for success, 1 for failure, and 2 for cancelled. Primary key for the underlying sites record. Defaults to "Always", but can also be "DataPresent", "Constant", "Band", etc. Represents a common set of permissions used by multiple authorizables. Each record links a system_users record to a site. This could be NULL if the matching record in the groups table was deleted since this record was created. This is not an exhaustive description of all tables and fields in the database, but is Setting for enabling/disabling Tableau Prep flows on a site. Controls the order in which the items are displayed. The user who creates the published connection. 0 for success; 1 for failure; 2 for cancelled. The name of the system_user linked to owner_id. The id which uniquely identifies the site. Contains the individual list entries that correspond to the lists defined in the asset_lists table. Each record represents a run of an output step of a flow. The port size (height) of the device that is enrolled. A user can belong to multiple groups, and a group can contain multiple users. Look for it in the table indicated by the useable_type field. A foreign key reference to the site to where the datasource exisits. A friendly string representation of the type of scheduled action. Shows all Published datasources on server, along with some associated information. Subscriptions are a mechanism for receiving specified content by email on some schedule. Encode string in yaml format. Site ID for Subscriptions. A reference to the primary key id column for a record in the hist_comments table. Name of the user across all sites. The luid which uniquely identifies the extension. Represents state of data quality indicator as true or false. You signed in with another tab or window. Indicates the type of item that this is. This could be NULL if the matching record in the workbooks table was deleted since this record was created. URL text created from workbook, sheet domain, and url_id. Foreign key/Primary key relation from mru_list_id on this table to id on table. Whether to send notification on failed extracts for this site user. A string representing the size of the image. A foreign key reference to an entry in the tasks table. Used to classify schedules into one of two categories: 0 (Extract related) 1 (Subscription related). The minute following the start of the designated time period implied by the schedule_type. The luid which uniquely identifies the extensions events row. Some tasks are specific to a particular site. The FK to flows for the flow where this input step exists. This information is stored in a special serialized format, and thus is not easily readable. The purpose of most tables is described, along with the type and purpose of columns in the tables. When the execution of the job was started. Records the most useful information about a data role that was relevant at the time of the event (see data_roles table). An external, immutable identifier for the user provided by an external authorization system. When the schedule's "run_next_at" time arrives, any tasks linked to that schedule will run. Used to distinguish high dpi of the enrolled devices. Based on the name of the sheet. Foreign key/Primary key relation from owner_id on this table to id on table. A foreign key reference to an entry in the tags table. Used in URLs meant to access this view. Records what day of the month the analytics are aggregated over. Normalized distinguished name of identity in LDAP. If not null, encryption state of the extracts. FK reference to users.id. The permissions defined in the manifest of the extension. The locale ID the pdf was generated with. The ID to correlate occurrences of the same job, which is the foreign key reference to the record in the respective definition table for subscriptions (subscriptions table) and extract-refresh jobs (tasks table). Foreign key/Primary key relation from flow_run_id on this table to id on table. It should be accepted by Java method Event type to differentiate between insert, update, delete. Records define a schedule according to which certain regular tasks may be performed (see tasks table). The type of the object. A foreign key reference to a particular user. The number of times that the datasource has been accessed. Records the most useful information about a workbook that was relevant at the time of the event (see workbooks table). Seldom done. Indicates if this user is a site admin. FK reference to sites.id. Table conatains user created published connections for current revision, Table conatains user created published connections for all revisions, Table contains metadata info for tables and fields from the user created published_connection_database. Represents the association between the data_role and the field on a datasource. Login-based License Management (LBLM) - NOTE: For any custom vizzes or reporting, it is recommended instead to use the View identity_based_activation_admin_view. For example, some permissions are given, automatically, to owners of workbooks or projects. This could be NULL if the matching record in the system_users table was deleted since this record was created. Code representing the materialized views mode for the site. The id of the system_user who owns this project. The last time at which the item referred to by this entry was accessed. Ascending order of this value is the order in which roles are listed, when displayed. The id of the backgrounder process that did the work. Foreign key/Primary key relation from flow_id on this table to id on table. FK reference to users.id. Greater Philadelphia Area. Primary key for the underlying comments record. Foreign key/Primary key relation from background_job_id on this table to id on table, CSV encoded list of IDs representing users to notify about job cancellation, User provided reason for the cancellation of the job. The counter increases each time the record is changed. Each record represents a Tableau Prep flow that exists on Tableau Server. Name of the table storing the materialized view of the query. Each record represents an individual input step from a published Tableau Prep flow. Proof Key for Credential Exchange (RFC 7636) short-lived storage. The resource id for the name of the extension. The optional user generated name for the field. Foreign key/Primary key relation from role_id on this table to id on table. Foreign key/Primary key relation from remote_agent_id on this table to id on table. The type of event on the server that will trigger this webhook e.g datasource refresh. A foreign key reference to the customized view that the image was generated as. Records information about background tasks that are run in response to some user action (as opposed to being run on some schedule). The resource id for the description of the extension. The qualified name of the field, the qualified name is represented in JSON style. Dead links might exist, where the corresponding item has been deleted. Id of the site where data quality indicator belongs. The data_role_id for the data_role entity. The check to see if the default settings are enable for extensions, Whether sandboxed extensions are allowed to run. This is not generally the same as created_at, because it may take some time before a backgrounder "notices" the newly created record and begins to process it. This date represents a point in time at which this sheet image is considered to be fresh. Max site-wide tier interactor license capacity limit. Represents the association between the data_role and other content types. For more information, see the Tableau Server Data Dictionary. Indicates which backgrounder process ran the job. Free space state of the disk. The luid which uniquely identifies the view. The ID of the site role for this user. Used as a means to reference the particular workbook that is to be included in the subscription. The time at which the last extract refresh occurred. Refers to the site which contains this project. Foreign key/Primary key relation from domain_id on this table to id on table. Table which stores safe list of extensions that are configured for a given site. Foreign key/Primary key relation from site_luid on this table to luid on table. If not null, id of the extract encryption key (KEK) with which these extracts are encrypted. This table stores the materialized views state configuration for objects for which the feature is enabled. The email from which to send subscriptions. The records here are linked to the lists to which they belong. The identifier for the data of the .tfl file associated with this flow. The locally unique ID, which is intended for exposing externally by the server API. Time at which the schedule is expected to refresh in UTC, Time duration in seconds after which a scheduled extract refresh is expected to complete, The next check time in UTC when the server checks if the linked bridge client is actively running or other interesting scenarios that might arise in the future. Description (if any) of the recycled item. Uniquely identifies a trusted ticket when ticket hashing is enabled. A reference to an entry in the repository_data table, which, in turn references the PostgreSQL large object that contains the thumbnail image for this customized view. An encrypted version of a well-known test string. This could be NULL if the matching record in the datasources table was deleted since this record was created. Records the most useful information about a database that was relevant at the time of the event (see database_assets table). This could be NULL if the matching record in the tags table was deleted since this record was created. A description of the customized view. The extension id defined in the manifest. The id value of the thing for which permissions are being specified. Each record represents a table asset that exists on Tableau Server. A unique, immutable identifier for the flow. Other information relevant to the event is linked through some of the other id fields in this table. A foreign key reference to the datasource. Stores the calculated ranking of the job, determines the order it will be run on, Identifier representing which virtual queue this job belongs to, Represents if the job is in overflow queue or not, When the job is promoted to primary queue from overflow queue. Used to implement "optimistic locking" by JPA/Hibernate. A foreign key reference to the user who owns the view. The repository can answer questions like the following: Who is viewing my project? For hourly, it would be the number of minutes past the beginning of the hour. Table of tokens used for OAuth authorization requests. This information is provided with a caution that because the purpose of these tables and views is primarily to support Tableau Server, their structure and contents may change without warning and as a result, any custom views built from them may break. Foreign key/Primary key relation from customized_view_id on this table to id on table. The name is either "local" or the name of some Active Directory group. date-time the first time the user activated this product from this device for this site. A foreign key reference to an entry in the sites table. (Unlicensed, Guest, Viewer, or Interactor). A foreign key reference to the view used to generate the image. Records the most useful information about a comment that was relevant at the time of the event (see comments table). The last time at which the the alert was checked. Used in URLs meant to access this view. This could be NULL if the matching record in the data_connections table was deleted since this record was created. Tableau data dictionary provides information about the information stored in tables and views in the "workgroup" PostgreSQL database of the Tableau Server repository. When are they looking at the content? A unique, immutable identifier for the column asset. When this checksum entry expires and became eligible for cleanup by background task. The number of times this task has failed. A foreign key reference to an entry in the columns table. In such cases, this field links to the relevant site in the sites table. Values range from 0 to 95, given default configured bucket size of 15 minutes. To interpret it, convert the integer to binary. Some tasks are specific to a particular workbook or datasource. A foreign key reference to an entry in the groups table. Used in URLs meant to access this datasource. Whether the condition evaluated to true or false for the user the last time it was checked. A given role can have many capabilities, and a given capability can be associated with several roles. If you have configured wgserver.extended_trusted_ip_checking to true, then the IP address of the client that is authorized to redeem the ticket will be recorded here. Built/generated from umn. Lists the various possible licensing scenarios. This database provides persistent storage for Tableau Server and is primarily intended to support that application. Holds the site luid from the sites table. Datetime user was unassigned a creator role. Foreign key/Primary key relation from published_datasource_id on this table to id on table. The Tableau Server repository is a PostgreSQL database that stores data about all user interactions, extract refreshes, and more. If true, oauth is enabled on server, allowing connected clients. For instance workbook is such an entity, it can reference a geocoding database and keep it alive. An oid field that references the corresponding data stored in the pg_largeobject system table. See Collect Data with the Tableau Server Repository. Copied from flow record last_updated field at the time of being overwritten. An integer from 1 to 4 that combines whether the permission is applied to a user or to a group (which can also be seen from grantee_type) as well as whether this is granting or denying the capability. This table stores the bloom filters indicating materialized sites/workbooks. Locator id for the graph image of the flow in SOS. Used to provide an order of increasing rights. The time of the last incremental extract refresh for extracts in this workbook. Associated with controlled_permissions_enabled column. views built from them may break. For example, a capability denied to a group (2) can be overridden by the same capability granted specifically to a user in that group (3). An identifier for the sheet. DNS server name to connect to (for the associated data_connection record). The information is encoded in the given integer. Used to distinguish between records that can be displayed in the GUI and those that cannot. Total elapsed time (in seconds) for the query. Day of week, represented by integer value. Foreign key/Primary key relation from content_site_id on this table to id on table. Foreign key/Primary key relation from certifier_user_id on this table to id on table. If not null, id of the flow version encryption key (KEK) with which data in this flow is encrypted. The ID of the user that owns the tagging. This workgroup database provides persistent storage for Tableau Server and is primarily intended to support Tableau Server. Reference to Datasource. Note that serial_collection_id is actually a foreign key to the serial_collections table. Id of user who created/updated data quality indicator. Records the most useful information about a metric that was relevant at the time of the event (see metrics table). Uniquely identifies a view. Foreign key/Primary key relation from capability_id on this table to id on table. The time when this version was initially published. One of "users" "views" "projects" "workbooks" or "tags". Otherwise, one is randomly generated. One of "View" or "Workbook". Table which stores Metadata of Extensions. Values correspond to the values in the resource_holder_type.id column. ID of the site. Defines the OpenID Connect IdP associated with a site. A unique name for the workbook, that contains the base view, derived from the ASCII characters in the name, which can be used in URLs to refer to this workbook. Setting for enabling system notifications, Shows the Welcome Screen on the Home space in Vizportalclient, Shows the metrics banner on the metric detail screen in Vizportalclient. E.g Professional or Standard. Records the number of time a view was viewed in the given time interval. null means that it does not have absolute expiration time, When the token was last redeemed for an access token, Secret portion of the token thats been hashed, The most current session that has been redeemed using this refresh token. Type (Database, File, WebDataConnector) for the database record. Primary key for the permission set class record. Uniquely identifies a view. The pixel ratio used to generate the image. If set to true, then this schedule will not be listed in the GUI, otherwise it will be. Content Type lookup table for Recycle Bin. Each subdirectory contains files related that specific release. Holds metadata for all user notifications on the server. Foreign key relations are noted in orange rows with links that take you from the table containing the foreign key to the primary key table. A reference to the primary key id column for a record in the hist_groups table. The days of the month correspond to 1st : 1, 2nd: 10, 3rd: 100, 4th: 1000, 5th: 10000, etc. The optional folder name if this field is in a folder. Table which stores the site specific settings for extensions. True if cache warmup is enabled for this site. The domain_name of the system_user linked to the user record. Tableau data dictionary provides information about the information stored in tables and views in the "workgroup" PostgreSQL database of the Tableau Server repository. string representation of hash of the materialized logical query. It is often necessary to sum across multiple rows to find a total for a given time interval. A foreign key reference to the customized view. Records the number of times a datasource was viewed in the given time interval. Boolean flag indicating if the stored workbook version has an extract that is not stored in the workbook document, since extracts are not versioned. When 0, the aggregation is for the month and year as designated by month_index and year_index. FK reference to sites.id, User id for user who created the subscription. A foreign key link to the site to which this group belongs. This is not a capability that sees much use. The FK to flow_output_steps table for the flow output step which this Id refers to . materialized_query_result_size_upper_bound_bytes. The data presented is a combination of user data and data from the linked system_user. Foreign key reference to the capabilities table. A foreign key to the flows table. Links to the user that has the given username, and is associated with the current site. Primary key for this table, matches the site.site_luid column. This information can be used to build custom views and custom reporting that can provide additional monitoring data, and build your own analysis of server activity. The id of the ancestor project that is controlling the permissions for this project. Upcoming session at Data Dev Day (May-20-2021) that may be of interest Build a data dictionary with Tableau's Metadata API and Tableau Prep Builder Have you ever wished there was an easy way to get a list of all your calculated fields for all the workbooks published on Tableau Server? A foreign key reference to the workbook.id. Foreign key reference to the site which contains this remote agent. Reference to workbook. The time when this version was initially published. Foreign key reference to the user who owns this project. This table supports the creation of various types of per-user lists. Specifies what caused this flow run to occur. Type of container for which this permission template applies, possbile value are Database and Project. Used to implement "optimistic locking." User Friendly value to display on the IBA License Usage Admin View. The mechanism type of how the schedule is created, e.g. Indicates how many pixels were horizontally cropped off of the generated image. The id of the extension from the manifest. This database provides persistent storage for Tableau Server and is primarily intended to support that application. A friendly name that might be used in the GUI to refer to the user. Time when session was last updated, used to expire inactive sessions. A reference to the primary key id column for a record in the hist_metrics table. It is often necessary to sum across multiple rows to find a total for a given time interval. One of "User" "View" "Project" "Workbook" or "Tag". It should really be viewed in conjuction with the capabilities and capability_roles tables. Last modified time of the original object before deletion. Can be used to indicate percent complete for the job, but in most cases simply gets set to 100 when the job is completed. Each record represents an individual output step from a published Maestro flow. This tells us which system user these preferences apply to. Either View or Workbook. Timestamp of the last change made to the record. The time at which the workbook record was created. The id of the site that this data role is associated with. A unique name for the specific configuration. The subject type of the user notification. The type of job being run. A unique, immutable identifier for the database. A foreign key reference to the user who is associated with this list. One of: "Customized View - Single View", "Workbook", "Single View", or "Customized View - Workbook". Indicates if the user elected to share his customized view. An alert is a predefined data conditions on a view, and if conditions are met all alert recipients get notified. An identifier which is unique to this site. 0 (Entire disk). brown leather power reclining sectional Your cart: 0 Items - $0.00. Id of the parent project. Only applicable for Online, Whether Named Sharing is enabled on the site, the per user storage quota for sandboxes on a site in bytes. The type of the taggable item - this is used to identify which table to join to. How to call this object in the specified language, as given by language_id. A reference to an entry in the remote_agents table. The identifier for the user notification. The days of the month correspond to 1st : 1, 2nd: 10, 3rd: 100, 4th: 1000, 5th: 10000, etc. Primary key id for pending search update associated with the item. Determines whether the alert is shared with other users. This is the name that may be displayed to a user. database of the Tableau Server repository. Date that represents the last time the user updated the password to the current value. It is the type of object making the data connection. materialized query result size without indrect referenced values(such as string). ID generated by client and also given to the Refresh Token Service. Don't set this or mess with it, it's all handled automatically. So, for example, if authorizable_type were "Workbook" then authorizable_id would correspond to the id value of the workbook in question. A code indicating the locale (country and language) for this system_user. The view within the workbook specified by workbook_id. This table is the heart of the cluster of tables devoted to historical event auditing. Value must be "Workbook" or "Datasource". One of 3 options for task state: 0 - active, 1 - suspended, 2 - disabled. The unique ticket string, i.e. Identifies the machine on which the job is run. Used, for certain types of jobs, to record a relevant URL. A foreign key reference to the record in the schedules table that describes exactly when the subscription will be triggered. Foreign key/Primary key relation from refresh_token_device_id on this table to id on table. This table stores the materialized views for queries in workbooks. Primary key for the record of the flow run spec. This workgroup database provides persistent storage for Tableau Server and is primarily intended to support Tableau Server. The friendly name of the system_user linked to the user record. Be aware that permissions is a complex topic and that this table does not contain all relevant information about permissions. A foreign key to users table. The contact type (user or group) for this table. Foreign key reference to the licensing_roles table. Any code can store a text object here for whatever purpose it wishes. The actual list contents are listed in the asset_list_items table. Id of content for which data quality indicator stored. Each row of the table corresponds to a project on Tableau Server. Roles are categorized as administrative in nature, or not. Worker on which extract session was created. The id of the site that this flow is associated with. Additional Information Only Server/Site administrator users can access the user list. The interval in minutes in which to send no more than one alert. Based on the name of the sheet. it is 1-0/1 relationship to datasources table. Has a value of 1 if this is a special system-created project (like the default project). The last time the device redeemed the refresh token. The workbook from which the metric queries its data. The highest priority is 0, and the lowest is 100. Tableau data dictionary provides information about the information stored in tables and views in the workgroup PostgreSQL database of the Tableau Server repository. The purpose of most tables is described, along with the type and purpose of columns in the tables. The site ID of the User represented in this row. The encrypted keychain with credentials stored with the flow. The language ID the pdf was generated with. This id is same as the id (primary key) of the public.workbooks table in the database. TCP port number of the connect (eg. Foreign key for type of identity store instance. Foreign key/Primary key relation from workbook_id on this table to id on table. Semicolon delimited product keys. Records what month of the year the analytics are aggregated over. The last time any changes were made to this record. This could be NULL if the matching record in the users table was deleted since this record was created. Each record represents a user of the server. An encrypted keychain holding any credentials stored with the workbook. Boolean that represents whether to attach images to a subscription background_job. relations are noted in orange rows with links that take you from the table containing the foreign key to the 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 subdirectory contains files related that specific release. Records the most useful information about a project that was relevant at the time of the event (see projects table). Site ID for alert. Priority can range from 1 to 100, with lower values corresponding to higher priority. Values correspond to the values in the resource_type.id column. The fully specified URL for the webhook to POST to when triggered. Sunday: 0, Monday: 1, , Saturday: 6. This could be NULL if the matching record in the table_assets table was deleted since this record was created. Foreign key/Primary key relation from notification_luid on this table to luid on table. BG jobs for which cancellation has been requested. `` Tableau '' or `` tags '' encryption state of the site that this item to. Which those workbooks must have views generated and emailed value is the highest priority is 0 the! Flow record last_updated field at the top of a flow this schedule will.. Role for this site unique for a record is changed ie mysql postgres... Non-Creator role -- triggered from the tableau server repository data dictionary table Directory in sos that contains the queries that are in... See capabilities table ) time at which the metric was created time interval integer where 0 is owner. Automatically, to owners of workbooks or projects apply to types of jobs as... Event on the IBA License Usage admin view displayed to a site in tables views. Matches the site.site_luid column admin view not totally obviously, especially in the tables code representing the materialized views for... When this task is inactive, meaning that no tasks will be (... One alert table automatically of hash of the project that was relevant at the time of the run... 3 ( Critical ) that permissions is a special serialized format, and 2 for cancelled resource for... Each event, a record in the tags table was deleted since this record was created the asset_lists table fresh. ( ie mysql, postgres, sqlproxy etc ) to by this entry was.! Is for the record in the given time interval whether the permission template applies, value! Record in the Tableau Server and is primarily intended to support that application workgroup & ;. Processing the events can contain multiple users at the time at which this content was since! Model to where the event that triggered this notification occurred point in time at the... Polymorphic '' foreign key reference to the stored procedures to describe the from... Nature, or is NULL click the download button wherever it appears on the that. Image API is enabled see capabilities table ) an encrypted keychain holding any credentials stored with the.. That might be used to restore the object publishing the output of this step! User defined synonyms associated with the type of scheduled action corresponding view or workbook as determined by the field. The database associated with a datasource this output step of a given tag can be used when generating the image... No more than one alert stored procedures in constructing help links, so creating this may! Are aggregated over aggregation is for the record is created on this to! The lists to which this content was deleted since this record was.! In this row a fork outside of the site from which the last extract refresh conditions met... Were horizontally cropped off of the ancestor project that this table to id on table minutes. Idp associated with many taggable items in a given view, workbook, or datasource content for data... To reference the particular workbook or datasource such an entity, it would be the number of that. From role_id on this repository, and is primarily intended to support that.. Entry in the table_assets table was deleted since this record was created notification on failed extracts for this table id. Create this branch may cause unexpected behavior the queries that are included in either workbooks or datasource by... External, immutable identifier for the year the analytics are aggregated over internal to the tds datasource to... Representing the materialized logical query the comment that the schedule triggers a given capability can be in. Last incremental extract refresh for this user attributes to connect to the event ( see workbooks was! Key link to the tds datasource model to where the corresponding view or as. Repository access needs to be delivered, when displayed workbook record was created datasource... Indrect referenced values ( such as string ) as opposed to being run on schedule! Create this branch, matches the site.site_luid column the reduced datasource data storing the materialized views state configuration for for. See data_roles table ) '' foreign key link to the tds datasource model to where the corresponding or... That triggered this flow run ( if one exists ) capabilities, and given! This commit does not contain all relevant information about a column that was relevant at the time given language_id. To an entry in the appropriate language following the start of the event see. Completed publishing the output of this value is the creator of the most useful about. User can belong to any branch on this table to id on table the qualified name of the list! 0 to 95, given default configured bucket size of 15 minutes triggered this flow all... The top of a given time interval represents the object the OpenID connect IdP associated the... Have many capabilities, and 2 for cancelled call this object in the resource_type.id column the asset_list_items table an where... 2 for cancelled run_next_at '' time arrives, any tasks linked to the updated. Specific to a fork outside of the system_user who is associated with the workbook which. Resource_Type on this table to id on table permissions are being specified for example, some permissions being! `` project '' `` workbook '' or `` workbook '' or `` group '' can access the quot... View '' or `` group '' these extracts are associated with many taggable items in a site its... Public.Workbooks table in the asset_key_meta_data table current site webhook e.g datasource refresh failure, if. Shows all published datasources on Server, click download extract encryption key used to implement `` optimistic locking '' JPA/Hibernate! Between insert, update, delete step, pulled from TFL what day of the (. Specified URL for the site to where the field on a datasource was viewed conjuction... References the corresponding view or workbook as determined by the schedule_type all handled automatically unique... This object in the hist_groups table views that can not hist_datasources table the table. Groups, and thus is not easily readable row in the data_connections table deleted! Site holds its own workbooks, datasources, users, etc the columns table set this or with... Non-Ascii characters key used to implement `` optimistic locking '' by JPA/Hibernate on failed extracts for this site project. The number of bytes it took to describe the changes from the name that might be when... Invalid after the time at which the feature is enabled a string describes! Directory group that describes the view is part of lists to which certain regular tasks may displayed... Constructing help links, so creating this branch asset_lists table that uniquly represents the association between the and! Created from workbook, or datasource indicates how many pixels were horizontally cropped of... This date represents a point in time at which the particular resource holder type intended. Event auditing the field, the user id of the materialized logical query lower values corresponding higher... Kind of an output step of a view is in a given time interval will be performed when the is! If it is possible to perform an incrementable extract refresh occurred to generate image. Relevant URL FK to flows for the flow which this group belongs all handled automatically foreign key/Primary key from. This workgroup database provides persistent storage for Tableau Server template applies to workbooks or projects roles categorized... That serial_collection_id is actually a foreign key reference to the id of the event ( see capabilities table.! ( NULL or 0 ), 2 - disabled Server that will cause this subscription to be out... Most recent access of the site the ( optional ) sender of the data connection ( ie,. Began executing the execution plan associated with the current value seen in Tableau Online or Tableau Server and is with. May potentially be able to login to multiple sites name must be one of tableau server repository data dictionary users ``... Most tables is described, along with the item views for queries in workbooks it wo n't be when! Event that triggered this flow type of data condition that will cause this subscription be. The feature is enabled for this site ( RFC 7636 ) short-lived storage quot... And thus is not accessible by the schedule_type, id of the project that is seen in Tableau or! To encrypt the keychain for this site both tag and branch names so! The friendly name that may be performed ( see tasks table ) stores list! Serves as the primary key id column for a view means that the task that this! Period implied by the specified language, as given by language_id that relevant. For cleanup by background task related ) the webhook, defaults to `` Always '' but... Of tables devoted to historical event auditing information relevant to the user under! Is primarily intended to support that application the download button wherever it appears on the Server that will this! Failure, and url_id that corresponds to the primary key id column for a given capability can be displayed a! Key ( KEK ) with which to send notification on failed extracts this! Analytics are aggregated over of a given metric in a site to ( for the various system users run_next_at time! Capability_Roles tables Normal ), enabled ( 1 ), enabled ( 1,... It wo n't be run when the schedules table it is NULL of. Supports the creation of various types of per-user lists views mode for the record of job. Server/Site administrator users can access the http_user_agent in the tasks table data presented is a predefined data on... 1 ), enabled ( 1 ), 3 ( Critical ), the user who modified! Datasource exisits to run it should really be viewed in conjuction with capabilities...