Looker

Explore the interactive ERD

Table & Field Reference

workspace_project

Column	Type	Keys
`id`	Unknown	PKFK
`workspace_id`	Unknown	PKFK

workspace

Column	Type	Keys
`id`	Unknown	PK
`can_index`	Unknown
`can_view`	Unknown

dashboard_layout_component

Column	Type	Keys
`id`	Unknown	PK
`dashboard_layout_dashboard_id`	Unknown	PKFK
`dashboard_layout_id`	Unknown	PKFK
`dashboard_element_id`	Unknown	FK
`columns`	Unknown
`deleted`	Unknown
`element_title`	Unknown
`element_title_hidden`	Unknown
`height`	Unknown
`row`	Unknown
`vis_type`	Unknown
`width`	Unknown

dashboard_layout

Column	Type	Keys
`id`	Unknown	PK
`dashboard_id`	Unknown	PKFK
`active`	Unknown
`can_create`	Unknown
`can_destroy`	Unknown
`can_index`	Unknown
`can_show`	Unknown
`can_update`	Unknown
`column_width`	Unknown
`dashboard_title`	Unknown
`deleted`	Unknown
`description`	Unknown
`label`	Unknown
`layout_order`	Unknown
`type`	Unknown
`width`	Unknown

user_attribute

Column	Type	Keys
`id`	Unknown	PK
`default_value`	Unknown
`label`	Unknown
`name`	Unknown
`type`	Unknown
`value_is_hidden`	Unknown

integration_hub

Column	Type	Keys
`id`	Unknown	PK
`can_accept_legal_agreement`	Unknown
`can_create`	Unknown
`can_destroy`	Unknown
`can_index`	Unknown
`can_show`	Unknown
`can_update`	Unknown
`fetch_error_message`	Unknown
`has_authorization_token`	Unknown
`label`	Unknown
`legal_agreement_required`	Unknown
`legal_agreement_signed`	Unknown
`legal_agreement_text`	Unknown
`official`	Unknown
`url`	Unknown

project

Column	Type	Keys
`id`	Unknown	PK
`allow_warnings`	Unknown
`can_deploy_ref_to_production`	Unknown
`can_index`	Unknown
`can_link_to_service`	Unknown
`can_show`	Unknown
`can_show_branches`	Unknown
`can_show_manifest`	Unknown
`can_update`	Unknown
`can_validate`	Unknown
`can_view_git_deploy_key`	Unknown
`can_webhook_deploy`	Unknown
`dependency_status`	Unknown
`git_application_server_http_port`	Unknown
`git_application_server_http_scheme`	Unknown
`git_password_user_attribute`	Unknown
`git_production_branch_name`	Unknown
`git_release_mgmt_enabled`	Unknown
`git_service_name`	Unknown
`git_username`	Unknown
`git_username_user_attribute`	Unknown
`is_example`	Unknown
`name`	Unknown
`pull_request_mode`	Unknown
`use_git_cookie_auth`	Unknown
`uses_git`	Unknown
`validation_required`	Unknown

connection_snippet

Column	Type	Keys
`_fivetran_id`	String	PK
`connection_name`	Unknown	FK
`label`	Unknown
`name`	Unknown
`sql`	Unknown

dialect_connection_test

Column	Type	Keys
`connection_test`	Unknown	PK
`connection_name`	Unknown	PKFK

connection

Column	Type	Keys
`name`	Unknown	PK
`user_id`	Unknown	FK
`after_connect_statements`	Unknown
`can_access_data`	Unknown
`can_cost_estimate`	Unknown
`can_create`	Unknown
`can_destroy`	Unknown
`can_explore`	Unknown
`can_index`	Unknown
`can_index_limited`	Unknown
`can_refresh_schemas`	Unknown
`can_run_sql_queries`	Unknown
`can_show`	Unknown
`can_test`	Unknown
`can_update`	Unknown
`cost_estimate_enabled`	Unknown
`created_at`	Unknown
`database`	Unknown
`dialect_automatically_run_sql_runner_snippets`	Unknown
`dialect_cost_estimate_style`	Unknown
`dialect_has_ssl_support`	Unknown
`dialect_label`	Unknown
`dialect_name`	Unknown
`dialect_persistent_table_distkey`	Unknown
`dialect_persistent_table_indexes`	Unknown
`dialect_persistent_table_sortkeys`	Unknown
`dialect_supports_cost_estimate`	Unknown
`dialect_supports_inducer`	Unknown
`dialect_supports_multiple_databases`	Unknown
`dialect_supports_persistent_derived_tables`	Unknown
`dialect_supports_streaming`	Unknown
`disable_context_comment`	Unknown
`example`	Unknown
`host`	Unknown
`jdbc_additional_params`	Unknown
`last_reap_at`	Unknown
`last_regen_at`	Unknown
`managed`	Unknown
`max_billing_gigabytes`	Unknown
`max_connections`	Unknown
`pdt_api_control_enabled`	Unknown
`pdt_concurrency`	Unknown
`pdt_context_override`	Unknown
`pdts_enabled`	Unknown
`pool_timeout`	Unknown
`sql_runner_precache_tables`	Unknown
`sql_writing_with_info_schema`	Unknown
`ssl`	Unknown
`supports_data_studio_link`	Unknown
`tmp_db_name`	Unknown
`tunnel_id`	Unknown
`user_attribute_fields`	Unknown
`uses_application_default_credentials`	Unknown
`uses_oauth`	Unknown
`verify_ssl`	Unknown

user_attribute_group_value

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`user_attribute_id`	Unknown	FK
`can`	Json
`rank`	Unknown
`value`	Unknown
`value_is_hidden`	Unknown

dashboard

Column	Type	Keys
`id`	Unknown	PK
`content_metadata_id`	Unknown	FK
`deleter_id`	Unknown	FK
`folder_id`	Unknown	FK
`last_updater_id`	Unknown	FK
`model_id`	Unknown	FK
`user_id`	Unknown	FK
`alert_sync_with_dashboard_filter_enabled`	Unknown
`background_color`	Unknown
`can_copy`	Unknown
`can_create`	Unknown
`can_destroy`	Unknown
`can_download`	Unknown
`can_index`	Unknown
`can_move`	Unknown
`can_recover`	Unknown
`can_render`	Unknown
`can_run`	Unknown
`can_schedule`	Unknown
`can_see_aggregate_table_lookml`	Unknown
`can_see_lookml`	Unknown
`can_show`	Unknown
`can_update`	Unknown
`certification_notes`	Unknown
`certification_status`	Unknown
`certification_ui_status`	Unknown
`certification_updated_at`	Unknown
`certification_user_name`	Unknown
`content_favorite_id`	Unknown
`created_at`	Unknown
`crossfilter_enabled`	Unknown
`deleted`	Unknown
`deleted_at`	Unknown
`description`	Unknown
`edit_uri`	Unknown
`enable_viz_full_screen`	Unknown
`favorite_count`	Unknown
`filters_bar_collapsed`	Unknown
`filters_location_top`	Unknown
`hidden`	Unknown
`last_accessed_at`	Unknown
`last_viewed_at`	Unknown
`load_configuration`	Unknown
`lookml_link_id`	Unknown
`model_label`	Unknown
`preferred_viewer`	Unknown
`query_timezone`	Unknown
`readonly`	Unknown
`refresh_interval`	Unknown
`refresh_interval_to_i`	Unknown
`show_filters_bar`	Unknown
`show_title`	Unknown
`slug`	Unknown
`text_tile_text_color`	Unknown
`tile_background_color`	Unknown
`tile_text_color`	Unknown
`title`	Unknown
`title_color`	Unknown
`updated_at`	Unknown
`url`	Unknown
`usage_count`	Unknown
`view_count`	Unknown

query

Column	Type	Keys
`id`	Unknown	PK
`column_limit`	Unknown
`dynamic_fields`	Unknown
`fields`	Unknown
`filter_config`	Unknown
`filter_expression`	Unknown
`filters`	Unknown
`model`	Unknown
`pivots`	Unknown
`query_timezone`	Unknown
`row_limit`	Unknown
`slug`	Unknown
`sorts`	Unknown
`url`	Unknown
`view`	Unknown
`vis_config`	Unknown

look

Column	Type	Keys
`id`	Unknown	PK
`content_metadata_id`	Unknown	FK
`creator_id`	Unknown	FK
`deleter_id`	Unknown	FK
`folder_id`	Unknown	FK
`last_updater_id`	Unknown	FK
`parent_id`	Unknown	FK
`user_id`	Unknown	FK
`can_copy`	Unknown
`can_create`	Unknown
`can_destroy`	Unknown
`can_download`	Unknown
`can_download_unlimited`	Unknown
`can_explore`	Unknown
`can_find_and_replace`	Unknown
`can_index`	Unknown
`can_move`	Unknown
`can_recover`	Unknown
`can_render`	Unknown
`can_run`	Unknown
`can_schedule`	Unknown
`can_show`	Unknown
`can_show_errors`	Unknown
`can_update`	Unknown
`certification_notes`	Unknown
`certification_status`	Unknown
`certification_ui_status`	Unknown
`certification_updated_at`	Unknown
`certification_user_name`	Unknown
`content_favorite_id`	Unknown
`created_at`	Unknown
`deleted`	Unknown
`deleted_at`	Unknown
`description`	Unknown
`embed_url`	Unknown
`excel_file_url`	Unknown
`favorite_count`	Unknown
`google_spreadsheet_formula`	Unknown
`image_embed_url`	Unknown
`is_run_on_load`	Unknown
`last_accessed_at`	Unknown
`last_viewed_at`	Unknown
`model_id`	Unknown
`model_label`	Unknown
`public`	Unknown
`public_slug`	Unknown
`public_url`	Unknown
`query_id`	Unknown
`short_url`	Unknown
`title`	Unknown
`updated_at`	Unknown
`view_count`	Unknown

user_looker_version

Column	Type	Keys
`version`	Unknown	PK
`user_id`	Unknown	PKFK

user_group

Column	Type	Keys
`group_id`	Unknown	PKFK
`user_id`	Unknown	PKFK

user_role

Column	Type	Keys
`role_id`	Unknown	PKFK
`user_id`	Unknown	PKFK

user_session

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	PKFK
`sudo_user_id`	Unknown	FK
`browser`	Unknown
`can`	Unknown
`city`	Unknown
`country`	Unknown
`created_at`	Unknown
`credentials_type`	Unknown
`expires_at`	Unknown
`extended_at`	Unknown
`extended_count`	Unknown
`ip_address`	Unknown
`operating_system`	Unknown
`state`	Unknown

user_credential_embed

Column	Type	Keys
`id`	Unknown	PK
`external_group_id`	Unknown	FK
`external_user_id`	Unknown	FK
`user_id`	Unknown	FK
`can`	Unknown
`created_at`	Unknown
`logged_in_at`	Unknown
`type`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`credentials_email_user_id`	Unknown	FK
`embed_group_folder_id`	Unknown	FK
`home_folder_id`	Unknown	FK
`personal_folder_id`	Unknown	FK
`allow_direct_roles`	Unknown
`allow_normal_group_membership`	Unknown
`allow_roles_from_normal_groups`	Unknown
`can_index`	Unknown
`can_index_details`	Unknown
`can_show`	Unknown
`can_show_creds`	Unknown
`can_show_details`	Unknown
`can_sudo`	Unknown
`can_update_creds`	Unknown
`credentials_email_account_setup_url`	Unknown
`credentials_email_created_at`	Unknown
`credentials_email_credentials_ldap`	Unknown
`credentials_email_credentials_looker_openid`	Unknown
`credentials_email_credentials_oidc`	Unknown
`credentials_email_credentials_saml`	Unknown
`credentials_email_credentials_totp`	Unknown
`credentials_email_display_name`	Unknown
`credentials_email_email`	Unknown
`credentials_email_forced_password_reset_at_next_login`	Unknown
`credentials_email_is_disabled`	Unknown
`credentials_email_logged_in_at`	Unknown
`credentials_email_type`	Unknown
`credentials_google`	Unknown
`credentials_ldap`	Unknown
`credentials_looker_openid`	Unknown
`credentials_oidc`	Unknown
`credentials_saml`	Unknown
`credentials_totp`	Unknown
`email`	Unknown
`is_disabled`	Unknown
`locale`	Unknown
`models_dir_validated`	Unknown
`presumed_looker_employee`	Unknown
`roles_externally_managed`	Unknown
`ui_state`	Unknown
`url`	Unknown
`verified_looker_employee`	Unknown

folder

Column	Type	Keys
`id`	Unknown	PK
`content_metadata_id`	Unknown	FK
`creator_id`	Unknown	FK
`parent_id`	Unknown	FK
`can_create`	Unknown
`can_destroy`	Unknown
`can_edit_content`	Unknown
`can_index`	Unknown
`can_move_content`	Unknown
`can_save_shared_space_as_embed_user`	Unknown
`can_see_admin_spaces`	Unknown
`can_show`	Unknown
`can_update`	Unknown
`child_count`	Unknown
`created_at`	Unknown
`external_id`	Unknown
`is_embed`	Unknown
`is_embed_shared_root`	Unknown
`is_embed_users_root`	Unknown
`is_personal`	Unknown
`is_personal_descendant`	Unknown
`is_shared_root`	Unknown
`is_users_root`	Unknown
`name`	Unknown

integration_supported_format

Column	Type	Keys
`supported_format`	Unknown	PK
`integration_id`	Unknown	PKFK

integration_supported_action_type

Column	Type	Keys
`supported_action_type`	Unknown	PK
`integration_id`	Unknown	PKFK

integration_supported_formatting

Column	Type	Keys
`supported_formatting`	Unknown	PK
`integration_id`	Unknown	PKFK

integration_supported_visualization_format

Column	Type	Keys
`supported_visualization_formatting`	Unknown	PK
`integration_id`	Unknown	PKFK

integration_supported_download_setting

Column	Type	Keys
`supported_download_setting`	Unknown	PK
`integration_id`	Unknown	PKFK

integration_param

Column	Type	Keys
`name`	Unknown	PK
`integration_id`	Unknown	PKFK
`delegate_oauth_url`	Unknown
`description`	Unknown
`has_value`	Unknown
`label`	Unknown
`per_user`	Unknown
`required`	Unknown
`sensitive`	Unknown
`value`	Unknown

integration_required_field

Column	Type	Keys
`tags`	Unknown	PK
`integration_id`	Unknown	PKFK
`all_tags`	Unknown
`any_tag`	Unknown

integration

Column	Type	Keys
`id`	Unknown	PK
`integration_hub_id`	Unknown	FK
`can_configure_user_attribute_params`	Unknown
`can_fetch_form`	Unknown
`can_index`	Unknown
`can_send_to`	Unknown
`can_show`	Unknown
`can_show_icon`	Unknown
`can_show_param_values`	Unknown
`can_test`	Unknown
`can_update`	Unknown
`delegate_oauth`	Unknown
`description`	Unknown
`enabled`	Unknown
`icon_url`	Unknown
`installed_delegate_oauth_targets`	Unknown
`label`	Unknown
`privacy_link`	Unknown
`uses_oauth`	Unknown

permission_set_permission

Column	Type	Keys
`permission`	Unknown	PKFK
`permission_set_id`	Unknown	PKFK

permission_set

Column	Type	Keys
`id`	Unknown	PK
`all_access`	Unknown
`built_in`	Unknown
`can_index`	Unknown
`can_show`	Unknown
`can_update`	Unknown
`name`	Unknown
`url`	Unknown

role

Column	Type	Keys
`id`	Unknown	PK
`model_set_id`	Unknown	FK
`permission_set_id`	Unknown	FK
`can_index`	Unknown
`can_show`	Unknown
`can_update`	Unknown
`name`	Unknown

role_group

Column	Type	Keys
`id`	Unknown	PK
`external_group_id`	Unknown	FK
`role_id`	Unknown	FK
`can_add_to_content_metadata`	Unknown
`can_create`	Unknown
`can_delete`	Unknown
`can_edit_in_ui`	Unknown
`can_index`	Unknown
`can_show`	Unknown
`can_update`	Unknown
`contains_current_user`	Unknown
`externally_managed`	Unknown
`include_by_default`	Unknown
`name`	Unknown
`user_count`	Unknown

content_metadata_access

Column	Type	Keys
`id`	Unknown	PK
`content_metadata_id`	Unknown	FK
`group_id`	Unknown	FK
`user_id`	Unknown	FK
`can`	Unknown
`permission_type`	Unknown

lookml_model_explore_dimension

Column	Type	Keys
`_fivetran_id`	String	PK
`lookml_model_explore_detail_lookml_model_name`	Unknown	PKFK
`lookml_model_explore_detail_name`	Unknown	PKFK
`description`	Unknown
`field_kind`	Unknown
`group_label`	Unknown
`hidden`	Unknown
`label`	Unknown
`name`	Unknown
`sql`	Unknown
`tags`	Unknown
`type`	Unknown
`view`	Unknown

lookml_model_explore_measure

Column	Type	Keys
`_fivetran_id`	String	PK
`lookml_model_explore_detail_lookml_model_name`	Unknown	PKFK
`lookml_model_explore_detail_name`	Unknown	PKFK
`description`	Unknown
`field_kind`	Unknown
`group_label`	Unknown
`hidden`	Unknown
`label`	Unknown
`name`	Unknown
`sql`	Unknown
`tags`	Unknown
`type`	Unknown
`view`	Unknown

lookml_model_explore_filter

Column	Type	Keys
`_fivetran_id`	String	PK
`lookml_model_explore_detail_lookml_model_name`	Unknown	PKFK
`lookml_model_explore_detail_name`	Unknown	PKFK
`description`	Unknown
`field_kind`	Unknown
`group_label`	Unknown
`hidden`	Unknown
`label`	Unknown
`name`	Unknown
`sql`	Unknown
`tags`	Unknown
`type`	Unknown
`view`	Unknown

lookml_model_explore_parameter

Column	Type	Keys
`_fivetran_id`	String	PK
`lookml_model_explore_detail_lookml_model_name`	Unknown	PKFK
`lookml_model_explore_detail_name`	Unknown	PKFK
`description`	Unknown
`field_kind`	Unknown
`group_label`	Unknown
`hidden`	Unknown
`label`	Unknown
`name`	Unknown
`sql`	Unknown
`tags`	Unknown
`type`	Unknown
`view`	Unknown

lookml_model_explore_join

Column	Type	Keys
`_fivetran_id`	String	PK
`lookml_model_explore_detail_lookml_model_name`	Unknown	PKFK
`lookml_model_explore_detail_name`	Unknown	PKFK
`name`	Unknown
`relationship`	Unknown
`sql_on`	Unknown
`type`	Unknown

lookml_model_explore_detail

Column	Type	Keys
`name`	Unknown	PK
`lookml_model_explore_name`	Unknown	PKFK
`lookml_model_name`	Unknown	PKFK
`connection_name`	Unknown
`description`	Unknown
`group_label`	Unknown
`hidden`	Unknown
`label`	Unknown
`tags`	Unknown

user_attribute_value

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	PKFK
`can`	Unknown
`hidden_value_domain_whitelist`	Unknown
`label`	Unknown
`name`	Unknown
`rank`	Unknown
`source`	Unknown
`user_can_edit`	Unknown
`value`	Unknown
`value_is_hidden`	Unknown

dashboard_result_filter

Column	Type	Keys
`_fivetran_id`	String	PK
`dashboard_element_id`	Unknown	FK
`listen`	Unknown
`model`	Unknown
`name`	Unknown
`view`	Unknown

dashboard_look_query

Column	Type	Keys
`id`	Unknown	PK
`dashboard_element_id`	Unknown	FK
`analysis_config`	Unknown
`client_id`	Unknown
`column_limit`	Unknown
`dynamic_fields`	Unknown
`fields`	Unknown
`fill_fields`	Unknown
`filter_config`	Unknown
`filter_expression`	Unknown
`filters`	Unknown
`has_table_calculations`	Unknown
`limits`	Unknown
`model`	Unknown
`pivots`	Unknown
`query_timezone`	Unknown
`quick_calcs`	Unknown
`row_total`	Unknown
`slug`	Unknown
`sorts`	Unknown
`sub_totals`	Unknown
`total`	Unknown
`view`	Unknown
`visible_ui_sections`	Unknown

dashboard_element

Column	Type	Keys
`id`	Unknown	PK
`dashboard_id`	Unknown	FK
`look_id`	Unknown	FK
`query_id`	Unknown	FK
`alert_count`	Unknown
`aria_description`	Unknown
`body_text`	Unknown
`can_create`	Unknown
`can_destroy`	Unknown
`can_explore`	Unknown
`can_find_and_replace`	Unknown
`can_index`	Unknown
`can_run`	Unknown
`can_see_aggregate_table_lookml`	Unknown
`can_show`	Unknown
`can_show_errors`	Unknown
`can_update`	Unknown
`certification_notes`	Unknown
`certification_status`	Unknown
`certification_ui_status`	Unknown
`certification_updated_at`	Unknown
`certification_user_name`	Unknown
`extension_id`	Unknown
`filter_id`	Unknown
`look_vis_config_conditional_formatting_ignored_fields`	Unknown
`look_vis_config_conditional_formatting_include_nulls`	Unknown
`look_vis_config_conditional_formatting_include_totals`	Unknown
`look_vis_config_enable_conditional_formatting`	Unknown
`look_vis_config_hide_row_totals`	Unknown
`look_vis_config_hide_totals`	Unknown
`look_vis_config_label_density`	Unknown
`look_vis_config_legend_position`	Unknown
`look_vis_config_limit_displayed_rows`	Unknown
`look_vis_config_ordering`	Unknown
`look_vis_config_series_types`	Unknown
`look_vis_config_show_null_labels`	Unknown
`look_vis_config_show_row_numbers`	Unknown
`look_vis_config_show_silhouette`	Unknown
`look_vis_config_show_totals_labels`	Unknown
`look_vis_config_show_value_labels`	Unknown
`look_vis_config_show_view_names`	Unknown
`look_vis_config_show_x_axis_label`	Unknown
`look_vis_config_show_x_axis_ticks`	Unknown
`look_vis_config_show_y_axis_labels`	Unknown
`look_vis_config_show_y_axis_ticks`	Unknown
`look_vis_config_stacking`	Unknown
`look_vis_config_table_theme`	Unknown
`look_vis_config_totals_color`	Unknown
`look_vis_config_truncate_column_names`	Unknown
`look_vis_config_type`	Unknown
`look_vis_config_x_axis_gridlines`	Unknown
`look_vis_config_x_axis_scale`	Unknown
`look_vis_config_y_axis_combined`	Unknown
`look_vis_config_y_axis_gridlines`	Unknown
`look_vis_config_y_axis_scale_mode`	Unknown
`look_vis_config_y_axis_tick_density`	Unknown
`look_vis_config_y_axis_tick_density_custom`	Unknown
`lookml_link_id`	Unknown
`merge_result_id`	Unknown
`note_display`	Unknown
`note_state`	Unknown
`note_text`	Unknown
`refresh_interval`	Unknown
`refresh_interval_to_i`	Unknown
`result_maker_dynamic_fields`	Unknown
`result_maker_id`	Unknown
`result_maker_merge_result_id`	Unknown
`result_maker_query_id`	Unknown
`result_maker_sorts`	Unknown
`result_maker_sql_query_id`	Unknown
`result_maker_total`	Unknown
`rich_content_json`	Unknown
`subtitle_text`	Unknown
`subtitle_text_as_html`	Unknown
`title`	Unknown
`title_hidden`	Unknown
`title_text`	Unknown
`title_text_as_html`	Unknown
`type`	Unknown

datagroup

Column	Type	Keys
`id`	Unknown	PK
`can_index`	Unknown
`can_show`	Unknown
`can_update`	Unknown
`created_at`	Unknown
`name`	Unknown
`stale_before`	Unknown
`trigger_check_at`	Unknown
`trigger_error`	Unknown
`trigger_value`	Unknown
`triggered_at`	Unknown

content_metadata

Column	Type	Keys
`id`	Unknown	PK
`dashboard_id`	Unknown	FK
`folder_id`	Unknown	FK
`inheriting_id`	Unknown	FK
`look_id`	Unknown	FK
`parent_id`	Unknown	FK
`agent_id`	Unknown
`can`	Unknown
`content_type`	Unknown
`inherits`	Unknown
`name`	Unknown
`slug`	Unknown

user_login_lockout

Column	Type	Keys
`_fivetran_id`	String	PK
`user_id`	Unknown	FK
`auth_type`	Unknown
`can`	Json
`email`	Unknown
`fail_count`	Unknown
`ip`	Unknown
`key`	Unknown
`lockout_at`	Unknown
`remote_id`	Unknown

model_set_model

Column	Type	Keys
`model`	Unknown	PK
`model_set_id`	Unknown	PKFK

model_set

Column	Type	Keys
`id`	Unknown	PK
`all_access`	Unknown
`built_in`	Unknown
`can_index`	Unknown
`can_show`	Unknown
`can_update`	Unknown
`name`	Unknown

dashboard_filter

Column	Type	Keys
`id`	Unknown	PK
`dashboard_id`	Unknown	FK
`allow_multiple_values`	Unknown
`can_create`	Unknown
`can_destroy`	Unknown
`can_show`	Unknown
`can_update`	Unknown
`default_value`	Unknown
`dimension`	Unknown
`explore`	Unknown
`filter_row`	Unknown
`listens_to_filters`	Unknown
`model`	Unknown
`name`	Unknown
`required`	Unknown
`title`	Unknown
`type`	Unknown
`ui_config`	Unknown

homepage_item

Column	Type	Keys
`id`	Unknown	PK
`content_created_by`	Unknown	FK
`content_metadata_id`	Unknown	FK
`dashboard_id`	Unknown	FK
`homepage_section_id`	Unknown	FK
`look_id`	Unknown	FK
`content_favorite_id`	Unknown
`content_updated_at`	Unknown
`custom_description`	Unknown
`custom_image_data_base_64`	Unknown
`custom_title`	Unknown
`description`	Unknown
`favourite_content`	Unknown
`location`	Unknown
`lookml_dasboard_id`	Unknown
`orders`	Unknown
`section_fetch_time`	Unknown
`title`	Unknown
`use_custom_description`	Unknown
`use_custom_image`	Unknown
`use_custom_title`	Unknown
`view_count`	Unknown

homepage_section

Column	Type	Keys
`id`	Unknown	PK
`homepage_id`	Unknown	FK
`can_create`	Unknown
`can_destroy`	Unknown
`can_index`	Unknown
`can_show`	Unknown
`can_update`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`description`	Unknown
`detail_url`	Unknown
`is_header`	Unknown
`item_order`	Unknown
`title`	Unknown
`updated_at`	Unknown
`visible_item_order`	Unknown

groups

Column	Type	Keys
`id`	Unknown	PK
`external_group_id`	Unknown	FK
`can_add_to_content_metadata`	Unknown
`can_create`	Unknown
`can_delete`	Unknown
`can_edit_in_ui`	Unknown
`can_index`	Unknown
`can_show`	Unknown
`can_update`	Unknown
`contains_current_user`	Unknown
`externally_managed`	Unknown
`include_by_default`	Unknown
`name`	Unknown
`user_count`	Unknown

git_branch

Column	Type	Keys
`_fivetran_id`	String	PK
`project_id`	Unknown	FK
`ahead_count`	Unknown
`behind_count`	Unknown
`can`	Unknown
`commit_at`	Unknown
`error`	Unknown
`is_local`	Unknown
`is_production`	Unknown
`is_remote`	Unknown
`message`	Unknown
`name`	Unknown
`owner_name`	Unknown
`personal`	Unknown
`readonly`	Unknown
`ref`	Unknown
`remote`	Unknown
`remote_name`	Unknown
`remote_ref`	Unknown

permission

Column	Type	Keys
`permission`	Unknown	PK
`parent`	Unknown	FK
`can`	Unknown
`description`	Unknown

lookml_model_explore

Column	Type	Keys
`name`	Unknown	PK
`lookml_model_name`	Unknown	PKFK
`description`	Unknown
`group_label`	Unknown
`hidden`	Unknown
`label`	Unknown

lookml_model

Column	Type	Keys
`name`	Unknown	PK
`project_name`	Unknown	FK
`allowed_db_connection_names`	Unknown
`can_create`	Unknown
`can_destroy`	Unknown
`can_index`	Unknown
`can_show`	Unknown
`can_update`	Unknown
`explores`	Unknown
`has_content`	Unknown
`label`	Unknown
`unlimited_db_connections`	Unknown

board_item

Column	Type	Keys
`id`	Unknown	PK
`board_section_id`	Unknown	FK
`content_metadata_id`	Unknown	FK
`dashboard_id`	Unknown	FK
`look_id`	Unknown	FK
`board_order`	Unknown
`can_create`	Unknown
`can_destroy`	Unknown
`can_show`	Unknown
`can_update`	Unknown
`content_created_by`	Unknown
`content_favorite_id`	Unknown
`content_updated_at`	Unknown
`custom_description`	Unknown
`custom_image_url`	Unknown
`custom_title`	Unknown
`custom_url`	Unknown
`description`	Unknown
`favorite_count`	Unknown
`image_url`	Unknown
`location`	Unknown
`lookml_dashboard_id`	Unknown
`title`	Unknown
`url`	Unknown
`use_custom_description`	Unknown
`use_custom_image`	Unknown
`use_custom_title`	Unknown
`use_custom_url`	Unknown
`view_count`	Unknown

board_section

Column	Type	Keys
`id`	Unknown	PK
`board_id`	Unknown	FK
`can_create`	Unknown
`can_destroy`	Unknown
`can_show`	Unknown
`can_update`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`description`	Unknown
`item_order`	Unknown
`title`	Unknown
`updated_at`	Unknown
`visible_item_order`	Unknown

board

Column	Type	Keys
`id`	Unknown	PK
`content_metadata_id`	Unknown	FK
`user_id`	Unknown	FK
`can_create`	Unknown
`can_destroy`	Unknown
`can_show`	Unknown
`can_update`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`description`	Unknown
`primary_homepage`	Unknown
`section_order`	Unknown
`title`	Unknown
`updated_at`	Unknown