The timezone to display dates in. Note that functionally, this is simply an integer value representing the number of hours to offset from UTC, which dates in the Tableau Server Repository are stored in. This means that it will not necessarily be accurate for timezones with Daylight Savings in place. The name of the Tableau Server instance. This value is used in the hyperlink calculations. -- obtain the proper ID value for a datasource for URL purposes SELECT MIN(dc.id) AS "id", dc.datasource_id FROM data_connections AS dc INNER JOIN datasources AS dc_d ON dc.datasource_id = dc_d.id AND dc_d.connectable = true GROUP BY dc.datasource_id --This subquery obtains the users granted Server Admin privileges the entire Tableau Server instance and returns all of their usernames in the "server_admins_string" field --This is used for row-level security SELECT 1 AS dummy_join_field , ';' || string_agg(DISTINCT su.name || ';', '') AS server_admins_string FROM users u INNER JOIN system_users su ON u.system_user_id = su.id WHERE su.admin_level = 10 --This subquery obtains the users granted Site Admin privileges the entire Tableau Server Site and returns all of their usernames in the "site_admins_string" field --This is used for row-level security SELECT u.site_id , ';' || string_agg(DISTINCT su.name || ';', '') AS site_admins_string FROM users u INNER JOIN system_users su ON u.system_user_id = su.id INNER JOIN site_roles sr ON u.site_role_id = sr.id WHERE sr.name LIKE '%SiteAdmin%' GROUP BY u.site_id --This subquery obtains the users granted Project Leader permissions for each project and returns all of their usernames in the "project_leaders_string" field -- This is used for row-level security SELECT project_permissions.project_id AS project_id , ';' || string_agg(DISTINCT su.name || ';', '') AS project_leaders_string FROM public.system_users su INNER JOIN public.users u ON su.id = u.system_user_id INNER JOIN ( -- users granted project leader rights via individual assignment SELECT ngp.grantee_id AS user_id , ngp.authorizable_id AS project_id FROM public.users u INNER JOIN public.next_gen_permissions ngp ON u.id = ngp.grantee_id AND ngp.capability_id = 19 -- Project Leader permissions AND ngp.grantee_type = 'User' AND ngp.permission = 3 -- Granted to user AND ngp.authorizable_type = 'Project' UNION -- users granted project leader rights via group membership SELECT gu.user_id AS user_id , ngp.authorizable_id AS project_id FROM public.group_users gu INNER JOIN public.groups g ON gu.group_id = g.id INNER JOIN public.next_gen_permissions ngp ON gu.group_id = ngp.grantee_id AND ngp.capability_id = 19 -- Project Leader permissions AND ngp.grantee_type = 'Group' AND ngp.permission = 1 -- Granted to group AND ngp.authorizable_type = 'Project' ) AS project_permissions ON u.id = project_permissions.user_id INNER JOIN public.projects p ON project_permissions.project_id = p.id GROUP BY project_permissions.project_id ORDER BY project_permissions.project_id id 3 [id] [historical_events] id 1 integer Sum 10 false [Migrated Data] historical_event_type_id 3 [historical_event_type_id] [historical_events] historical_event_type_id 2 integer Sum 10 false [Migrated Data] worker 129 [worker] [historical_events] worker 3 string Count 2147483647 true true "true" [Migrated Data] duration_in_ms 3 [duration_in_ms] [historical_events] duration_in_ms 4 integer Sum 10 true [Migrated Data] is_failure 11 [is_failure] [historical_events] is_failure 5 boolean Count true [Migrated Data] details 129 [details] [historical_events] details 6 string Count 2147483647 true true "true" [Migrated Data] created_at 135 [created_at] [historical_events] created_at 7 datetime Year false [Migrated Data] hist_actor_user_id 3 [hist_actor_user_id] [historical_events] hist_actor_user_id 8 integer Sum 10 true [Migrated Data] hist_target_user_id 3 [hist_target_user_id] [historical_events] hist_target_user_id 9 integer Sum 10 true [Migrated Data] hist_actor_site_id 3 [hist_actor_site_id] [historical_events] hist_actor_site_id 10 integer Sum 10 true [Migrated Data] hist_target_site_id 3 [hist_target_site_id] [historical_events] hist_target_site_id 11 integer Sum 10 true [Migrated Data] hist_project_id 3 [hist_project_id] [historical_events] hist_project_id 12 integer Sum 10 true [Migrated Data] hist_workbook_id 3 [hist_workbook_id] [historical_events] hist_workbook_id 13 integer Sum 10 true [Migrated Data] hist_view_id 3 [hist_view_id] [historical_events] hist_view_id 14 integer Sum 10 true [Migrated Data] hist_datasource_id 3 [hist_datasource_id] [historical_events] hist_datasource_id 15 integer Sum 10 true [Migrated Data] hist_comment_id 3 [hist_comment_id] [historical_events] hist_comment_id 16 integer Sum 10 true [Migrated Data] hist_tag_id 3 [hist_tag_id] [historical_events] hist_tag_id 17 integer Sum 10 true [Migrated Data] hist_group_id 3 [hist_group_id] [historical_events] hist_group_id 18 integer Sum 10 true [Migrated Data] hist_licensing_role_id 3 [hist_licensing_role_id] [historical_events] hist_licensing_role_id 19 integer Sum 10 true [Migrated Data] hist_schedule_id 3 [hist_schedule_id] [historical_events] hist_schedule_id 20 integer Sum 10 true [Migrated Data] hist_task_id 3 [hist_task_id] [historical_events] hist_task_id 21 integer Sum 10 true [Migrated Data] hist_data_connection_id 3 [hist_data_connection_id] [historical_events] hist_data_connection_id 22 integer Sum 10 true [Migrated Data] hist_config_id 3 [hist_config_id] [historical_events] hist_config_id 23 integer Sum 10 true [Migrated Data] hist_capability_id 3 [hist_capability_id] [historical_events] hist_capability_id 24 integer Sum 10 true [Migrated Data] hist_remote_agent_id 3 [hist_remote_agent_id] [historical_events] hist_remote_agent_id 25 integer Sum 10 true [Migrated Data] hist_flow_id 3 [hist_flow_id] [historical_events] hist_flow_id 26 integer Sum 10 true [Migrated Data] hist_data_role_id 3 [hist_data_role_id] [historical_events] hist_data_role_id 27 integer Sum 10 true [Migrated Data] hist_database_id 3 [hist_database_id] [historical_events] hist_database_id 28 integer Sum 10 true [Migrated Data] hist_table_id 3 [hist_table_id] [historical_events] hist_table_id 29 integer Sum 10 true [Migrated Data] hist_column_id 3 [hist_column_id] [historical_events] hist_column_id 30 integer Sum 10 true [Migrated Data] hist_metric_id 3 [hist_metric_id] [historical_events] hist_metric_id 31 integer Sum 10 true [Migrated Data] hist_published_connection_id 3 [hist_published_connection_id] [historical_events] hist_published_connection_id 32 integer Sum 10 true [Migrated Data] hist_collection_id 3 [hist_collection_id] [historical_events] hist_collection_id 33 integer Sum 10 true [Migrated Data] hist_flow_draft_id 3 [hist_flow_draft_id] [historical_events] hist_flow_draft_id 34 integer Sum 10 true [Migrated Data] hist_data_quality_indicator_id 3 [hist_data_quality_indicator_id] [historical_events] hist_data_quality_indicator_id 35 integer Sum 10 true [Migrated Data] type_id 3 [type_id] [historical_event_types] type_id 37 integer Sum 10 false [Migrated Data] name 129 [name] [historical_event_types] name 38 string Count 2147483647 true true "true" [Migrated Data] action_type 129 [action_type] [historical_event_types] action_type 39 string Count 2147483647 true true "true" [Migrated Data] id 3 [id (hist_projects)] [hist_projects] id 41 integer Sum 10 true [Migrated Data] project_id 3 [project_id] [hist_projects] project_id 42 integer Sum 10 true [Migrated Data] name 129 [name (hist_projects)] [hist_projects] name 43 string Count 2147483647 true true "true" [Migrated Data] id 3 [id (hist_workbooks)] [hist_workbooks] id 45 integer Sum 10 true [Migrated Data] workbook_id 3 [workbook_id] [hist_workbooks] workbook_id 46 integer Sum 10 true [Migrated Data] name 129 [name (hist_workbooks)] [hist_workbooks] name 47 string Count 2147483647 true true "true" [Migrated Data] repository_url 129 [repository_url] [hist_workbooks] repository_url 48 string Count 2147483647 true true "true" [Migrated Data] size 20 [size] [hist_workbooks] size 49 integer Sum 19 true [Migrated Data] revision 129 [revision] [hist_workbooks] revision 50 string Count 2147483647 true true "true" [Migrated Data] id 3 [id (hist_users)] [hist_users] id 52 integer Sum 10 true [Migrated Data] user_id 3 [user_id] [hist_users] user_id 53 integer Sum 10 true [Migrated Data] name 129 [name (hist_users)] [hist_users] name 54 string Count 2147483647 true true "true" [Migrated Data] domain_name 129 [domain_name] [hist_users] domain_name 55 string Count 2147483647 true true "true" [Migrated Data] email 129 [email] [hist_users] email 56 string Count 2147483647 true true "true" [Migrated Data] system_user_id 3 [system_user_id] [hist_users] system_user_id 57 integer Sum 10 true [Migrated Data] system_admin_level 3 [system_admin_level] [hist_users] system_admin_level 58 integer Sum 10 true [Migrated Data] hist_licensing_role_id 3 [hist_licensing_role_id (hist_users)] [hist_users] hist_licensing_role_id 59 integer Sum 10 true [Migrated Data] site_admin_level 3 [site_admin_level] [hist_users] site_admin_level 60 integer Sum 10 true [Migrated Data] publisher_tristate 3 [publisher_tristate] [hist_users] publisher_tristate 61 integer Sum 10 true [Migrated Data] site_role_id 3 [site_role_id] [hist_users] site_role_id 62 integer Sum 10 true [Migrated Data] id 3 [id (hist_datasources)] [hist_datasources] id 64 integer Sum 10 true [Migrated Data] datasource_id 3 [datasource_id] [hist_datasources] datasource_id 65 integer Sum 10 true [Migrated Data] name 129 [name (hist_datasources)] [hist_datasources] name 66 string Count 2147483647 true true "true" [Migrated Data] repository_url 129 [repository_url (hist_datasources)] [hist_datasources] repository_url 67 string Count 2147483647 true true "true" [Migrated Data] size 20 [size (hist_datasources)] [hist_datasources] size 68 integer Sum 19 true [Migrated Data] revision 129 [revision (hist_datasources)] [hist_datasources] revision 69 string Count 2147483647 true true "true" [Migrated Data] using_remote_query_agent 11 [using_remote_query_agent] [hist_datasources] using_remote_query_agent 70 boolean Count true [Migrated Data] remote_query_agent_name 129 [remote_query_agent_name] [hist_datasources] remote_query_agent_name 71 string Count 2147483647 true true "true" [Migrated Data] is_certified 11 [is_certified (hist_datasources)] [hist_datasources] is_certified 72 boolean Count true [Migrated Data] certification_note 129 [certification_note (hist_datasources)] [hist_datasources] certification_note 73 string Count 2147483647 true true "true" [Migrated Data] id 3 [id (hist_views)] [hist_views] id 75 integer Sum 10 true [Migrated Data] view_id 3 [view_id] [hist_views] view_id 76 integer Sum 10 true [Migrated Data] name 129 [name (hist_views)] [hist_views] name 77 string Count 2147483647 true true "true" [Migrated Data] repository_url 129 [repository_url (hist_views)] [hist_views] repository_url 78 string Count 2147483647 true true "true" [Migrated Data] revision 129 [revision (hist_views)] [hist_views] revision 79 string Count 2147483647 true true "true" [Migrated Data] id 3 [id (workbooks)] [workbooks] id 81 integer Sum 10 true [Migrated Data] name 129 [name (workbooks)] [workbooks] name 82 string Count 255 true "true" [Migrated Data] repository_url 129 [repository_url (workbooks)] [workbooks] repository_url 83 string Count 2147483647 true true "true" [Migrated Data] description 129 [description] [workbooks] description 84 string Count 2147483647 true true "true" [Migrated Data] created_at 135 [created_at (workbooks)] [workbooks] created_at 85 datetime Year true [Migrated Data] updated_at 135 [updated_at] [workbooks] updated_at 86 datetime Year true [Migrated Data] owner_id 3 [owner_id] [workbooks] owner_id 87 integer Sum 10 true [Migrated Data] project_id 3 [project_id (workbooks)] [workbooks] project_id 88 integer Sum 10 true [Migrated Data] view_count 3 [view_count] [workbooks] view_count 89 integer Sum 10 true [Migrated Data] size 20 [size (workbooks)] [workbooks] size 90 integer Sum 19 true [Migrated Data] embedded 129 [embedded] [workbooks] embedded 91 string Count 2147483647 true true "true" [Migrated Data] thumb_user 3 [thumb_user] [workbooks] thumb_user 92 integer Sum 10 true [Migrated Data] refreshable_extracts 11 [refreshable_extracts] [workbooks] refreshable_extracts 93 boolean Count true [Migrated Data] extracts_refreshed_at 135 [extracts_refreshed_at] [workbooks] extracts_refreshed_at 94 datetime Year true [Migrated Data] lock_version 3 [lock_version] [workbooks] lock_version 95 integer Sum 10 true [Migrated Data] state 129 [state] [workbooks] state 96 string Count 32 true "true" [Migrated Data] version 129 [version] [workbooks] version 97 string Count 255 true "true" [Migrated Data] checksum 129 [checksum] [workbooks] checksum 98 string Count 255 true "true" [Migrated Data] display_tabs 11 [display_tabs] [workbooks] display_tabs 99 boolean Count true [Migrated Data] data_engine_extracts 11 [data_engine_extracts] [workbooks] data_engine_extracts 100 boolean Count true [Migrated Data] incrementable_extracts 11 [incrementable_extracts] [workbooks] incrementable_extracts 101 boolean Count true [Migrated Data] site_id 3 [site_id] [workbooks] site_id 102 integer Sum 10 true [Migrated Data] revision 129 [revision (workbooks)] [workbooks] revision 103 string Count 255 true "true" [Migrated Data] repository_data_id 20 [repository_data_id] [workbooks] repository_data_id 104 integer Sum 19 true [Migrated Data] repository_extract_data_id 20 [repository_extract_data_id] [workbooks] repository_extract_data_id 105 integer Sum 19 true [Migrated Data] first_published_at 135 [first_published_at] [workbooks] first_published_at 106 datetime Year true [Migrated Data] primary_content_url 129 [primary_content_url] [workbooks] primary_content_url 107 string Count 255 true "true" [Migrated Data] share_description 129 [share_description] [workbooks] share_description 108 string Count 255 true "true" [Migrated Data] show_toolbar 11 [show_toolbar] [workbooks] show_toolbar 109 boolean Count true [Migrated Data] extracts_incremented_at 135 [extracts_incremented_at] [workbooks] extracts_incremented_at 110 datetime Year true [Migrated Data] default_view_index 3 [default_view_index] [workbooks] default_view_index 111 integer Sum 10 true [Migrated Data] luid 72 [luid] [workbooks] luid 112 string Count 2147483647 true [Migrated Data] asset_key_id 3 [asset_key_id] [workbooks] asset_key_id 113 integer Sum 10 true [Migrated Data] document_version 129 [document_version] [workbooks] document_version 114 string Count 255 true "true" [Migrated Data] content_version 3 [content_version] [workbooks] content_version 115 integer Sum 10 true [Migrated Data] last_published_at 135 [last_published_at] [workbooks] last_published_at 116 datetime Year true [Migrated Data] data_id 129 [data_id] [workbooks] data_id 117 string Count 50 true "true" [Migrated Data] reduced_data_id 129 [reduced_data_id] [workbooks] reduced_data_id 118 string Count 50 true "true" [Migrated Data] published_all_sheets 11 [published_all_sheets] [workbooks] published_all_sheets 119 boolean Count true [Migrated Data] extract_encryption_state 2 [extract_encryption_state] [workbooks] extract_encryption_state 120 integer Sum 5 true [Migrated Data] extract_creation_pending 2 [extract_creation_pending] [workbooks] extract_creation_pending 121 integer Sum 5 true [Migrated Data] is_deleted 11 [is_deleted (workbooks)] [workbooks] is_deleted 122 boolean Count true [Migrated Data] parent_workbook_id 3 [parent_workbook_id (workbooks)] [workbooks] parent_workbook_id 123 integer Sum 10 true [Migrated Data] is_private 11 [is_private] [workbooks] is_private 124 boolean Count true [Migrated Data] modified_by_user_id 3 [modified_by_user_id] [workbooks] modified_by_user_id 125 integer Sum 10 true [Migrated Data] extract_storage_format 2 [extract_storage_format] [workbooks] extract_storage_format 126 integer Sum 5 true [Migrated Data] id 3 [id (views)] [views] id 128 integer Sum 10 true [Migrated Data] name 129 [name (views)] [views] name 129 string Count 255 true "true" [Migrated Data] repository_url 129 [repository_url (views)] [views] repository_url 130 string Count 2147483647 true true "true" [Migrated Data] description 129 [description (views)] [views] description 131 string Count 2147483647 true true "true" [Migrated Data] created_at 135 [created_at (views)] [views] created_at 132 datetime Year true [Migrated Data] locked 11 [locked] [views] locked 133 boolean Count true [Migrated Data] published 11 [published] [views] published 134 boolean Count true [Migrated Data] read_count 3 [read_count] [views] read_count 135 integer Sum 10 true [Migrated Data] edit_count 3 [edit_count] [views] edit_count 136 integer Sum 10 true [Migrated Data] datasource_id 3 [datasource_id (views)] [views] datasource_id 137 integer Sum 10 true [Migrated Data] workbook_id 3 [workbook_id (views)] [views] workbook_id 138 integer Sum 10 true [Migrated Data] index 3 [index] [views] index 139 integer Sum 10 true [Migrated Data] updated_at 135 [updated_at (views)] [views] updated_at 140 datetime Year true [Migrated Data] owner_id 3 [owner_id (views)] [views] owner_id 141 integer Sum 10 true [Migrated Data] fields 129 [fields] [views] fields 142 string Count 2147483647 true true "true" [Migrated Data] title 129 [title] [views] title 143 string Count 2147483647 true true "true" [Migrated Data] caption 129 [caption] [views] caption 144 string Count 2147483647 true true "true" [Migrated Data] sheet_id 129 [sheet_id] [views] sheet_id 145 string Count 255 true "true" [Migrated Data] state 129 [state (views)] [views] state 146 string Count 32 true "true" [Migrated Data] sheettype 129 [sheettype] [views] sheettype 147 string Count 255 true "true" [Migrated Data] site_id 3 [site_id (views)] [views] site_id 148 integer Sum 10 true [Migrated Data] repository_data_id 20 [repository_data_id (views)] [views] repository_data_id 149 integer Sum 19 true [Migrated Data] first_published_at 135 [first_published_at (views)] [views] first_published_at 150 datetime Year true [Migrated Data] revision 129 [revision (views)] [views] revision 151 string Count 255 true "true" [Migrated Data] for_cache_updated_at 135 [for_cache_updated_at] [views] for_cache_updated_at 152 datetime Year true [Migrated Data] luid 72 [luid (views)] [views] luid 153 string Count 2147483647 true [Migrated Data] thumbnail_id 129 [thumbnail_id] [views] thumbnail_id 154 string Count 50 true "true" [Migrated Data] is_deleted 11 [is_deleted] [views] is_deleted 155 boolean Count true [Migrated Data] id 3 [id (datasources)] [datasources] id 157 integer Sum 10 true [Migrated Data] name 129 [name (datasources)] [datasources] name 158 string Count 255 true "true" [Migrated Data] repository_url 129 [repository_url (datasources)] [datasources] repository_url 159 string Count 2147483647 true true "true" [Migrated Data] owner_id 3 [owner_id (datasources)] [datasources] owner_id 160 integer Sum 10 true [Migrated Data] created_at 135 [created_at (datasources)] [datasources] created_at 161 datetime Year true [Migrated Data] updated_at 135 [updated_at (datasources)] [datasources] updated_at 162 datetime Year true [Migrated Data] project_id 3 [project_id (datasources)] [datasources] project_id 163 integer Sum 10 true [Migrated Data] size 20 [size (datasources)] [datasources] size 164 integer Sum 19 true [Migrated Data] lock_version 3 [lock_version (datasources)] [datasources] lock_version 165 integer Sum 10 true [Migrated Data] state 129 [state (datasources)] [datasources] state 166 string Count 32 true "true" [Migrated Data] db_class 129 [db_class] [datasources] db_class 167 string Count 2147483647 true true "true" [Migrated Data] db_name 129 [db_name] [datasources] db_name 168 string Count 2147483647 true true "true" [Migrated Data] table_name 129 [table_name] [datasources] table_name 169 string Count 2147483647 true true "true" [Migrated Data] site_id 3 [site_id (datasources)] [datasources] site_id 170 integer Sum 10 true [Migrated Data] revision 129 [revision (datasources)] [datasources] revision 171 string Count 255 true "true" [Migrated Data] repository_data_id 20 [repository_data_id (datasources)] [datasources] repository_data_id 172 integer Sum 19 true [Migrated Data] repository_extract_data_id 20 [repository_extract_data_id (datasources)] [datasources] repository_extract_data_id 173 integer Sum 19 true [Migrated Data] embedded 129 [embedded (datasources)] [datasources] embedded 174 string Count 2147483647 true true "true" [Migrated Data] incrementable_extracts 11 [incrementable_extracts (datasources)] [datasources] incrementable_extracts 175 boolean Count true [Migrated Data] refreshable_extracts 11 [refreshable_extracts (datasources)] [datasources] refreshable_extracts 176 boolean Count true [Migrated Data] data_engine_extracts 11 [data_engine_extracts (datasources)] [datasources] data_engine_extracts 177 boolean Count true [Migrated Data] extracts_refreshed_at 135 [extracts_refreshed_at (datasources)] [datasources] extracts_refreshed_at 178 datetime Year true [Migrated Data] first_published_at 135 [first_published_at (datasources)] [datasources] first_published_at 179 datetime Year true [Migrated Data] connectable 11 [connectable] [datasources] connectable 180 boolean Count true [Migrated Data] is_hierarchical 11 [is_hierarchical] [datasources] is_hierarchical 181 boolean Count true [Migrated Data] extracts_incremented_at 135 [extracts_incremented_at (datasources)] [datasources] extracts_incremented_at 182 datetime Year true [Migrated Data] luid 72 [luid (datasources)] [datasources] luid 183 string Count 2147483647 true [Migrated Data] asset_key_id 3 [asset_key_id (datasources)] [datasources] asset_key_id 184 integer Sum 10 true [Migrated Data] document_version 129 [document_version (datasources)] [datasources] document_version 185 string Count 255 true "true" [Migrated Data] description 129 [description (datasources)] [datasources] description 186 string Count 2147483647 true true "true" [Migrated Data] content_version 3 [content_version (datasources)] [datasources] content_version 187 integer Sum 10 true [Migrated Data] parent_workbook_id 3 [parent_workbook_id] [datasources] parent_workbook_id 188 integer Sum 10 true [Migrated Data] hidden_name 129 [hidden_name] [datasources] hidden_name 189 string Count 255 true "true" [Migrated Data] last_published_at 135 [last_published_at (datasources)] [datasources] last_published_at 190 datetime Year true [Migrated Data] data_id 129 [data_id (datasources)] [datasources] data_id 191 string Count 50 true "true" [Migrated Data] reduced_data_id 129 [reduced_data_id (datasources)] [datasources] reduced_data_id 192 string Count 50 true "true" [Migrated Data] remote_query_agent_id 3 [remote_query_agent_id] [datasources] remote_query_agent_id 193 integer Sum 10 true [Migrated Data] using_remote_query_agent 11 [using_remote_query_agent (datasources)] [datasources] using_remote_query_agent 194 boolean Count true [Migrated Data] is_certified 11 [is_certified] [datasources] is_certified 195 boolean Count true [Migrated Data] certification_note 129 [certification_note] [datasources] certification_note 196 string Count 2147483647 true true "true" [Migrated Data] certifier_user_id 3 [certifier_user_id] [datasources] certifier_user_id 197 integer Sum 10 true [Migrated Data] certifier_details 129 [certifier_details] [datasources] certifier_details 198 string Count 2147483647 true true "true" [Migrated Data] extract_encryption_state 2 [extract_encryption_state (datasources)] [datasources] extract_encryption_state 199 integer Sum 5 true [Migrated Data] nlp_setting 129 [nlp_setting] [datasources] nlp_setting 200 string Count 2147483647 true true "true" [Migrated Data] extract_creation_pending 2 [extract_creation_pending (datasources)] [datasources] extract_creation_pending 201 integer Sum 5 true [Migrated Data] parent_type 129 [parent_type] [datasources] parent_type 202 string Count 2147483647 true true "true" [Migrated Data] nlp_setting_new 129 [nlp_setting_new] [datasources] nlp_setting_new 203 string Count 2147483647 true true "true" [Migrated Data] modified_by_user_id 3 [modified_by_user_id (datasources)] [datasources] modified_by_user_id 204 integer Sum 10 true [Migrated Data] separated_data_id 129 [separated_data_id] [datasources] separated_data_id 205 string Count 50 true "true" [Migrated Data] tds_luid 129 [tds_luid] [datasources] tds_luid 206 string Count 2147483647 true true "true" [Migrated Data] ask_data_setting 129 [ask_data_setting] [datasources] ask_data_setting 207 string Count 255 true "true" [Migrated Data] ask_data_indexing 129 [ask_data_indexing] [datasources] ask_data_indexing 208 string Count 255 true "true" [Migrated Data] ask_data_curator_feedback 129 [ask_data_curator_feedback] [datasources] ask_data_curator_feedback 209 string Count 255 true "true" [Migrated Data] separated_reduced_data_id 129 [separated_reduced_data_id] [datasources] separated_reduced_data_id 210 string Count 50 true "true" [Migrated Data] extract_storage_format 2 [extract_storage_format (datasources)] [datasources] extract_storage_format 211 integer Sum 5 true [Migrated Data] ask_data_indexing_new 129 [ask_data_indexing_new] [datasources] ask_data_indexing_new 212 string Count 255 true "true" [Migrated Data] id 3 [id (hist_tasks)] [hist_tasks] id 214 integer Sum 10 true [Migrated Data] task_id 3 [task_id] [hist_tasks] task_id 215 integer Sum 10 true [Migrated Data] type 129 [type] [hist_tasks] type 216 string Count 2147483647 true true "true" [Migrated Data] priority 3 [priority] [hist_tasks] priority 217 integer Sum 10 true [Migrated Data] state 3 [state (hist_tasks)] [hist_tasks] state 218 integer Sum 10 true [Migrated Data] id 3 [id (tasks)] [tasks] id 220 integer Sum 10 true [Migrated Data] schedule_id 3 [schedule_id] [tasks] schedule_id 221 integer Sum 10 true [Migrated Data] type 129 [type (tasks)] [tasks] type 222 string Count 255 true "true" [Migrated Data] priority 3 [priority (tasks)] [tasks] priority 223 integer Sum 10 true [Migrated Data] obj_id 3 [obj_id] [tasks] obj_id 224 integer Sum 10 true [Migrated Data] created_at 135 [created_at (tasks)] [tasks] created_at 225 datetime Year true [Migrated Data] updated_at 135 [updated_at (tasks)] [tasks] updated_at 226 datetime Year true [Migrated Data] site_id 3 [site_id (tasks)] [tasks] site_id 227 integer Sum 10 true [Migrated Data] obj_type 129 [obj_type] [tasks] obj_type 228 string Count 255 true "true" [Migrated Data] luid 72 [luid (tasks)] [tasks] luid 229 string Count 2147483647 true [Migrated Data] consecutive_failure_count 3 [consecutive_failure_count] [tasks] consecutive_failure_count 230 integer Sum 10 true [Migrated Data] active 11 [active] [tasks] active 231 boolean Count true [Migrated Data] args 129 [args] [tasks] args 232 string Count 2147483647 true true "true" [Migrated Data] title 129 [title (tasks)] [tasks] title 233 string Count 2147483647 true true "true" [Migrated Data] subtitle 129 [subtitle] [tasks] subtitle 234 string Count 2147483647 true true "true" [Migrated Data] historical_run_time 3 [historical_run_time] [tasks] historical_run_time 235 integer Sum 10 true [Migrated Data] historical_queue_time 3 [historical_queue_time] [tasks] historical_queue_time 236 integer Sum 10 true [Migrated Data] run_count 3 [run_count] [tasks] run_count 237 integer Sum 10 true [Migrated Data] state 3 [state (tasks)] [tasks] state 238 integer Sum 10 true [Migrated Data] last_success_completed_at 135 [last_success_completed_at] [tasks] last_success_completed_at 239 datetime Year true [Migrated Data] creator_id 3 [creator_id] [tasks] creator_id 240 integer Sum 10 true [Migrated Data] id 3 [id (hist_sites)] [hist_sites] id 242 integer Sum 10 true [Migrated Data] site_id 3 [site_id (hist_sites)] [hist_sites] site_id 243 integer Sum 10 true [Migrated Data] name 129 [name (hist_sites)] [hist_sites] name 244 string Count 2147483647 true true "true" [Migrated Data] url_namespace 129 [url_namespace] [hist_sites] url_namespace 245 string Count 2147483647 true true "true" [Migrated Data] id 3 [id (hist_schedules)] [hist_schedules] id 247 integer Sum 10 true [Migrated Data] schedule_id 3 [schedule_id (hist_schedules)] [hist_schedules] schedule_id 248 integer Sum 10 true [Migrated Data] name 129 [name (hist_schedules)] [hist_schedules] name 249 string Count 2147483647 true true "true" [Migrated Data] schedule_type 3 [schedule_type] [hist_schedules] schedule_type 250 integer Sum 10 true [Migrated Data] priority 3 [priority (hist_schedules)] [hist_schedules] priority 251 integer Sum 10 true [Migrated Data] scheduled_action 3 [scheduled_action] [hist_schedules] scheduled_action 252 integer Sum 10 true [Migrated Data] is_serial 11 [is_serial] [hist_schedules] is_serial 253 boolean Count true [Migrated Data] day_of_week_mask 3 [day_of_week_mask] [hist_schedules] day_of_week_mask 254 integer Sum 10 true [Migrated Data] day_of_month_mask 3 [day_of_month_mask] [hist_schedules] day_of_month_mask 255 integer Sum 10 true [Migrated Data] start_at_minute 3 [start_at_minute] [hist_schedules] start_at_minute 256 integer Sum 10 true [Migrated Data] minute_interval 3 [minute_interval] [hist_schedules] minute_interval 257 integer Sum 10 true [Migrated Data] end_at_minute 3 [end_at_minute] [hist_schedules] end_at_minute 258 integer Sum 10 true [Migrated Data] end_schedule_at 135 [end_schedule_at] [hist_schedules] end_schedule_at 259 datetime Year true [Migrated Data] id 3 [id (site_roles)] [site_roles] id 261 integer Sum 10 true [Migrated Data] name 129 [name (site_roles)] [site_roles] name 262 string Count 255 true "true" [Migrated Data] licensing_rank 3 [licensing_rank] [site_roles] licensing_rank 263 integer Sum 10 true [Migrated Data] display_name 129 [display_name] [site_roles] display_name 264 string Count 255 true "true" [Migrated Data] id 3 [id (hist_flows)] [hist_flows] id 266 integer Sum 10 true [Migrated Data] flow_id 3 [flow_id] [hist_flows] flow_id 267 integer Sum 10 true [Migrated Data] name 129 [name (hist_flows)] [hist_flows] name 268 string Count 255 true "true" [Migrated Data] size 20 [size (hist_flows)] [hist_flows] size 269 integer Sum 19 true [Migrated Data] content_version 129 [content_version (hist_flows)] [hist_flows] content_version 270 string Count 255 true "true" [Migrated Data] id 3 [id (flows)] [flows] id 272 integer Sum 10 true [Migrated Data] name 129 [name (flows)] [flows] name 273 string Count 255 true "true" [Migrated Data] luid 72 [luid (flows)] [flows] luid 274 string Count 2147483647 true [Migrated Data] owner_id 3 [owner_id (flows)] [flows] owner_id 275 integer Sum 10 true [Migrated Data] project_id 3 [project_id (flows)] [flows] project_id 276 integer Sum 10 true [Migrated Data] site_id 3 [site_id (flows)] [flows] site_id 277 integer Sum 10 true [Migrated Data] data_id 129 [data_id (flows)] [flows] data_id 278 string Count 50 true "true" [Migrated Data] reduced_data_id 129 [reduced_data_id (flows)] [flows] reduced_data_id 279 string Count 50 true "true" [Migrated Data] created_at 135 [created_at (flows)] [flows] created_at 280 datetime Year true [Migrated Data] updated_at 135 [updated_at (flows)] [flows] updated_at 281 datetime Year true [Migrated Data] description 129 [description (flows)] [flows] description 282 string Count 2147483647 true true "true" [Migrated Data] lock_version 3 [lock_version (flows)] [flows] lock_version 283 integer Sum 10 true [Migrated Data] size 20 [size (flows)] [flows] size 284 integer Sum 19 true [Migrated Data] embedded 129 [embedded (flows)] [flows] embedded 285 string Count 2147483647 true true "true" [Migrated Data] asset_key_id 3 [asset_key_id (flows)] [flows] asset_key_id 286 integer Sum 10 true [Migrated Data] thumbnail_id 129 [thumbnail_id (flows)] [flows] thumbnail_id 287 string Count 50 true "true" [Migrated Data] last_published_at 135 [last_published_at (flows)] [flows] last_published_at 288 datetime Year true [Migrated Data] content_version 3 [content_version (flows)] [flows] content_version 289 integer Sum 10 true [Migrated Data] document_version 129 [document_version (flows)] [flows] document_version 290 string Count 255 true "true" [Migrated Data] file_type 129 [file_type] [flows] file_type 291 string Count 4 true "true" [Migrated Data] graph_image_id 129 [graph_image_id] [flows] graph_image_id 292 string Count 255 true "true" [Migrated Data] encryption_key_id 129 [encryption_key_id] [flows] encryption_key_id 293 string Count 2147483647 true "true" [Migrated Data] data_engine_extracts 11 [data_engine_extracts (flows)] [flows] data_engine_extracts 294 boolean Count true [Migrated Data] extract_encryption_state 2 [extract_encryption_state (flows)] [flows] extract_encryption_state 295 integer Sum 5 true [Migrated Data] is_deleted 11 [is_deleted (flows)] [flows] is_deleted 296 boolean Count true [Migrated Data] hidden 11 [hidden] [flows] hidden 297 boolean Count true [Migrated Data] kind 129 [kind] [flows] kind 298 string Count 255 true "true" [Migrated Data] id 3 [id (Custom SQL Query)] [Data Connection Ids] id 300 integer Sum 10 true [Migrated Data] datasource_id 3 [datasource_id (Custom SQL Query)] [Data Connection Ids] datasource_id 301 integer Sum 10 true [Migrated Data] id 3 [id (sites)] [sites] id 303 integer Sum 10 true [Migrated Data] name 129 [name (sites)] [sites] name 304 string Count 255 true "true" [Migrated Data] url_namespace 129 [url_namespace (sites)] [sites] url_namespace 305 string Count 255 true "true" [Migrated Data] status 129 [status] [sites] status 306 string Count 255 true "true" [Migrated Data] created_at 135 [created_at (sites)] [sites] created_at 307 datetime Year true [Migrated Data] updated_at 135 [updated_at (sites)] [sites] updated_at 308 datetime Year true [Migrated Data] user_quota 3 [user_quota] [sites] user_quota 309 integer Sum 10 true [Migrated Data] content_admin_mode 3 [content_admin_mode] [sites] content_admin_mode 310 integer Sum 10 true [Migrated Data] storage_quota 20 [storage_quota] [sites] storage_quota 311 integer Sum 19 true [Migrated Data] metrics_level 2 [metrics_level] [sites] metrics_level 312 integer Sum 5 true [Migrated Data] status_reason 129 [status_reason] [sites] status_reason 313 string Count 255 true "true" [Migrated Data] subscriptions_enabled 11 [subscriptions_enabled] [sites] subscriptions_enabled 314 boolean Count true [Migrated Data] custom_subscription_footer 129 [custom_subscription_footer] [sites] custom_subscription_footer 315 string Count 2147483647 true true "true" [Migrated Data] custom_subscription_email 129 [custom_subscription_email] [sites] custom_subscription_email 316 string Count 2147483647 true true "true" [Migrated Data] luid 72 [luid (sites)] [sites] luid 317 string Count 2147483647 true [Migrated Data] query_limit 3 [query_limit] [sites] query_limit 318 integer Sum 10 true [Migrated Data] authoring_disabled 11 [authoring_disabled] [sites] authoring_disabled 319 boolean Count true [Migrated Data] sheet_image_enabled 11 [sheet_image_enabled] [sites] sheet_image_enabled 320 boolean Count true [Migrated Data] refresh_token_setting 3 [refresh_token_setting] [sites] refresh_token_setting 321 integer Sum 10 true [Migrated Data] version_history_enabled 11 [version_history_enabled] [sites] version_history_enabled 322 boolean Count true [Migrated Data] notification_enabled 11 [notification_enabled] [sites] notification_enabled 323 boolean Count true [Migrated Data] content_version_limit 3 [content_version_limit] [sites] content_version_limit 324 integer Sum 10 true [Migrated Data] subscribe_others_enabled 11 [subscribe_others_enabled] [sites] subscribe_others_enabled 325 boolean Count true [Migrated Data] lock_version 3 [lock_version (sites)] [sites] lock_version 326 integer Sum 10 true [Migrated Data] guest_access_enabled 11 [guest_access_enabled] [sites] guest_access_enabled 327 boolean Count true [Migrated Data] support_access_enabled 11 [support_access_enabled] [sites] support_access_enabled 328 boolean Count true [Migrated Data] cache_warmup_enabled 11 [cache_warmup_enabled] [sites] cache_warmup_enabled 329 boolean Count true [Migrated Data] cache_warmup_threshold 2 [cache_warmup_threshold] [sites] cache_warmup_threshold 330 integer Sum 5 true [Migrated Data] data_alerts_enabled 11 [data_alerts_enabled] [sites] data_alerts_enabled 331 boolean Count true [Migrated Data] allow_live_query_sync 11 [allow_live_query_sync] [sites] allow_live_query_sync 332 boolean Count true [Migrated Data] commenting_enabled 11 [commenting_enabled] [sites] commenting_enabled 333 boolean Count true [Migrated Data] self_service_schedules_enabled 11 [self_service_schedules_enabled] [sites] self_service_schedules_enabled 334 boolean Count true [Migrated Data] tier_interactor_capacity 3 [tier_interactor_capacity] [sites] tier_interactor_capacity 335 integer Sum 10 true [Migrated Data] tier_basic_user_capacity 3 [tier_basic_user_capacity] [sites] tier_basic_user_capacity 336 integer Sum 10 true [Migrated Data] tier_author_capacity 3 [tier_author_capacity] [sites] tier_author_capacity 337 integer Sum 10 true [Migrated Data] viz_in_tooltip_enabled 11 [viz_in_tooltip_enabled] [sites] viz_in_tooltip_enabled 338 boolean Count true [Migrated Data] protocol_cache_lifetime 3 [protocol_cache_lifetime] [sites] protocol_cache_lifetime 339 integer Sum 10 true [Migrated Data] protocol_group_size_limit 3 [protocol_group_size_limit] [sites] protocol_group_size_limit 340 integer Sum 10 true [Migrated Data] commenting_mentions_enabled 11 [commenting_mentions_enabled] [sites] commenting_mentions_enabled 341 boolean Count true [Migrated Data] mixed_content_enabled 11 [mixed_content_enabled] [sites] mixed_content_enabled 342 boolean Count true [Migrated Data] site_invite_notification_enabled 11 [site_invite_notification_enabled] [sites] site_invite_notification_enabled 343 boolean Count true [Migrated Data] extract_encryption_mode 2 [extract_encryption_mode] [sites] extract_encryption_mode 344 integer Sum 5 true [Migrated Data] flows_enabled 11 [flows_enabled] [sites] flows_enabled 345 boolean Count true [Migrated Data] materialized_views_enabled 11 [materialized_views_enabled] [sites] materialized_views_enabled 346 boolean Count true [Migrated Data] allow_subscriptions_attach_pdf 11 [allow_subscriptions_attach_pdf] [sites] allow_subscriptions_attach_pdf 347 boolean Count true [Migrated Data] materialized_views_mode 2 [materialized_views_mode] [sites] materialized_views_mode 348 integer Sum 5 true [Migrated Data] start_page_uri 129 [start_page_uri] [sites] start_page_uri 349 string Count 2147483647 true true "true" [Migrated Data] afe_enabled 11 [afe_enabled] [sites] afe_enabled 350 boolean Count true [Migrated Data] sandbox_enabled 11 [sandbox_enabled] [sites] sandbox_enabled 351 boolean Count true [Migrated Data] viz_recs_enabled 11 [viz_recs_enabled] [sites] viz_recs_enabled 352 boolean Count true [Migrated Data] biometrics_mobile_enabled 11 [biometrics_mobile_enabled] [sites] biometrics_mobile_enabled 353 boolean Count true [Migrated Data] iba_enabled 11 [iba_enabled] [sites] iba_enabled 354 boolean Count true [Migrated Data] named_sharing_enabled 11 [named_sharing_enabled] [sites] named_sharing_enabled 355 boolean Count true [Migrated Data] sandbox_storage_quota 20 [sandbox_storage_quota] [sites] sandbox_storage_quota 356 integer Sum 19 true [Migrated Data] sandbox_datasources_enabled 11 [sandbox_datasources_enabled] [sites] sandbox_datasources_enabled 357 boolean Count true [Migrated Data] sandbox_flows_enabled 11 [sandbox_flows_enabled] [sites] sandbox_flows_enabled 358 boolean Count true [Migrated Data] cataloging_enabled 11 [cataloging_enabled] [sites] cataloging_enabled 359 boolean Count true [Migrated Data] derived_permissions_enabled 11 [derived_permissions_enabled] [sites] derived_permissions_enabled 360 boolean Count true [Migrated Data] viz_recs_username_enabled 11 [viz_recs_username_enabled] [sites] viz_recs_username_enabled 361 boolean Count true [Migrated Data] user_visibility 3 [user_visibility] [sites] user_visibility 362 integer Sum 10 true [Migrated Data] request_access 3 [request_access] [sites] request_access 363 integer Sum 10 true [Migrated Data] ask_data_mode 129 [ask_data_mode] [sites] ask_data_mode 364 string Count 2147483647 true true "true" [Migrated Data] run_now_enabled 11 [run_now_enabled] [sites] run_now_enabled 365 boolean Count true [Migrated Data] web_extraction_enabled 2 [web_extraction_enabled] [sites] web_extraction_enabled 366 integer Sum 5 true [Migrated Data] metrics_enabled 11 [metrics_enabled] [sites] metrics_enabled 367 boolean Count true [Migrated Data] web_editing_enabled 11 [web_editing_enabled] [sites] web_editing_enabled 368 boolean Count true [Migrated Data] notify_site_admins_on_throttle 11 [notify_site_admins_on_throttle] [sites] notify_site_admins_on_throttle 369 boolean Count true [Migrated Data] obfuscation_enabled 11 [obfuscation_enabled] [sites] obfuscation_enabled 370 boolean Count true [Migrated Data] flow_auto_save_enabled 11 [flow_auto_save_enabled] [sites] flow_auto_save_enabled 371 boolean Count true [Migrated Data] time_zone 129 [time_zone] [sites] time_zone 372 string Count 2147483647 true true "true" [Migrated Data] public_collections_enabled 11 [public_collections_enabled] [sites] public_collections_enabled 373 boolean Count true [Migrated Data] self_service_schedule_for_refresh_enabled 11 [self_service_schedule_for_refresh_enabled] [sites] self_service_schedule_for_refresh_enabled 374 boolean Count true [Migrated Data] self_service_schedule_for_flow_enabled 11 [self_service_schedule_for_flow_enabled] [sites] self_service_schedule_for_flow_enabled 375 boolean Count true [Migrated Data] auto_suspend_refresh_enabled 11 [auto_suspend_refresh_enabled] [sites] auto_suspend_refresh_enabled 376 boolean Count true [Migrated Data] auto_suspend_refresh_inactivity_window 3 [auto_suspend_refresh_inactivity_window] [sites] auto_suspend_refresh_inactivity_window 377 integer Sum 10 true [Migrated Data] web_zone_content_enabled 11 [web_zone_content_enabled] [sites] web_zone_content_enabled 378 boolean Count true [Migrated Data] personal_space_enabled 11 [personal_space_enabled] [sites] personal_space_enabled 379 boolean Count true [Migrated Data] personal_space_storage_quota 20 [personal_space_storage_quota] [sites] personal_space_storage_quota 380 integer Sum 19 true [Migrated Data] tag_limit 3 [tag_limit] [sites] tag_limit 381 integer Sum 10 true [Migrated Data] einstein_in_flow_enabled 11 [einstein_in_flow_enabled] [sites] einstein_in_flow_enabled 382 boolean Count true [Migrated Data] explain_data_enabled 11 [explain_data_enabled] [sites] explain_data_enabled 383 boolean Count true [Migrated Data] linked_tasks_enabled 11 [linked_tasks_enabled] [sites] linked_tasks_enabled 384 boolean Count true [Migrated Data] linked_tasks_run_now_enabled 11 [linked_tasks_run_now_enabled] [sites] linked_tasks_run_now_enabled 385 boolean Count true [Migrated Data] dqw_subscriptions_enabled 11 [dqw_subscriptions_enabled] [sites] dqw_subscriptions_enabled 386 boolean Count true [Migrated Data] flow_output_subscriptions_enabled 11 [flow_output_subscriptions_enabled] [sites] flow_output_subscriptions_enabled 387 boolean Count true [Migrated Data] flow_output_subscriptions_data_in_email_body_enabled 11 [flow_output_subscriptions_data_in_email_body_enabled] [sites] flow_output_subscriptions_data_in_email_body_enabled 388 boolean Count true [Migrated Data] flow_output_subscriptions_data_as_email_attachment_enabled 11 [flow_output_subscriptions_data_as_email_attachment_enabled] [sites] flow_output_subscriptions_data_as_email_attachment_enabled 389 boolean Count true [Migrated Data] flow_parameters_enabled 11 [flow_parameters_enabled] [sites] flow_parameters_enabled 390 boolean Count true [Migrated Data] flow_parameters_any_type_enabled 11 [flow_parameters_any_type_enabled] [sites] flow_parameters_any_type_enabled 391 boolean Count true [Migrated Data] admin_insights_publish_frequency 3 [admin_insights_publish_frequency] [sites] admin_insights_publish_frequency 392 integer Sum 10 true [Migrated Data] backgrounder_governance_default_limit_enabled 11 [backgrounder_governance_default_limit_enabled] [sites] backgrounder_governance_default_limit_enabled 393 boolean Count true [Migrated Data] dummy_join_field 3 [dummy_join_field] [Server Admin Permissions] dummy_join_field 395 integer Sum 10 true [Migrated Data] server_admins_string 129 [server_admins_string] [Server Admin Permissions] server_admins_string 396 string Count 2147483647 true true "true" [Migrated Data] site_id 3 [site_id (Custom SQL Query)] [Site Admin Permissions] site_id 398 integer Sum 10 true [Migrated Data] site_admins_string 129 [site_admins_string] [Site Admin Permissions] site_admins_string 399 string Count 2147483647 true true "true" [Migrated Data] id 3 [id (hist_metrics)] [hist_metrics] id 401 integer Sum 10 true [Migrated Data] metric_id 3 [metric_id] [hist_metrics] metric_id 402 integer Sum 10 true [Migrated Data] name 129 [name (hist_metrics)] [hist_metrics] name 403 string Count 255 true "true" [Migrated Data] id 3 [id (metrics)] [metrics] id 405 integer Sum 10 true [Migrated Data] name 129 [name (metrics)] [metrics] name 406 string Count 255 true "true" [Migrated Data] luid 72 [luid (metrics)] [metrics] luid 407 string Count 2147483647 true [Migrated Data] owner_id 3 [owner_id (metrics)] [metrics] owner_id 408 integer Sum 10 true [Migrated Data] project_id 3 [project_id (metrics)] [metrics] project_id 409 integer Sum 10 true [Migrated Data] site_id 3 [site_id (metrics)] [metrics] site_id 410 integer Sum 10 true [Migrated Data] created_at 135 [created_at (metrics)] [metrics] created_at 411 datetime Year true [Migrated Data] description 129 [description (metrics)] [metrics] description 412 string Count 2147483647 true true "true" [Migrated Data] embedded 129 [embedded (metrics)] [metrics] embedded 413 string Count 2147483647 true true "true" [Migrated Data] asset_key_id 3 [asset_key_id (metrics)] [metrics] asset_key_id 414 integer Sum 10 true [Migrated Data] updated_at 135 [updated_at (metrics)] [metrics] updated_at 415 datetime Year true [Migrated Data] datasource_id 3 [datasource_id (metrics)] [metrics] datasource_id 416 integer Sum 10 true [Migrated Data] dataalert_id 3 [dataalert_id] [metrics] dataalert_id 417 integer Sum 10 true [Migrated Data] workbook_id 3 [workbook_id (metrics)] [metrics] workbook_id 418 integer Sum 10 true [Migrated Data] view_id 3 [view_id (metrics)] [metrics] view_id 419 integer Sum 10 true [Migrated Data] last_scheduled_at 135 [last_scheduled_at] [metrics] last_scheduled_at 420 datetime Year true [Migrated Data] last_refreshed_at 135 [last_refreshed_at] [metrics] last_refreshed_at 421 datetime Year true [Migrated Data] incomplete_refresh_attempts 3 [incomplete_refresh_attempts] [metrics] incomplete_refresh_attempts 422 integer Sum 10 true [Migrated Data] customized_view_id 3 [customized_view_id] [metrics] customized_view_id 423 integer Sum 10 true [Migrated Data] suspend_state 3 [suspend_state] [metrics] suspend_state 424 integer Sum 10 true [Migrated Data] connected_view_path 129 [connected_view_path] [metrics] connected_view_path 425 string Count 255 true "true" [Migrated Data] connected_view_name 129 [connected_view_name] [metrics] connected_view_name 426 string Count 255 true "true" [Migrated Data] id 3 [id (hist_collections)] [hist_collections] id 428 integer Sum 10 true [Migrated Data] collection_luid 129 [collection_luid] [hist_collections] collection_luid 429 string Count 255 true "true" [Migrated Data] name 129 [name (hist_collections)] [hist_collections] name 430 string Count 255 true "true" [Migrated Data] id 3 [id (asset_lists)] [asset_lists] id 432 integer Sum 10 true [Migrated Data] name 129 [name (asset_lists)] [asset_lists] name 433 string Count 255 true "true" [Migrated Data] owner_id 3 [owner_id (asset_lists)] [asset_lists] owner_id 434 integer Sum 10 true [Migrated Data] site_id 3 [site_id (asset_lists)] [asset_lists] site_id 435 integer Sum 10 true [Migrated Data] description 129 [description (asset_lists)] [asset_lists] description 436 string Count 4000 true "true" [Migrated Data] visibility 129 [visibility] [asset_lists] visibility 437 string Count 255 true "true" [Migrated Data] list_type 129 [list_type] [asset_lists] list_type 438 string Count 255 true "true" [Migrated Data] created_timestamp 135 [created_timestamp] [asset_lists] created_timestamp 439 datetime Year true [Migrated Data] updated_at 135 [updated_at (asset_lists)] [asset_lists] updated_at 440 datetime Year true [Migrated Data] luid 72 [luid (asset_lists)] [asset_lists] luid 441 string Count 2147483647 true [Migrated Data] sync_token 129 [sync_token] [asset_lists] sync_token 442 string Count 255 true "true" [Migrated Data] site_luid 72 [site_luid] [asset_lists] site_luid 443 string Count 2147483647 true [Migrated Data] id 3 [id (_users) #1] [_users] id 445 integer Sum 10 true [Migrated Data] name 129 [name (Current Datasource Owner)] [_users] name 446 string Count 255 true "true" [Migrated Data] login_at 135 [login_at (_users)] [_users] login_at 447 datetime Year true [Migrated Data] friendly_name 129 [friendly_name (Current Datasource Owner)] [_users] friendly_name 448 string Count 255 true "true" [Migrated Data] licensing_role_id 3 [licensing_role_id (_users)] [_users] licensing_role_id 449 integer Sum 10 true [Migrated Data] licensing_role_name 129 [licensing_role_name (Current Datasource Owner)] [_users] licensing_role_name 450 string Count 255 true "true" [Migrated Data] domain_id 3 [domain_id (Current Datasource Owner)] [_users] domain_id 451 integer Sum 10 true [Migrated Data] system_user_id 3 [system_user_id (_users) #1] [_users] system_user_id 452 integer Sum 10 true [Migrated Data] domain_name 129 [domain_name (Current Datasource Owner)] [_users] domain_name 453 string Count 255 true "true" [Migrated Data] domain_short_name 129 [domain_short_name (Current Datasource Owner)] [_users] domain_short_name 454 string Count 80 true "true" [Migrated Data] site_id 3 [site_id (_users) #1] [_users] site_id 455 integer Sum 10 true [Migrated Data] id 3 [id (system_users) #1] [system_users] id 457 integer Sum 10 true [Migrated Data] name 129 [name (system_users) #1] [system_users] name 458 string Count 255 true "true" [Migrated Data] email 129 [email (system_users) #1] [system_users] email 459 string Count 255 true "true" [Migrated Data] hashed_password 129 [hashed_password (system_users)] [system_users] hashed_password 460 string Count 255 true "true" [Migrated Data] salt 129 [salt (system_users)] [system_users] salt 461 string Count 255 true "true" [Migrated Data] sys 11 [sys (system_users)] [system_users] sys 462 boolean Count true [Migrated Data] keychain 129 [keychain (system_users)] [system_users] keychain 463 string Count 2147483647 true true "true" [Migrated Data] domain_id 3 [domain_id (system_users)] [system_users] domain_id 464 integer Sum 10 true [Migrated Data] friendly_name 129 [friendly_name (system_users)] [system_users] friendly_name 465 string Count 255 true "true" [Migrated Data] custom_display_name 11 [custom_display_name (system_users)] [system_users] custom_display_name 466 boolean Count true [Migrated Data] activation_code 129 [activation_code (system_users)] [system_users] activation_code 467 string Count 255 true "true" [Migrated Data] activated_at 135 [activated_at (system_users)] [system_users] activated_at 468 datetime Year true [Migrated Data] state 129 [state (system_users) #1] [system_users] state 469 string Count 255 true "true" [Migrated Data] admin_level 3 [admin_level (system_users) #1] [system_users] admin_level 470 integer Sum 10 true [Migrated Data] created_at 135 [created_at (system_users) #1] [system_users] created_at 471 datetime Year true [Migrated Data] updated_at 135 [updated_at (system_users) #1] [system_users] updated_at 472 datetime Year true [Migrated Data] deleted_at 135 [deleted_at (system_users)] [system_users] deleted_at 473 datetime Year true [Migrated Data] auth_user_id 129 [auth_user_id (system_users)] [system_users] auth_user_id 474 string Count 255 true "true" [Migrated Data] asset_key_id 3 [asset_key_id (system_users) #1] [system_users] asset_key_id 475 integer Sum 10 true [Migrated Data] lock_version 3 [lock_version (Current Datasource Owner (system_user))] [system_users] lock_version 476 integer Sum 10 true [Migrated Data] last_password_update 135 [last_password_update (Current Datasource Owner (system_user))] [system_users] last_password_update 477 datetime Year true [Migrated Data] force_password_update 11 [force_password_update (Current Datasource Owner (system_user))] [system_users] force_password_update 478 boolean Count true [Migrated Data] protected_password 129 [protected_password (Current Datasource Owner (system_user))] [system_users] protected_password 479 string Count 2147483647 true "true" [Migrated Data] last_failed_login 135 [last_failed_login (Current Datasource Owner (system_user))] [system_users] last_failed_login 480 datetime Year true [Migrated Data] failed_login_attempts 3 [failed_login_attempts (Current Datasource Owner (system_user))] [system_users] failed_login_attempts 481 integer Sum 10 true [Migrated Data] protected_password_bad_format 11 [protected_password_bad_format (Current Datasource Owner (system_user))] [system_users] protected_password_bad_format 482 boolean Count true [Migrated Data] id 3 [id (projects_contents)] [projects_contents] id 484 integer Sum 10 true [Migrated Data] project_id 3 [project_id (projects_contents)] [projects_contents] project_id 485 integer Sum 10 true [Migrated Data] site_id 3 [site_id (projects_contents)] [projects_contents] site_id 486 integer Sum 10 true [Migrated Data] content_id 3 [content_id] [projects_contents] content_id 487 integer Sum 10 true [Migrated Data] content_type 129 [content_type] [projects_contents] content_type 488 string Count 12 true "true" [Migrated Data] id 3 [id (projects)] [projects] id 490 integer Sum 10 true [Migrated Data] name 129 [name (projects)] [projects] name 491 string Count 255 true "true" [Migrated Data] owner_id 3 [owner_id (projects)] [projects] owner_id 492 integer Sum 10 true [Migrated Data] created_at 135 [created_at (projects)] [projects] created_at 493 datetime Year true [Migrated Data] updated_at 135 [updated_at (projects)] [projects] updated_at 494 datetime Year true [Migrated Data] state 129 [state (projects)] [projects] state 495 string Count 32 true "true" [Migrated Data] description 129 [description (projects)] [projects] description 496 string Count 2147483647 true true "true" [Migrated Data] site_id 3 [site_id (projects)] [projects] site_id 497 integer Sum 10 true [Migrated Data] special 3 [special] [projects] special 498 integer Sum 10 true [Migrated Data] luid 72 [luid (projects)] [projects] luid 499 string Count 2147483647 true [Migrated Data] controlled_permissions_enabled 11 [controlled_permissions_enabled] [projects] controlled_permissions_enabled 500 boolean Count true [Migrated Data] parent_project_id 3 [parent_project_id] [projects] parent_project_id 501 integer Sum 10 true [Migrated Data] admin_insights_enabled 11 [admin_insights_enabled] [projects] admin_insights_enabled 502 boolean Count true [Migrated Data] nested_projects_permissions_included 11 [nested_projects_permissions_included] [projects] nested_projects_permissions_included 503 boolean Count true [Migrated Data] controlling_permissions_project_id 3 [controlling_permissions_project_id] [projects] controlling_permissions_project_id 504 integer Sum 10 true [Migrated Data] lower_name 129 [lower_name] [projects] lower_name 505 string Count 255 true "true" [Migrated Data] project_id 3 [project_id (Custom SQL Query) #1] [Project Leader Permissions] project_id 507 integer Sum 10 true [Migrated Data] project_leaders_string 129 [project_leaders_string (Custom SQL Query)] [Project Leader Permissions] project_leaders_string 508 string Count 2147483647 true true "true" [Migrated Data] id 3 [id (users) #1] [Project Owner (users)] id 510 integer Sum 10 true [Migrated Data] login_at 135 [login_at (users) #1] [Project Owner (users)] login_at 511 datetime Year true [Migrated Data] nonce 129 [nonce (users)] [Project Owner (users)] nonce 512 string Count 32 true "true" [Migrated Data] row_limit 3 [row_limit (users)] [Project Owner (users)] row_limit 513 integer Sum 10 true [Migrated Data] storage_limit 3 [storage_limit (users)] [Project Owner (users)] storage_limit 514 integer Sum 10 true [Migrated Data] created_at 135 [created_at (users) #1] [Project Owner (users)] created_at 515 datetime Year true [Migrated Data] extracts_required 11 [extracts_required (users)] [Project Owner (users)] extracts_required 516 boolean Count true [Migrated Data] updated_at 135 [updated_at (users) #1] [Project Owner (users)] updated_at 517 datetime Year true [Migrated Data] raw_data_suppressor_tristate 3 [raw_data_suppressor_tristate (users)] [Project Owner (users)] raw_data_suppressor_tristate 518 integer Sum 10 true [Migrated Data] site_id 3 [site_id (users) #1] [Project Owner (users)] site_id 519 integer Sum 10 true [Migrated Data] system_user_id 3 [system_user_id (users) #1] [Project Owner (users)] system_user_id 520 integer Sum 10 true [Migrated Data] system_admin_auto 11 [system_admin_auto (users)] [Project Owner (users)] system_admin_auto 521 boolean Count true [Migrated Data] luid 72 [luid (users) #1] [Project Owner (users)] luid 522 string Count 2147483647 true [Migrated Data] lock_version 3 [lock_version (users) #1] [Project Owner (users)] lock_version 523 integer Sum 10 true [Migrated Data] site_role_id 3 [site_role_id (users) #1] [Project Owner (users)] site_role_id 524 integer Sum 10 true [Migrated Data] id 3 [id (system_users) #4] [Project Owner (system_users)] id 526 integer Sum 10 true [Migrated Data] name 129 [name (system_users) #4] [Project Owner (system_users)] name 527 string Count 255 true "true" [Migrated Data] email 129 [email (system_users) #4] [Project Owner (system_users)] email 528 string Count 255 true "true" [Migrated Data] hashed_password 129 [hashed_password (system_users) #3] [Project Owner (system_users)] hashed_password 529 string Count 255 true "true" [Migrated Data] salt 129 [salt (system_users) #3] [Project Owner (system_users)] salt 530 string Count 255 true "true" [Migrated Data] sys 11 [sys (system_users) #3] [Project Owner (system_users)] sys 531 boolean Count true [Migrated Data] keychain 129 [keychain (system_users) #3] [Project Owner (system_users)] keychain 532 string Count 2147483647 true true "true" [Migrated Data] domain_id 3 [domain_id (system_users) #3] [Project Owner (system_users)] domain_id 533 integer Sum 10 true [Migrated Data] friendly_name 129 [friendly_name (system_users) #3] [Project Owner (system_users)] friendly_name 534 string Count 255 true "true" [Migrated Data] custom_display_name 11 [custom_display_name (system_users) #3] [Project Owner (system_users)] custom_display_name 535 boolean Count true [Migrated Data] activation_code 129 [activation_code (system_users) #3] [Project Owner (system_users)] activation_code 536 string Count 255 true "true" [Migrated Data] activated_at 135 [activated_at (system_users) #3] [Project Owner (system_users)] activated_at 537 datetime Year true [Migrated Data] state 129 [state (system_users) #4] [Project Owner (system_users)] state 538 string Count 255 true "true" [Migrated Data] admin_level 3 [admin_level (system_users) #3] [Project Owner (system_users)] admin_level 539 integer Sum 10 true [Migrated Data] created_at 135 [created_at (system_users) #4] [Project Owner (system_users)] created_at 540 datetime Year true [Migrated Data] updated_at 135 [updated_at (system_users) #4] [Project Owner (system_users)] updated_at 541 datetime Year true [Migrated Data] deleted_at 135 [deleted_at (system_users) #3] [Project Owner (system_users)] deleted_at 542 datetime Year true [Migrated Data] auth_user_id 129 [auth_user_id (system_users) #3] [Project Owner (system_users)] auth_user_id 543 string Count 255 true "true" [Migrated Data] asset_key_id 3 [asset_key_id (system_users) #4] [Project Owner (system_users)] asset_key_id 544 integer Sum 10 true [Migrated Data] lock_version 3 [lock_version (system_users) #1] [Project Owner (system_users)] lock_version 545 integer Sum 10 true [Migrated Data] last_password_update 135 [last_password_update (system_users) #1] [Project Owner (system_users)] last_password_update 546 datetime Year true [Migrated Data] force_password_update 11 [force_password_update (system_users) #1] [Project Owner (system_users)] force_password_update 547 boolean Count true [Migrated Data] protected_password 129 [protected_password (system_users) #1] [Project Owner (system_users)] protected_password 548 string Count 2147483647 true "true" [Migrated Data] last_failed_login 135 [last_failed_login (system_users) #1] [Project Owner (system_users)] last_failed_login 549 datetime Year true [Migrated Data] failed_login_attempts 3 [failed_login_attempts (system_users) #1] [Project Owner (system_users)] failed_login_attempts 550 integer Sum 10 true [Migrated Data] protected_password_bad_format 11 [protected_password_bad_format (system_users) #1] [Project Owner (system_users)] protected_password_bad_format 551 boolean Count true [Migrated Data] Semicolon-delimited list of usernames that have been granted Project Leader rights to the project the item exists in. Example: ";mcoles;jdrummey;" This can be referenced in the User Filter field to allow Project Leaders to access data on background tasks that pertain to the projects they are responsible for. The user name of the user who owns the project the item acted upon lives in. The LUID of the Data Source, Workbook or View the event was performed against. Guaranteed to be unique to this Item across the entire Server instance. Generally used to reference content via the Tableau Server API. The site role for the user who initiated the event. Will be NULL for any event generated by Tableau Server itself. The version of the item the event was performed against, at the time that the event was performed. Note that the repository uses two fields for the same purpose: "revision" and "content_version", formatted as "2.2" and "23", respectively. This field converts the first format to the latter, so it matches what you would see in the revision history on Tableau Server. The CURRENT LUID of the Project within which the event took place, if it was performed against content. (LUIDs are primarily useful for referencing using the Tableau Server API) This calc isnt used for anything, it's just here to keep the version of the data source, e.g."02.01" (version set [dot] iteration). The CURRENT name of the Data Source or Workbook the event was performed against. The date and time that the event in question took place, adjusted by the Timezone Offset parameter you've set. Note that for older data, a simple adjustement like this will not be accurate if your timezone uses Daylight Savings! Determines whether the Tableau Server user accessing this data source has rights to see an event described by it. This is set as a Data Source level filter so that it applies to anyone accessing the datasource. Measure representing the total number of events Measure representing the count of unique Actors (users intiating the events). Usage Example: Displaying this measure on Rows, with Event Date on Columns aggregated to the minute would answer the question ("how many concurrent users per minute does my server have?") A unique, url-style path to the Data Source, Workbook, or View that the event was performed against. This value preserves the historical path an item was available at during the time when the event was performed. The ID of the Data Source, Workbook or View the event was performed against. The CURRENT version of the Data Source or Workbook the event was performed against. URL to jump into Web Edit mode on the view, workbook, or datasource on Tableau Server. Full URL to view the datasource or workbook on Tableau Server. The ID of the user who currently owns the View, Datasource, or Workbook the event was performed against. The CURRENT name of the Project within which the event took place, if it was performed against content. A unique, url-style path to the Data Source, Workbook, or View that the event was performed against. This value describes the CURRENT path an item is available at. It will be NULL if the event was not performed against one of the three items listed above, or if the item has since been deleted. The name of the Data Source or Workbook the event was performed against, at the time that the event was performed. If the event was performed against content, this will be one of Data Source, Workbook, or View. IT will be NULL if the event was not performed against content. The CURRENT name for the User who owns the View, Datasource, or Workbook the event was performed against. The system name for the User who owns the View, Datasource, or Workbook the event was performed against. The CURRENT email address for the User who owns the View, Datasource, or Workbook the event was performed against. Full URL to view the Details page of the datasource or workbook on Tableau Server. A unique, url-style path to the Data Source, Workbook, or View that the event was performed against. This differs from Item Repository URL in that if the event was performed against a View, the Item Root Repository URL will be the path to the parent Workbook. This is useful when comparing Workbook actions with View loads on those workbooks, or blending with other data sources. Full URL to view the Extract Schedule page for this datasource or workbook on Tableau Server. Full URL to download the datasource or workbook from Tableau Server. The CURRENT Id of the Project within which the event took place, if it was performed against content. Site LUID for the site this content currently lives in. Generally used to reference content via the Tableau Server API. Events are grouped together into action types, such as Create, Access, Update and Delete. Full URL to view the datasource or workbook on Tableau Server. The CURRENT name of the Data Source or Workbook the event was performed against. The CURRENT name of the Project within which the event took place, if it was performed against content. If the event was performed against content, this will be one of Data Source, Workbook, or View. IT will be NULL if the event was not performed against content. The CURRENT Id of the Project within which the event took place, if it was performed against content. The date and time that the event in question took place, in UTC. [TS Events_9.3].[none:created_at:qk] ([TS Events_9.3].[none:Item Id (copy):ok] / ([TS Events_9.3].[none:Item Owner Id (copy):nk] / ([TS Events_9.3].[none:Item Owner Email (copy):nk] / ([TS Events_9.3].[none:Item Owner Name (copy):nk] / [TS Events_9.3].[none:Calculation_698339484915068929:nk]))))[TS Events_9.3].[usr:Calculation_979814406487343104:qk] The timezone to display dates in. Note that functionally, this is simply an integer value representing the number of hours to offset from UTC, which dates in the Tableau Server Repository are stored in. This means that it will not necessarily be accurate for timezones with Daylight Savings in place. The date and time that the event in question took place, adjusted by the Timezone Offset parameter you've set. Note that for older data, a simple adjustement like this will not be accurate if your timezone uses Daylight Savings! Measure representing the total number of events The date and time that the event in question took place, in UTC. Unique identifier for the event. The name of the specific event that occurred. [TS Events_9.3].[none:created_at:qk] The timezone to display dates in. Note that functionally, this is simply an integer value representing the number of hours to offset from UTC, which dates in the Tableau Server Repository are stored in. This means that it will not necessarily be accurate for timezones with Daylight Savings in place. The name of the Tableau Server instance. This value is used in the hyperlink calculations. The LUID of the Data Source, Workbook or View the event was performed against. Guaranteed to be unique to this Item across the entire Server instance. Generally used to reference content via the Tableau Server API. The CURRENT name of the Data Source or Workbook the event was performed against. The date and time that the event in question took place, adjusted by the Timezone Offset parameter you've set. Note that for older data, a simple adjustement like this will not be accurate if your timezone uses Daylight Savings! Measure representing the total number of events The ID of the Data Source, Workbook or View the event was performed against. Full URL to view the datasource or workbook on Tableau Server. The CURRENT name of the Project within which the event took place, if it was performed against content. A unique, url-style path to the Data Source, Workbook, or View that the event was performed against. This value describes the CURRENT path an item is available at. It will be NULL if the event was not performed against one of the three items listed above, or if the item has since been deleted. If the event was performed against content, this will be one of Data Source, Workbook, or View. IT will be NULL if the event was not performed against content. The date and time that the event in question took place, in UTC. [TS Events_9.3].[none:Item Name (copy):nk] [TS Events_9.3].[none:name:nk] [TS Events_9.3].[none:created_at:qk] [TS Events_9.3].[none:Calculation_698339484915068929:nk] ([TS Events_9.3].[none:Calculation_698339484915068929:nk] * [TS Events_9.3].[usr:Calculation_979814406487343104:qk])[TS Events_9.3].[tdy:Calculation_920704701759684608:qk]