-
Notifications
You must be signed in to change notification settings - Fork 27
/
data_dictionary.htm
9254 lines (9253 loc) · 817 KB
/
data_dictionary.htm
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
<!DOCTYPE html>
<html>
<head>
<style type="text/css">
#table { font-family:"Lucida Sans Unicode", "Lucida Grande", Sans-Serif;font-size:12px;text-align:left;border-collapse:collapse;margin-left:10%;margin-right:10%;margin-top:40px;margin-bottom:40px; }
#table tr.field th {font-size:14px;font-weight:bold;background:#b9c9fe;border-top:4px solid #aabcfe;border-bottom:1px solid #fff;color:#039;padding:8px;}
#table tr.field td {background:#e8edff;border-bottom:1px solid #fff;color:#669;border-top:1px solid transparent;padding:8px;}
#table tr.field:hover td {background: #BCD4EC;}
#table tr.fk td {background:#FFD494;border-bottom:1px solid #fff;color:#786549;border-top:1px solid transparent;padding:8px;}
#table tr.fk:hover td {background:#FFBD5C;}
table.pgtable_toc { background:#D3E6EA; font-family:"Lucida Sans Unicode", "Lucida Grande", Sans-Serif;font-size:12px;text-align:left;border-collapse:collapse;margin-left:10%;margin-right:10%;margin-top:40px;margin-bottom:40px; }
table.pgtable_toc tr th { font-size:14px;font-weight:bold;background:#b9c9fe;border-top:4px solid #aabcfe;border-bottom:1px solid #fff;color:#039;padding:8px;}
table.pgtable_toc tr td { border-bottom:1px solid #fff;color:#669;border-top:1px solid transparent;padding:8px;}
table.pgtable_toc tr:hover td {background: #BCD4EC;}
</style>
</head>
<body>
<center><h1>Workgroups Database</h1></center>
<h2>Introduction</h2>
<p>
The following "data dictionary" provides information about the tables and views in the "workgroup" PostgreSQL
database of the Tableau Server repository.
This database provides persistent storage for Tableau Server and is primarily intended to support that application.
</p>
<p>
The purpose of most tables is described, along with the type and purpose of columns in the tables. Foreign key
relations are noted in orange rows with links that take you from the table containing the foreign key to the
primary key table. This is not an exhaustive description of all tables and fields in the database, but is
provided here for those customers who want to query it for information about their Tableau Server usage.
This information is provided with a caution that because the purpose of these tables and views is primarily to
support Tableau Server, their structure and contents may change without warning and as a result, any custom
views built from them may break.
</p>
<p class="note"><![CDATA[
]]><strong>Note</strong>: All timestamps are in UTC time.
</p>
<h2>Contents</h2>
<h3>Tables (these are available to the "readonly" user)</h3>
<table class="pgtable_toc">
<thead><tr>
<th>Table Name</th>
<th>Description</th>
</tr></thead>
<tbody>
<tr><td><a href="#allegro.concurrency_limit_anchor">allegro.concurrency_limit</a></td><td class="pgtable_description">Run time table for concurrency limit.</td></tr>
<tr><td><a href="#allegro.concurrency_limit_config_anchor">allegro.concurrency_limit_config</a></td><td class="pgtable_description">Config of the concurrency limit.</td></tr>
<tr><td><a href="#allegro.rate_limit_anchor">allegro.rate_limit</a></td><td class="pgtable_description">Run time table for rate limit.</td></tr>
<tr><td><a href="#allegro.rate_limit_config_anchor">allegro.rate_limit_config</a></td><td class="pgtable_description">Config of the rate limit.</td></tr>
<tr><td><a href="#broadcast.broadcast_views_anchor">broadcast.broadcast_views</a></td><td class="pgtable_description">Holds the status of broadcast vizzes</td></tr>
<tr><td><a href="#container_service.container_contents_anchor">container_service.container_contents</a></td><td class="pgtable_description">Table which stores the container contents for container service</td></tr>
<tr><td><a href="#container_service.containers_anchor">container_service.containers</a></td><td class="pgtable_description">Table which stores the containers for container service</td></tr>
<tr><td><a href="#credentials_service.credentials_anchor">credentials_service.credentials</a></td><td class="pgtable_description">This table stores credential summary, which does not include the actual credentials.</td></tr>
<tr><td><a href="#credentials_service.internal_credentials_anchor">credentials_service.internal_credentials</a></td><td class="pgtable_description">The internal_credentials table holds encrypted credentials.</td></tr>
<tr><td><a href="#explain_data.permission_migration_status_anchor">explain_data.permission_migration_status</a></td><td class="pgtable_description">Current status of the Explain Data Permission Migration background job.</td></tr>
<tr><td><a href="#explain_data.processed_workbooks_anchor">explain_data.processed_workbooks</a></td><td class="pgtable_description">Workbooks that have been processed by the Explain Data Permission Migration background job.</td></tr>
<tr><td><a href="#extensions.extensions_events_anchor">extensions.extensions_events</a></td><td class="pgtable_description">Missing description</td></tr>
<tr><td><a href="#extensions.extensions_instances_anchor">extensions.extensions_instances</a></td><td class="pgtable_description">Missing description</td></tr>
<tr><td><a href="#extensions.extensions_metadata_anchor">extensions.extensions_metadata</a></td><td class="pgtable_description">Missing description</td></tr>
<tr><td><a href="#extensions.safe_list_anchor">extensions.safe_list</a></td><td class="pgtable_description">Missing description</td></tr>
<tr><td><a href="#extensions.site_settings_anchor">extensions.site_settings</a></td><td class="pgtable_description">Missing description</td></tr>
<tr><td><a href="#floweditor.session_store_anchor">floweditor.session_store</a></td><td class="pgtable_description">Each row in the table is a floweditor user session.</td></tr>
<tr><td><a href="#hyper_service.hyper_service_capabilities_anchor">hyper_service.hyper_service_capabilities</a></td><td class="pgtable_description">The capabilities of nodes in the cluster</td></tr>
<tr><td><a href="#hyper_service.hyper_service_locks_anchor">hyper_service.hyper_service_locks</a></td><td class="pgtable_description">The database entities currently locked in the Hyper Service</td></tr>
<tr><td><a href="#hyper_service.hyper_service_migration_databases_anchor">hyper_service.hyper_service_migration_databases</a></td><td class="pgtable_description">The databases currently being migrated to new Hyper nodes</td></tr>
<tr><td><a href="#hyper_service.hyper_service_migration_workspace_database_mapping_anchor">hyper_service.hyper_service_migration_workspace_database_mapping</a></td><td class="pgtable_description">The attached workspace databases of sessions that are currently being migrated to new Hyper nodes</td></tr>
<tr><td><a href="#hyper_service.hyper_service_migration_workspace_mapping_anchor">hyper_service.hyper_service_migration_workspace_mapping</a></td><td class="pgtable_description">The workspaces of currently active session migrations</td></tr>
<tr><td><a href="#hyper_service.hyper_service_migrations_anchor">hyper_service.hyper_service_migrations</a></td><td class="pgtable_description">The currently active migrations</td></tr>
<tr><td><a href="#hyper_service.hyper_service_nodes_anchor">hyper_service.hyper_service_nodes</a></td><td class="pgtable_description">The Hyper nodes currently running in the Hyper Service</td></tr>
<tr><td><a href="#messagebus.subscriptions_anchor">messagebus.subscriptions</a></td><td class="pgtable_description">The table to hold the subscription request details to handle service recovery</td></tr>
<tr><td><a href="#meta.dependency_map_anchor">meta.dependency_map</a></td><td class="pgtable_description">Table with foreign key dependencies between tables</td></tr>
<tr><td><a href="#nlp.datasource_usage_stats_anchor">nlp.datasource_usage_stats</a></td><td class="pgtable_description">Usage stats stored for recommendation</td></tr>
<tr><td><a href="#nlp.datasources_anchor">nlp.datasources</a></td><td class="pgtable_description">The table to hold semantic model datasource in nlp service</td></tr>
<tr><td><a href="#nlp.es_historical_configurations_anchor">nlp.es_historical_configurations</a></td><td class="pgtable_description">Elastic Search Configuration History for Tableau Server</td></tr>
<tr><td><a href="#nlp.events_anchor">nlp.events</a></td><td class="pgtable_description">Store the last event processed by nlp service</td></tr>
<tr><td><a href="#nlp.expressions_anchor">nlp.expressions</a></td><td class="pgtable_description">Versioned expressions created by user interactions</td></tr>
<tr><td><a href="#nlp.fields_anchor">nlp.fields</a></td><td class="pgtable_description">The table to hold fields of semantic model datasource in nlp service</td></tr>
<tr><td><a href="#nlp.jobs_anchor">nlp.jobs</a></td><td class="pgtable_description">Store the enqueued jobs to be processed by nlp service</td></tr>
<tr><td><a href="#nlp.links_anchor">nlp.links</a></td><td class="pgtable_description">User created links, each points to a specific LOD expression</td></tr>
<tr><td><a href="#nlp.phrase_recommendation_models_anchor">nlp.phrase_recommendation_models</a></td><td class="pgtable_description">Trained machine learning models for phrases recommendation</td></tr>
<tr><td><a href="#nlp.queries_anchor">nlp.queries</a></td><td class="pgtable_description">Queries stored for datasource analytics</td></tr>
<tr><td><a href="#nlp.recommendation_stats_anchor">nlp.recommendation_stats</a></td><td class="pgtable_description">Recommendation stats extracted from nlp usage data</td></tr>
<tr><td><a href="#nlp.user_datasources_anchor">nlp.user_datasources</a></td><td class="pgtable_description">User specific table to support RLS</td></tr>
<tr><td><a href="#nlp.user_fields_anchor">nlp.user_fields</a></td><td class="pgtable_description">User specific table to support RLS</td></tr>
<tr><td><a href="#nlp.visualizations_anchor">nlp.visualizations</a></td><td class="pgtable_description">visualizations stored for datasource analytics</td></tr>
<tr><td><a href="#public.allow_list_anchor">public.allow_list</a></td><td class="pgtable_description">This table is to store a list of IPs and URLS to restrict prep access to databases.</td></tr>
<tr><td><a href="#public.api_tokens_anchor">public.api_tokens</a></td><td class="pgtable_description">Records for the api tokens</td></tr>
<tr><td><a href="#public.asset_key_marker_anchor">public.asset_key_marker</a></td><td class="pgtable_description">Records are used to flag a particular record in the asset_key_meta_data table.</td></tr>
<tr><td><a href="#public.asset_key_meta_data_anchor">public.asset_key_meta_data</a></td><td class="pgtable_description">Each record holds meta data for an asset encryption key.</td></tr>
<tr><td><a href="#public.asset_list_items_anchor">public.asset_list_items</a></td><td class="pgtable_description">Contains the individual list entries that correspond to the lists defined in the asset_lists table.</td></tr>
<tr><td><a href="#public.asset_lists_anchor">public.asset_lists</a></td><td class="pgtable_description">This table supports the creation of various types of per-user lists. The actual list contents are listed in the asset_list_items table.</td></tr>
<tr><td><a href="#public.async_jobs_anchor">public.async_jobs</a></td><td class="pgtable_description">Records information about background tasks that are run in response to some user action (as opposed to being run on some schedule).</td></tr>
<tr><td><a href="#public.async_service_request_anchor">public.async_service_request</a></td><td class="pgtable_description">Table which stores the requests for async services</td></tr>
<tr><td><a href="#public.async_service_request_execute_history_anchor">public.async_service_request_execute_history</a></td><td class="pgtable_description">Table which stores the execution history for async service request</td></tr>
<tr><td><a href="#public.authorizable_permission_sets_anchor">public.authorizable_permission_sets</a></td><td class="pgtable_description">Many-to-many mapping table between authorizables and permission sets. An authorizable may have a permission set for every permission_set_class.</td></tr>
<tr><td><a href="#public.authorization_servers_anchor">public.authorization_servers</a></td><td class="pgtable_description">Properties of External Authorization Servers</td></tr>
<tr><td><a href="#public.background_jobs_anchor">public.background_jobs</a></td><td class="pgtable_description">Records information about background tasks that are run by a Backgrounder process. These tasks are almost always run according to some schedule, but in a few cases they may also be triggered by some user actions.</td></tr>
<tr><td><a href="#public.background_jobs_cancel_anchor">public.background_jobs_cancel</a></td><td class="pgtable_description">BG jobs for which cancellation has been requested</td></tr>
<tr><td><a href="#public.big_texts_anchor">public.big_texts</a></td><td class="pgtable_description">This table serves as a convenient place to store a big text object, if necessary. It's kind of a utility table. This table is really just used for internal purposes.</td></tr>
<tr><td><a href="#public.caching_policies_anchor">public.caching_policies</a></td><td class="pgtable_description">This table stores the caching policy configuration for workbooks for which the feature is enabled.</td></tr>
<tr><td><a href="#public.capabilities_anchor">public.capabilities</a></td><td class="pgtable_description">Holds a relatively short list of capabilities. 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. Capabilities are things like read, write, export_data, publish, web_authoring, etc.</td></tr>
<tr><td><a href="#public.capability_roles_anchor">public.capability_roles</a></td><td class="pgtable_description">This table serves primarily to associate roles with capabilities. A given role can have many capabilities, and a given capability can be associated with several roles.</td></tr>
<tr><td><a href="#public.cdp_asset_metadata_anchor">public.cdp_asset_metadata</a></td><td class="pgtable_description">Each record represents a cdp asset metadata that exists on Tableau Server.</td></tr>
<tr><td><a href="#public.collection_metrics_aggregations_anchor">public.collection_metrics_aggregations</a></td><td class="pgtable_description">Each record represents a partial aggregation of analytics for a given collection in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.</td></tr>
<tr><td><a href="#public.column_assets_anchor">public.column_assets</a></td><td class="pgtable_description">Each record represents a column asset that exists on Tableau Server.</td></tr>
<tr><td><a href="#public.command_job_mappings_anchor">public.command_job_mappings</a></td><td class="pgtable_description">Each record represents a mapping between an extract command and a background job.</td></tr>
<tr><td><a href="#public.comment_attachments_anchor">public.comment_attachments</a></td><td class="pgtable_description">Attachments for comments.</td></tr>
<tr><td><a href="#public.comments_anchor">public.comments</a></td><td class="pgtable_description">Comments users made on views.</td></tr>
<tr><td><a href="#public.connected_apps_anchor">public.connected_apps</a></td><td class="pgtable_description">Properties of Connected Apps</td></tr>
<tr><td><a href="#public.connected_apps_projects_anchor">public.connected_apps_projects</a></td><td class="pgtable_description">Properties of Connected Apps Projects lookup table</td></tr>
<tr><td><a href="#public.content_migration_manifest_anchor">public.content_migration_manifest</a></td><td class="pgtable_description">for storing data related to a content migration</td></tr>
<tr><td><a href="#public.content_migrations_anchor">public.content_migrations</a></td><td class="pgtable_description">for storing data related to a content migration</td></tr>
<tr><td><a href="#public.content_sync_token_anchor">public.content_sync_token</a></td><td class="pgtable_description">Each record stores the checksum associated to a piece of content</td></tr>
<tr><td><a href="#public.content_usage_anchor">public.content_usage</a></td><td class="pgtable_description">Information about operations performed on Server content.</td></tr>
<tr><td><a href="#public.custom_views_metrics_aggregations_anchor">public.custom_views_metrics_aggregations</a></td><td class="pgtable_description">Each record represents a partial aggregation of analytics for a given custom view in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.</td></tr>
<tr><td><a href="#public.customized_views_anchor">public.customized_views</a></td><td class="pgtable_description">When a user creates a customized view, the data that supports that goes in this table.</td></tr>
<tr><td><a href="#public.data_acceleration_schedule_anchor">public.data_acceleration_schedule</a></td><td class="pgtable_description">for storing the schedules of data acceleration backgrounder jobs</td></tr>
<tr><td><a href="#public.data_alerts_anchor">public.data_alerts</a></td><td class="pgtable_description">Each record represents an alert. An alert is a predefined data conditions on a view, and if conditions are met all alert recipients get notified.</td></tr>
<tr><td><a href="#public.data_alerts_recipients_anchor">public.data_alerts_recipients</a></td><td class="pgtable_description">Each record represents the intent of recipient to be notified if an event is triggered.</td></tr>
<tr><td><a href="#public.data_connections_anchor">public.data_connections</a></td><td class="pgtable_description">Describes various data sources that are included in either workbooks or datasources.</td></tr>
<tr><td><a href="#public.data_quality_indicators_anchor">public.data_quality_indicators</a></td><td class="pgtable_description">Table to store data quality indicators.</td></tr>
<tr><td><a href="#public.data_quality_triggers_anchor">public.data_quality_triggers</a></td><td class="pgtable_description">Table to store data quality triggers.</td></tr>
<tr><td><a href="#public.data_role_contents_association_anchor">public.data_role_contents_association</a></td><td class="pgtable_description">Represents the association between the data_role and other content types.</td></tr>
<tr><td><a href="#public.data_role_datasource_field_association_anchor">public.data_role_datasource_field_association</a></td><td class="pgtable_description">Represents the association between the data_role and the field on a datasource</td></tr>
<tr><td><a href="#public.data_roles_anchor">public.data_roles</a></td><td class="pgtable_description">Each record represents an entry of Semantics Service data role metadata.</td></tr>
<tr><td><a href="#public.data_update_job_artifacts_anchor">public.data_update_job_artifacts</a></td><td class="pgtable_description">Information about files used by data update jobs.</td></tr>
<tr><td><a href="#public.database_asset_events_anchor">public.database_asset_events</a></td><td class="pgtable_description">Used to store database_asset events stream.</td></tr>
<tr><td><a href="#public.database_assets_anchor">public.database_assets</a></td><td class="pgtable_description">Each record represents a database that exists on Tableau Server.</td></tr>
<tr><td><a href="#public.datasource_events_anchor">public.datasource_events</a></td><td class="pgtable_description">Used to store datasource events stream.</td></tr>
<tr><td><a href="#public.datasource_fields_anchor">public.datasource_fields</a></td><td class="pgtable_description">Describes datasource fields.</td></tr>
<tr><td><a href="#public.datasource_metrics_aggregations_anchor">public.datasource_metrics_aggregations</a></td><td class="pgtable_description">Each record represents a partial aggregation of analytics for a given datasource in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.</td></tr>
<tr><td><a href="#public.datasource_refresh_properties_anchor">public.datasource_refresh_properties</a></td><td class="pgtable_description">Extension of datasources table for refresh properties (Online). This is 1-0/1 relationship to datasources table. It is
a separate table since it contains Online-specific properties.</td></tr>
<tr><td><a href="#public.datasource_versions_anchor">public.datasource_versions</a></td><td class="pgtable_description">Datasource versions saved on server.</td></tr>
<tr><td><a href="#public.datasources_anchor">public.datasources</a></td><td class="pgtable_description">Records all Published datasources on server.</td></tr>
<tr><td><a href="#public.desktop_reporting_anchor">public.desktop_reporting</a></td><td class="pgtable_description">Each record represents a Tableau Desktop usage report.</td></tr>
<tr><td><a href="#public.domains_anchor">public.domains</a></td><td class="pgtable_description">Records represent either an Active Directory domain or an authenticate system.</td></tr>
<tr><td><a href="#public.draft_metadata_anchor">public.draft_metadata</a></td><td class="pgtable_description">Each record represents a workbook draft per site, per project per user.</td></tr>
<tr><td><a href="#public.edge_pool_domain_mappings_anchor">public.edge_pool_domain_mappings</a></td><td class="pgtable_description">Each record represents a resource URI managed by edge pool.</td></tr>
<tr><td><a href="#public.edge_pool_metadata_anchor">public.edge_pool_metadata</a></td><td class="pgtable_description">Each record represents an edge pool.</td></tr>
<tr><td><a href="#public.encryption_keys_anchor">public.encryption_keys</a></td><td class="pgtable_description">Table storing encryption keys.</td></tr>
<tr><td><a href="#public.extensions_block_list_anchor">public.extensions_block_list</a></td><td class="pgtable_description">Table which stores the block list of extensions on this server</td></tr>
<tr><td><a href="#public.extensions_events_anchor">public.extensions_events</a></td><td class="pgtable_description">Table which stores the events of referenced extensions calculation service</td></tr>
<tr><td><a href="#public.extensions_instances_anchor">public.extensions_instances</a></td><td class="pgtable_description">Table which stores referenced extensions information calculated from across the workbooks.</td></tr>
<tr><td><a href="#public.extensions_metadata_anchor">public.extensions_metadata</a></td><td class="pgtable_description">Table which stores Metadata of Extensions.</td></tr>
<tr><td><a href="#public.extensions_safe_list_anchor">public.extensions_safe_list</a></td><td class="pgtable_description">Table which stores safe list of extensions that are configured for a given site.</td></tr>
<tr><td><a href="#public.extensions_site_settings_anchor">public.extensions_site_settings</a></td><td class="pgtable_description">Table which stores the site specific settings for extensions</td></tr>
<tr><td><a href="#public.external_service_connections_anchor">public.external_service_connections</a></td><td class="pgtable_description">Table which stores the site specific settings for external service connections</td></tr>
<tr><td><a href="#public.external_service_site_settings_anchor">public.external_service_site_settings</a></td><td class="pgtable_description">Table which stores the site level settings for external services</td></tr>
<tr><td><a href="#public.extract_operations_anchor">public.extract_operations</a></td><td class="pgtable_description">Each record represents an extract create operation on a Tableau workbook.</td></tr>
<tr><td><a href="#public.extract_service_commands_anchor">public.extract_service_commands</a></td><td class="pgtable_description">Table which stores the extract commands for extract service</td></tr>
<tr><td><a href="#public.extract_service_extracts_anchor">public.extract_service_extracts</a></td><td class="pgtable_description">Table which stores the extracts for extract service</td></tr>
<tr><td><a href="#public.extract_service_object_queue_anchor">public.extract_service_object_queue</a></td><td class="pgtable_description">Table which stores the object queue for extract service</td></tr>
<tr><td><a href="#public.extract_service_object_queue_element_anchor">public.extract_service_object_queue_element</a></td><td class="pgtable_description">Table which stores the object queue for extract service</td></tr>
<tr><td><a href="#public.extract_service_results_anchor">public.extract_service_results</a></td><td class="pgtable_description">Table which stores the extract results for extract service</td></tr>
<tr><td><a href="#public.extract_sessions_anchor">public.extract_sessions</a></td><td class="pgtable_description">Extracts that have active vizql sessions.</td></tr>
<tr><td><a href="#public.extract_storage_upgrades_anchor">public.extract_storage_upgrades</a></td><td class="pgtable_description">Information for the upgrade process of extract storage.</td></tr>
<tr><td><a href="#public.extracts_anchor">public.extracts</a></td><td class="pgtable_description">Each record corresponds to a directory that contains one or more extract files associated with either a workbook or datasource.</td></tr>
<tr><td><a href="#public.field_indexability_anchor">public.field_indexability</a></td><td class="pgtable_description">The user-defined NLP indexability rules for fields in datasources</td></tr>
<tr><td><a href="#public.flow_drafts_anchor">public.flow_drafts</a></td><td class="pgtable_description">Each record represents a draft for a Tableau Prep flow that exists on Tableau Server.</td></tr>
<tr><td><a href="#public.flow_events_anchor">public.flow_events</a></td><td class="pgtable_description">Each row represents an event affecting a flow</td></tr>
<tr><td><a href="#public.flow_input_steps_anchor">public.flow_input_steps</a></td><td class="pgtable_description">Each record represents an individual input step from a published Tableau Prep flow.</td></tr>
<tr><td><a href="#public.flow_models_anchor">public.flow_models</a></td><td class="pgtable_description">Each row contains model metadata for a flow</td></tr>
<tr><td><a href="#public.flow_output_step_runs_anchor">public.flow_output_step_runs</a></td><td class="pgtable_description">Each record represents a run of an output step of a flow. See flow_runs for per-flow run history.</td></tr>
<tr><td><a href="#public.flow_output_steps_anchor">public.flow_output_steps</a></td><td class="pgtable_description">Each record represents an individual output step from a published Maestro flow.</td></tr>
<tr><td><a href="#public.flow_output_steps_data_connections_anchor">public.flow_output_steps_data_connections</a></td><td class="pgtable_description">Serves as a linking mechanism between flow output steps, data_connections, and datasources.</td></tr>
<tr><td><a href="#public.flow_output_steps_parameters_anchor">public.flow_output_steps_parameters</a></td><td class="pgtable_description">Serves as a many to many linking mechanism between flow parameters and flow output steps. An output step can require multiple parameters, and a parameter can be required by multiple output steps.</td></tr>
<tr><td><a href="#public.flow_parameter_list_domain_values_anchor">public.flow_parameter_list_domain_values</a></td><td class="pgtable_description">Each record contains a value for the domain for a list type parameter.</td></tr>
<tr><td><a href="#public.flow_parameter_list_domains_anchor">public.flow_parameter_list_domains</a></td><td class="pgtable_description">Each record contains the domain information for a list type parameter.</td></tr>
<tr><td><a href="#public.flow_parameter_range_domains_anchor">public.flow_parameter_range_domains</a></td><td class="pgtable_description">Each record contains the domain information for a range type parameter.</td></tr>
<tr><td><a href="#public.flow_parameters_anchor">public.flow_parameters</a></td><td class="pgtable_description">Each record represents a parameter for a flow on Tableau Server.</td></tr>
<tr><td><a href="#public.flow_run_errors_anchor">public.flow_run_errors</a></td><td class="pgtable_description">Each record represents an individual flow run error which has detailed information about the error</td></tr>
<tr><td><a href="#public.flow_run_spec_output_steps_anchor">public.flow_run_spec_output_steps</a></td><td class="pgtable_description">Each record represents an individual output step in a flow run specification.</td></tr>
<tr><td><a href="#public.flow_run_spec_parameters_anchor">public.flow_run_spec_parameters</a></td><td class="pgtable_description">Each record holds the override value for a parameter.</td></tr>
<tr><td><a href="#public.flow_run_specs_anchor">public.flow_run_specs</a></td><td class="pgtable_description">Each record represents an individual specification about how a Tableau Prep flow should be run</td></tr>
<tr><td><a href="#public.flow_runs_anchor">public.flow_runs</a></td><td class="pgtable_description">Each record represents a run of a flow. See flow_output_step_runs for per-output-step run history.</td></tr>
<tr><td><a href="#public.flow_runtime_owners_anchor">public.flow_runtime_owners</a></td><td class="pgtable_description">Table to keep track of flow/flow output step owner at flow run time. Used to calculate derived permission on flow outputs.</td></tr>
<tr><td><a href="#public.flow_user_settings_anchor">public.flow_user_settings</a></td><td class="pgtable_description">Each record represents a users selected settings for a Prep flow.</td></tr>
<tr><td><a href="#public.flow_versions_anchor">public.flow_versions</a></td><td class="pgtable_description">flow versions saved on server.</td></tr>
<tr><td><a href="#public.flows_anchor">public.flows</a></td><td class="pgtable_description">Each record represents a Tableau Prep flow that exists on Tableau Server.</td></tr>
<tr><td><a href="#public.geocoding_anchor">public.geocoding</a></td><td class="pgtable_description">Information about geocoding databases.</td></tr>
<tr><td><a href="#public.geocoding_configs_anchor">public.geocoding_configs</a></td><td class="pgtable_description">Metadata about each geocoding config for a datasource.</td></tr>
<tr><td><a href="#public.global_geocoding_anchor">public.global_geocoding</a></td><td class="pgtable_description">Information about global geocoding databases.</td></tr>
<tr><td><a href="#public.group_users_anchor">public.group_users</a></td><td class="pgtable_description">Serves as a many to many linking mechanism between users and groups. A user can belong to multiple groups, and a group can contain multiple users.</td></tr>
<tr><td><a href="#public.group_users_count_anchor">public.group_users_count</a></td><td class="pgtable_description">Each record represents a partial aggregation of a given users count for a group.</td></tr>
<tr><td><a href="#public.groups_anchor">public.groups</a></td><td class="pgtable_description">A grouping of users. Can be locally created or imported from Active Directory.</td></tr>
<tr><td><a href="#public.groupset_groups_anchor">public.groupset_groups</a></td><td class="pgtable_description">Serves as a many to many linking mechanism between groups and groupsets. A group can belong to multiple groupsets, and a groupset can contain multiple groups.</td></tr>
<tr><td><a href="#public.groupsets_anchor">public.groupsets</a></td><td class="pgtable_description">Each record represents a groupset (set of groups) asset that exists on Tableau Server.</td></tr>
<tr><td><a href="#public.hist_capabilities_anchor">public.hist_capabilities</a></td><td class="pgtable_description">Records the most useful information about a capability that was relevant at the time of the event (see capabilities table).</td></tr>
<tr><td><a href="#public.hist_collections_anchor">public.hist_collections</a></td><td class="pgtable_description">Records the most useful information about a collection that was relevant at the time of the event.</td></tr>
<tr><td><a href="#public.hist_column_assets_anchor">public.hist_column_assets</a></td><td class="pgtable_description">Records the most useful information about a column that was relevant at the time of the event (see column_assets table).</td></tr>
<tr><td><a href="#public.hist_comments_anchor">public.hist_comments</a></td><td class="pgtable_description">Records the most useful information about a comment that was relevant at the time of the event (see comments table).</td></tr>
<tr><td><a href="#public.hist_configs_anchor">public.hist_configs</a></td><td class="pgtable_description">Can be used to record information about configuration that was in effect at the time of the historical event.</td></tr>
<tr><td><a href="#public.hist_data_connections_anchor">public.hist_data_connections</a></td><td class="pgtable_description">Records the most useful information about a data connection that was relevant at the time of the event (see data_connections table).</td></tr>
<tr><td><a href="#public.hist_data_quality_indicators_anchor">public.hist_data_quality_indicators</a></td><td class="pgtable_description">Records the most useful information about a data quality indicator that was relevant at the time of the event (see data_quality_indicators table).</td></tr>
<tr><td><a href="#public.hist_data_roles_anchor">public.hist_data_roles</a></td><td class="pgtable_description">Records the most useful information about a data role that was relevant at the time of the event (see data_roles table).</td></tr>
<tr><td><a href="#public.hist_database_assets_anchor">public.hist_database_assets</a></td><td class="pgtable_description">Records the most useful information about a database that was relevant at the time of the event (see database_assets table).</td></tr>
<tr><td><a href="#public.hist_datasources_anchor">public.hist_datasources</a></td><td class="pgtable_description">Records the most useful information about a data source that was relevant at the time of the event (see datasources table).</td></tr>
<tr><td><a href="#public.hist_flow_drafts_anchor">public.hist_flow_drafts</a></td><td class="pgtable_description">Records the most useful information about a flow draft that was relevant at the time of the event (see flow_drafts table).</td></tr>
<tr><td><a href="#public.hist_flows_anchor">public.hist_flows</a></td><td class="pgtable_description">Records the most useful information about a flow that was relevant at the time of the event (see flows table).</td></tr>
<tr><td><a href="#public.hist_groups_anchor">public.hist_groups</a></td><td class="pgtable_description">Records the most useful information about a group that was relevant at the time of the event (see groups table).</td></tr>
<tr><td><a href="#public.hist_licensing_roles_anchor">public.hist_licensing_roles</a></td><td class="pgtable_description">Records the most useful information about a licensing role that was relevant at the time of the event (see licensing_roles table).</td></tr>
<tr><td><a href="#public.hist_metrics_anchor">public.hist_metrics</a></td><td class="pgtable_description">Records the most useful information about a metric that was relevant at the time of the event (see metrics table).</td></tr>
<tr><td><a href="#public.hist_projects_anchor">public.hist_projects</a></td><td class="pgtable_description">Records the most useful information about a project that was relevant at the time of the event (see projects table).</td></tr>
<tr><td><a href="#public.hist_published_connections_anchor">public.hist_published_connections</a></td><td class="pgtable_description">Records the most useful information about a published connection that was relevant at the time of the event (see published_connections table).</td></tr>
<tr><td><a href="#public.hist_remote_agents_anchor">public.hist_remote_agents</a></td><td class="pgtable_description">Records the most useful information about a remote agent that was relevant at the time of the event.</td></tr>
<tr><td><a href="#public.hist_schedules_anchor">public.hist_schedules</a></td><td class="pgtable_description">Records the most useful information about a schedule that was relevant at the time of the event (see schedules table).</td></tr>
<tr><td><a href="#public.hist_sites_anchor">public.hist_sites</a></td><td class="pgtable_description">Records the most useful information about a site that was relevant at the time of the event (see sites table).</td></tr>
<tr><td><a href="#public.hist_table_assets_anchor">public.hist_table_assets</a></td><td class="pgtable_description">Records the most useful information about a table that was relevant at the time of the event (see table_assets table).</td></tr>
<tr><td><a href="#public.hist_tags_anchor">public.hist_tags</a></td><td class="pgtable_description">Records the most useful information about a tag that was relevant at the time of the event (see tags table).</td></tr>
<tr><td><a href="#public.hist_tasks_anchor">public.hist_tasks</a></td><td class="pgtable_description">Records the most useful information about a task that was relevant at the time of the event (see tasks table).</td></tr>
<tr><td><a href="#public.hist_users_anchor">public.hist_users</a></td><td class="pgtable_description">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).</td></tr>
<tr><td><a href="#public.hist_views_anchor">public.hist_views</a></td><td class="pgtable_description">Records the most useful information about a view that was relevant at the time of the event (see views table).</td></tr>
<tr><td><a href="#public.hist_workbooks_anchor">public.hist_workbooks</a></td><td class="pgtable_description">Records the most useful information about a workbook that was relevant at the time of the event (see workbooks table).</td></tr>
<tr><td><a href="#public.historical_disk_usage_anchor">public.historical_disk_usage</a></td><td class="pgtable_description">Records historical disk utilization by Tableau Server for storage monitoring.</td></tr>
<tr><td><a href="#public.historical_event_types_anchor">public.historical_event_types</a></td><td class="pgtable_description">The types of historical events which can be recorded.</td></tr>
<tr><td><a href="#public.historical_events_anchor">public.historical_events</a></td><td class="pgtable_description">This table is the heart of the cluster of tables devoted to historical event auditing. For each event, a record is created on this table. The type of event is indicated through historical_event_type_id, which links to the historical_event_types table. Other information relevant to the event is linked through some of the other id fields in this table. Note these links go to other hist* tables, which allows the event to refer to things that might have since been deleted from the regular tables.</td></tr>
<tr><td><a href="#public.http_requests_anchor">public.http_requests</a></td><td class="pgtable_description">Each record represents a request received by Tableau Server.</td></tr>
<tr><td><a href="#public.hyper_data_update_jobs_anchor">public.hyper_data_update_jobs</a></td><td class="pgtable_description">Each record represents a data update job for a live-to-Hyper connection.</td></tr>
<tr><td><a href="#public.hyper_databases_anchor">public.hyper_databases</a></td><td class="pgtable_description">Information about Hyper databases.</td></tr>
<tr><td><a href="#public.hyper_databases_validation_anchor">public.hyper_databases_validation</a></td><td class="pgtable_description">Stores hyper databases which went through validation.</td></tr>
<tr><td><a href="#public.id__ad_identity_stores_anchor">public.id__ad_identity_stores</a></td><td class="pgtable_description">Identities for Active Directory identity stores.</td></tr>
<tr><td><a href="#public.id__auth_type_instances_anchor">public.id__auth_type_instances</a></td><td class="pgtable_description">Instance of authentication type.</td></tr>
<tr><td><a href="#public.id__identity_pools_anchor">public.id__identity_pools</a></td><td class="pgtable_description">Instance of identity pool.</td></tr>
<tr><td><a href="#public.id__identity_store_identity_states_anchor">public.id__identity_store_identity_states</a></td><td class="pgtable_description">States of identity.</td></tr>
<tr><td><a href="#public.id__identity_store_instances_anchor">public.id__identity_store_instances</a></td><td class="pgtable_description">Instances of identity stores.</td></tr>
<tr><td><a href="#public.id__identity_store_types_anchor">public.id__identity_store_types</a></td><td class="pgtable_description">Types of identity stores.</td></tr>
<tr><td><a href="#public.id__ldap_identity_stores_anchor">public.id__ldap_identity_stores</a></td><td class="pgtable_description">Identities for LDAP identity stores.</td></tr>
<tr><td><a href="#public.id__local_identity_stores_anchor">public.id__local_identity_stores</a></td><td class="pgtable_description">Identities for Local identity stores.</td></tr>
<tr><td><a href="#public.id__oidc_auth_configurations_anchor">public.id__oidc_auth_configurations</a></td><td class="pgtable_description">The OIDC configuration associated with identity pool.</td></tr>
<tr><td><a href="#public.identity_based_activation_reporting_anchor">public.identity_based_activation_reporting</a></td><td class="pgtable_description">Login-based License Management (LBLM) - NOTE: For any custom vizzes or reporting, it is recommended instead to use the View identity_based_activation_admin_view. In this table each row contains important dates with regard to ATR Issuing and Login-based License Usage for a given User, Site, Device and Product combination.</td></tr>
<tr><td><a href="#public.identity_based_activation_user_role_change_anchor">public.identity_based_activation_user_role_change</a></td><td class="pgtable_description">Login-based License Management (LBLM) - NOTE: For any custom vizzes or reporting, it is recommended instead to use the View identity_based_activation_admin_view. This table tracks site role creator changes for each given user on a given site.</td></tr>
<tr><td><a href="#public.integ_slack_users_anchor">public.integ_slack_users</a></td><td class="pgtable_description">Holds slack user specific information.</td></tr>
<tr><td><a href="#public.integ_slack_workspaces_anchor">public.integ_slack_workspaces</a></td><td class="pgtable_description">Holds metadata for slack workspaces.</td></tr>
<tr><td><a href="#public.integ_tab_sites_anchor">public.integ_tab_sites</a></td><td class="pgtable_description">Holds site-specific metadata for app integrations.</td></tr>
<tr><td><a href="#public.integ_tab_slack_site_contexts_anchor">public.integ_tab_slack_site_contexts</a></td><td class="pgtable_description">Holds slack-workspace to tableau-site association metadata.</td></tr>
<tr><td><a href="#public.integ_tab_slack_user_context_anchor">public.integ_tab_slack_user_context</a></td><td class="pgtable_description">Holds association of a slack user to tableau user. </td></tr>
<tr><td><a href="#public.integ_tab_users_anchor">public.integ_tab_users</a></td><td class="pgtable_description">Holds Tableau user specific information.</td></tr>
<tr><td><a href="#public.jwt_info_anchor">public.jwt_info</a></td><td class="pgtable_description">Records for the JWT token ids</td></tr>
<tr><td><a href="#public.label_categories_anchor">public.label_categories</a></td><td class="pgtable_description">Custom categories that label values belong to</td></tr>
<tr><td><a href="#public.label_values_anchor">public.label_values</a></td><td class="pgtable_description">Custom values that can be assigned to labels</td></tr>
<tr><td><a href="#public.language_prefs_anchor">public.language_prefs</a></td><td class="pgtable_description">Contains a listing of information about languages for which Tableau Server has been localized.</td></tr>
<tr><td><a href="#public.last_seen_user_notifications_anchor">public.last_seen_user_notifications</a></td><td class="pgtable_description">This table stores the last seen notification time for each user.</td></tr>
<tr><td><a href="#public.lens_content_relationships_anchor">public.lens_content_relationships</a></td><td class="pgtable_description">Represents the relationship between the lens and other content types.</td></tr>
<tr><td><a href="#public.lens_datasource_associations_anchor">public.lens_datasource_associations</a></td><td class="pgtable_description">Represents the association between the lens and the source datasources for a lens.</td></tr>
<tr><td><a href="#public.lens_fields_anchor">public.lens_fields</a></td><td class="pgtable_description">Table to store fields associated with lenses</td></tr>
<tr><td><a href="#public.lenses_anchor">public.lenses</a></td><td class="pgtable_description">Represents the table for storing lenses.</td></tr>
<tr><td><a href="#public.licensing_roles_anchor">public.licensing_roles</a></td><td class="pgtable_description">Lists the various possible licensing scenarios. (Unlicensed, Guest, Viewer, or Interactor).</td></tr>
<tr><td><a href="#public.link_users_anchor">public.link_users</a></td><td class="pgtable_description">Mapping table between Link user ID to a system_user on a site.</td></tr>
<tr><td><a href="#public.linked_task_actions_anchor">public.linked_task_actions</a></td><td class="pgtable_description">Stores an action for a linked task step.</td></tr>
<tr><td><a href="#public.linked_task_child_jobs_anchor">public.linked_task_child_jobs</a></td><td class="pgtable_description">A job for a child step of a linked task.</td></tr>
<tr><td><a href="#public.linked_task_jobs_anchor">public.linked_task_jobs</a></td><td class="pgtable_description">A specific run of a a linked task.</td></tr>
<tr><td><a href="#public.linked_task_steps_anchor">public.linked_task_steps</a></td><td class="pgtable_description">Stores a step for a linked task.</td></tr>
<tr><td><a href="#public.linked_task_triggers_anchor">public.linked_task_triggers</a></td><td class="pgtable_description">A trigger for a linked task. Will fire on completion on the associated task.</td></tr>
<tr><td><a href="#public.linked_tasks_anchor">public.linked_tasks</a></td><td class="pgtable_description">Stores linked tasks, which allow users to specify tasks to run after each other in sequence.</td></tr>
<tr><td><a href="#public.local_names_anchor">public.local_names</a></td><td class="pgtable_description">Contains translations of certain words or phrases that are relevant to some Tableau Server database constructs.</td></tr>
<tr><td><a href="#public.materialize_views_job_sos_directory_anchor">public.materialize_views_job_sos_directory</a></td><td class="pgtable_description">Each row in the table is a mapping of a workbook id and revision in a materialize views job to the sos directories that the job requires.</td></tr>
<tr><td><a href="#public.materialized_queries_anchor">public.materialized_queries</a></td><td class="pgtable_description">This table stores the information for materialized queries.</td></tr>
<tr><td><a href="#public.materialized_sheets_to_queries_anchor">public.materialized_sheets_to_queries</a></td><td class="pgtable_description">Enabled sheets and materialized queries are many to many relation. This table stores the mapping between sheets and materialized queries.</td></tr>
<tr><td><a href="#public.materialized_views_anchor">public.materialized_views</a></td><td class="pgtable_description">This table stores the materialized views for queries in workbooks.</td></tr>
<tr><td><a href="#public.materialized_views_bloom_filters_anchor">public.materialized_views_bloom_filters</a></td><td class="pgtable_description">This table stores the bloom filters indicating materialized sites/workbooks.</td></tr>
<tr><td><a href="#public.materialized_views_connections_anchor">public.materialized_views_connections</a></td><td class="pgtable_description">This table stores the information required to fetch materialized views files from the server where they are stored.</td></tr>
<tr><td><a href="#public.materialized_views_job_stats_anchor">public.materialized_views_job_stats</a></td><td class="pgtable_description">This table stores daily aggregated materialized views job stats.</td></tr>
<tr><td><a href="#public.materialized_views_metadata_anchor">public.materialized_views_metadata</a></td><td class="pgtable_description">This table stores the metadata for the materialized view service.</td></tr>
<tr><td><a href="#public.materialized_views_object_status_anchor">public.materialized_views_object_status</a></td><td class="pgtable_description">This table stores the materialized views state configuration for objects for which the feature is enabled.</td></tr>
<tr><td><a href="#public.materialized_views_query_store_anchor">public.materialized_views_query_store</a></td><td class="pgtable_description">for storing logical queries and their stats from the traffic</td></tr>
<tr><td><a href="#public.materialized_views_sheet_performance_anchor">public.materialized_views_sheet_performance</a></td><td class="pgtable_description">This table stores daily aggregated materialized views job stats.</td></tr>
<tr><td><a href="#public.materialized_views_sheet_performance_monthly_anchor">public.materialized_views_sheet_performance_monthly</a></td><td class="pgtable_description">This table stores daily aggregated materialized views job stats.</td></tr>
<tr><td><a href="#public.materialized_views_sheet_status_anchor">public.materialized_views_sheet_status</a></td><td class="pgtable_description">This table stores the materialized views state configuration for worksheets for which the feature is enabled.</td></tr>
<tr><td><a href="#public.materialized_views_site_metadata_anchor">public.materialized_views_site_metadata</a></td><td class="pgtable_description">This table is to store materialized views site metadata information.</td></tr>
<tr><td><a href="#public.materialized_views_site_resource_limit_anchor">public.materialized_views_site_resource_limit</a></td><td class="pgtable_description">This table stores the resource limit for acceleration for each site.</td></tr>
<tr><td><a href="#public.mentions_anchor">public.mentions</a></td><td class="pgtable_description">Mentions for comments.</td></tr>
<tr><td><a href="#public.metric_metrics_aggregations_anchor">public.metric_metrics_aggregations</a></td><td class="pgtable_description">Each record represents a partial aggregation of analytics for a given metric in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.</td></tr>
<tr><td><a href="#public.metrics_anchor">public.metrics</a></td><td class="pgtable_description">Each record represents a Metric.</td></tr>
<tr><td><a href="#public.metrics_definition_anchor">public.metrics_definition</a></td><td class="pgtable_description">Each record represents a metrics definition.</td></tr>
<tr><td><a href="#public.metrics_snapshot_anchor">public.metrics_snapshot</a></td><td class="pgtable_description">Each record represents a metrics snapshot.</td></tr>
<tr><td><a href="#public.metrics_snapshot_delta_anchor">public.metrics_snapshot_delta</a></td><td class="pgtable_description">Each record represents a metrics snapshot delta.</td></tr>
<tr><td><a href="#public.metrics_view_anchor">public.metrics_view</a></td><td class="pgtable_description">Each record represents a metrics view.</td></tr>
<tr><td><a href="#public.mobile_security_server_settings_anchor">public.mobile_security_server_settings</a></td><td class="pgtable_description">A key-value store for mobile secuirty server settings.</td></tr>
<tr><td><a href="#public.mobile_security_site_settings_anchor">public.mobile_security_site_settings</a></td><td class="pgtable_description">A key-value store for mobile security site settings.</td></tr>
<tr><td><a href="#public.most_recent_refreshes_anchor">public.most_recent_refreshes</a></td><td class="pgtable_description">most recent refresh data for alerts</td></tr>
<tr><td><a href="#public.most_recent_subscription_runs_anchor">public.most_recent_subscription_runs</a></td><td class="pgtable_description">most recent subscription runs data for suspend subscriptions</td></tr>
<tr><td><a href="#public.mru_list_entries_anchor">public.mru_list_entries</a></td><td class="pgtable_description">Holds most recently used list entries. The records here are linked to the lists to which they belong. Those lists are defined in the mru_lists table.</td></tr>
<tr><td><a href="#public.mru_lists_anchor">public.mru_lists</a></td><td class="pgtable_description">Most recently used lists by user. The actual list contents are in the mru_list_entries table.</td></tr>
<tr><td><a href="#public.next_gen_permissions_anchor">public.next_gen_permissions</a></td><td class="pgtable_description">This table provides a flexible means of describing which users and groups have been granted which capabilities, on which things. Be aware that permissions is a complex topic and that this table does not contain all relevant information about permissions. For example, some permissions are given, automatically, to owners of workbooks or projects.</td></tr>
<tr><td><a href="#public.nlp_suggested_questions_anchor">public.nlp_suggested_questions</a></td><td class="pgtable_description">Suggested questions</td></tr>
<tr><td><a href="#public.nlp_suggestion_groups_anchor">public.nlp_suggestion_groups</a></td><td class="pgtable_description">Suggested question groups</td></tr>
<tr><td><a href="#public.oauth_authorization_codes_anchor">public.oauth_authorization_codes</a></td><td class="pgtable_description">OAuth authorization codes</td></tr>
<tr><td><a href="#public.oauth_clients_anchor">public.oauth_clients</a></td><td class="pgtable_description">A map that register oauth CI/CS/redierctUri per site per dbclass.</td></tr>
<tr><td><a href="#public.oauth_request_tokens_anchor">public.oauth_request_tokens</a></td><td class="pgtable_description">Table of tokens used for OAuth authorization requests.</td></tr>
<tr><td><a href="#public.oauth_service_code_verifiers_anchor">public.oauth_service_code_verifiers</a></td><td class="pgtable_description">Short lived storage for the code verifier used in PKCE requests.</td></tr>
<tr><td><a href="#public.oauth_states_anchor">public.oauth_states</a></td><td class="pgtable_description">The OAuth request state, will be verified later to prevent CSRF attack.</td></tr>
<tr><td><a href="#public.password_tokens_anchor">public.password_tokens</a></td><td class="pgtable_description">Tokens issued to client through link in email which can be redeemed to change their password</td></tr>
<tr><td><a href="#public.pdf_subscription_options_anchor">public.pdf_subscription_options</a></td><td class="pgtable_description">Used to store different PDF layout options.</td></tr>
<tr><td><a href="#public.pending_search_update_items_anchor">public.pending_search_update_items</a></td><td class="pgtable_description">This table represents an item that is associated with a pending_search_update.</td></tr>
<tr><td><a href="#public.permission_reasons_anchor">public.permission_reasons</a></td><td class="pgtable_description">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. The integer precedence is internal to the stored procedures. The effective permission reason is returned to callers.</td></tr>
<tr><td><a href="#public.permission_set_classes_anchor">public.permission_set_classes</a></td><td class="pgtable_description">Represents a class of permission sets. Generally 1-to-1 with capabilities.</td></tr>
<tr><td><a href="#public.permission_set_items_anchor">public.permission_set_items</a></td><td class="pgtable_description">Represents a single next_gen_permission in a permission_set. The columns mirror the next_gen_permissions table.</td></tr>
<tr><td><a href="#public.permission_sets_anchor">public.permission_sets</a></td><td class="pgtable_description">Represents a common set of permissions used by multiple authorizables.</td></tr>
<tr><td><a href="#public.permissions_templates_anchor">public.permissions_templates</a></td><td class="pgtable_description">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. Be aware that permissions is a complex topic and that this table does not contain all relevant information about permissions. For example, some permissions are given, automatically, to owners of workbooks or projects.</td></tr>
<tr><td><a href="#public.pkce_tokens_anchor">public.pkce_tokens</a></td><td class="pgtable_description">Proof Key for Credential Exchange (RFC 7636) short-lived storage.</td></tr>
<tr><td><a href="#public.predictive_model_jobs_anchor">public.predictive_model_jobs</a></td><td class="pgtable_description">Table contains data corresponding with predictive model data transfer and training jobs</td></tr>
<tr><td><a href="#public.predictive_model_recipients_anchor">public.predictive_model_recipients</a></td><td class="pgtable_description">Table contains data corresponding with predictive model notification recipients</td></tr>
<tr><td><a href="#public.predictive_model_version_deployments_anchor">public.predictive_model_version_deployments</a></td><td class="pgtable_description">Table contains deployment timestamps associated with a particular Predictive Model Version of a Predictive Model</td></tr>
<tr><td><a href="#public.predictive_model_versions_anchor">public.predictive_model_versions</a></td><td class="pgtable_description">Table contains user-created predictive model versions associated with a predictive model</td></tr>
<tr><td><a href="#public.predictive_models_anchor">public.predictive_models</a></td><td class="pgtable_description">Table contains user-created Predictive Models</td></tr>
<tr><td><a href="#public.projects_anchor">public.projects</a></td><td class="pgtable_description">Each row of the table corresponds to a project on Tableau Server.</td></tr>
<tr><td><a href="#public.projects_contents_anchor">public.projects_contents</a></td><td class="pgtable_description">Table which stores the contents of projects</td></tr>
<tr><td><a href="#public.published_connection_revision_tables_anchor">public.published_connection_revision_tables</a></td><td class="pgtable_description">Represents a table of a revision of a published connection.</td></tr>
<tr><td><a href="#public.published_connection_revisions_anchor">public.published_connection_revisions</a></td><td class="pgtable_description">Represents a revision of a published connection.</td></tr>
<tr><td><a href="#public.published_connection_tables_anchor">public.published_connection_tables</a></td><td class="pgtable_description">Represents the published connection table content type.</td></tr>
<tr><td><a href="#public.published_connections_anchor">public.published_connections</a></td><td class="pgtable_description">Represents the published connection content type.</td></tr>
<tr><td><a href="#public.querypolicycollection_anchor">public.querypolicycollection</a></td><td class="pgtable_description">Table to store query policy collections.</td></tr>
<tr><td><a href="#public.quota_definitions_anchor">public.quota_definitions</a></td><td class="pgtable_description">Table which stores all the quota definitions for QuotaService</td></tr>
<tr><td><a href="#public.quota_limits_anchor">public.quota_limits</a></td><td class="pgtable_description">Table which stores the limits info for all quotas for QuotaService</td></tr>
<tr><td><a href="#public.quota_usage_anchor">public.quota_usage</a></td><td class="pgtable_description">Table which stores the usage info for all quotas for QuotaService</td></tr>
<tr><td><a href="#public.recommendations_dismissed_views_anchor">public.recommendations_dismissed_views</a></td><td class="pgtable_description">Views dismissed by user in context of viz recommendations</td></tr>
<tr><td><a href="#public.recycle_bin_content_types_anchor">public.recycle_bin_content_types</a></td><td class="pgtable_description">Content Type lookup table for Recycle Bin.</td></tr>
<tr><td><a href="#public.refresh_token_devices_anchor">public.refresh_token_devices</a></td><td class="pgtable_description">Devices that have been issued at least one refresh token</td></tr>
<tr><td><a href="#public.refresh_tokens_anchor">public.refresh_tokens</a></td><td class="pgtable_description">Tokens issued to clients which can be redeemed by the client for access to the server</td></tr>
<tr><td><a href="#public.remote_agent_host_map_anchor">public.remote_agent_host_map</a></td><td class="pgtable_description">Table for mapping remote agent to worker host serving requests for that agent</td></tr>
<tr><td><a href="#public.remote_agents_anchor">public.remote_agents</a></td><td class="pgtable_description">Registry of remote agents (Online). Remote agents are programs installed on customer PC and executing tasks
on a behalf of a customer. The first example of agent is Tableau Data Sync. It is running in background on
customer desktop and performing automatic data source refreshes based on schedules defined by customers.</td></tr>
<tr><td><a href="#public.repository_data_anchor">public.repository_data</a></td><td class="pgtable_description">This table forms the link between other tables that need to store "large object" data, and the large object storage, itself.</td></tr>
<tr><td><a href="#public.resource_holder_types_anchor">public.resource_holder_types</a></td><td class="pgtable_description">Information about entities which can hold on to resources. For instance workbook is such an entity, it can reference a geocoding database and keep it alive.</td></tr>
<tr><td><a href="#public.resource_types_anchor">public.resource_types</a></td><td class="pgtable_description">Information about resources which are used by some server entities. For instance geocoding databases are such resources, a workbook can reference a geocoding database and keep it alive.</td></tr>
<tr><td><a href="#public.resource_usage_anchor">public.resource_usage</a></td><td class="pgtable_description">Information about resources by tableau server entities, for example which geocoding databases are used by which workbooks.</td></tr>
<tr><td><a href="#public.roles_anchor">public.roles</a></td><td class="pgtable_description">This table contains records corresponding to various classifications of users. It should really be viewed in conjuction with the capabilities and capability_roles tables. Taken together, these tables associate different roles with different sets of capabilities. The capabilities sets serve as templates when creating content.</td></tr>
<tr><td><a href="#public.saml_assertions_metadata_anchor">public.saml_assertions_metadata</a></td><td class="pgtable_description">Records for the saml assertions</td></tr>
<tr><td><a href="#public.schedules_anchor">public.schedules</a></td><td class="pgtable_description">Records in this table define a schedule according to which certain regular tasks may be performed (see tasks table). They also indicate the next time at which the schedule will be triggered.</td></tr>
<tr><td><a href="#public.schema_migrations_anchor">public.schema_migrations</a></td><td class="pgtable_description">This table tracks which database migrations have been applied to this database.</td></tr>
<tr><td><a href="#public.serial_collections_anchor">public.serial_collections</a></td><td class="pgtable_description">Records in this table represent groups of background jobs that should not be run simultaneously. </td></tr>
<tr><td><a href="#public.sessions_anchor">public.sessions</a></td><td class="pgtable_description">Settings associated with a user's browser session.</td></tr>
<tr><td><a href="#public.share_actions_anchor">public.share_actions</a></td><td class="pgtable_description">Table storing share actions.</td></tr>
<tr><td><a href="#public.share_contents_anchor">public.share_contents</a></td><td class="pgtable_description">Table storing shared content (view/workboook/etc).</td></tr>
<tr><td><a href="#public.share_deleted_sharers_anchor">public.share_deleted_sharers</a></td><td class="pgtable_description">Table storing deleted sharers backed up details (e.g. name). Needed because we do not cascade delete sharing action after sharer was deleted.</td></tr>
<tr><td><a href="#public.share_recipients_anchor">public.share_recipients</a></td><td class="pgtable_description">Table storing share recipients (users/groups/etc).</td></tr>
<tr><td><a href="#public.share_single_user_options_anchor">public.share_single_user_options</a></td><td class="pgtable_description">Table storing single user options on shared content (does not change the content itself).</td></tr>
<tr><td><a href="#public.sheet_images_anchor">public.sheet_images</a></td><td class="pgtable_description">Serves as a cache for all the sheet images generated by server.</td></tr>
<tr><td><a href="#public.site_auth_tokens_anchor">public.site_auth_tokens</a></td><td class="pgtable_description">Table to house site-scoped refresh tokens</td></tr>
<tr><td><a href="#public.site_gdot_tenant_anchor">public.site_gdot_tenant</a></td><td class="pgtable_description">tenant record created in GDoT for sites</td></tr>
<tr><td><a href="#public.site_keychains_anchor">public.site_keychains</a></td><td class="pgtable_description">This table stores keychains for site, which is used for credentials service V1</td></tr>
<tr><td><a href="#public.site_logos_anchor">public.site_logos</a></td><td class="pgtable_description">custom logo image metadata for sites</td></tr>
<tr><td><a href="#public.site_oauth_clients_anchor">public.site_oauth_clients</a></td><td class="pgtable_description">OAuth clients approval override for a site; Only applicable for Online</td></tr>
<tr><td><a href="#public.site_oidc_configurations_anchor">public.site_oidc_configurations</a></td><td class="pgtable_description">Defines the OpenID Connect IdP associated with a site.</td></tr>
<tr><td><a href="#public.site_roles_anchor">public.site_roles</a></td><td class="pgtable_description">Lists the various possible user site roles.</td></tr>
<tr><td><a href="#public.site_saml_configurations_anchor">public.site_saml_configurations</a></td><td class="pgtable_description">Defines the SAML IdP associated with a site.</td></tr>
<tr><td><a href="#public.site_saml_entity_descriptors_anchor">public.site_saml_entity_descriptors</a></td><td class="pgtable_description">External SAML Service Providers used by samlservice.</td></tr>
<tr><td><a href="#public.site_saml_events_anchor">public.site_saml_events</a></td><td class="pgtable_description">Log table for all SAML actions.</td></tr>
<tr><td><a href="#public.site_saml_sessions_anchor">public.site_saml_sessions</a></td><td class="pgtable_description">Records the user sessions authenticated by the SiteSAML service.</td></tr>
<tr><td><a href="#public.site_saml_users_anchor">public.site_saml_users</a></td><td class="pgtable_description">Users that are allowed to use Per Site SAML authentication.</td></tr>
<tr><td><a href="#public.site_user_prefs_anchor">public.site_user_prefs</a></td><td class="pgtable_description">Site user preferences.</td></tr>
<tr><td><a href="#public.sites_anchor">public.sites</a></td><td class="pgtable_description">Each record represents a site. Each site holds its own workbooks, datasources, users, etc. Strict isolation between the contents of each site is maintained.</td></tr>
<tr><td><a href="#public.slack_version_update_anchor">public.slack_version_update</a></td><td class="pgtable_description">Table which holds flag indicating whether SlackVersionUpdate job has executed. This job is triggered manually before an upcoming Tableau Cloud release, if it contains new version of Slack app. The trigger will send email to admins of sites, which are connected to Slack. see TFS1302023</td></tr>
<tr><td><a href="#public.sos_blob_data_anchor">public.sos_blob_data</a></td><td class="pgtable_description">table to store sos file types as binary data</td></tr>
<tr><td><a href="#public.sos_blob_data_site_enabled_anchor">public.sos_blob_data_site_enabled</a></td><td class="pgtable_description">table with site_luid column to store sos file types as binary data</td></tr>
<tr><td><a href="#public.sos_metadata_anchor">public.sos_metadata</a></td><td class="pgtable_description">This table with site_luid column forms the link between other tables that need to store blob data, and the blob storage, itself.</td></tr>
<tr><td><a href="#public.sos_virtual_folder_entries_anchor">public.sos_virtual_folder_entries</a></td><td class="pgtable_description">Each record represents a file in a virtual folder currently tracked in Simple Object Storage.</td></tr>
<tr><td><a href="#public.sos_virtual_folders_anchor">public.sos_virtual_folders</a></td><td class="pgtable_description">Each record represents a virtual folder currently tracked in Simple Object Storage.</td></tr>
<tr><td><a href="#public.ss_custom_value_concepts_anchor">public.ss_custom_value_concepts</a></td><td class="pgtable_description">The table to hold value concepts used by semantics service</td></tr>
<tr><td><a href="#public.ss_field_concepts_anchor">public.ss_field_concepts</a></td><td class="pgtable_description">The table to hold field concepts used by semantics service</td></tr>
<tr><td><a href="#public.ss_object_concepts_anchor">public.ss_object_concepts</a></td><td class="pgtable_description">The table to hold object concepts used by semantics service</td></tr>
<tr><td><a href="#public.ss_ontologies_anchor">public.ss_ontologies</a></td><td class="pgtable_description">The table to hold ontologies used by semantics service</td></tr>
<tr><td><a href="#public.subscription_messages_anchor">public.subscription_messages</a></td><td class="pgtable_description">This table represent a subscription email message.</td></tr>
<tr><td><a href="#public.subscriptions_anchor">public.subscriptions</a></td><td class="pgtable_description">Each record represents a subscription.</td></tr>
<tr><td><a href="#public.subscriptions_customized_views_anchor">public.subscriptions_customized_views</a></td><td class="pgtable_description">This table is used to link various customized views to the subscriptions in which those customized views must be generated and emailed.</td></tr>
<tr><td><a href="#public.subscriptions_flow_metadata_anchor">public.subscriptions_flow_metadata</a></td><td class="pgtable_description">Stores subscriptions metadata, which allow users to subscribe to flow outputs.</td></tr>
<tr><td><a href="#public.subscriptions_flows_anchor">public.subscriptions_flows</a></td><td class="pgtable_description">Stores subscriptions flows, which allow users to subscribe to flow outputs.</td></tr>
<tr><td><a href="#public.subscriptions_views_anchor">public.subscriptions_views</a></td><td class="pgtable_description">This table is used to link various views to the subscriptions in which those views must be generated and emailed.</td></tr>
<tr><td><a href="#public.subscriptions_workbooks_anchor">public.subscriptions_workbooks</a></td><td class="pgtable_description">This table is used to link various workbooks to the subscriptions in which those workbooks must have views generated and emailed.</td></tr>
<tr><td><a href="#public.synonyms_anchor">public.synonyms</a></td><td class="pgtable_description">The table to hold the synonyms for fields of datasources</td></tr>
<tr><td><a href="#public.system_user_identities_anchor">public.system_user_identities</a></td><td class="pgtable_description">Identity to SystemUser mappings.</td></tr>
<tr><td><a href="#public.system_user_migration_conflicts_anchor">public.system_user_migration_conflicts</a></td><td class="pgtable_description">Conflicts when migrating system_user identities.</td></tr>
<tr><td><a href="#public.system_user_migration_conflicts_identity_data_anchor">public.system_user_migration_conflicts_identity_data</a></td><td class="pgtable_description">Identity information related to ambiguous results when migrating system_user identities.</td></tr>
<tr><td><a href="#public.system_users_anchor">public.system_users</a></td><td class="pgtable_description">Each record represents a user of the server. These records correspond to login identity. A single system_user may potentially be able to login to multiple sites. The linkage between a system_user and their allowed sites is defined through the "users" table.</td></tr>
<tr><td><a href="#public.table_asset_events_anchor">public.table_asset_events</a></td><td class="pgtable_description">Used to store table_asset events stream.</td></tr>
<tr><td><a href="#public.table_asset_sources_anchor">public.table_asset_sources</a></td><td class="pgtable_description">Used to store mappings between tables and their source.</td></tr>
<tr><td><a href="#public.table_assets_anchor">public.table_assets</a></td><td class="pgtable_description">Each record represents a table asset that exists on Tableau Server.</td></tr>
<tr><td><a href="#public.taggings_anchor">public.taggings</a></td><td class="pgtable_description">Associates tags with taggable items.</td></tr>
<tr><td><a href="#public.tags_anchor">public.tags</a></td><td class="pgtable_description">Each tag is a string value. A given tag can be associated with many taggable items in a site.</td></tr>
<tr><td><a href="#public.tasks_anchor">public.tasks</a></td><td class="pgtable_description">Serves to connect schedules with background tasks that should be run on that schedule. The schedule is defined in the schedules table, while the task is defined by type.</td></tr>
<tr><td><a href="#public.tde_files_anchor">public.tde_files</a></td><td class="pgtable_description">Information about TDE files.</td></tr>
<tr><td><a href="#public.tde_upgrades_anchor">public.tde_upgrades</a></td><td class="pgtable_description">Information for the upgrade process of TDE extracts to Hyper.</td></tr>
<tr><td><a href="#public.tds_datasource_files_anchor">public.tds_datasource_files</a></td><td class="pgtable_description">The TDS files.</td></tr>
<tr><td><a href="#public.trusted_tickets_anchor">public.trusted_tickets</a></td><td class="pgtable_description">This table lists trusted tickets that have been created. Tickets that are redeemed are deleted once used, hence can only be used once. Tickets that are never redeemed become invalid after the time given by "expires_at" and are eventually deleted from the table automatically.</td></tr>
<tr><td><a href="#public.usage_statistics_partition_past_anchor">public.usage_statistics_partition_past</a></td><td class="pgtable_description">Each record represents a partial aggregation of analytics for content in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.</td></tr>
<tr><td><a href="#public.usage_statistics_partition_today_anchor">public.usage_statistics_partition_today</a></td><td class="pgtable_description">Each record represents a partial aggregation of analytics for content in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.</td></tr>
<tr><td><a href="#public.user_default_customized_views_anchor">public.user_default_customized_views</a></td><td class="pgtable_description">Defines what customized view a user should see for a given view, by default.</td></tr>
<tr><td><a href="#public.user_images_anchor">public.user_images</a></td><td class="pgtable_description">Represents images for each associated system user.</td></tr>
<tr><td><a href="#public.user_notification_content_reference_list_items_anchor">public.user_notification_content_reference_list_items</a></td><td class="pgtable_description">Lists of references to other DB records in user notification content.</td></tr>
<tr><td><a href="#public.user_notification_content_references_anchor">public.user_notification_content_references</a></td><td class="pgtable_description">References to other DB records in user notification content.</td></tr>
<tr><td><a href="#public.user_notification_recipients_anchor">public.user_notification_recipients</a></td><td class="pgtable_description">Holds metadata for all user notification recipients on the server.</td></tr>
<tr><td><a href="#public.user_notifications_anchor">public.user_notifications</a></td><td class="pgtable_description">Holds metadata for all user notifications on the server.</td></tr>
<tr><td><a href="#public.user_notifications_server_settings_anchor">public.user_notifications_server_settings</a></td><td class="pgtable_description">A key-value store for user notifications server settings.</td></tr>
<tr><td><a href="#public.user_notifications_site_settings_anchor">public.user_notifications_site_settings</a></td><td class="pgtable_description">A key-value store for user notifications site settings.</td></tr>
<tr><td><a href="#public.user_notifications_user_settings_anchor">public.user_notifications_user_settings</a></td><td class="pgtable_description">A key-value store for user notifications user settings.</td></tr>
<tr><td><a href="#public.user_onboardings_anchor">public.user_onboardings</a></td><td class="pgtable_description">This table stores onboarding information for tableau features based on system user ids</td></tr>
<tr><td><a href="#public.user_prefs_anchor">public.user_prefs</a></td><td class="pgtable_description">Contains a variety of preferences for the various system users.</td></tr>
<tr><td><a href="#public.users_anchor">public.users</a></td><td class="pgtable_description">Each record links a system_users record to a site. The user's site specific settings are captured here.</td></tr>
<tr><td><a href="#public.value_synonyms_anchor">public.value_synonyms</a></td><td class="pgtable_description">The user defined synonyms associated with values of fields in datasources</td></tr>
<tr><td><a href="#public.view_acceleration_excluded_views_anchor">public.view_acceleration_excluded_views</a></td><td class="pgtable_description">This table is to store, at the sheet level, information related to recommendating views for acceleration.</td></tr>
<tr><td><a href="#public.view_acceleration_recommendation_ranks_anchor">public.view_acceleration_recommendation_ranks</a></td><td class="pgtable_description">This table is to store ranking scores for view acceleration recommendations.</td></tr>
<tr><td><a href="#public.view_acceleration_viewer_recommendations_anchor">public.view_acceleration_viewer_recommendations</a></td><td class="pgtable_description">This table is to store viewers recommendation views for acceleration.</td></tr>
<tr><td><a href="#public.view_metrics_aggregations_anchor">public.view_metrics_aggregations</a></td><td class="pgtable_description">Each record represents a partial aggregation of analytics for a given view in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.</td></tr>
<tr><td><a href="#public.view_refreshed_timestamps_anchor">public.view_refreshed_timestamps</a></td><td class="pgtable_description">This table stores timestamps at which users click on the refresh button.</td></tr>
<tr><td><a href="#public.views_anchor">public.views</a></td><td class="pgtable_description">Each records represents a view in a workbook.</td></tr>
<tr><td><a href="#public.views_stats_anchor">public.views_stats</a></td><td class="pgtable_description">This table is used to track how many times each user has accessed different views.</td></tr>
<tr><td><a href="#public.viz_snapshots_anchor">public.viz_snapshots</a></td><td class="pgtable_description">This table represents a snapshots of viz.</td></tr>
<tr><td><a href="#public.viz_states_anchor">public.viz_states</a></td><td class="pgtable_description">This table represents a snapshot of the state of a viz.</td></tr>
<tr><td><a href="#public.webhooks_anchor">public.webhooks</a></td><td class="pgtable_description">Holds metadata for all registered webhooks on the server.</td></tr>
<tr><td><a href="#public.workbook_checksums_anchor">public.workbook_checksums</a></td><td class="pgtable_description">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.</td></tr>
<tr><td><a href="#public.workbook_events_anchor">public.workbook_events</a></td><td class="pgtable_description">Used to store workbook events stream.</td></tr>
<tr><td><a href="#public.workbook_exports_anchor">public.workbook_exports</a></td><td class="pgtable_description">Each row in the table corresponds to a cached pdf file.</td></tr>
<tr><td><a href="#public.workbook_extension_connections_anchor">public.workbook_extension_connections</a></td><td class="pgtable_description">Associate a workbook with an analytics extension connection.</td></tr>
<tr><td><a href="#public.workbook_versions_anchor">public.workbook_versions</a></td><td class="pgtable_description">Workbook versions saved on server.</td></tr>
<tr><td><a href="#public.workbooks_anchor">public.workbooks</a></td><td class="pgtable_description">Each record represents a workbook that exists on the server.</td></tr>
<tr><td><a href="#public.wps_extracts_anchor">public.wps_extracts</a></td><td class="pgtable_description">Each record represents an extract.</td></tr>
<tr><td><a href="#public.wps_workbooks_anchor">public.wps_workbooks</a></td><td class="pgtable_description">Each record represents a versioned, per-user, per-site workbook.</td></tr>
<tr><td><a href="#recommendations.connection_fields_anchor">recommendations.connection_fields</a></td><td class="pgtable_description">fields used in joins (extracted for the joins recommender)</td></tr>
<tr><td><a href="#recommendations.connection_tables_anchor">recommendations.connection_tables</a></td><td class="pgtable_description">tables used in a connection in a published or embedded data source</td></tr>
<tr><td><a href="#recommendations.connections_anchor">recommendations.connections</a></td><td class="pgtable_description">a connection used by a Datasource to connect to an underlying database or data file</td></tr>
<tr><td><a href="#recommendations.datasources_anchor">recommendations.datasources</a></td><td class="pgtable_description">stores published datasource metadata for datasource recs trainer</td></tr>
<tr><td><a href="#recommendations.fields_anchor">recommendations.fields</a></td><td class="pgtable_description">field in a data source</td></tr>
<tr><td><a href="#recommendations.join_expressions_anchor">recommendations.join_expressions</a></td><td class="pgtable_description">join expressions for TableJoinTrainer</td></tr>
<tr><td><a href="#recommendations.joins_anchor">recommendations.joins</a></td><td class="pgtable_description">stores joins in data sources for the TableJoinTrainer</td></tr>
<tr><td><a href="#recommendations.ml_association_rules_anchor">recommendations.ml_association_rules</a></td><td class="pgtable_description">the association rules used by the table recommender</td></tr>
<tr><td><a href="#recommendations.ml_factorization_models_anchor">recommendations.ml_factorization_models</a></td><td class="pgtable_description">the collaborative filter model used for data source recommendations</td></tr>
<tr><td><a href="#recommendations.ml_last_trained_anchor">recommendations.ml_last_trained</a></td><td class="pgtable_description">Track model loading and training on a per-site basis so it can be resumed if interrupted</td></tr>
<tr><td><a href="#recommendations.ml_ranked_datasource_fields_anchor">recommendations.ml_ranked_datasource_fields</a></td><td class="pgtable_description">Selected top fields per datasource and their usage statistics (for published datasources)</td></tr>
<tr><td><a href="#recommendations.ml_viz_recommendations_models_anchor">recommendations.ml_viz_recommendations_models</a></td><td class="pgtable_description">Viz recommendations models. Stores a model per user, site pair.</td></tr>
<tr><td><a href="#recommendations.views_json_anchor">recommendations.views_json</a></td><td class="pgtable_description">Views info stored as json</td></tr>
<tr><td><a href="#recommendations.workbooks_anchor">recommendations.workbooks</a></td><td class="pgtable_description">workbook metadata extracted for view and data source recommenders</td></tr>
<tr><td><a href="#recommendations.worksheet_fields_anchor">recommendations.worksheet_fields</a></td><td class="pgtable_description">map from extracted worksheet id to field ids</td></tr>
<tr><td><a href="#recommendations.worksheets_anchor">recommendations.worksheets</a></td><td class="pgtable_description">worksheets, used to map user access counts to datasource access in the datasource trainer</td></tr>
<tr><td><a href="#semantics.indexing_status_anchor">semantics.indexing_status</a></td><td class="pgtable_description">This table holds indexing status of field concepts.</td></tr>
<tr><td><a href="#webhooks.webhooks_anchor">webhooks.webhooks</a></td><td class="pgtable_description">Holds metadata for all registered webhooks on the server.</td></tr>
</tbody>
</table>
<h3>Views (these are available to both the "tableau" and the "readonly" users)</h3>
<table class="pgtable_toc">
<thead><tr>
<th>View Name</th>
<th>Description</th>
</tr></thead>
<tbody>
<tr><td><a href="#meta.sites_dependencygraph_view_anchor">meta.sites_dependencygraph_view</a></td><td class="pgtable_description">View with dependency graph rooted on Sites table</td></tr>
<tr><td><a href="#public._background_tasks_anchor">public._background_tasks</a></td><td class="pgtable_description">This view combines the important contents of both the background_jobs table and the async_jobs table to give an overall picture of jobs that were given to a backgrounder process.</td></tr>
<tr><td><a href="#public._comments_anchor">public._comments</a></td><td class="pgtable_description">Comments users made on views.</td></tr>
<tr><td><a href="#public._customized_views_anchor">public._customized_views</a></td><td class="pgtable_description">When a user creates a customized view, the data that supports that goes in the customized_views table, and is reflected in this view.</td></tr>
<tr><td><a href="#public._datasources_anchor">public._datasources</a></td><td class="pgtable_description">Shows all Published datasources on server, along with some associated information.</td></tr>
<tr><td><a href="#public._datasources_stats_anchor">public._datasources_stats</a></td><td class="pgtable_description">Some historical useage information about datasources. Based on the records that exist in the historical events tables.</td></tr>
<tr><td><a href="#public._groups_anchor">public._groups</a></td><td class="pgtable_description">A grouping of users. Can be locally created or imported from Active Directory. Reflects the contents of the groups table and associated tables.</td></tr>
<tr><td><a href="#public._http_requests_anchor">public._http_requests</a></td><td class="pgtable_description">Each record represents a request received by Tableau Server. Reflects data in the http_requests table.</td></tr>
<tr><td><a href="#public._projects_anchor">public._projects</a></td><td class="pgtable_description">Each row of the table corresponds to a project on Tableau Server.</td></tr>
<tr><td><a href="#public._schedules_anchor">public._schedules</a></td><td class="pgtable_description">Records define a schedule according to which certain regular tasks may be performed (see tasks table). They also indicate the next time at which the schedule will be triggered.</td></tr>
<tr><td><a href="#public._sessions_anchor">public._sessions</a></td><td class="pgtable_description">Settings associated with a user's browser session.</td></tr>
<tr><td><a href="#public._sites_anchor">public._sites</a></td><td class="pgtable_description">Each record represents a site. Each site holds its own workbooks, datasources, users, etc. Strict isolation between the contents of each site is maintained.</td></tr>
<tr><td><a href="#public._subscriptions_anchor">public._subscriptions</a></td><td class="pgtable_description">Each record provides information about subscriptions that are scheduled. Subscriptions are a mechanism for receiving specified content by email on some schedule.</td></tr>
<tr><td><a href="#public._system_users_anchor">public._system_users</a></td><td class="pgtable_description">Each record represents a user of the server. These records correspond to login identity. A single system_user may potentially be able to login to multiple sites. The linkage between a system_user and their allowed sites is defined through the "users" table.</td></tr>
<tr><td><a href="#public._tags_anchor">public._tags</a></td><td class="pgtable_description">Each tag is a string value. A given tag can be associated with many taggable items in a site.</td></tr>
<tr><td><a href="#public._users_anchor">public._users</a></td><td class="pgtable_description">Information relating to users.</td></tr>
<tr><td><a href="#public._views_anchor">public._views</a></td><td class="pgtable_description">Each records represents a view in a workbook.</td></tr>
<tr><td><a href="#public._views_stats_anchor">public._views_stats</a></td><td class="pgtable_description">Used to track how many times each user has accessed different views.</td></tr>
<tr><td><a href="#public._workbooks_anchor">public._workbooks</a></td><td class="pgtable_description">Each record represents a workbook that exists on the server.</td></tr>
<tr><td><a href="#public.identity_based_activation_admin_view_anchor">public.identity_based_activation_admin_view</a></td><td class="pgtable_description">Login-based License Management (LBLM) - Database view to faciliate Admin Server and Site Views for Login-based License Usage Reporting.</td></tr>
<tr><td><a href="#public.users_view_anchor">public.users_view</a></td><td class="pgtable_description">Each record corresponds to a user on the system. The data presented is a combination of user data and data from the linked system_user.</td></tr>
</tbody>
</table>
<a name="allegro.concurrency_limit_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>allegro.concurrency_limit</dfn>: Run time table for concurrency limit.</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>id</td><td>integer</td><td>Primary key for the table.</td><tr>
<tr class="field"><td>config_key_name</td><td>text</td><td>The key name of the config.</td><tr>
<tr class="field"><td>lease_key_name</td><td>text</td><td>The key name of the lease item.</td><tr>
<tr class="field"><td>token_count</td><td>integer</td><td>The token count of the lease item.</td><tr>
<tr class="field"><td>expire_at</td><td>timestamp without time zone</td><td>The timestamp for expiring the config.</td><tr>
<tr class="field"><td>created_at</td><td>timestamp without time zone</td><td>The timestamp for creating the config.</td><tr>
<tr class="field"><td>updated_at</td><td>timestamp without time zone</td><td>The timestamp for updating the config.</td><tr>
</tbody>
</table>
<a name="allegro.concurrency_limit_config_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>allegro.concurrency_limit_config</dfn>: Config of the concurrency limit.</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>id</td><td>integer</td><td>Primary key for the config.</td><tr>
<tr class="field"><td>key_name</td><td>text</td><td>The key name of the config.</td><tr>
<tr class="field"><td>capacity</td><td>integer</td><td>The capacity of the config.</td><tr>
<tr class="field"><td>created_at</td><td>timestamp without time zone</td><td>The timestamp for creating the config.</td><tr>
<tr class="field"><td>updated_at</td><td>timestamp without time zone</td><td>The timestamp for updating the config.</td><tr>
</tbody>
</table>
<a name="allegro.rate_limit_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>allegro.rate_limit</dfn>: Run time table for rate limit.</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>id</td><td>integer</td><td>Primary key for the table.</td><tr>
<tr class="field"><td>key_name</td><td>text</td><td>The key name of the config.</td><tr>
<tr class="field"><td>capacity</td><td>text</td><td>The capacity of the config.</td><tr>
<tr class="field"><td>last_refilled</td><td>timestamp without time zone</td><td>The last refill timstamp for the config.</td><tr>
<tr class="field"><td>available</td><td>integer</td><td>The available capacity in seconds.</td><tr>
<tr class="field"><td>overridden_capacity</td><td>integer</td><td>The overridden capacity for the keyname.</td><tr>
<tr class="field"><td>strategy</td><td>integer</td><td>The strategy for the config.</td><tr>
<tr class="field"><td>expire_at</td><td>timestamp without time zone</td><td>The timestamp for expiring the config.</td><tr>
<tr class="field"><td>created_at</td><td>timestamp without time zone</td><td>The timestamp for creating the config.</td><tr>
<tr class="field"><td>updated_at</td><td>timestamp without time zone</td><td>The timestamp for updating the config.</td><tr>
</tbody>
</table>
<a name="allegro.rate_limit_config_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>allegro.rate_limit_config</dfn>: Config of the rate limit.</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>id</td><td>integer</td><td>Primary key for the config.</td><tr>
<tr class="field"><td>key_name</td><td>text</td><td>The key name of the config. The format is jobtype:guid.</td><tr>
<tr class="field"><td>capacity</td><td>integer</td><td>The capacity of the config.</td><tr>
<tr class="field"><td>refill_at_minute</td><td>integer</td><td>The minute of the day to refill the config.</td><tr>
<tr class="field"><td>strategy</td><td>integer</td><td>The strategy for the config.</td><tr>
<tr class="field"><td>created_at</td><td>timestamp without time zone</td><td>The timestamp for creating the config.</td><tr>
<tr class="field"><td>updated_at</td><td>timestamp without time zone</td><td>The timestamp for updating the config.</td><tr>
</tbody>
</table>
<a name="broadcast.broadcast_views_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>broadcast.broadcast_views</dfn>: Holds the status of broadcast vizzes</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>id</td><td>integer</td><td>Sequential id</td><tr>
<tr class="field"><td>site_luid</td><td>uuid</td><td>The local site luid</td><tr>
<tr class="field"><td>view_luid</td><td>uuid</td><td>The local view luid of the broadcast</td><tr>
<tr class="field"><td>workbook_luid</td><td>uuid</td><td>The local workbook luid containing the view luid</td><tr>
<tr class="field"><td>broadcast_workbook_luid</td><td>uuid</td><td>A "foreign key" to the broadcasted workbook on the remote system</td><tr>
<tr class="field"><td>broadcast_workbook_url</td><td>text</td><td>A "foreign key" to the broadcasted workbook on the remote system; specifically the "repo url", which is different than `broadcast_url`</td><tr>
<tr class="field"><td>broadcast_view_name</td><td>character varying</td><td>The name of the view when last updated</td><tr>
<tr class="field"><td>broadcast_workbook_name</td><td>character varying</td><td>The name of the workbook when last updated</td><tr>
<tr class="field"><td>broadcast_url</td><td>text</td><td>The browsable location of the broadcast</td><tr>
<tr class="field"><td>first_published_at</td><td>timestamp with time zone</td><td>First published time of the broadcasted viz.</td><tr>
<tr class="field"><td>last_published_at</td><td>timestamp with time zone</td><td>Last published time of the broadcasted viz.</td><tr>
</tbody>
</table>
<a name="container_service.container_contents_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>container_service.container_contents</dfn>: Table which stores the container contents for container service</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
<tr class="fk"><td colspan="3">Foreign key/Primary key relation from container_luid on this table to luid on table, <a href="#container_service.containers_anchor">container_service.containers</a></td></tr>
</tfoot>
<tbody>
<tr class="field"><td>id</td><td>integer</td><td>The id which uniquely identifies row in the table</td><tr>
<tr class="field"><td>content_luid</td><td>uuid</td><td>The content_luid identifies the content from a monolith that the row is indirecty associated with</td><tr>
<tr class="field"><td>content_type</td><td>character varying</td><td>The type of content being represented by the given row</td><tr>
<tr class="field"><td>container_luid</td><td>uuid</td><td>The LUID of the container</td><tr>
<tr class="field"><td>site_luid</td><td>uuid</td><td>The LUID of the site</td><tr>
<tr class="field"><td>name</td><td>character varying</td><td>The name of the content</td><tr>
<tr class="field"><td>requires_name_uniqueness</td><td>boolean</td><td>Whether a piece of content should have a unique name</td><tr>
<tr class="field"><td>size_in_bytes</td><td>bigint</td><td>The size of the content in bytes</td><tr>
</tbody>
</table>
<a name="container_service.containers_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>container_service.containers</dfn>: Table which stores the containers for container service</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>id</td><td>integer</td><td>The id which uniquely identifies row in the table</td><tr>
<tr class="field"><td>luid</td><td>uuid</td><td>An immutable identifier for the record.</td><tr>
<tr class="field"><td>name</td><td>character varying</td><td>The name of the container.</td><tr>
<tr class="field"><td>site_luid</td><td>uuid</td><td>The site_luid identifies the site that the row is indirecty associated with</td><tr>
<tr class="field"><td>owner_luid</td><td>uuid</td><td>The owner_luid identifies the user owner that the row is indirecty associated with</td><tr>
<tr class="field"><td>container_type</td><td>character varying</td><td>The type of container being represented by the given row</td><tr>
<tr class="field"><td>created_at</td><td>timestamp without time zone</td><td>The time at which this record was created.</td><tr>
<tr class="field"><td>updated_at</td><td>timestamp without time zone</td><td>The last time any changes were made to this record.</td><tr>
<tr class="field"><td>storage_quota</td><td>bigint</td><td>The total (maximum allowed) storage quota of the container in bytes</td><tr>
</tbody>
</table>
<a name="credentials_service.credentials_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>credentials_service.credentials</dfn>: This table stores credential summary, which does not include the actual credentials.</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
<tr class="fk"><td colspan="3">Foreign key/Primary key relation from internal_credential_id on this table to id on table, <a href="#credentials_service.internal_credentials_anchor">credentials_service.internal_credentials</a></td></tr>
</tfoot>
<tbody>
<tr class="field"><td>id</td><td>integer</td><td>Primary key for the record.</td><tr>
<tr class="field"><td>luid</td><td>uuid</td><td>A unique, immutable identifier for the credential.</td><tr>
<tr class="field"><td>site_luid</td><td>uuid</td><td>The associated site luid.</td><tr>
<tr class="field"><td>owner_type</td><td>integer</td><td>The credential owner type.</td><tr>
<tr class="field"><td>owner_luid</td><td>uuid</td><td>The credential owner luid.</td><tr>
<tr class="field"><td>target_class</td><td>character varying</td><td>The dsClass this credential belongs to.</td><tr>
<tr class="field"><td>target_auth</td><td>character varying</td><td>The authenticationType of this credential.</td><tr>
<tr class="field"><td>target_endpoint</td><td>character varying</td><td>Part of this credential identifier, usually would be a Database server address.</td><tr>
<tr class="field"><td>target_port</td><td>integer</td><td>Database server port.</td><tr>
<tr class="field"><td>target_user_name</td><td>character varying</td><td>Part of this credential identifier, usually would be a Database username.</td><tr>
<tr class="field"><td>target_db</td><td>character varying</td><td>Part of this credential identifier, can be a database name/project-id.</td><tr>
<tr class="field"><td>target_user_role</td><td>character varying</td><td>Used when the credential has a "role" property such as Snowflake OAuth.</td><tr>
<tr class="field"><td>target_extra_info</td><td>text</td><td>Extra info about the target.</td><tr>
<tr class="field"><td>credential_type</td><td>integer</td><td>Type of the credential</td><tr>
<tr class="field"><td>internal_credential_id</td><td>integer</td><td>If not null, it is the id of internal_credentials.</td><tr>
<tr class="field"><td>created_at</td><td>timestamp without time zone</td><td>The time the credential was created.</td><tr>
<tr class="field"><td>updated_at</td><td>timestamp without time zone</td><td>The latest time the credential was updated.</td><tr>
<tr class="field"><td>target_oauth_config_id</td><td>character varying</td><td>The oauth config id used for itentifying oauth config, can be null</td><tr>
<tr class="field"><td>target_subclass</td><td>character varying</td><td>The credential target subclass, can be null</td><tr>
<tr class="field"><td>target_authorization_endpoint</td><td>character varying</td><td>The credential target authorization endpoint, can be null</td><tr>
<tr class="field"><td>session_id</td><td>character varying</td><td>The workgroup session id associated with the credential, can be null</td><tr>
</tbody>
</table>
<a name="credentials_service.internal_credentials_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>credentials_service.internal_credentials</dfn>: The internal_credentials table holds encrypted credentials.</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>id</td><td>integer</td><td>Primary key for the internal_credential.</td><tr>
<tr class="field"><td>asset_key_id</td><td>integer</td><td>If not null, indicate which asset_key is used to encrypt the data. This info can be get from the asset_key_metadata table.</td><tr>
<tr class="field"><td>data</td><td>character varying</td><td>The encrypted credential.</td><tr>
</tbody>
</table>
<a name="explain_data.permission_migration_status_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>explain_data.permission_migration_status</dfn>: Current status of the Explain Data Permission Migration background job.</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>id</td><td>integer</td><td>Unique identifier of a row.</td><tr>
<tr class="field"><td>site_id</td><td>integer</td><td>Site id of the last workbook that was processed.</td><tr>
<tr class="field"><td>workbook_id</td><td>integer</td><td>Id of the last workbook that was processed.</td><tr>
<tr class="field"><td>processing_attempt_count</td><td>integer</td><td>Number of processing attempts for the last workbook that was processed.</td><tr>
<tr class="field"><td>processing_complete</td><td>boolean</td><td>Was the workbook successfully processed?</td><tr>
</tbody>
</table>
<a name="explain_data.processed_workbooks_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>explain_data.processed_workbooks</dfn>: Workbooks that have been processed by the Explain Data Permission Migration background job.</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>workbook_id</td><td>integer</td><td>Id of a workbook that was processed.</td><tr>
</tbody>
</table>
<a name="extensions.extensions_events_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>extensions.extensions_events</dfn>: Missing description</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>luid</td><td>uuid</td><td>Missing description</td><tr>
<tr class="field"><td>workbook_luid</td><td>uuid</td><td>Missing description</td><tr>
<tr class="field"><td>site_luid</td><td>uuid</td><td>Missing description</td><tr>
<tr class="field"><td>status</td><td>integer</td><td>Missing description</td><tr>
<tr class="field"><td>created_at</td><td>timestamp without time zone</td><td>Missing description</td><tr>
<tr class="field"><td>updated_at</td><td>timestamp without time zone</td><td>Missing description</td><tr>
</tbody>
</table>
<a name="extensions.extensions_instances_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>extensions.extensions_instances</dfn>: Missing description</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
<tr class="fk"><td colspan="3">Foreign key/Primary key relation from extension_luid on this table to luid on table, <a href="#extensions.extensions_metadata_anchor">extensions.extensions_metadata</a></td></tr>
</tfoot>
<tbody>
<tr class="field"><td>luid</td><td>uuid</td><td>Missing description</td><tr>
<tr class="field"><td>extension_luid</td><td>uuid</td><td>Missing description</td><tr>
<tr class="field"><td>workbook_luid</td><td>uuid</td><td>Missing description</td><tr>
<tr class="field"><td>view_luid</td><td>uuid</td><td>Missing description</td><tr>
<tr class="field"><td>site_luid</td><td>uuid</td><td>Missing description</td><tr>
<tr class="field"><td>active</td><td>boolean</td><td>Missing description</td><tr>
<tr class="field"><td>count</td><td>integer</td><td>Missing description</td><tr>
<tr class="field"><td>created_at</td><td>timestamp without time zone</td><td>Missing description</td><tr>
<tr class="field"><td>updated_at</td><td>timestamp without time zone</td><td>Missing description</td><tr>
</tbody>
</table>
<a name="extensions.extensions_metadata_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>extensions.extensions_metadata</dfn>: Missing description</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>luid</td><td>uuid</td><td>Missing description</td><tr>
<tr class="field"><td>site_luid</td><td>uuid</td><td>Missing description</td><tr>
<tr class="field"><td>id</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>type</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>version</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>manifest_version</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>min_api_version</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>default_locale</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>name_locale_value</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>name_locale_resourceid</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>desc_locale_value</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>dec_locale_resourceid</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>author_name</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>author_email</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>author_org</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>author_website</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>url</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>icon</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>installed</td><td>boolean</td><td>Missing description</td><tr>
<tr class="field"><td>created_at</td><td>timestamp without time zone</td><td>Missing description</td><tr>
<tr class="field"><td>updated_at</td><td>timestamp without time zone</td><td>Missing description</td><tr>
<tr class="field"><td>permissions</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>resources</td><td>text</td><td>Missing description</td><tr>
</tbody>
</table>
<a name="extensions.safe_list_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>extensions.safe_list</dfn>: Missing description</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>site_luid</td><td>uuid</td><td>Missing description</td><tr>
<tr class="field"><td>luid</td><td>uuid</td><td>Missing description</td><tr>
<tr class="field"><td>url</td><td>text</td><td>Missing description</td><tr>
<tr class="field"><td>allow_full_data</td><td>boolean</td><td>Missing description</td><tr>
<tr class="field"><td>prompt_needed</td><td>boolean</td><td>Missing description</td><tr>
<tr class="field"><td>active</td><td>boolean</td><td>Missing description</td><tr>
<tr class="field"><td>created_at</td><td>timestamp without time zone</td><td>Missing description</td><tr>
<tr class="field"><td>updated_at</td><td>timestamp without time zone</td><td>Missing description</td><tr>
</tbody>
</table>
<a name="extensions.site_settings_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>extensions.site_settings</dfn>: Missing description</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>site_luid</td><td>uuid</td><td>Missing description</td><tr>
<tr class="field"><td>luid</td><td>uuid</td><td>Missing description</td><tr>
<tr class="field"><td>extensions_enabled</td><td>boolean</td><td>Missing description</td><tr>
<tr class="field"><td>default_setting</td><td>boolean</td><td>Missing description</td><tr>
<tr class="field"><td>active</td><td>boolean</td><td>Missing description</td><tr>
<tr class="field"><td>updated_at</td><td>timestamp without time zone</td><td>Missing description</td><tr>
</tbody>
</table>
<a name="floweditor.session_store_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>floweditor.session_store</dfn>: Each row in the table is a floweditor user session.</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>id</td><td>bigint</td><td>Primary key for the record.</td><tr>
<tr class="field"><td>version</td><td>integer</td><td>The version of the flow edit session schema.</td><tr>
<tr class="field"><td>sessionid</td><td>character varying</td><td>The sessionid of the flow edit user session.</td><tr>
<tr class="field"><td>draftid</td><td>character varying</td><td>The draftid of the draft for the current user session.</td><tr>
<tr class="field"><td>siteid</td><td>integer</td><td>The site id to enforce site isolation.</td><tr>
<tr class="field"><td>workgroupsessionid</td><td>character varying</td><td>The workgroupsessionid.</td><tr>
<tr class="field"><td>userid</td><td>integer</td><td>The user id.</td><tr>
<tr class="field"><td>lastaccesstime</td><td>timestamp without time zone</td><td>The timestamp when the row is last accessed.</td><tr>
<tr class="field"><td>language</td><td>character varying</td><td>The user language .</td><tr>
<tr class="field"><td>currentsessiondbname</td><td>character varying</td><td>The hyper dbname for the session .</td><tr>
<tr class="field"><td>state</td><td>character varying</td><td>State of the session. It can be Active, Expired, Reaped.</td><tr>
<tr class="field"><td>serverconfig</td><td>character varying</td><td>This is either PWA or EMPTY. Required by hyper.</td><tr>
<tr class="field"><td>useragent</td><td>character varying</td><td>The user agent. Required by hyper</td><tr>
<tr class="field"><td>noneedcachedb</td><td>boolean</td><td>The boolean to decide if cache db is required for the session.</td><tr>
<tr class="field"><td>site_luid</td><td>character varying</td><td>The LUID of the site</td><tr>
<tr class="field"><td>username</td><td>character varying</td><td>The user name.</td><tr>
<tr class="field"><td>userluid</td><td>character varying</td><td>The user luid.</td><tr>
<tr class="field"><td>site_luid_uuid</td><td>uuid</td><td>The luid of the site</td><tr>
</tbody>
</table>
<a name="hyper_service.hyper_service_capabilities_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>hyper_service.hyper_service_capabilities</dfn>: The capabilities of nodes in the cluster</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
<tr class="fk"><td colspan="3">Foreign key/Primary key relation from node_id on this table to id on table, <a href="#hyper_service.hyper_service_nodes_anchor">hyper_service.hyper_service_nodes</a></td></tr>
</tfoot>
<tbody>
<tr class="field"><td>node_id</td><td>bigint</td><td>The id of the node in hyper_service_nodes with this capability</td><tr>
<tr class="field"><td>capability</td><td>character varying</td><td>The capabilities name</td><tr>
<tr class="field"><td>min_version</td><td>character varying</td><td>The Hyper Service Version for which the capability is active</td><tr>
<tr class="field"><td>max_version</td><td>character varying</td><td>The Hyper Service Version for which the capability is active</td><tr>
</tbody>
</table>
<a name="hyper_service.hyper_service_locks_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>hyper_service.hyper_service_locks</dfn>: The database entities currently locked in the Hyper Service</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
<tr class="fk"><td colspan="3">Foreign key/Primary key relation from node_id on this table to id on table, <a href="#hyper_service.hyper_service_nodes_anchor">hyper_service.hyper_service_nodes</a></td></tr>
</tfoot>
<tbody>
<tr class="field"><td>node_id</td><td>bigint</td><td>The id of the node in hyper_service_nodes holding the lock</td><tr>
<tr class="field"><td>entity_type</td><td>integer</td><td>The entity type of the locked entity. Can be (0=Database, 1=Workspace, 2=Session)</td><tr>
<tr class="field"><td>entity_name</td><td>character varying</td><td>The name of the locked entity</td><tr>
<tr class="field"><td>access_mode</td><td>integer</td><td>The access mode of the locked entity. Can be (0=Shared, 1=Exclusive)</td><tr>
</tbody>
</table>
<a name="hyper_service.hyper_service_migration_databases_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>hyper_service.hyper_service_migration_databases</dfn>: The databases currently being migrated to new Hyper nodes</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
<tr class="fk"><td colspan="3">Foreign key/Primary key relation from entity_type, entity_name on this table to entity_type, entity_name on table, <a href="#hyper_service.hyper_service_migrations_anchor">hyper_service.hyper_service_migrations</a></td></tr>
</tfoot>
<tbody>
<tr class="field"><td>entity_type</td><td>integer</td><td>The type of the entity that the database belongs to. Can be (1=Workspace, 2=Session)</td><tr>
<tr class="field"><td>entity_name</td><td>character varying</td><td>The name of the entity that the database belongs to</td><tr>
<tr class="field"><td>database_name</td><td>character varying</td><td>The name of the database</td><tr>
<tr class="field"><td>uploaded</td><td>boolean</td><td>Whether the database has been successfully uploaded</td><tr>
</tbody>
</table>
<a name="hyper_service.hyper_service_migration_workspace_database_mapping_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>hyper_service.hyper_service_migration_workspace_database_mapping</dfn>: The attached workspace databases of sessions that are currently being migrated to new Hyper nodes</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
<tr class="fk"><td colspan="3">Foreign key/Primary key relation from entity_type, session_id on this table to entity_type, entity_name on table, <a href="#hyper_service.hyper_service_migrations_anchor">hyper_service.hyper_service_migrations</a></td></tr>
</tfoot>
<tbody>
<tr class="field"><td>entity_type</td><td>integer</td><td>The type of the entity that is migrated. Can only be (2=Session) in this table, required for Foreign Key</td><tr>
<tr class="field"><td>session_id</td><td>character varying</td><td>The UUIDv4 session identifier of the migrating session</td><tr>
<tr class="field"><td>workspace_database_name</td><td>character varying</td><td>The name of the attached workspace database</td><tr>
</tbody>
</table>
<a name="hyper_service.hyper_service_migration_workspace_mapping_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>hyper_service.hyper_service_migration_workspace_mapping</dfn>: The workspaces of currently active session migrations</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
<tr class="fk"><td colspan="3">Foreign key/Primary key relation from entity_type, session_id on this table to entity_type, entity_name on table, <a href="#hyper_service.hyper_service_migrations_anchor">hyper_service.hyper_service_migrations</a></td></tr>
</tfoot>
<tbody>
<tr class="field"><td>entity_type</td><td>integer</td><td>The type of the entity that is migrated. Can only be (2=Session) in this table, required for Foreign Key</td><tr>
<tr class="field"><td>session_id</td><td>character varying</td><td>The UUIDv4 session identifier of the migrating session</td><tr>
<tr class="field"><td>workspace</td><td>character varying</td><td>The workspace the session belongs to</td><tr>
</tbody>
</table>
<a name="hyper_service.hyper_service_migrations_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>hyper_service.hyper_service_migrations</dfn>: The currently active migrations</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
<tr class="fk"><td colspan="3">Foreign key/Primary key relation from node_id on this table to id on table, <a href="#hyper_service.hyper_service_nodes_anchor">hyper_service.hyper_service_nodes</a></td></tr>
</tfoot>
<tbody>
<tr class="field"><td>entity_type</td><td>integer</td><td>The type of the entity that is migrated. Can be (1=Workspace, 2=Session)</td><tr>
<tr class="field"><td>entity_name</td><td>character varying</td><td>The name of the entity that is migrated (workspace name or UUIDv4 session identifier)</td><tr>
<tr class="field"><td>node_id</td><td>bigint</td><td>The id of the node in hyper_service_nodes that the entity is being migrated from</td><tr>
<tr class="field"><td>ready</td><td>boolean</td><td>Whether the corresponding databases have been added to hyper_service_migrations_databases</td><tr>
<tr class="field"><td>expiration_date</td><td>timestamp with time zone</td><td>The expiration date after which the migration will be cleaned up</td><tr>
<tr class="field"><td>tenant</td><td>character varying</td><td>The tenant of the entity that is migrated</td><tr>
<tr class="field"><td>resource_pool</td><td>character varying</td><td>The resource pool of the entity that is migrated</td><tr>
</tbody>
</table>
<a name="hyper_service.hyper_service_nodes_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>hyper_service.hyper_service_nodes</dfn>: The Hyper nodes currently running in the Hyper Service</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>id</td><td>bigint</td><td>The auto-generated identifier for a node in the Hyper Service</td><tr>
<tr class="field"><td>resource_pool</td><td>character varying</td><td>The resource_pool which a node is assigned to</td><tr>
<tr class="field"><td>address</td><td>character varying</td><td>The address of the host running the Hyper process</td><tr>
<tr class="field"><td>port</td><td>integer</td><td>The port on which Hyper is listening</td><tr>
<tr class="field"><td>load</td><td>double precision</td><td>The load reported by Hyper</td><tr>
<tr class="field"><td>last_heartbeat</td><td>timestamp without time zone</td><td>The last heartbeart from this node</td><tr>
<tr class="field"><td>status</td><td>integer</td><td>The status of this node. Can be (0=Startup,1=Running, 2=DrainConnections, 3=Shutdown)</td><tr>
<tr class="field"><td>version</td><td>character varying</td><td>The Hyper version running on the node</td><tr>
<tr class="field"><td>lease_timeout</td><td>integer</td><td>The timeout value until leases get invalidated in ms</td><tr>
<tr class="field"><td>min_hyper_service_version</td><td>character varying</td><td>The minimum Hyper Service Version Number supported by the node</td><tr>
<tr class="field"><td>max_hyper_service_version</td><td>character varying</td><td>The maximum Hyper Service Version Number supported by the node</td><tr>
</tbody>
</table>
<a name="messagebus.subscriptions_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>messagebus.subscriptions</dfn>: The table to hold the subscription request details to handle service recovery</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>id</td><td>uuid</td><td>The unique identifier for this row that is automatically generated on insert</td><tr>
<tr class="field"><td>created_at</td><td>timestamp with time zone</td><td>The timestamp for when this row entry was created</td><tr>
<tr class="field"><td>updated_at</td><td>timestamp with time zone</td><td>The timestamp for when this row entry was updated</td><tr>
<tr class="field"><td>topic_name</td><td>text</td><td>The topic name for which subscriber will receive message</td><tr>
<tr class="field"><td>scaling_group_name</td><td>text</td><td>The scaling group name to which subscriber belongs</td><tr>
<tr class="field"><td>destination_service_name</td><td>text</td><td>The service name for which the response will be delivered</td><tr>
<tr class="field"><td>instance_count</td><td>integer</td><td>The instance count of the listeners for the subscription</td><tr>
</tbody>
</table>
<a name="meta.dependency_map_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>meta.dependency_map</dfn>: Table with foreign key dependencies between tables</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<tr class="field"><td>id</td><td>bigint</td><td>Auto-generated id from postgres; also the primary key for the table.</td><tr>
<tr class="field"><td>schema_name</td><td>name</td><td>The schema for the table.</td><tr>
<tr class="field"><td>table_name</td><td>name</td><td>The name of the table with a foreign key relationship.</td><tr>
<tr class="field"><td>ref_schema</td><td>name</td><td>The schema for the table referenced by the foreign key.</td><tr>
<tr class="field"><td>ref_table</td><td>name</td><td>The name of the table referenced by the foreign key.</td><tr>
<tr class="field"><td>columns</td><td>character varying</td><td>The columns from the table that contain the FK values.</td><tr>
<tr class="field"><td>ref_columns</td><td>character varying</td><td>The columns from the referenced table that make up its primary key.</td><tr>
<tr class="field"><td>delete_action</td><td>character</td><td>The action expected after deleting a row from the referenced table (a: no action, r: restrict, c: cascade, n: null, d: set default, i: ignore).</td><tr>
<tr class="field"><td>update_action</td><td>character</td><td>The action expected after updating the primary key in a row from the referenced table (a: no action, r: restrict, c: cascade, n: null, d: set default, i: ignore).</td><tr>
<tr class="field"><td>is_implicit</td><td>boolean</td><td>Indicates that the foreign key relationship is implicit (no FK constraint)</td><tr>
<tr class="field"><td>discriminator_column</td><td>name</td><td>Contains the name of the discriminator column if it applies</td><tr>
<tr class="field"><td>discriminator_value</td><td>character varying</td><td>Contains the expected value of the discriminator column</td><tr>
<tr class="field"><td>updated_by</td><td>character varying</td><td>The process that updated the record.</td><tr>
<tr class="field"><td>updated_at</td><td>timestamp without time zone</td><td>The latest time the data was updated.</td><tr>
</tbody>
</table>
<a name="nlp.datasource_usage_stats_anchor"></a>
<table id="table">
<thead>
<tr class="field"><th colspan="3"><dfn>nlp.datasource_usage_stats</dfn>: Usage stats stored for recommendation</th></tr>
<tr class="field"><th scope="col">Name</th><th scope="col">Type</th><th scope="col">Description</th></tr>
</thead>
<tfoot>
<tr class="fk"><td colspan="3">Foreign key/Primary key relation from datasource_uri on this table to uri on table, <a href="#nlp.datasources_anchor">nlp.datasources</a></td></tr>
<tr class="fk"><td colspan="3">Foreign key/Primary key relation from lens_id on this table to id on table, <a href="#nlp.lenses_anchor">nlp.lenses</a></td></tr>
</tfoot>
<tbody>
<tr class="field"><td>id</td><td>bigint</td><td>The unique identifier for this row that is automatically generated on insert</td><tr>
<tr class="field"><td>created_at</td><td>timestamp with time zone</td><td>The timestamp for when this row entry was created</td><tr>
<tr class="field"><td>updated_at</td><td>timestamp with time zone</td><td>The timestamp for when this row entry was updated</td><tr>
<tr class="field"><td>datasource_uri</td><td>text</td><td>URI of data source the usage stats belongs to</td><tr>
<tr class="field"><td>usage_stats</td><td>json</td><td>Aggregated data source usage stats</td><tr>
<tr class="field"><td>lens_id</td><td>integer</td><td>lens id</td><tr>
</tbody>
</table>
<a name="nlp.datasources_anchor"></a>
<table id="table">
<thead>