Indicates if it is possible to perform an incrementable extract refresh for this workbook. Defines the OpenID Connect IdP associated with a site. This could be NULL if the matching record in the workbooks table was deleted since this record was created. Holds most recently used list entries. Datetime user was unassigned a creator role. This could be NULL if the matching record in the views table was deleted since this record was created. The port size (height) used to generate the image. The port size (height) of the device that is enrolled. Each record represents a partial aggregation of analytics for a given datasource in a given time interval. The prompt needed setting of an extension. A foreign key reference to an entry in the users table. Records the most useful information about a schedule that was relevant at the time of the event (see schedules table). Links to the user that has the given username, and is associated with the current site. Foreign key/Primary key relation from table_id on this table to id on table. Explanation for the certification status of this datasource. FK reference to users.id. Not useful for customers. 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. When true admins receive notification about suspended alerts, When true, users will see mark animations on sheets. Records the most useful information about a view that was relevant at the time of the event (see views table). Each record represents a table asset that exists on Tableau Server. The next time the subscription should be sent. Id of the site where data quality indicator belongs.

The luid which uniquely identifies the extensions settings row. The ID of the workbook or datasource that is creating the data connection. Free space state of the disk. Integer values in between are also valid. The trigger type of this flow run, currently 0 for scheduled run, 1 for ad-hoc run. A reference to the primary key id column for a record in the hist_data_connections table. The port on which the request was received. Foreign key/Primary key relation from creator_id on this table to id on table. Id of the sos directory in which the materialized views are contained. Reference to entry in sites table. materialized_query_result_size_lower_bound_bytes. Unique id for the output step, pulled from the TFL file. Used to distinguish high dpi of the enrolled devices. ID of the entity for which this entry was created. Id of user who created/updated data quality indicator. Event type to differentiate between insert, update, delete. The count of extensions in views of a given workbook. When the first publication of this datasource occurred.

The information is encoded in the given integer. Otherwise, one is randomly generated. String used in the construction of URLs that target this site. Hostname of the worker the resource exists on. A short version of the domain that this group is linked to. Reference to workbook. This table is used to link various views to the subscriptions in which those views must be generated and emailed. Unique ID used to track the repository data. An oid field that references the corresponding data stored in the pg_largeobject system table. This could be NULL if the matching record in the datasources table was deleted since this record was created. Often errors. userPrincipalName of identity in Active Directory. How recently a view must have been viewed to run warmup for it in days, defaulting to 30.

The luid which uniquely identifies the view. Reference to entury in sites table. Serves as a cache for all the sheet images generated by server. This table stores the metadata for the materialized view service. The name of the specific event that occurred. on a behalf of a customer. Indicates if the user elected to share his customized view. The user's site specific settings are captured here. Matches the auth_user_id of the user stored in the system_users table. A foreign key reference to the workbook the view is part of. Tickets can be redeemed no more than one time, but if it gets any later than this time, then the ticket cannot be redeemed at all. application/product version being used at the client level. The integer precedence is internal to the stored procedures. This is not a capability that sees much use. 1000-600 Tier Interactor users, down to 500 - Basic Tier users, 300 - Support users, 200 - guest users, 100 and below - Unlicensed. Each row contains important dates with regard to ATR Issuing and Identity Based Activation Usage for a given User, Site, Device and Product combination. Foreign key to the site to which the user belongs. This table contains records corresponding to various classifications of users. The associated project ID where the datasource was published. This table provides a set of checksums associated with a workbook which can be used to validate existence of a workbook based on its checksum. ID generated by client and also given to the Refresh Token Service. Represents hash of the possible show commands to be applied to the viz in the native api code. null or 0 - unencrypted, 1 - encrypted, 2 - pending encryption, 3 - pending decryption, 5 - pending rekey, Setting to enable/disable nlp feature on this datasource, null or 0 - there is not extract creation in progress, 1 - there is an extract creation in progress, Indicates the parent_type of the datasource (datarole, workbook, null), Setting to specify whether a datasource should have Ask Data enabled, disabled, or set to the site default. Foreign key/Primary key relation from generated_as_user_id on this table to id on table. The language ID the pdf was generated with. Indicates what user id is the creator of the task. Information about resources by tableau server entities, for example which geocoding databases are used by which workbooks. It is generated automatically, and is nothing that a customer needs to worry about. Foreign key/Primary key relation from data_connection_id on this table to id on table. Can be used to indicate percent complete for the job, but in most cases simply gets set to 100 when the job is completed. database of the Tableau Server repository. The primary key for the underlying workbook record. A timestamp indicating when the image was generated. The id of the site that the user belongs to. A reference to the primary key id column for a record in the hist_flows table. An identifier for the sheet. Locator for the thumbnail image of the viz snapshot. A user can belong to multiple groups, and a group can contain multiple users. True if subscriptions are allowed for this site, otherwise false. Can point to deleted user. Metadata about how this version was published on server, such as visiblity of views. date-time the last time an ATR request returned from from the ATR Service SUCCESSFULLY for this user, device, product and site. The days of the week correspond to Sunday : 1, Monday : 10, Tuesday : 100, Wednesday : 1000, Thursday : 10000, Friday : 100000, Saturday : 1000000. Integer values in between are also valid. When this record was created, i.e. Records the timestamp for the first time this view was published.

A user may be enrolled under multiple devices if the devices have different attributes (pixel width, pixel height, pixel ratio), most recent subscription runs data for suspend subscriptions. A reference to the primary key id column for a record in the hist_database_assets table. The name is either "local" or the name of some Active Directory group. Identifies the machine on which the job is run. Primary key id for pending search update associated with the item. The size, in bytes, of this version of datasource. The name of the site sourced from the name column in the sites table. Used as a means of passing parameters about the background job. Each record represents an individual input step from a published Tableau Prep flow. Indicates how many pixels were horizontally cropped off of the generated image. Time that the user last published this datasource to server. Each record provides information about subscriptions that are scheduled.

Different users can have same agent (for example of shared computer). Average queue time of jobs within interval of configured length in minutes, for day of the week and each job type. The time at which the workbook record was created. One of either "Workbook" or "Datasource". A foreign key to the datasources table. JSON template for the body of the request to send when the webhook is triggered. Completion status for the job. The average queue time, in minutes, of all jobs for a particular job type and day of week, within specified interval. If this is anything other than "active" then the project is inactive. This could be NULL if the matching record in the system_users table was deleted since this record was created. Records the time of the last full extract refresh. Used in URLs meant to access this datasource. Look for it in the table indicated by the useable_type field.

serialized_materialized_view_connection_attributes. Revision of the workbook whose id is the workbook_id column. Unique ID used to identify the reduced tflx (extracts removed from tflx and stored separately). Primary key for the record of the flow run spec output step. Foreign key/Primary key relation from workbook_id on this table to id on table. Value of a property for a node present in graph. The timestamp at which the pdf was generated. updated on each publish. The interval in minutes in which to send no more than one alert. Information about the last refresh error for the purpose of reconstructing the client view of the errors. When 0, the aggregation is for the year as designated by year_index. Two jobs with the same serial_collection_id cannot be processed simultaneously. The FK to flow output step runs for the flow output step run where this error got reported from. null - there is no parenet workbook; if not null, it stores the id of the original workbook from which this private workbook is derived, null or false - this is not a private workbook, true - this is a private workbook. It is running in background on

Records what year the analytics are aggregated over. Each record represents an entry of Semantics Service data role metadata. A foreign key reference to a record in the subscriptions table. Foreign key/Primary key relation from data_alert_id on this table to id on table. XML block of the EntityDescriptor for the Identity Provider. Unique ID used to identify the thumbnail. The UUID that is the name of the directory where the extracts are saved. The timestamp when the record was created.

Unique ID used to identify the workbook data.

If the extracts are associated with a workbook, then this is a foreign key link to that workbook, otherwise it is NULL. 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 unique ticket string, i.e. The check to see if the default settings are enable for extensions, Whether sandboxed extensions are allowed to run. The user ID of the owner/uploader of the datasource. Primary key for the record of the input step. Id of content for which data quality indicator stored. A descriptive phrase constructed for the worksheet, based on the workbook definition. The last time at which the the alert was checked. Foreign key/Primary key relation from pending_search_update_id on this table to id on table. Triggered by site role change in the users table. The minute following the start of the designated time period implied by the schedule_type. Foreign key reference to the view associated with this viz state. GUID, that represents a reservation that a remote agent has yet to claim. A serialized object containing the various preferences. Ascending order corresponds to increasing precedence. 3 = Interactor

ID of the Site from which this content was deleted. If set to false, this means that the schedule is inactive, meaning that no tasks will be performed when the schedules triggers. A foreign key to the serial_collections table.

Name of the preconfigured provider, which must be defined in SiteSAML application.yml file. The id of the system_user who owns this project. Each record represents a workbook that exists on the server. Must be one of "Project" "Workbook" "Datasource" "View" or "NamedResource". This is how the system identifies what code to execute when this task is to be run. Each record represents an individual specification about how a Tableau Prep flow should be run. The time at which this record was created. A foreign key reference to the site that the workbooked referred to by repository_url belongs. Defaults to "Always", but can also be "DataPresent", "Constant", "Band", etc. The algorithm used in conjunction with this key. primary key table. Records the most useful information about a task that was relevant at the time of the event (see tasks table). A foreign key reference to the user the image was generated as. Unique id for the input step, pulled from the TFL file. Don't set this or mess with it, it's all handled automatically. URL text created from workbook, sheet domain, and url_id. A foreign key reference to the customized view that the image was generated as. The luid which uniquely identifies the extensions metadata row. E.g Professional or Standard.

Links to the site that contains this workbook. A code indicating the locale (country and language) for this system_user. A code indicating the locale used to generate the image. Locator id for the graph image of the flow in SOS. The id of the site associated with the flow where this input step exists. Foreign key/Primary key relation from owner_id on this table to id on table. The last time any changes were made to this record.

When is_deleted is true then flow is deleted, no active job or user request can see it.

The FK to flow_output_steps table for the flow output step which this Id refers to . A possibly useful string that is mostly here to make it easier to debug. Foreign key/Primary key relation from task_id on this table to id on table. Capabilities are things like read, write, export_data, publish, web_authoring, etc. Auto-generated name for the datasource extracted from the twb/tds file. Indicates the type of item that this is. Foreign key/Primary key relation from schedule_id on this table to id on table. Governs the order in which these languages will appear when listed in the user interface. Foreign key/Primary key relation from object_id on this table to id on table. This table is used to track how many times each user has accessed different views. This date represents a point in time at which this sheet image is considered to be fresh. The id of the backgrounder process that did the work. Records in this table define a schedule according to which certain regular tasks may be performed (see tasks table). Identifies the project for which this permission template applies. When the schedule's "run_next_at" time arrives, any tasks linked to that schedule will run. See flow_runs for per-flow run history. Device type detected for Device Designer (non-null only if view is dashboard in non-authoring mode). The IANA timezoneid for the schedule when it is created i.e. Locator for the data of the viz snapshot. Contains the individual list entries that correspond to the lists defined in the asset_lists table. Holds the site luid from the sites table. Whether or not the job succeeded. The last time at which the the alert was sent to the user.

The number of records associated with the interval. The name of the system_user who is the owner. 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. The records here are linked to the lists to which they belong. The size, in bytes, of this version of flow. Foreign key/Primary key relation from datasource_id on this table to id on table. An encrypted version of a well-known test string. It should really be viewed in conjuction with the capabilities and capability_roles tables. Otherwise NULL. The unique identifier for this row that is automatically generated on insert, The timestamp for when this row entry was updated, The ID of the event that is last processed by semantics service. Emailing the view referenced by the repository_url is one of the activities of the linked subscription. The minute following the start of the designated time period implied by the schedule_type. The days of the month correspond to 1st : 1, 2nd: 10, 3rd: 100, 4th: 1000, 5th: 10000, etc. customer desktop and performing automatic data source refreshes based on schedules defined by customers.

A given tag can be associated with many taggable items in a site. Indicates if the domain is active or not. 0 = SiteAdministrator Don't set this or mess with it, it's all handled automatically. When set, this should generally agree with the updated_at field. If part of the site pool to handle shared work. One of "Datasource" or "Workbook". java.util.TimeZone.getTimeZone(java.lang.String). Array of DatasourceRefreshSchedule objects in JSON format. 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. Datetime user was unassigned from a creator role to a non-creator role -- triggered from the users table. The site in which this datasource exists. The computed checksum of the workbook during download. Null for non overflow jobs. Holds metadata for all registered webhooks on the server. The effective permission reason is returned to callers. The qualified name of the field, the qualified name is represented in JSON style. A foreign key reference to the domain of the owner. 0: device type is default, 1: device type is desktop, 2: device type is tablet, 3: device type is phone. Reference to entry in sites table. Primary key for the underlying user record. TCP port number of the connect (eg. A foreign key reference to a record in the subscriptions table. Indicates the licensing role that is assigned to this user. This is not an exhaustive description of all tables and fields in the database, but is A string that describes the recipient type, currently single user or group. Each row contains model metadata for a flow. The information is encoded in the given integer. One of: "Customized View - Single View", "Workbook", "Single View", or "Customized View - Workbook". The user who is the current owner of the webhook. The view within the workbook specified by workbook_id. Whether this flow output step is deleted or not. This table forms the link between other tables that need to store "large object" data, and the large object storage, itself. The ID of the user that owns the tagging. A reference to the primary key id column for a record in the hist_groups table. Datasource ID from datasources table. Unique ID used to identify the reduced datasource data. Will be true for success, and false for failure. Primary key for the item. True or false as to whether refreshable extracts are avaliable for the published datasource. materialized query result size with indrect referened values (such as string). A foreign key reference to the user who is enrolled. 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. For hourly, it would be the number of minutes past the beginning of the hour. Specifies what caused this flow run to occur. Unique identifier for this data_connection. Strict isolation between the contents of each site is maintained. A reference to the primary key id column for a record in the hist_datasources table. Type of data connection (ie mysql, postgres, sqlproxy etc).