The timestamp when the record was last updated. Workgroups Database - Tableau Open Source The identifier for the data of the .tfl file associated with this flow. This table is used to track how many times each user has accessed different views. Value of a property for a node present in graph. Type of the entity which references the resource. Foreign key/Primary key relation from capability_id on this table to id on table. Null if no sessions have been redeemed, Reference to the device the token is issued to, Secret portion of the token thats been hashed for the next refresh token, The salt used when hashing the secret for the next refresh_token. The name is either "local" or the name of some Active Directory group. A foreign key reference to an entry in the tables table. The name of the input step, pulled from TFL. For instance, for workbooks it is the workbook ID. This table provides a flexible means of describing which users and groups have been granted which capabilities, on which things. Whether or not the job succeeded. Uniquely identifies a view. In such cases, this field links to the relevant site in the sites table. FK reference to users.id. A reference to the primary key id column for a record in the hist_column_assets table. Identifies the machine on which the job is run. Which type of authentication to use, e.g. May not be implemented across all events. The primary key for the underlying workbook record. 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. Site ID for alert. This could be NULL if the matching record in the groups table was deleted since this record was created. A reference to an entry in the repository_data table. Identities for legacy Active Directory identity stores. A reference to the primary key id column for a record in the hist_database_assets table. Represents a single next_gen_permission in a permission_set. Represents the association between the data_role and other content types. The permissions defined in the manifest of the extension. This could be NULL if the matching record in the workbooks table was deleted since this record was created. The minimum site role given to members of the AD group, Last time that synchronization for an AD group was completed, the id of the minimum site role of the group. A foreign key reference to the customized view that the image was generated as. An authorizable may have a permission set for every permission_set_class. Whether controlled permissions are enabled for the database. One of either "Workbook" or "Datasource". The user who last modified and published this workbook to server or saved the workbook during web edit. This could be NULL if the matching record in the projects table was deleted since this record was created. Changing the My Tableau Repository Location Holds whatever text object is desired. The name of the project that this workbook is part of. The FK to flows for the flow which this run spec is about. When this record was created, i.e. Collect Data with the Tableau Server Repository - Tableau The meaning of the values is: 1: grant to group, 2: deny to group, 3: grant to user, 4: deny to user. The size, in bytes, of this version of datasource. A relative url of the start page saved by the user. But because data sources are more general than databases, in some instances, this might actually be a file path, or blank. date-time the last time an ATR request returned from from the ATR Service UNSUCCESSFULLY-(FAILED) for this user, device, product and site. A foreign key link to the user who owns this group. May no longer exist. If this is anything other than "active" then the project is inactive. support Tableau Server, their structure and contents may change without warning and as a result, any custom The name of the system_user who will receive the subscription. Foreign key/Primary key relation from permission_set_id on this table to id on table. This table is used to link various customized views to the subscriptions in which those customized views must be generated and emailed. Indicates what user id is the creator of the task. Foreign key/Primary key relation from group_id on this table to id on table. Records the most useful information about a group that was relevant at the time of the event (see groups table). Records the most useful information about a table that was relevant at the time of the event (see table_assets table). When 0, the aggregation is for the month and year as designated by month_index and year_index. Generally 1-to-1 with capabilities. A unique name for the specific configuration. Proof Key for Credential Exchange (RFC 7636) short-lived storage. 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. The FK to flow_output_steps table for the flow output step which this Id refers to . Uniquely identifies company's hardware asset. A foreign key reference to an entry in the data_connections table. Serves as a cache for all the sheet images generated by server. You might want to do this if you have a particular server you want to use for your active repository (a computer with more disk space or memory for example), or if you are using custom administrative views. Describes various data sources that are included in either workbooks or datasources. Foreign key/Primary key relation from creator_id on this table to id on table. May no longer exist. This could be NULL if the matching record in the table_assets table was deleted since this record was created. Primary key for the user notification recipient. Primary key for the pending search update item. FK reference to sites.id. The id of the system_user that corresponds to the user. Access to content is provided as if the ticket redeemer were this user. The Tableau repository is a PostgreSQL database that can be accessed from Tableau Desktop. This table is really just used for internal purposes. The type of object that this item corresponds to. A reference to the primary key id column for a record in the hist_comments table. materialized_query_result_size_upper_bound_bytes. Id of user who created/updated data quality indicator. The luid which uniquely identifies the site. Platform-parsable blob that describes which data to track. User site role ID is unique key correspondent to site_role_id from users table. Indicates the site to which this datasource version belongs to. Values range from 0 to 95, given default configured bucket size of 15 minutes. ID of key used to encrypt the token secret. The identifier for the subject of the user notification. Remote agents are programs installed on customer PC and executing tasks Foreign key reference to the system_users table. LiveQueryAlpha, LiveQueryBeta, LiveQueryV1. Foreign key to the site to which the user belongs. Indicates if the domain is active or not. Foreign key/Primary key relation from type_id on this table to id on table. The upgrade process will migrate the content from your current external repository to your new instance. Foreign key/Primary key relation from database_id on this table to id on table. The extension id defined in the manifest. The id of the project that this data role lives under. Maximum storage for the site in megabytes. Reference to workbook. Allows site filtering to work on Admin Views. The time at which this record was created. The last time at which the the alert was sent to the user. Each record represents an entry of Semantics Service data role metadata. Reference to Datasource. Uniquely identifies a trusted ticket when ticket hashing is enabled. Copied from flow record last_updated field at the time of being overwritten. The last time the flow file was published. Automatic repository failover means that if there is a problem with the active Tableau Server repository, the server will automatically switch to using the passive repository. If not null, id of database that is a duplicate of this one. Is set to null for published datasources or else references the workbook id that contains this datasource. Follow a community of data enthusiasts Keep getting inspired by your favorite Tableau authors. 5 : site admin, 0 : not site admin. Indicates the type of item that this is. Foreign key/Primary key relation from materialized_view_connection_id on this table to id on table. The actual name of 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. A user can belong to multiple groups, and a group can contain multiple users. The FK to flows for the flow where this input step exists. Data managed by Tableau Server : consists of the Tableau PostgreSQL database or repository, and File Store, which contains workbook and user metadata, data extract files, and site configuration data. Identifies the content-type which is associated with the data_role. Many-to-many mapping table between authorizables and permission sets. Only Tableau admins have access to the Tableau Server Repository. 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). The text content of the user notification. A foreign key reference to an entry in the datasources table. The luid which uniquely identifies the extensions instance row. Usually NULL for job that are attempted only once. date-time the last time an ATR request returned from from the ATR Service SUCCESSFULLY for this user, device, product and site. It is often necessary to sum across multiple rows to find a total for a given time interval. User license role rank for the purpose of licensing users with the correct priority when the number of available licenses is less that users. The site ID of the User represented in this row. date-time when the user activated this product from this device for this site for the first time. A foreign key reference to an entry in the schedules table. Records the most useful information about a data source that was relevant at the time of the event (see datasources table). This includes custom data connectors, shape files, bookmarks, style sheets and more. Artificial auto-incrementing integer that serves as the primary key. The luid which uniquely identifies the view. A foreign key reference to an entry in the metrics table. Used in the perm_users_*_capabilities functions. Each record represents a partial aggregation of analytics for a given datasource in a given time interval. Time when session was last updated, used to expire inactive sessions. Can be used to indicate percent complete for the job, but in most cases simply gets set to 100 when the job is completed. When calculating effective permissions in the perm_users_*_capabilities functions, this table maps the integer precedence of the effective permission rule to the varchar effective permission reason. Unique identifier of the device. The Tableau Server repository is a PostgreSQL database that stores data about all user interactions, extract refreshes, and more. For example, if the PostgreSQL minimum compatible version is 13.4, the maximum compatible version is 13.x where is equal or higher than 4. Type of the resource, e.g. Datasource ID from datasources table. The name of the database associated with the published datasource. Primary key for the record of the output step. However other configuration problems may not trigger a failure for up to 5 minutes. The following exceptions apply to Tableau Servers using external repository: Any custom user accounts that are created in the external Tableau Server repository will be included in the restore, but the passwords for the custom user accounts will not be. The passwords will have to be reconfigured after restore is complete. Taken together, these tables associate different roles with different sets of capabilities. Capabilities are things like read, write, export_data, publish, web_authoring, etc. 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. The data alert from which the metric queries its data. materialized_query_result_size_lower_bound_bytes. This is how the system identifies what code to execute when this task is to be run. Whether user chooses incremental run in scheduler. Subscriptions are a mechanism for receiving specified content by email on some schedule. Because the database and its contents are intended to support Tableau Server, the structure and contents may change without warning. The IP address of the originator of the request. A foreign key reference to the site to where the datasource exists. How To Use Tableau Repository to Monitor Your Tableau Server 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. Foreign key/Primary key relation from data_alert_id on this table to id on table. Display Database Stored Images | Tableau Software The last time at which the the alert was checked. Represents the association between the data_role and the field on a datasource. Those lists are defined in the mru_lists table. Devices that have been issued at least one refresh token, Tokens issued to clients which can be redeemed by the client for access to the server. The highest priority is 0, and the lowest is 100. For example, some permissions are given, automatically, to owners of workbooks or projects. Primary key for the permission set class record. sAMAccountName of identity in Active Directory. The name of the specific event that occurred. Disk space used by the resource in bytes. Links to the user who triggered the running of the job. Timestamp at which the view is considered obsolete and becomes a candidate for removal by MaterializedViewService.garbageCollector. Serialized connection attributes for the source datasource connection from which the materialized views are created. Records the most useful information about a comment that was relevant at the time of the event (see comments table). With these conditions satisfied, repository failover will occur if the active repository becomes unavailable, either due to a problem with the process, or a problem with the node the process is running on. Workgroups Database Introduction. Associated with controlled_permissions_enabled column. Looking for Tableau Server on Linux? A foreign key reference to an entry in the users table. The port size (height) used to generate the image. For more details, see Upgrade Tableau Server with External Repository for a New Major Version of PostgreSQL. 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. When the job finished execution. A reference to an entry in SOS which references a tcv file of the viz state. Locator id for the graph image of the flow in SOS. Links to a site, if one is relevant, otherwise it is left NULL. This is automatically generated. Two jobs with the same serial_collection_id cannot be processed simultaneously. Explicitly not a foreign key to allow for tasks to be deleted without deleting related job records. A reference to the primary key id column for a record in the hist_metrics table. the time of creation of the ticket. Table which stores safe list of extensions that are configured for a given site. Can be used to provide some additional information about the job. One reason would be if that instance of the repository is installed on a computer with more resources. updated on each publish. The name of the domain that the user belongs to. A foreign key reference to the site that the workbooked referred to by repository_url belongs. Refers to the type of the authorizable (e.g. relations are noted in orange rows with links that take you from the table containing the foreign key to the Each record represents a partial aggregation of analytics for a given metric in a given time interval. database of the Tableau Server repository. Whether this datasource is using remote query agent. 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. The id of the system_user that owns the tagging. Used to classify schedules into categories: 0 (Extracts), 1 (Subscriptions), 2 (Sync AD users and groups), 3 (Auto Refresh Extracts), 4 (Flows). The following "data dictionary" provides information about the tables and views in the "workgroup" PostgreSQL database of the Tableau Server repository. Login-based License Management (LBLM) - Database view to faciliate Admin Server and Site Views for Login-based License Usage Reporting. A string representing the size of the image. Used as a means of passing parameters about the background job. This is not an exhaustive description of all tables and fields in the database, but is This table stores the bloom filters indicating materialized sites/workbooks. Contains a listing of information about languages for which Tableau Server has been localized. Used to store database_asset events stream. The type of job being run. The id of the site associated with the flow which the entire flow run spec is about. This could be NULL if the matching record in the tags table was deleted since this record was created. The highest priority is 0, and the lowest is 100. Foreign key/Primary key relation from refresh_token_device_id on this table to id on table. Max site-wide tier interactor license capacity limit. Will be NULL if the background_job is not a subscription. Do not set this or mess with it, its all handled automatically. This database provides persistent storage for Tableau Server and is primarily intended to support that application. it is 1-0/1 relationship to datasources table. Records the most useful information about a task that was relevant at the time of the event (see tasks table). Revision of the workbook whose id is the workbook_id column. Links to the user who created this record, or is NULL. If set to false, this means that the task is inactive, implying it won't be run when the schedule triggers. (Can be used for on-premises, Azure VM, or AWS EC2 installations). The ID of the customized view the metric was created on. Follow authors on Tableau Public to receive updates when they publish new visualizations or add to their favorites. Characters beyond 9 replaced with X. Controls the order in which the items are displayed. Each tag is a string value. Create custom maps, charts, and graphs in clicks Based on the name of the sheet. This could be NULL if the matching record in the tasks table was deleted since this record was created. Starts with 1.0 and increments by 0.1 with each republication. Can point to deleted user. True if the notification has been read, false if it is unread. It is considered to reside in Recycle Bin until either restored or permanently deleted. One of: "Customized View - Single View", "Workbook", "Single View", or "Customized View - Workbook". 10 : system admin, 0 : not a system admin. A nice readable name for this type of job. XML block of the EntityDescriptor for the Identity Provider. Used to implement "optimistic locking". Used to indicate a point in time, after which the schedule should never trigger. Seems not to be used commonly. Holds metadata for all registered webhooks on the server. The number of bytes used in storing the workbook information. Most recently used lists by user. Foreign key/Primary key relation from flow_run_id on this table to id on table. A foreign key reference to the user who is associated with this list. Records the time of the last full extract refresh. ID of the entity for which this entry was created. The remote query agent name used by the data source. The name of the domain that this group is linked to. User will typically be enrolled onto server by logging into server through the mobile client. The check to determine if the current entry is active or archived. The Tableau Server Repository is a PostgreSQL database that stores data about all user interactions, extract refreshes, and more. A reference to the primary key id column for a record in the hist_datasources table. When you use TSM to create a backup, all of this data is saved in a single file with a .tsbak extension. A foreign key reference to an entry in the views table. Describes the type of thing for which permissions are being specified. Unique identifier with which to associate to the refresh token series. if not set the value from global_settings.start_page_uri is used, Alternative Federation Engine (afe) is enabled or not, Whether to enable sandbox for the site or not, Setting for enabling/disabling Viz Recommendations on a site, Setting for enabling/disabling biometrics for mobile clients for a site, Setting for enabling/disabling Identity Based Activation on a site. Dead links might exist, where the corresponding item has been deleted. True or false as to whether incrementable extracts are allowed for the published datasource. This data includes information about Tableau Server users, groups and group assignments, permissions, projects, data sources, workbooks, and extract metadata and refresh information. When the items are shown in order, this field defines that order. materialized query result size without indrect referenced values(such as string). An identifier for the sheet. A string uniquely identifying a computer. serialized_materialized_view_connection_attributes. Foreign key/Primary key relation from instance_id on this table to id on table. When true admins receive notification about suspended alerts, When true, users will see mark animations on sheets. A code indicating the locale (country and language) for this system_user. Your Tableau Server must be using the following versions: For the right version of PostgreSQL to use, see Azure Database for PostgreSQL Flexible Server . Querying Tableau's internal PostgreSQL repository database - Medium Records the most useful information about a schedule that was relevant at the time of the event (see schedules table). Note:The maximum compatibility version for any Tableau Server version is the minimum major version or any minor update to that. The repository can be installed as locally on the same nodes as the Tableau Server or installed externally: The port on which the request was received. Number of times this task has run since we created this column. Data roles are stored in table `data_roles`. Records the most useful information about a workbook that was relevant at the time of the event (see workbooks table). Type of content for which data quality indicator stored. date-time the last time the user used this product from this device for this site. The identifier for the user notification. Each record represents a Tableau Prep flow that exists on Tableau Server. customer desktop and performing automatic data source refreshes based on schedules defined by customers. identifies the logo image on the storage back_end. Table which stores Metadata of Extensions. The following "data dictionary" provides information about the tables and views in the "workgroup" PostgreSQL database of the Tableau Server repository. Whether file is embedded (e.g., packaged in a twbx/tflx) or not. The id value of the thing for which permissions are being specified. It is possible to designate a job as part of a "serial collection," by setting its serial_collection_id. Records the most useful information about a user and corresponding system_user that was relevant at the time of the event (see users and system_users tables). The last time at which the the subscription was sent. Whoever creates the serial collection can decide what they want this description to say. Foreign key to site_roles table to allow access to site_roles display_name. Version of the flow file, increments by 1 on each publish. Records the most useful information about a site that was relevant at the time of the event (see sites table). Must be one of "Project" "Workbook" "Datasource" "View" or "NamedResource". Version number of the workbook. unsigned 64 bit hash of the materialized logical query. ID of the workbook whose query results in this materialized view. The Data Dictionary is not a complete description of all tables and fields in the database, and is provided for customers who want to query the database for information about usage on Tableau Server. A unique, immutable identifier for the flow run spec. The number of times that the datasource has been accessed. Identifier for a given run from the flow processing system. Primary key for the underlying record in the projects table. Name of the preconfigured provider, which must be defined in SiteSAML application.yml file. How recently a view must have been viewed to run warmup for it in days, defaulting to 30. Flag which indicates if user has selected to suppress getting started notifications (used in online case only so far). User who published this version. The database name to which the particular connection is linked. The id of a site user preference. java.util.TimeZone.getTimeZone(java.lang.String). An integer where 0 is the highest priority and 10 is the default priority. A string that indicates the version of the document description that was used when saving this workbook. A foreign key link to the domain that corresponds to this group. Type of the database source, if this database is embedded. To enable this feature you must first activate the Advanced Management product keys on Tableau Server.For more information, see About Tableau Advanced Management on Tableau Server. A foreign key reference to an entry in the groups table. Auto-generated name for the datasource extracted from the twb/tds file. The luid which uniquely identifies the extensions settings row. In your repository, Tableau allocates space for your data sources, workbooks and other files Tableau needs to run or you need to create.
Houston Astros Fitted Hat - Red,
Body Shop Tea Tree Scalp Scrub,
Phi Phi Villa Resort-sha Extra Plus,
Data Security Training For Employees Ppt,
Articles T