# Looker schema ERD

Table and field reference for the Fivetran Looker connector.

## Table & Field Reference

### workspace_project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |

### 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 | PK, FK |
| dashboard_layout_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |

### user_group

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| role_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### user_session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |

### integration_supported_action_type

| Column | Type | Keys |
| --- | --- | --- |
| supported_action_type | Unknown | PK |
| integration_id | Unknown | PK, FK |

### integration_supported_formatting

| Column | Type | Keys |
| --- | --- | --- |
| supported_formatting | Unknown | PK |
| integration_id | Unknown | PK, FK |

### integration_supported_visualization_format

| Column | Type | Keys |
| --- | --- | --- |
| supported_visualization_formatting | Unknown | PK |
| integration_id | Unknown | PK, FK |

### integration_supported_download_setting

| Column | Type | Keys |
| --- | --- | --- |
| supported_download_setting | Unknown | PK |
| integration_id | Unknown | PK, FK |

### integration_param

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| integration_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| permission_set_id | Unknown | PK, FK |

### 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 | PK, FK |
| lookml_model_explore_detail_name | Unknown | PK, FK |
| 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 | PK, FK |
| lookml_model_explore_detail_name | Unknown | PK, FK |
| 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 | PK, FK |
| lookml_model_explore_detail_name | Unknown | PK, FK |
| 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 | PK, FK |
| lookml_model_explore_detail_name | Unknown | PK, FK |
| 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 | PK, FK |
| lookml_model_explore_detail_name | Unknown | PK, FK |
| name | Unknown |  |
| relationship | Unknown |  |
| sql_on | Unknown |  |
| type | Unknown |  |

### lookml_model_explore_detail

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| lookml_model_explore_name | Unknown | PK, FK |
| lookml_model_name | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |
| 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 |  |

## Relationships

- workspace_project(id) → project(id)
- workspace_project(workspace_id) → workspace(id)
- dashboard_layout_component(dashboard_element_id) → dashboard_element(id)
- dashboard_layout_component(dashboard_layout_dashboard_id) → dashboard_layout(dashboard_id)
- dashboard_layout_component(dashboard_layout_id) → dashboard_layout(id)
- dashboard_layout(dashboard_id) → dashboard(id)
- connection_snippet(connection_name) → connection(name)
- dialect_connection_test(connection_name) → connection(name)
- connection(user_id) → users(id)
- user_attribute_group_value(group_id) → groups(id)
- user_attribute_group_value(user_attribute_id) → user_attribute_value(id)
- dashboard(user_id) → users(id)
- dashboard(folder_id) → folder(id)
- dashboard(deleter_id) → users(id)
- dashboard(last_updater_id) → users(id)
- dashboard(content_metadata_id) → content_metadata(id)
- dashboard(model_id) → look(model_id)
- look(user_id) → users(id)
- look(folder_id) → folder(id)
- look(deleter_id) → users(id)
- look(last_updater_id) → users(id)
- look(parent_id) → look(id)
- look(creator_id) → users(id)
- look(content_metadata_id) → content_metadata(id)
- user_looker_version(user_id) → users(id)
- user_group(group_id) → groups(id)
- user_group(user_id) → users(id)
- user_role(role_id) → role(id)
- user_role(user_id) → users(id)
- user_session(sudo_user_id) → users(id)
- user_session(user_id) → users(id)
- user_credential_embed(external_group_id) → groups(id)
- user_credential_embed(external_user_id) → users(id)
- user_credential_embed(user_id) → users(id)
- users(personal_folder_id) → folder(id)
- users(home_folder_id) → folder(id)
- users(embed_group_folder_id) → folder(id)
- users(credentials_email_user_id) → users(id)
- folder(parent_id) → folder(id)
- folder(creator_id) → users(id)
- folder(content_metadata_id) → content_metadata(id)
- integration_supported_format(integration_id) → integration(id)
- integration_supported_action_type(integration_id) → integration(id)
- integration_supported_formatting(integration_id) → integration(id)
- integration_supported_visualization_format(integration_id) → integration(id)
- integration_supported_download_setting(integration_id) → integration(id)
- integration_param(integration_id) → integration(id)
- integration_required_field(integration_id) → integration(id)
- integration(integration_hub_id) → integration_hub(id)
- permission_set_permission(permission) → permission(permission)
- permission_set_permission(permission_set_id) → permission_set(id)
- role(permission_set_id) → permission_set(id)
- role(model_set_id) → model_set(id)
- role_group(external_group_id) → groups(id)
- role_group(role_id) → role(id)
- content_metadata_access(content_metadata_id) → content_metadata(id)
- content_metadata_access(group_id) → groups(id)
- content_metadata_access(user_id) → users(id)
- lookml_model_explore_dimension(lookml_model_explore_detail_name) → lookml_model_explore_detail(name)
- lookml_model_explore_dimension(lookml_model_explore_detail_lookml_model_name) → lookml_model_explore_detail(lookml_model_name)
- lookml_model_explore_measure(lookml_model_explore_detail_name) → lookml_model_explore_detail(name)
- lookml_model_explore_measure(lookml_model_explore_detail_lookml_model_name) → lookml_model_explore_detail(lookml_model_name)
- lookml_model_explore_filter(lookml_model_explore_detail_name) → lookml_model_explore_detail(name)
- lookml_model_explore_filter(lookml_model_explore_detail_lookml_model_name) → lookml_model_explore_detail(lookml_model_name)
- lookml_model_explore_parameter(lookml_model_explore_detail_name) → lookml_model_explore_detail(name)
- lookml_model_explore_parameter(lookml_model_explore_detail_lookml_model_name) → lookml_model_explore_detail(lookml_model_name)
- lookml_model_explore_join(lookml_model_explore_detail_name) → lookml_model_explore_detail(name)
- lookml_model_explore_join(lookml_model_explore_detail_lookml_model_name) → lookml_model_explore_detail(lookml_model_name)
- lookml_model_explore_detail(lookml_model_name) → lookml_model(name)
- lookml_model_explore_detail(lookml_model_explore_name) → lookml_model_explore(name)
- user_attribute_value(user_id) → users(id)
- dashboard_result_filter(dashboard_element_id) → dashboard_element(id)
- dashboard_look_query(dashboard_element_id) → dashboard_element(id)
- dashboard_element(query_id) → look(query_id)
- dashboard_element(look_id) → look(id)
- dashboard_element(dashboard_id) → dashboard(id)
- content_metadata(folder_id) → folder(id)
- content_metadata(look_id) → look(id)
- content_metadata(parent_id) → content_metadata(id)
- content_metadata(inheriting_id) → content_metadata(id)
- content_metadata(dashboard_id) → dashboard(id)
- user_login_lockout(user_id) → users(id)
- model_set_model(model_set_id) → model_set(id)
- dashboard_filter(dashboard_id) → dashboard(id)
- homepage_item(homepage_section_id) → homepage_section(id)
- homepage_item(content_created_by) → users(id)
- homepage_item(look_id) → look(id)
- homepage_item(content_metadata_id) → content_metadata(id)
- homepage_item(dashboard_id) → dashboard(id)
- homepage_section(homepage_id) → homepage_section(id)
- groups(external_group_id) → groups(id)
- git_branch(project_id) → project(id)
- permission(parent) → permission(permission)
- lookml_model_explore(lookml_model_name) → lookml_model(name)
- lookml_model(project_name) → project(id)
- board_item(board_section_id) → board_section(id)
- board_item(look_id) → look(id)
- board_item(content_metadata_id) → content_metadata(id)
- board_item(dashboard_id) → dashboard(id)
- board_section(board_id) → board(id)
- board(user_id) → users(id)
- board(content_metadata_id) → content_metadata(id)