Tableau

Explore the interactive ERD

Table & Field Reference

workbook_revision

Column	Type	Keys
`revision_number`	Unknown	PK
`workbook_id`	Unknown	PKFK
`site_id`	String	FK
`user_id`	Unknown	FK
`is_current`	Unknown
`is_deleted`	Unknown
`published_at`	Unknown
`size_in_byte`	Unknown

data_source_permission_grantee_capabilities_capability

Column	Type	Keys
`index`	Unknown	PK
`data_source_permission_grantee_capability_index`	Unknown	PKFK
`data_source_permission_id`	Unknown	PKFK
`mode`	Unknown
`name`	Unknown

data_source_permission_grantee_capability

Column	Type	Keys
`index`	Unknown	PK
`data_source_permission_id`	Unknown	PKFK
`group_id`	Unknown
`user_id`	Unknown

data_source_permission

Column	Type	Keys
`id`	Unknown	PKFK
`datasource_owner_id`	Unknown	FK
`parent_id`	Unknown	FK
`site_id`	String	FK
`name`	Unknown
`parent_type`	Unknown

project

Column	Type	Keys
`id`	Unknown	PK
`controlling_permissions_project_id`	Unknown	FK
`owner_id`	Unknown	FK
`parent_project_id`	Unknown	FK
`site_id`	String	FK
`content_permission`	Unknown
`created_at`	Unknown
`datasource_count`	Unknown
`description`	Unknown
`name`	Unknown
`project_count`	Unknown
`top_level_project`	Unknown
`updated_at`	Unknown
`view_count`	Unknown
`workbook_count`	Unknown
`writeable`	Unknown

flow_connection

Column	Type	Keys
`id`	Unknown	PK
`flow_id`	Unknown	FK
`site_id`	String	FK
`embed_password`	Unknown
`query_tagging_enabled`	Unknown
`server_address`	Unknown
`type`	Unknown
`user_name`	Unknown

view

Column	Type	Keys
`id`	Unknown	PK
`owner_id`	Unknown	FK
`site_id`	String	FK
`workbook_id`	Unknown	FK
`content_url`	Unknown
`name`	Unknown

extract_refresh_task

Column	Type	Keys
`id`	Unknown	PK
`datasource_id`	Unknown	FK
`schedule_id`	Unknown	FK
`site_id`	String	FK
`workbook_id`	Unknown	FK
`consecutive_failed_count`	Unknown
`priority`	Unknown
`schedule_frequency`	Unknown
`schedule_frequency_details_interval_weekday`	Json
`schedule_frequency_details_start`	Unknown
`schedule_next_run_at`	Unknown
`type`	Unknown

server_schedule

Column	Type	Keys
`id`	Unknown	PK
`site_id`	String	FK
`created_at`	Unknown
`end_schedule_at`	Unknown
`frequency`	Unknown
`name`	Unknown
`next_run_at`	Unknown
`priority`	Unknown
`state`	Unknown
`type`	Unknown
`updated_at`	Unknown

virtual_connection_permission_grantee_capabilities_capability

Column	Type	Keys
`index`	Unknown	PK
`virtual_connection_permission_grantee_capability_index`	Unknown	PKFK
`virtual_connection_permission_id`	Unknown	PKFK
`mode`	Unknown
`name`	Unknown

virtual_connection_permission_grantee_capability

Column	Type	Keys
`index`	Unknown	PK
`virtual_connection_permission_id`	Unknown	PKFK
`group_id`	Unknown
`user_id`	Unknown

virtual_connection_permission

Column	Type	Keys
`id`	Unknown	PKFK
`site_id`	String	FK
`virtual_connection_owner_id`	Unknown	FK

connected_app

Column	Type	Keys
`_fivetran_id`	String	PK
`owner_id`	Unknown	FK
`site_id`	String	FK
`workbook_id`	Unknown	FK
`content_url`	Unknown
`id`	Unknown
`name`	Unknown

data_source_connection

Column	Type	Keys
`id`	Unknown	PK
`data_source_id`	Unknown	FK
`site_id`	String	FK
`authentication_type`	Unknown
`embed_password`	Unknown
`query_tagging_enabled`	Unknown
`server_address`	Unknown
`server_port`	Unknown
`type`	Unknown
`use_oauth_managed_key_chain`	Unknown
`user_name`	Unknown

users_personal_access_token

Column	Type	Keys
`id`	Unknown	PK
`site_id`	String	FK
`expires_at`	Unknown
`last_used_at`	Unknown
`token_name`	Unknown

flow_parameter

Column	Type	Keys
`id`	Unknown	PK
`flow_id`	Unknown	PKFK
`description`	Unknown
`domain_type`	Unknown
`domain_xsi_type`	Unknown
`name`	Unknown
`site_id`	String
`type`	Unknown

flow_tag

Column	Type	Keys
`index`	Unknown	PK
`flow_id`	Unknown	PKFK
`label`	Unknown

flow

Column	Type	Keys
`id`	Unknown	PK
`owner_id`	Unknown	FK
`project_id`	Unknown	FK
`site_id`	String	FK
`created_at`	Unknown
`description`	Unknown
`file_type`	Unknown
`name`	Unknown
`updated_at`	Unknown
`webpage_url`	Unknown

databases_default_permission_capability

Column	Type	Keys
`index`	Unknown	PK
`default_permission_id`	Unknown	PKFK
`mode`	Unknown
`name`	Unknown

databases_default_permission

Column	Type	Keys
`id`	Unknown	PKFK
`project_owner_id`	Unknown	FK
`site_id`	String	FK
`grantee_capabilities_user_id`	Unknown

collection_item

Column	Type	Keys
`content_id`	Unknown	PK
`collection_luid`	Unknown	PKFK
`added_date`	Unknown
`content_type`	Unknown
`position`	Unknown
`site_id`	Unknown
`title`	Unknown
`extra_data_`

table_default_permission_capability

Column	Type	Keys
`index`	Unknown	PK
`default_permission_id`	Unknown	PKFK
`mode`	Unknown
`name`	Unknown

table_default_permission

Column	Type	Keys
`id`	Unknown	PKFK
`project_owner_id`	Unknown	FK
`site_id`	String	FK
`grantee_capabilities_user_id`	Unknown

collection_permission_grantee_capabilities_capability

Column	Type	Keys
`index`	Unknown	PK
`collection_permission_grantee_capability_index`	Unknown	PKFK
`collection_permission_id`	Unknown	PKFK
`mode`	Unknown
`name`	Unknown

collection_permission_grantee_capability

Column	Type	Keys
`index`	Unknown	PK
`collection_permission_id`	Unknown	PKFK
`group_id`	Unknown	FK
`user_id`	Unknown	FK

collection_permission

Column	Type	Keys
`id`	Unknown	PKFK
`collection_owner_id`	Unknown	FK
`site_id`	String	FK

collection

Column	Type	Keys
`id`	Unknown	PK
`site_id`	Unknown	FK
`user_id`	Unknown	FK
`collection_value_id`	Unknown
`created_at`	Unknown
`description`	Unknown
`favorite`	Unknown
`name`	Unknown
`owner_alias`	Unknown
`owner_domain`	Unknown
`owner_name`	Unknown
`updated_at`	Unknown
`visibility`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`site_id`	String	FK
`auth_setting`	Unknown
`domain_name`	Unknown
`email`	Unknown
`external_auth_user_id`	Unknown
`full_name`	Unknown
`languages`	Unknown
`last_login`	Unknown
`locale`	Unknown
`name`	Unknown
`site_role`	Unknown

data_source_tag

Column	Type	Keys
`label`	Unknown	PK
`data_source_id`	Unknown	PKFK
`site_id`	String

data_source

Column	Type	Keys
`id`	Unknown	PK
`owner_id`	Unknown	FK
`project_id`	Unknown	FK
`site_id`	String	FK
`content_url`	Unknown
`created_at`	Unknown
`description`	Unknown
`encrypt_extract`	Unknown
`has_extract`	Unknown
`is_certified`	Unknown
`name`	Unknown
`updated_at`	Unknown
`use_remote_query_agent`	Unknown
`webpage_url`	Unknown

workbook_connection

Column	Type	Keys
`id`	Unknown	PK
`site_id`	String	FK
`workbook_id`	Unknown	FK
`authentication_type`	Unknown
`datasource_id`	Unknown
`datasource_name`	Unknown
`embed_password`	Unknown
`query_tagging_enabled`	Unknown
`server_address`	Unknown
`server_port`	Unknown
`type`	Unknown
`use_oauth_managed_key_chain`	Unknown
`user_name`	Unknown

virtual_connection_database_connection

Column	Type	Keys
`id`	Unknown	PK
`site_id`	String	FK
`virtual_connection_id`	Unknown	FK
`db_class`	Unknown
`port`	Unknown
`server`	Unknown
`server_address`	Unknown
`server_port`	Unknown
`user_name`	Unknown

data_source_revision

Column	Type	Keys
`revision_number`	Unknown	PK
`data_source_id`	Unknown	PKFK
`site_id`	String	FK
`user_id`	Unknown	FK
`is_current`	Unknown
`is_deleted`	Unknown
`published_at`	Unknown
`size_in_byte`	Unknown

job

Column	Type	Keys
`id`	Unknown	PK
`site_id`	String	FK
`created_at`	Instant
`ended_at`	Unknown
`job_type`	Unknown
`priority`	Unknown
`started_at`	Unknown
`status`	Unknown

favorite

Column	Type	Keys
`label`	Unknown	PK
`users_id`	Unknown	PKFK
`datasource_id`	Unknown	FK
`site_id`	String	FK
`view_id`	Unknown	FK
`workbook_id`	Unknown	FK
`view_created_at`	Unknown
`view_updated_at`	Unknown
`view_url_name`	Unknown

user_notification

Column	Type	Keys
`_fivetran_id`	String	PK
`site_id`	String	FK
`channel`	Unknown
`disabled_by_override`	Unknown
`enabled`	Unknown
`id`	Unknown
`notification_type`	Unknown

subscription

Column	Type	Keys
`id`	Unknown	PK
`schedule_id`	Unknown	FK
`site_id`	String	FK
`user_id`	Unknown	FK
`attach_image`	Unknown
`attach_pdf`	Unknown
`content_id`	Unknown
`content_send_if_view_empty`	Unknown
`content_type`	Unknown
`page_orientation`	Unknown
`page_size_option`	Unknown
`schedule_frequency_details_interval_weekday`	Unknown
`schedule_frequency_details_start`	Unknown
`subject`	Unknown
`suspended`	Unknown

view_permission_grantee_capabilities_capability

Column	Type	Keys
`index`	Unknown	PK
`view_permission_grantee_capability_index`	Unknown	PKFK
`view_permission_id`	Unknown	PKFK
`mode`	Unknown
`name`	Unknown

view_permission_grantee_capability

Column	Type	Keys
`index`	Unknown	PK
`view_permission_id`	Unknown	PKFK
`group_id`	Unknown
`user_id`	Unknown

view_permission

Column	Type	Keys
`id`	Unknown	PKFK
`site_id`	String	FK
`view_owner_id`	Unknown	FK

virtual_connection_default_permission_capability

Column	Type	Keys
`index`	Unknown	PK
`default_permission_id`	Unknown	PKFK
`mode`	Unknown
`name`	Unknown

virtual_connection_default_permission

Column	Type	Keys
`id`	Unknown	PKFK
`project_owner_id`	Unknown	FK
`site_id`	String	FK
`grantee_capabilities_user_id`	Unknown

workbook_default_permission_capability

Column	Type	Keys
`index`	Unknown	PK
`default_permission_id`	Unknown	PKFK
`mode`	Unknown
`name`	Unknown

workbook_default_permission

Column	Type	Keys
`id`	Unknown	PKFK
`project_owner_id`	Unknown	FK
`site_id`	String	FK
`grantee_capabilities_user_id`	Unknown

data_source_default_permission_capability

Column	Type	Keys
`index`	Unknown	PK
`default_permission_id`	Unknown	PKFK
`mode`	Unknown
`name`	Unknown

data_source_default_permission

Column	Type	Keys
`id`	Unknown	PKFK
`project_owner_id`	Unknown	FK
`site_id`	String	FK
`grantee_capabilities_user_id`	Unknown

metric_default_permission_capability

Column	Type	Keys
`index`	Unknown	PK
`default_permission_id`	Unknown	PKFK
`mode`	Unknown
`name`	Unknown

metric_default_permission

Column	Type	Keys
`id`	Unknown	PKFK
`project_owner_id`	Unknown	FK
`site_id`	String	FK
`grantee_capabilities_user_id`	Unknown

flow_default_permission_capability

Column	Type	Keys
`index`	Unknown	PK
`default_permission_id`	Unknown	PKFK
`mode`	Unknown
`name`	Unknown

flow_default_permission

Column	Type	Keys
`id`	Unknown	PKFK
`project_owner_id`	Unknown	FK
`site_id`	String	FK
`grantee_capabilities_user_id`	Unknown

workbook_tag

Column	Type	Keys
`label`	Unknown	PK
`workbook_id`	Unknown	PKFK
`site_id`	String

workbook

Column	Type	Keys
`id`	Unknown	PK
`owner_id`	Unknown	FK
`project_id`	Unknown	FK
`site_id`	String	FK
`acceleration_enabled`	Unknown
`acceleration_last_updated_at`	Unknown
`acceleration_status`	Unknown
`content_url`	Unknown
`created_at`	Unknown
`default_view_id`	Unknown
`description`	Unknown
`encrypt_extract`	Unknown
`location_id`	Unknown
`location_name`	Unknown
`location_type`	Unknown
`name`	Unknown
`show_tab`	Unknown
`size`	Unknown
`updated_at`	Unknown
`webpage_url`	Unknown

flow_permission_grantee_capabilities_capability

Column	Type	Keys
`index`	Unknown	PK
`flow_permission_grantee_capability_index`	Unknown	PKFK
`flow_permission_id`	Unknown	PKFK
`mode`	Unknown
`name`	Unknown

flow_permission_grantee_capability

Column	Type	Keys
`index`	Unknown	PK
`flow_permission_id`	Unknown	PKFK
`group_id`	Unknown
`user_id`	Unknown

flow_permission

Column	Type	Keys
`id`	Unknown	PKFK
`flow_owner_id`	Unknown	FK
`parent_id`	Unknown	FK
`site_id`	String	FK
`parent_type`	Unknown

groups

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	PKFK
`site_id`	String	FK
`domain_name`	Unknown
`import_domain_name`	Unknown
`import_grant_license_mode`	Unknown
`import_site_role`	Unknown
`import_source`	Unknown
`name`	Unknown

virtual_connection

Column	Type	Keys
`id`	Unknown	PK
`site_id`	String	FK
`created_at`	Instant
`has_extracts`	Unknown
`is_certified`	Unknown
`name`	Unknown
`updated_at`	Unknown
`webpage_url`	Unknown

site

Column	Type	Keys
`id`	Unknown	PK
`admin_mode`	Unknown
`allow_subscription_attachments`	Unknown
`ask_data_mode`	Unknown
`cache_warmup_enabled`	Unknown
`cataloging_enabled`	Unknown
`commenting_enabled`	Unknown
`content_url`	Unknown
`derived_permissions_enabled`	Unknown
`disable_subscriptions`	Unknown
`dqw_subscriptions_enabled`	Unknown
`editing_flows_enabled`	Unknown
`explain_data_enabled`	Unknown
`extract_encryption_mode`	Unknown
`guest_access_enabled`	Unknown
`is_data_alerts_enabled`	Unknown
`name`	Unknown
`request_access_enabled`	Unknown
`revision_history_enabled`	Unknown
`revision_limit`	Unknown
`run_now_enabled`	Unknown
`scheduling_flows_enabled`	Unknown
`state`	Unknown
`status_reason`	Unknown
`storage_quota`	Unknown
`subscribe_others_enabled`	Unknown
`time_zone`	Unknown
`use_default_time_zone`	Unknown
`user_quota`	Unknown

data_driven_alert

Column	Type	Keys
`id`	Unknown	PK
`created_id`	Unknown	FK
`project_id`	Unknown	FK
`site_id`	String	FK
`workbook_id`	Unknown	FK
`created_at`	Unknown
`frequency`	Unknown
`owner_id`	Unknown
`public`	Unknown
`subject`	Unknown
`updated_at`	Unknown

user_workbook

Column	Type	Keys
`id`	Unknown	PK
`owner_id`	Unknown	FK
`project_id`	Unknown	FK
`site_id`	String	FK
`content_url`	Unknown
`created_at`	Unknown
`data_acceleration_config`	Unknown
`default_view_id`	Unknown
`description`	Unknown
`encrypt_extract`	Unknown
`location_id`	Unknown
`location_name`	Unknown
`location_type`	Unknown
`name`	Unknown
`show_tabs`	Unknown
`size`	Unknown
`tags`	Json
`updated_at`	Unknown
`webpage_url`	Unknown

project_permission_grantee_capabilities_capability

Column	Type	Keys
`index`	Unknown	PK
`project_permission_grantee_capability_index`	Unknown	PKFK
`project_permission_id`	Unknown	PKFK
`mode`	Unknown
`name`	Unknown

project_permission_grantee_capability

Column	Type	Keys
`index`	Unknown	PK
`project_permission_id`	Unknown	PKFK
`group_id`	Unknown
`user_id`	Unknown

project_permission

Column	Type	Keys
`id`	Unknown	PKFK
`project_owner_id`	Unknown	FK
`site_id`	String	FK

workbook_permission_grantee_capabilities_capability

Column	Type	Keys
`index`	Unknown	PK
`workbook_permission_grantee_capability_index`	Unknown	PKFK
`workbook_permission_id`	Unknown	PKFK
`mode`	Unknown
`name`	Unknown

workbook_permission_grantee_capability

Column	Type	Keys
`index`	Unknown	PK
`workbook_permission_id`	Unknown	PKFK
`group_id`	Unknown
`user_id`	Unknown

workbook_permission

Column	Type	Keys
`id`	Unknown	PKFK
`site_id`	String	FK
`workbook_owner_id`	Unknown	FK