# Looker
Looker is an enterprise platform for BI, data applications, and embedded analytics that helps organizations explore and share insights in real time.
Looker integration replicates data using the [Looker v4 API](https://developers.looker.com/api/explorer/4.0).
See the [Schema](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#Schema) section for a list of objects available for replication.
## Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
Information noteMake sure that the account you use has read access to the tables you want to fetch.
You need administrator permissions in your Looker account.
To retrieve your client ID and client secret:
1. Log into your [Looker](https://lookerstudio.google.com/overview) account.
2. Navigate to Edit Users > Edit Keys.
3. On the Edit User API3 Keys page, click New API3 key.
4. Copy and paste your client ID and client secret into a secured file.
## Creating the connection
For more information, see [Connecting to SaaS applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Landing/connecting-web-applications.htm).
1. Fill in the required connection properties.
2. Provide a name for the connection in Connection name.
3. Select Open connection metadata to define metadata for the connection when it has been created.
4. Click Create.
Connection settings
| Setting | Description |
| --- | --- |
| Data gateway | Select a Data Movement gateway if required by your use case.
Information note
This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None.
For information on the benefits of Data Movement gateway and use cases that require it, see [Qlik Data Gateway - Data Movement](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/replication-gateway.htm). |
| Start Date | Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target. |
| API Port | The API port is typically `19999`. If you host the API internally, use the internal API port instead. |
| Client ID | Client ID. |
| Client Secret | Client secret. |
| Subdomain | You can find your subdomain in your Looker URL. If the URL is https://demo.cloud.looker.com/folders/home, the subdomain is demo. |
| Domain | You can find your domain in your Looker URL. If the URL is https://demo.cloud.looker.com/folders/home, the domain is looker.com, unless you use a custom domain. |
## Schema
Information note
Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
Depending on your destination, table and column names may not appear as they are outlined below.
### color\_collections
The `color_collections` table contains information about color collections in your Looker account.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/color-collection#get_all_color_collections "Opens in new tab: Looker API method") |
color\_collections table foreign keys
| Join color\_collections with | on |
| --- | --- |
| [themes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#themes) | ```
color_collections.id = themes.settings.color_collection_id
``` |
color\_collections table schema
| **categoricalPalettes**
ARRAY
This is a nested data structure:
- colors: ARRAY, which is also a nested data structure.
- id: STRING
- label: STRING
- type: STRING
|
| --- |
| **divergingPalettes**
ARRAY
This is a nested data structure:
- id: STRING
- label: STRING
- stops: ARRAY, which is also a nested data structure.
- color: STRING
- offset: NUMBER
- type: STRING
|
| **id**
STRING |
| **label**
STRING |
| **sequentialPalettes**
ARRAY
This is a nested data structure:
- id: STRING
- label: STRING
- stops: ARRAY, which is also a nested data structure.
- color: STRING
- offset: NUMBER
- type: STRING
|
### connections
The `connections` table contains information about connections in your Looker account.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | name |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/connection#get_all_connections "Opens in new tab: Looker API method") |
connections table foreign keys
| Join connections with | on |
| --- | --- |
| [content_favorites](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-favorites) | ```
connections.user_id = content_favorites.dashboard.folder.creator_id
```
```
connections.user_id = content_favorites.dashboard.space.creator_id
```
```
connections.user_id = content_favorites.user_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
connections.user_id = content_views.user_id
``` |
| [dashboard_elements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-elements) | ```
connections.user_id = dashboard_elements.look.deleter_id
```
```
connections.user_id = dashboard_elements.look.folder.creator_id
```
```
connections.user_id = dashboard_elements.look.last_updater_id
```
```
connections.user_id = dashboard_elements.look.space.creator_id
```
```
connections.user_id = dashboard_elements.look.user.id
```
```
connections.user_id = dashboard_elements.look.user_id
``` |
| [dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboards) | ```
connections.user_id = dashboards.space.creator_id
```
```
connections.user_id = dashboards.user_id
``` |
| [folders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#folders) | ```
connections.user_id = folders.creator_id
```
```
connections.user_id = folders.dashboards.user_id
```
```
connections.user_id = folders.dashboards.folder.creator_id
```
```
connections.user_id = folders.dashboards.space.creator_id
```
```
connections.user_id = folders.looks.deleter_id
```
```
connections.user_id = folders.looks.last_updater_id
```
```
connections.user_id = folders.looks.user.id
``` |
| [lookml_dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#lookml-dashboards) | ```
connections.user_id = lookml_dashboards.folder.creator_id
```
```
connections.user_id = lookml_dashboards.space.creator_id
```
```
connections.user_id = lookml_dashboards.user_id
``` |
| [looks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#looks) | ```
connections.user_id = looks.deleter_id
```
```
connections.user_id = looks.folder.creator_id
```
```
connections.user_id = looks.user.id
```
```
connections.user_id = looks.user_id
``` |
| [scheduled_plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#scheduled-plans) | ```
connections.user_id = scheduled_plans.user.id
```
```
connections.user_id = scheduled_plans.user_id
``` |
| [user_login_lockouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-login-lockouts) | ```
connections.user_id = user_login_lockouts.user_id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
connections.user_id = users.id
``` |
connections table schema
| **after\_connect\_statements**
STRING |
| --- |
| **certificate**
STRING |
| **created\_at**
STRING |
| **database**
STRING |
| **db\_timezone**
STRING |
| **dialect**
OBJECT
This is a nested data structure:
- automatically_run_sql_runner_snippets: BOOLEAN
- connection_tests: ARRAY, which is also a nested data structure.
- label: STRING
- name: STRING
- persistent_table_distkey: STRING
- persistent_table_indexes: STRING
- persistent_table_sortkeys: STRING
- supports_cost_estimate: BOOLEAN
- supports_inducer: BOOLEAN
- supports_streaming: BOOLEAN
- supports_upload_tables: BOOLEAN
|
| **dialect\_name**
STRING |
| **example**
BOOLEAN |
| **file\_type**
STRING |
| **host**
STRING |
| **jdbc\_additional\_params**
STRING |
| **last\_reap\_at**
INTEGER |
| **last\_regen\_at**
INTEGER |
| **maintenance\_cron**
STRING |
| **max\_billing\_gigabytes**
NUMBER |
| **max\_connections**
INTEGER |
| **name**
STRING |
| **password**
STRING |
| **pdt\_context\_override**
OBJECT
This is a nested data structure:
- after_connect_statements: STRING
- certificate: STRING
- context: STRING
- database: STRING
- file_type: STRING
- has_password: BOOLEAN
- host: STRING
- jdbc_additional_params: STRING
- password: STRING
- port: STRING
- schema: STRING
- username: STRING
|
| **pool\_timeout**
INTEGER |
| **port**
STRING |
| **query\_timezone**
STRING |
| **schema**
STRING |
| **snippets**
ARRAY
This is a nested data structure:
- label: STRING
- name: STRING
- sql: STRING
|
| **sql\_runner\_precache\_tables**
BOOLEAN |
| **ssl**
BOOLEAN |
| **tmp\_db\_name**
STRING |
| **user\_attribute\_fields**
ARRAY
This is a nested data structure. |
| **user\_db\_credentials**
BOOLEAN |
| **user\_id**
STRING |
| **username**
STRING |
| **uses\_oauth**
BOOLEAN |
| **verify\_ssl**
BOOLEAN |
### content\_favorites
The `content_favorites` table contains info about users’ favorite content in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/content#search_favorite_contents "Opens in new tab: Looker API method") |
content\_favorites table foreign keys
| Join content\_favorites with | on |
| --- | --- |
| [dashboard_elements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-elements) | ```
content_favorites.id = dashboard_elements.look.content_favorite_id
```
```
content_favorites.dashboard.content_favorite_id = dashboard_elements.look.content_favorite_id
```
```
content_favorites.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
content_favorites.dashboard.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
content_favorites.dashboard.folder.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
content_favorites.dashboard.space.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
content_favorites.look.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
content_favorites.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
content_favorites.dashboard.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
content_favorites.dashboard.folder.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
content_favorites.dashboard.space.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
content_favorites.look.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
content_favorites.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
content_favorites.dashboard.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
content_favorites.dashboard.folder.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
content_favorites.dashboard.space.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
content_favorites.look.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
content_favorites.dashboard.id = dashboard_elements.dashboard_id
```
```
content_favorites.dashboard_id = dashboard_elements.dashboard_id
```
```
content_favorites.dashboard.folder.id = dashboard_elements.look.folder.id
```
```
content_favorites.dashboard.folder.parent_id = dashboard_elements.look.folder.id
```
```
content_favorites.dashboard.folder.id = dashboard_elements.look.folder.parent_id
```
```
content_favorites.dashboard.folder.parent_id = dashboard_elements.look.folder.parent_id
```
```
content_favorites.dashboard.folder.id = dashboard_elements.look.folder_id
```
```
content_favorites.dashboard.folder.parent_id = dashboard_elements.look.folder_id
```
```
content_favorites.look_id = dashboard_elements.look.id
```
```
content_favorites.look.id = dashboard_elements.look.id
```
```
content_favorites.look_id = dashboard_elements.look_id
```
```
content_favorites.look.id = dashboard_elements.look_id
```
```
content_favorites.dashboard.model.id = dashboard_elements.look.model.id
```
```
content_favorites.dashboard.space.id = dashboard_elements.look.space.id
```
```
content_favorites.dashboard.space.parent_id = dashboard_elements.look.space.id
```
```
content_favorites.dashboard.space.id = dashboard_elements.look.space.parent_id
```
```
content_favorites.dashboard.space.parent_id = dashboard_elements.look.space.parent_id
```
```
content_favorites.dashboard.folder.creator_id = dashboard_elements.look.deleter_id
```
```
content_favorites.dashboard.space.creator_id = dashboard_elements.look.deleter_id
```
```
content_favorites.user_id = dashboard_elements.look.deleter_id
```
```
content_favorites.dashboard.folder.creator_id = dashboard_elements.look.folder.creator_id
```
```
content_favorites.dashboard.space.creator_id = dashboard_elements.look.folder.creator_id
```
```
content_favorites.user_id = dashboard_elements.look.folder.creator_id
```
```
content_favorites.dashboard.folder.creator_id = dashboard_elements.look.last_updater_id
```
```
content_favorites.dashboard.space.creator_id = dashboard_elements.look.last_updater_id
```
```
content_favorites.user_id = dashboard_elements.look.last_updater_id
```
```
content_favorites.dashboard.folder.creator_id = dashboard_elements.look.space.creator_id
```
```
content_favorites.dashboard.space.creator_id = dashboard_elements.look.space.creator_id
```
```
content_favorites.user_id = dashboard_elements.look.space.creator_id
```
```
content_favorites.dashboard.folder.creator_id = dashboard_elements.look.user.id
```
```
content_favorites.dashboard.space.creator_id = dashboard_elements.look.user.id
```
```
content_favorites.user_id = dashboard_elements.look.user.id
```
```
content_favorites.dashboard.folder.creator_id = dashboard_elements.look.user_id
```
```
content_favorites.dashboard.space.creator_id = dashboard_elements.look.user_id
```
```
content_favorites.user_id = dashboard_elements.look.user_id
``` |
| [dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboards) | ```
content_favorites.id = dashboards.content_favorite_id
```
```
content_favorites.dashboard.content_favorite_id = dashboards.content_favorite_id
```
```
content_favorites.content_metadata_id = dashboards.content_metadata_id
```
```
content_favorites.dashboard.content_metadata_id = dashboards.content_metadata_id
```
```
content_favorites.dashboard.folder.content_metadata_id = dashboards.content_metadata_id
```
```
content_favorites.dashboard.space.content_metadata_id = dashboards.content_metadata_id
```
```
content_favorites.look.content_metadata_id = dashboards.content_metadata_id
```
```
content_favorites.content_metadata_id = dashboards.folder.content_metadata_id
```
```
content_favorites.dashboard.content_metadata_id = dashboards.folder.content_metadata_id
```
```
content_favorites.dashboard.folder.content_metadata_id = dashboards.folder.content_metadata_id
```
```
content_favorites.dashboard.space.content_metadata_id = dashboards.folder.content_metadata_id
```
```
content_favorites.look.content_metadata_id = dashboards.folder.content_metadata_id
```
```
content_favorites.content_metadata_id = dashboards.space.content_metadata_id
```
```
content_favorites.dashboard.content_metadata_id = dashboards.space.content_metadata_id
```
```
content_favorites.dashboard.folder.content_metadata_id = dashboards.space.content_metadata_id
```
```
content_favorites.dashboard.space.content_metadata_id = dashboards.space.content_metadata_id
```
```
content_favorites.look.content_metadata_id = dashboards.space.content_metadata_id
```
```
content_favorites.dashboard.id = dashboards.id
```
```
content_favorites.dashboard_id = dashboards.id
```
```
content_favorites.dashboard.folder.id = dashboards.folder.id
```
```
content_favorites.dashboard.folder.parent_id = dashboards.folder.id
```
```
content_favorites.dashboard.folder.id = dashboards.folder.parent_id
```
```
content_favorites.dashboard.folder.parent_id = dashboards.folder.parent_id
```
```
content_favorites.dashboard.model.id = dashboards.model.id
```
```
content_favorites.dashboard.space.id = dashboards.space.id
```
```
content_favorites.dashboard.space.parent_id = dashboards.space.id
```
```
content_favorites.dashboard.space.id = dashboards.space.parent_id
```
```
content_favorites.dashboard.space.parent_id = dashboards.space.parent_id
```
```
content_favorites.dashboard.folder.creator_id = dashboards.space.creator_id
```
```
content_favorites.dashboard.space.creator_id = dashboards.space.creator_id
```
```
content_favorites.user_id = dashboards.space.creator_id
```
```
content_favorites.dashboard.folder.creator_id = dashboards.user_id
```
```
content_favorites.dashboard.space.creator_id = dashboards.user_id
```
```
content_favorites.user_id = dashboards.user_id
``` |
| [folders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#folders) | ```
content_favorites.id = folders.dashboards.content_favorite_id
```
```
content_favorites.dashboard.content_favorite_id = folders.dashboards.content_favorite_id
```
```
content_favorites.id = folders.looks.content_favorite_id
```
```
content_favorites.dashboard.content_favorite_id = folders.looks.content_favorite_id
```
```
content_favorites.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
content_favorites.dashboard.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
content_favorites.dashboard.folder.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
content_favorites.dashboard.space.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
content_favorites.look.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
content_favorites.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
content_favorites.dashboard.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
content_favorites.dashboard.folder.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
content_favorites.dashboard.space.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
content_favorites.look.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
content_favorites.content_metadata_id = folders.looks.content_metadata_id
```
```
content_favorites.dashboard.content_metadata_id = folders.looks.content_metadata_id
```
```
content_favorites.dashboard.folder.content_metadata_id = folders.looks.content_metadata_id
```
```
content_favorites.dashboard.space.content_metadata_id = folders.looks.content_metadata_id
```
```
content_favorites.look.content_metadata_id = folders.looks.content_metadata_id
```
```
content_favorites.content_metadata_id = folders.looks.folder.content_metadata_id
```
```
content_favorites.dashboard.content_metadata_id = folders.looks.folder.content_metadata_id
```
```
content_favorites.dashboard.folder.content_metadata_id = folders.looks.folder.content_metadata_id
```
```
content_favorites.dashboard.space.content_metadata_id = folders.looks.folder.content_metadata_id
```
```
content_favorites.look.content_metadata_id = folders.looks.folder.content_metadata_id
```
```
content_favorites.dashboard.id = folders.dashboards.id
```
```
content_favorites.dashboard_id = folders.dashboards.id
```
```
content_favorites.dashboard.folder.id = folders.id
```
```
content_favorites.dashboard.folder.parent_id = folders.id
```
```
content_favorites.dashboard.folder.id = folders.dashboards.folder.id
```
```
content_favorites.dashboard.folder.parent_id = folders.dashboards.folder.id
```
```
content_favorites.dashboard.folder.id = folders.dashboards.folder.parent_id
```
```
content_favorites.dashboard.folder.parent_id = folders.dashboards.folder.parent_id
```
```
content_favorites.dashboard.folder.id = folders.looks.folder.id
```
```
content_favorites.dashboard.folder.parent_id = folders.looks.folder.id
```
```
content_favorites.dashboard.folder.id = folders.looks.folder.parent_id
```
```
content_favorites.dashboard.folder.parent_id = folders.looks.folder.parent_id
```
```
content_favorites.dashboard.folder.id = folders.parent_id
```
```
content_favorites.dashboard.folder.parent_id = folders.parent_id
```
```
content_favorites.look_id = folders.looks.id
```
```
content_favorites.look.id = folders.looks.id
```
```
content_favorites.dashboard.model.id = folders.dashboards.model.id
```
```
content_favorites.dashboard.model.id = folders.looks.model.id
```
```
content_favorites.dashboard.space.id = folders.dashboards.space.id
```
```
content_favorites.dashboard.space.parent_id = folders.dashboards.space.id
```
```
content_favorites.dashboard.space.id = folders.dashboards.space.parent_id
```
```
content_favorites.dashboard.space.parent_id = folders.dashboards.space.parent_id
```
```
content_favorites.dashboard.space.id = folders.looks.space.id
```
```
content_favorites.dashboard.space.parent_id = folders.looks.space.id
```
```
content_favorites.dashboard.space.id = folders.looks.space.parent_id
```
```
content_favorites.dashboard.space.parent_id = folders.looks.space.parent_id
```
```
content_favorites.dashboard.space.id = folders.looks.space_id
```
```
content_favorites.dashboard.space.parent_id = folders.looks.space_id
```
```
content_favorites.dashboard.folder.creator_id = folders.creator_id
```
```
content_favorites.dashboard.space.creator_id = folders.creator_id
```
```
content_favorites.user_id = folders.creator_id
```
```
content_favorites.dashboard.folder.creator_id = folders.dashboards.user_id
```
```
content_favorites.dashboard.space.creator_id = folders.dashboards.user_id
```
```
content_favorites.user_id = folders.dashboards.user_id
```
```
content_favorites.dashboard.folder.creator_id = folders.dashboards.folder.creator_id
```
```
content_favorites.dashboard.space.creator_id = folders.dashboards.folder.creator_id
```
```
content_favorites.user_id = folders.dashboards.folder.creator_id
```
```
content_favorites.dashboard.folder.creator_id = folders.dashboards.space.creator_id
```
```
content_favorites.dashboard.space.creator_id = folders.dashboards.space.creator_id
```
```
content_favorites.user_id = folders.dashboards.space.creator_id
```
```
content_favorites.dashboard.folder.creator_id = folders.looks.deleter_id
```
```
content_favorites.dashboard.space.creator_id = folders.looks.deleter_id
```
```
content_favorites.user_id = folders.looks.deleter_id
```
```
content_favorites.dashboard.folder.creator_id = folders.looks.last_updater_id
```
```
content_favorites.dashboard.space.creator_id = folders.looks.last_updater_id
```
```
content_favorites.user_id = folders.looks.last_updater_id
```
```
content_favorites.dashboard.folder.creator_id = folders.looks.user.id
```
```
content_favorites.dashboard.space.creator_id = folders.looks.user.id
```
```
content_favorites.user_id = folders.looks.user.id
``` |
| [lookml_dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#lookml-dashboards) | ```
content_favorites.id = lookml_dashboards.content_favorite_id
```
```
content_favorites.dashboard.content_favorite_id = lookml_dashboards.content_favorite_id
```
```
content_favorites.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
content_favorites.dashboard.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
content_favorites.dashboard.folder.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
content_favorites.dashboard.space.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
content_favorites.look.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
content_favorites.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
content_favorites.dashboard.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
content_favorites.dashboard.folder.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
content_favorites.dashboard.space.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
content_favorites.look.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
content_favorites.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
content_favorites.dashboard.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
content_favorites.dashboard.folder.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
content_favorites.dashboard.space.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
content_favorites.look.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
content_favorites.dashboard.folder.id = lookml_dashboards.folder.id
```
```
content_favorites.dashboard.folder.parent_id = lookml_dashboards.folder.id
```
```
content_favorites.dashboard.folder.id = lookml_dashboards.folder.parent_id
```
```
content_favorites.dashboard.folder.parent_id = lookml_dashboards.folder.parent_id
```
```
content_favorites.dashboard.model.id = lookml_dashboards.model.id
```
```
content_favorites.dashboard.space.id = lookml_dashboards.space.id
```
```
content_favorites.dashboard.space.parent_id = lookml_dashboards.space.id
```
```
content_favorites.dashboard.space.id = lookml_dashboards.space.parent_id
```
```
content_favorites.dashboard.space.parent_id = lookml_dashboards.space.parent_id
```
```
content_favorites.dashboard.folder.creator_id = lookml_dashboards.folder.creator_id
```
```
content_favorites.dashboard.space.creator_id = lookml_dashboards.folder.creator_id
```
```
content_favorites.user_id = lookml_dashboards.folder.creator_id
```
```
content_favorites.dashboard.folder.creator_id = lookml_dashboards.space.creator_id
```
```
content_favorites.dashboard.space.creator_id = lookml_dashboards.space.creator_id
```
```
content_favorites.user_id = lookml_dashboards.space.creator_id
```
```
content_favorites.dashboard.folder.creator_id = lookml_dashboards.user_id
```
```
content_favorites.dashboard.space.creator_id = lookml_dashboards.user_id
```
```
content_favorites.user_id = lookml_dashboards.user_id
``` |
| [looks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#looks) | ```
content_favorites.id = looks.content_favorite_id
```
```
content_favorites.dashboard.content_favorite_id = looks.content_favorite_id
```
```
content_favorites.content_metadata_id = looks.content_metadata_id
```
```
content_favorites.dashboard.content_metadata_id = looks.content_metadata_id
```
```
content_favorites.dashboard.folder.content_metadata_id = looks.content_metadata_id
```
```
content_favorites.dashboard.space.content_metadata_id = looks.content_metadata_id
```
```
content_favorites.look.content_metadata_id = looks.content_metadata_id
```
```
content_favorites.dashboard.folder.id = looks.folder.id
```
```
content_favorites.dashboard.folder.parent_id = looks.folder.id
```
```
content_favorites.dashboard.folder.id = looks.folder_id
```
```
content_favorites.dashboard.folder.parent_id = looks.folder_id
```
```
content_favorites.dashboard.folder.id = looks.folder.parent_id
```
```
content_favorites.dashboard.folder.parent_id = looks.folder.parent_id
```
```
content_favorites.look_id = looks.id
```
```
content_favorites.look.id = looks.id
```
```
content_favorites.dashboard.model.id = looks.model.id
```
```
content_favorites.dashboard.space.id = looks.space.id
```
```
content_favorites.dashboard.space.parent_id = looks.space.id
```
```
content_favorites.dashboard.space.id = looks.space.parent_id
```
```
content_favorites.dashboard.space.parent_id = looks.space.parent_id
```
```
content_favorites.dashboard.space.id = looks.space_id
```
```
content_favorites.dashboard.space.parent_id = looks.space_id
```
```
content_favorites.dashboard.folder.creator_id = looks.deleter_id
```
```
content_favorites.dashboard.space.creator_id = looks.deleter_id
```
```
content_favorites.user_id = looks.deleter_id
```
```
content_favorites.dashboard.folder.creator_id = looks.folder.creator_id
```
```
content_favorites.dashboard.space.creator_id = looks.folder.creator_id
```
```
content_favorites.user_id = looks.folder.creator_id
```
```
content_favorites.dashboard.folder.creator_id = looks.user.id
```
```
content_favorites.dashboard.space.creator_id = looks.user.id
```
```
content_favorites.user_id = looks.user.id
```
```
content_favorites.dashboard.folder.creator_id = looks.user_id
```
```
content_favorites.dashboard.space.creator_id = looks.user_id
```
```
content_favorites.user_id = looks.user_id
``` |
| [content_metadata](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata) | ```
content_favorites.content_metadata_id = content_metadata.id
```
```
content_favorites.dashboard.content_metadata_id = content_metadata.id
```
```
content_favorites.dashboard.folder.content_metadata_id = content_metadata.id
```
```
content_favorites.dashboard.space.content_metadata_id = content_metadata.id
```
```
content_favorites.look.content_metadata_id = content_metadata.id
```
```
content_favorites.content_metadata_id = content_metadata.parent_id
```
```
content_favorites.dashboard.content_metadata_id = content_metadata.parent_id
```
```
content_favorites.dashboard.folder.content_metadata_id = content_metadata.parent_id
```
```
content_favorites.dashboard.space.content_metadata_id = content_metadata.parent_id
```
```
content_favorites.look.content_metadata_id = content_metadata.parent_id
```
```
content_favorites.dashboard.id = content_metadata.dashboard_id
```
```
content_favorites.dashboard_id = content_metadata.dashboard_id
```
```
content_favorites.look_id = content_metadata.look_id
```
```
content_favorites.look.id = content_metadata.look_id
```
```
content_favorites.dashboard.space.id = content_metadata.space_id
```
```
content_favorites.dashboard.space.parent_id = content_metadata.space_id
``` |
| [content_metadata_access](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata-access) | ```
content_favorites.content_metadata_id = content_metadata_access.content_metadata_id
```
```
content_favorites.dashboard.content_metadata_id = content_metadata_access.content_metadata_id
```
```
content_favorites.dashboard.folder.content_metadata_id = content_metadata_access.content_metadata_id
```
```
content_favorites.dashboard.space.content_metadata_id = content_metadata_access.content_metadata_id
```
```
content_favorites.look.content_metadata_id = content_metadata_access.content_metadata_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
content_favorites.content_metadata_id = content_views.content_metadata_id
```
```
content_favorites.dashboard.content_metadata_id = content_views.content_metadata_id
```
```
content_favorites.dashboard.folder.content_metadata_id = content_views.content_metadata_id
```
```
content_favorites.dashboard.space.content_metadata_id = content_views.content_metadata_id
```
```
content_favorites.look.content_metadata_id = content_views.content_metadata_id
```
```
content_favorites.dashboard.id = content_views.dashboard_id
```
```
content_favorites.dashboard_id = content_views.dashboard_id
```
```
content_favorites.look_id = content_views.look_id
```
```
content_favorites.look.id = content_views.look_id
```
```
content_favorites.dashboard.folder.creator_id = content_views.user_id
```
```
content_favorites.dashboard.space.creator_id = content_views.user_id
```
```
content_favorites.user_id = content_views.user_id
``` |
| [dashboard_filters](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-filters) | ```
content_favorites.dashboard.id = dashboard_filters.dashboard_id
```
```
content_favorites.dashboard_id = dashboard_filters.dashboard_id
``` |
| [dashboard_layouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-layouts) | ```
content_favorites.dashboard.id = dashboard_layouts.dashboard_id
```
```
content_favorites.dashboard_id = dashboard_layouts.dashboard_id
``` |
| [scheduled_plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#scheduled-plans) | ```
content_favorites.dashboard.id = scheduled_plans.dashboard_id
```
```
content_favorites.dashboard_id = scheduled_plans.dashboard_id
```
```
content_favorites.look_id = scheduled_plans.look_id
```
```
content_favorites.look.id = scheduled_plans.look_id
```
```
content_favorites.dashboard.folder.creator_id = scheduled_plans.user.id
```
```
content_favorites.dashboard.space.creator_id = scheduled_plans.user.id
```
```
content_favorites.user_id = scheduled_plans.user.id
```
```
content_favorites.dashboard.folder.creator_id = scheduled_plans.user_id
```
```
content_favorites.dashboard.space.creator_id = scheduled_plans.user_id
```
```
content_favorites.user_id = scheduled_plans.user_id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
content_favorites.dashboard.folder.id = users.home_folder_id
```
```
content_favorites.dashboard.folder.parent_id = users.home_folder_id
```
```
content_favorites.dashboard.folder.id = users.personal_folder_id
```
```
content_favorites.dashboard.folder.parent_id = users.personal_folder_id
```
```
content_favorites.dashboard.space.id = users.home_space_id
```
```
content_favorites.dashboard.space.parent_id = users.home_space_id
```
```
content_favorites.dashboard.space.id = users.personal_space_id
```
```
content_favorites.dashboard.space.parent_id = users.personal_space_id
```
```
content_favorites.dashboard.folder.creator_id = users.id
```
```
content_favorites.dashboard.space.creator_id = users.id
```
```
content_favorites.user_id = users.id
``` |
| [roles](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#roles) | ```
content_favorites.dashboard.model.id = roles.model_set.models
``` |
| [connections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#connections) | ```
content_favorites.dashboard.folder.creator_id = connections.user_id
```
```
content_favorites.dashboard.space.creator_id = connections.user_id
```
```
content_favorites.user_id = connections.user_id
``` |
| [user_login_lockouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-login-lockouts) | ```
content_favorites.dashboard.folder.creator_id = user_login_lockouts.user_id
```
```
content_favorites.dashboard.space.creator_id = user_login_lockouts.user_id
```
```
content_favorites.user_id = user_login_lockouts.user_id
``` |
content\_favorites table schema
| **content\_metadata\_id**
STRING |
| --- |
| **dashboard**
OBJECT
This is a nested data structure:
- content_favorite_id: STRING
- content_metadata_id: STRING
- description: STRING
- folder: OBJECT, which is also a nested data structure.
- child_count: INTEGER
- content_metadata_id: STRING
- creator_id: STRING
- external_id: STRING
- id: STRING
- is_embed: BOOLEAN
- is_embed_shared_root: BOOLEAN
- is_embed_users_root: BOOLEAN
- is_personal: BOOLEAN
- is_personal_descendant: BOOLEAN
- is_shared_root: BOOLEAN
- is_users_root: BOOLEAN
- name: STRING
- parent_id: STRING
- hidden: BOOLEAN
- id: STRING
- model: OBJECT, which is also a nested data structure.
- query_timezone: STRING
- readonly: BOOLEAN
- refresh_interval: STRING
- refresh_interval_to_i: INTEGER
- space: OBJECT, which is also a nested data structure.
- child_count: INTEGER
- content_metadata_id: STRING
- creator_id: STRING
- external_id: STRING
- id: STRING
- is_embed: BOOLEAN
- is_embed_shared_root: BOOLEAN
- is_embed_users_root: BOOLEAN
- is_personal: BOOLEAN
- is_personal_descendant: BOOLEAN
- is_shared_root: BOOLEAN
- is_users_root: BOOLEAN
- name: STRING
- parent_id: STRING
- title: STRING
- user_id: STRING
|
| **dashboard\_id**
STRING |
| **id**
STRING |
| **look**
OBJECT
This is a nested data structure:
- content_metadata_id: STRING
- id: STRING
- title: STRING
|
| **look\_id**
STRING |
| **user\_id**
STRING |
### content\_metadata
The `content_metadata` table contains information about content metadata in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/content#get_all_content_metadatas "Opens in new tab: Looker API method") |
content\_metadata table foreign keys
| Join content\_metadata with | on |
| --- | --- |
| [content_favorites](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-favorites) | ```
content_metadata.id = content_favorites.content_metadata_id
```
```
content_metadata.parent_id = content_favorites.content_metadata_id
```
```
content_metadata.id = content_favorites.dashboard.content_metadata_id
```
```
content_metadata.parent_id = content_favorites.dashboard.content_metadata_id
```
```
content_metadata.id = content_favorites.dashboard.folder.content_metadata_id
```
```
content_metadata.parent_id = content_favorites.dashboard.folder.content_metadata_id
```
```
content_metadata.id = content_favorites.dashboard.space.content_metadata_id
```
```
content_metadata.parent_id = content_favorites.dashboard.space.content_metadata_id
```
```
content_metadata.id = content_favorites.look.content_metadata_id
```
```
content_metadata.parent_id = content_favorites.look.content_metadata_id
```
```
content_metadata.dashboard_id = content_favorites.dashboard.id
```
```
content_metadata.dashboard_id = content_favorites.dashboard_id
```
```
content_metadata.look_id = content_favorites.look_id
```
```
content_metadata.look_id = content_favorites.look.id
```
```
content_metadata.space_id = content_favorites.dashboard.space.id
```
```
content_metadata.space_id = content_favorites.dashboard.space.parent_id
``` |
| [content_metadata_access](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata-access) | ```
content_metadata.id = content_metadata_access.content_metadata_id
```
```
content_metadata.parent_id = content_metadata_access.content_metadata_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
content_metadata.id = content_views.content_metadata_id
```
```
content_metadata.parent_id = content_views.content_metadata_id
```
```
content_metadata.dashboard_id = content_views.dashboard_id
```
```
content_metadata.look_id = content_views.look_id
``` |
| [dashboard_elements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-elements) | ```
content_metadata.id = dashboard_elements.look.content_metadata_id
```
```
content_metadata.parent_id = dashboard_elements.look.content_metadata_id
```
```
content_metadata.id = dashboard_elements.look.folder.content_metadata_id
```
```
content_metadata.parent_id = dashboard_elements.look.folder.content_metadata_id
```
```
content_metadata.id = dashboard_elements.look.space.content_metadata_id
```
```
content_metadata.parent_id = dashboard_elements.look.space.content_metadata_id
```
```
content_metadata.dashboard_id = dashboard_elements.dashboard_id
```
```
content_metadata.look_id = dashboard_elements.look.id
```
```
content_metadata.look_id = dashboard_elements.look_id
```
```
content_metadata.space_id = dashboard_elements.look.space.id
```
```
content_metadata.space_id = dashboard_elements.look.space.parent_id
``` |
| [dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboards) | ```
content_metadata.id = dashboards.content_metadata_id
```
```
content_metadata.parent_id = dashboards.content_metadata_id
```
```
content_metadata.id = dashboards.folder.content_metadata_id
```
```
content_metadata.parent_id = dashboards.folder.content_metadata_id
```
```
content_metadata.id = dashboards.space.content_metadata_id
```
```
content_metadata.parent_id = dashboards.space.content_metadata_id
```
```
content_metadata.dashboard_id = dashboards.id
```
```
content_metadata.space_id = dashboards.space.id
```
```
content_metadata.space_id = dashboards.space.parent_id
``` |
| [folders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#folders) | ```
content_metadata.id = folders.dashboards.folder.content_metadata_id
```
```
content_metadata.parent_id = folders.dashboards.folder.content_metadata_id
```
```
content_metadata.id = folders.dashboards.space.content_metadata_id
```
```
content_metadata.parent_id = folders.dashboards.space.content_metadata_id
```
```
content_metadata.id = folders.looks.content_metadata_id
```
```
content_metadata.parent_id = folders.looks.content_metadata_id
```
```
content_metadata.id = folders.looks.folder.content_metadata_id
```
```
content_metadata.parent_id = folders.looks.folder.content_metadata_id
```
```
content_metadata.dashboard_id = folders.dashboards.id
```
```
content_metadata.look_id = folders.looks.id
```
```
content_metadata.space_id = folders.dashboards.space.id
```
```
content_metadata.space_id = folders.dashboards.space.parent_id
```
```
content_metadata.space_id = folders.looks.space.id
```
```
content_metadata.space_id = folders.looks.space.parent_id
```
```
content_metadata.space_id = folders.looks.space_id
``` |
| [lookml_dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#lookml-dashboards) | ```
content_metadata.id = lookml_dashboards.content_metadata_id
```
```
content_metadata.parent_id = lookml_dashboards.content_metadata_id
```
```
content_metadata.id = lookml_dashboards.folder.content_metadata_id
```
```
content_metadata.parent_id = lookml_dashboards.folder.content_metadata_id
```
```
content_metadata.id = lookml_dashboards.space.content_metadata_id
```
```
content_metadata.parent_id = lookml_dashboards.space.content_metadata_id
```
```
content_metadata.space_id = lookml_dashboards.space.id
```
```
content_metadata.space_id = lookml_dashboards.space.parent_id
``` |
| [looks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#looks) | ```
content_metadata.id = looks.content_metadata_id
```
```
content_metadata.parent_id = looks.content_metadata_id
```
```
content_metadata.look_id = looks.id
```
```
content_metadata.space_id = looks.space.id
```
```
content_metadata.space_id = looks.space.parent_id
```
```
content_metadata.space_id = looks.space_id
``` |
| [dashboard_filters](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-filters) | ```
content_metadata.dashboard_id = dashboard_filters.dashboard_id
``` |
| [dashboard_layouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-layouts) | ```
content_metadata.dashboard_id = dashboard_layouts.dashboard_id
``` |
| [scheduled_plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#scheduled-plans) | ```
content_metadata.dashboard_id = scheduled_plans.dashboard_id
```
```
content_metadata.look_id = scheduled_plans.look_id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
content_metadata.space_id = users.home_space_id
```
```
content_metadata.space_id = users.personal_space_id
``` |
content\_metadata table schema
| **content\_type**
STRING |
| --- |
| **dashboard\_id**
STRING |
| **folder\_id**
STRING |
| **id**
STRING |
| **inheriting\_id**
STRING |
| **inherits**
BOOLEAN |
| **look\_id**
STRING |
| **name**
STRING |
| **parent\_id**
STRING |
| **slug**
STRING |
| **space\_id**
STRING |
### content\_metadata\_access
The `content_metadata_access` table contains information about content metadata access records in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/content#get_all_content_metadata_accesses "Opens in new tab: Looker API method") |
content\_metadata\_access table foreign keys
| Join content\_metadata\_access with | on |
| --- | --- |
| [content_favorites](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-favorites) | ```
content_metadata_access.content_metadata_id = content_favorites.content_metadata_id
```
```
content_metadata_access.content_metadata_id = content_favorites.dashboard.content_metadata_id
```
```
content_metadata_access.content_metadata_id = content_favorites.dashboard.folder.content_metadata_id
```
```
content_metadata_access.content_metadata_id = content_favorites.dashboard.space.content_metadata_id
```
```
content_metadata_access.content_metadata_id = content_favorites.look.content_metadata_id
``` |
| [content_metadata](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata) | ```
content_metadata_access.content_metadata_id = content_metadata.id
```
```
content_metadata_access.content_metadata_id = content_metadata.parent_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
content_metadata_access.content_metadata_id = content_views.content_metadata_id
```
```
content_metadata_access.group_id = content_views.group_id
``` |
| [dashboard_elements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-elements) | ```
content_metadata_access.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
content_metadata_access.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
content_metadata_access.content_metadata_id = dashboard_elements.look.space.content_metadata_id
``` |
| [dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboards) | ```
content_metadata_access.content_metadata_id = dashboards.content_metadata_id
```
```
content_metadata_access.content_metadata_id = dashboards.folder.content_metadata_id
```
```
content_metadata_access.content_metadata_id = dashboards.space.content_metadata_id
``` |
| [folders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#folders) | ```
content_metadata_access.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
content_metadata_access.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
content_metadata_access.content_metadata_id = folders.looks.content_metadata_id
```
```
content_metadata_access.content_metadata_id = folders.looks.folder.content_metadata_id
``` |
| [lookml_dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#lookml-dashboards) | ```
content_metadata_access.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
content_metadata_access.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
content_metadata_access.content_metadata_id = lookml_dashboards.space.content_metadata_id
``` |
| [looks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#looks) | ```
content_metadata_access.content_metadata_id = looks.content_metadata_id
``` |
| [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#groups) | ```
content_metadata_access.group_id = groups.id
``` |
| [groups_in_group](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#groups-in-group) | ```
content_metadata_access.group_id = groups_in_group.id
```
```
content_metadata_access.group_id = groups_in_group.parent_group_id
``` |
| [user_attribute_group_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-attribute-group-values) | ```
content_metadata_access.group_id = user_attribute_group_values.group_id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
content_metadata_access.group_id = users.group_ids
``` |
content\_metadata\_access table schema
| **content\_metadata\_id**
STRING |
| --- |
| **group\_id**
STRING |
| **id**
STRING |
| **permission\_type**
STRING |
| **user\_id**
STRING |
### content\_views
The `content_views` table contains info about user content views recorded in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/user#search_users "Opens in new tab: Looker API method") |
content\_views table foreign keys
| Join content\_views with | on |
| --- | --- |
| [content_favorites](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-favorites) | ```
content_views.content_metadata_id = content_favorites.content_metadata_id
```
```
content_views.content_metadata_id = content_favorites.dashboard.content_metadata_id
```
```
content_views.content_metadata_id = content_favorites.dashboard.folder.content_metadata_id
```
```
content_views.content_metadata_id = content_favorites.dashboard.space.content_metadata_id
```
```
content_views.content_metadata_id = content_favorites.look.content_metadata_id
```
```
content_views.dashboard_id = content_favorites.dashboard.id
```
```
content_views.dashboard_id = content_favorites.dashboard_id
```
```
content_views.look_id = content_favorites.look_id
```
```
content_views.look_id = content_favorites.look.id
```
```
content_views.user_id = content_favorites.dashboard.folder.creator_id
```
```
content_views.user_id = content_favorites.dashboard.space.creator_id
```
```
content_views.user_id = content_favorites.user_id
``` |
| [content_metadata](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata) | ```
content_views.content_metadata_id = content_metadata.id
```
```
content_views.content_metadata_id = content_metadata.parent_id
```
```
content_views.dashboard_id = content_metadata.dashboard_id
```
```
content_views.look_id = content_metadata.look_id
``` |
| [content_metadata_access](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata-access) | ```
content_views.content_metadata_id = content_metadata_access.content_metadata_id
```
```
content_views.group_id = content_metadata_access.group_id
``` |
| [dashboard_elements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-elements) | ```
content_views.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
content_views.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
content_views.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
content_views.dashboard_id = dashboard_elements.dashboard_id
```
```
content_views.look_id = dashboard_elements.look.id
```
```
content_views.look_id = dashboard_elements.look_id
```
```
content_views.user_id = dashboard_elements.look.deleter_id
```
```
content_views.user_id = dashboard_elements.look.folder.creator_id
```
```
content_views.user_id = dashboard_elements.look.last_updater_id
```
```
content_views.user_id = dashboard_elements.look.space.creator_id
```
```
content_views.user_id = dashboard_elements.look.user.id
```
```
content_views.user_id = dashboard_elements.look.user_id
``` |
| [dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboards) | ```
content_views.content_metadata_id = dashboards.content_metadata_id
```
```
content_views.content_metadata_id = dashboards.folder.content_metadata_id
```
```
content_views.content_metadata_id = dashboards.space.content_metadata_id
```
```
content_views.dashboard_id = dashboards.id
```
```
content_views.user_id = dashboards.space.creator_id
```
```
content_views.user_id = dashboards.user_id
``` |
| [folders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#folders) | ```
content_views.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
content_views.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
content_views.content_metadata_id = folders.looks.content_metadata_id
```
```
content_views.content_metadata_id = folders.looks.folder.content_metadata_id
```
```
content_views.dashboard_id = folders.dashboards.id
```
```
content_views.look_id = folders.looks.id
```
```
content_views.user_id = folders.creator_id
```
```
content_views.user_id = folders.dashboards.user_id
```
```
content_views.user_id = folders.dashboards.folder.creator_id
```
```
content_views.user_id = folders.dashboards.space.creator_id
```
```
content_views.user_id = folders.looks.deleter_id
```
```
content_views.user_id = folders.looks.last_updater_id
```
```
content_views.user_id = folders.looks.user.id
``` |
| [lookml_dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#lookml-dashboards) | ```
content_views.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
content_views.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
content_views.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
content_views.user_id = lookml_dashboards.folder.creator_id
```
```
content_views.user_id = lookml_dashboards.space.creator_id
```
```
content_views.user_id = lookml_dashboards.user_id
``` |
| [looks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#looks) | ```
content_views.content_metadata_id = looks.content_metadata_id
```
```
content_views.look_id = looks.id
```
```
content_views.user_id = looks.deleter_id
```
```
content_views.user_id = looks.folder.creator_id
```
```
content_views.user_id = looks.user.id
```
```
content_views.user_id = looks.user_id
``` |
| [dashboard_filters](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-filters) | ```
content_views.dashboard_id = dashboard_filters.dashboard_id
``` |
| [dashboard_layouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-layouts) | ```
content_views.dashboard_id = dashboard_layouts.dashboard_id
``` |
| [scheduled_plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#scheduled-plans) | ```
content_views.dashboard_id = scheduled_plans.dashboard_id
```
```
content_views.look_id = scheduled_plans.look_id
```
```
content_views.user_id = scheduled_plans.user.id
```
```
content_views.user_id = scheduled_plans.user_id
``` |
| [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#groups) | ```
content_views.group_id = groups.id
``` |
| [groups_in_group](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#groups-in-group) | ```
content_views.group_id = groups_in_group.id
```
```
content_views.group_id = groups_in_group.parent_group_id
``` |
| [user_attribute_group_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-attribute-group-values) | ```
content_views.group_id = user_attribute_group_values.group_id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
content_views.group_id = users.group_ids
```
```
content_views.user_id = users.id
``` |
| [connections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#connections) | ```
content_views.user_id = connections.user_id
``` |
| [user_login_lockouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-login-lockouts) | ```
content_views.user_id = user_login_lockouts.user_id
``` |
content\_views table schema
| **content\_metadata\_id**
STRING |
| --- |
| **dashboard\_id**
STRING |
| **favorite\_count**
INTEGER |
| **group\_id**
STRING |
| **id**
STRING |
| **last\_viewed\_at**
STRING |
| **look\_id**
STRING |
| **start\_of\_week\_date**
STRING |
| **user\_id**
STRING |
| **view\_count**
INTEGER |
### dashboard\_elements
The `dashboard_elements` table contains information about all dashboard elements in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/dashboard#get_all_dashboardelements "Opens in new tab: Looker API method") |
dashboard\_elements table foreign keys
| Join dashboard\_elements with | on |
| --- | --- |
| [content_favorites](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-favorites) | ```
dashboard_elements.look.content_favorite_id = content_favorites.id
```
```
dashboard_elements.look.content_favorite_id = content_favorites.dashboard.content_favorite_id
```
```
dashboard_elements.look.content_metadata_id = content_favorites.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = content_favorites.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = content_favorites.content_metadata_id
```
```
dashboard_elements.look.content_metadata_id = content_favorites.dashboard.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = content_favorites.dashboard.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = content_favorites.dashboard.content_metadata_id
```
```
dashboard_elements.look.content_metadata_id = content_favorites.dashboard.folder.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = content_favorites.dashboard.folder.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = content_favorites.dashboard.folder.content_metadata_id
```
```
dashboard_elements.look.content_metadata_id = content_favorites.dashboard.space.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = content_favorites.dashboard.space.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = content_favorites.dashboard.space.content_metadata_id
```
```
dashboard_elements.look.content_metadata_id = content_favorites.look.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = content_favorites.look.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = content_favorites.look.content_metadata_id
```
```
dashboard_elements.dashboard_id = content_favorites.dashboard.id
```
```
dashboard_elements.dashboard_id = content_favorites.dashboard_id
```
```
dashboard_elements.look.folder.id = content_favorites.dashboard.folder.id
```
```
dashboard_elements.look.folder.parent_id = content_favorites.dashboard.folder.id
```
```
dashboard_elements.look.folder_id = content_favorites.dashboard.folder.id
```
```
dashboard_elements.look.folder.id = content_favorites.dashboard.folder.parent_id
```
```
dashboard_elements.look.folder.parent_id = content_favorites.dashboard.folder.parent_id
```
```
dashboard_elements.look.folder_id = content_favorites.dashboard.folder.parent_id
```
```
dashboard_elements.look.id = content_favorites.look_id
```
```
dashboard_elements.look_id = content_favorites.look_id
```
```
dashboard_elements.look.id = content_favorites.look.id
```
```
dashboard_elements.look_id = content_favorites.look.id
```
```
dashboard_elements.look.model.id = content_favorites.dashboard.model.id
```
```
dashboard_elements.look.space.id = content_favorites.dashboard.space.id
```
```
dashboard_elements.look.space.parent_id = content_favorites.dashboard.space.id
```
```
dashboard_elements.look.space.id = content_favorites.dashboard.space.parent_id
```
```
dashboard_elements.look.space.parent_id = content_favorites.dashboard.space.parent_id
```
```
dashboard_elements.look.deleter_id = content_favorites.dashboard.folder.creator_id
```
```
dashboard_elements.look.folder.creator_id = content_favorites.dashboard.folder.creator_id
```
```
dashboard_elements.look.last_updater_id = content_favorites.dashboard.folder.creator_id
```
```
dashboard_elements.look.space.creator_id = content_favorites.dashboard.folder.creator_id
```
```
dashboard_elements.look.user.id = content_favorites.dashboard.folder.creator_id
```
```
dashboard_elements.look.user_id = content_favorites.dashboard.folder.creator_id
```
```
dashboard_elements.look.deleter_id = content_favorites.dashboard.space.creator_id
```
```
dashboard_elements.look.folder.creator_id = content_favorites.dashboard.space.creator_id
```
```
dashboard_elements.look.last_updater_id = content_favorites.dashboard.space.creator_id
```
```
dashboard_elements.look.space.creator_id = content_favorites.dashboard.space.creator_id
```
```
dashboard_elements.look.user.id = content_favorites.dashboard.space.creator_id
```
```
dashboard_elements.look.user_id = content_favorites.dashboard.space.creator_id
```
```
dashboard_elements.look.deleter_id = content_favorites.user_id
```
```
dashboard_elements.look.folder.creator_id = content_favorites.user_id
```
```
dashboard_elements.look.last_updater_id = content_favorites.user_id
```
```
dashboard_elements.look.space.creator_id = content_favorites.user_id
```
```
dashboard_elements.look.user.id = content_favorites.user_id
```
```
dashboard_elements.look.user_id = content_favorites.user_id
``` |
| [dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboards) | ```
dashboard_elements.look.content_favorite_id = dashboards.content_favorite_id
```
```
dashboard_elements.look.content_metadata_id = dashboards.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = dashboards.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = dashboards.content_metadata_id
```
```
dashboard_elements.look.content_metadata_id = dashboards.folder.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = dashboards.folder.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = dashboards.folder.content_metadata_id
```
```
dashboard_elements.look.content_metadata_id = dashboards.space.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = dashboards.space.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = dashboards.space.content_metadata_id
```
```
dashboard_elements.dashboard_id = dashboards.id
```
```
dashboard_elements.look.folder.id = dashboards.folder.id
```
```
dashboard_elements.look.folder.parent_id = dashboards.folder.id
```
```
dashboard_elements.look.folder_id = dashboards.folder.id
```
```
dashboard_elements.look.folder.id = dashboards.folder.parent_id
```
```
dashboard_elements.look.folder.parent_id = dashboards.folder.parent_id
```
```
dashboard_elements.look.folder_id = dashboards.folder.parent_id
```
```
dashboard_elements.look.model.id = dashboards.model.id
```
```
dashboard_elements.look.space.id = dashboards.space.id
```
```
dashboard_elements.look.space.parent_id = dashboards.space.id
```
```
dashboard_elements.look.space.id = dashboards.space.parent_id
```
```
dashboard_elements.look.space.parent_id = dashboards.space.parent_id
```
```
dashboard_elements.look.deleter_id = dashboards.space.creator_id
```
```
dashboard_elements.look.folder.creator_id = dashboards.space.creator_id
```
```
dashboard_elements.look.last_updater_id = dashboards.space.creator_id
```
```
dashboard_elements.look.space.creator_id = dashboards.space.creator_id
```
```
dashboard_elements.look.user.id = dashboards.space.creator_id
```
```
dashboard_elements.look.user_id = dashboards.space.creator_id
```
```
dashboard_elements.look.deleter_id = dashboards.user_id
```
```
dashboard_elements.look.folder.creator_id = dashboards.user_id
```
```
dashboard_elements.look.last_updater_id = dashboards.user_id
```
```
dashboard_elements.look.space.creator_id = dashboards.user_id
```
```
dashboard_elements.look.user.id = dashboards.user_id
```
```
dashboard_elements.look.user_id = dashboards.user_id
``` |
| [folders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#folders) | ```
dashboard_elements.look.content_favorite_id = folders.dashboards.content_favorite_id
```
```
dashboard_elements.look.content_favorite_id = folders.looks.content_favorite_id
```
```
dashboard_elements.look.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
dashboard_elements.look.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
dashboard_elements.look.content_metadata_id = folders.looks.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = folders.looks.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = folders.looks.content_metadata_id
```
```
dashboard_elements.look.content_metadata_id = folders.looks.folder.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = folders.looks.folder.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = folders.looks.folder.content_metadata_id
```
```
dashboard_elements.dashboard_id = folders.dashboards.id
```
```
dashboard_elements.look.folder.id = folders.id
```
```
dashboard_elements.look.folder.parent_id = folders.id
```
```
dashboard_elements.look.folder_id = folders.id
```
```
dashboard_elements.look.folder.id = folders.dashboards.folder.id
```
```
dashboard_elements.look.folder.parent_id = folders.dashboards.folder.id
```
```
dashboard_elements.look.folder_id = folders.dashboards.folder.id
```
```
dashboard_elements.look.folder.id = folders.dashboards.folder.parent_id
```
```
dashboard_elements.look.folder.parent_id = folders.dashboards.folder.parent_id
```
```
dashboard_elements.look.folder_id = folders.dashboards.folder.parent_id
```
```
dashboard_elements.look.folder.id = folders.looks.folder.id
```
```
dashboard_elements.look.folder.parent_id = folders.looks.folder.id
```
```
dashboard_elements.look.folder_id = folders.looks.folder.id
```
```
dashboard_elements.look.folder.id = folders.looks.folder.parent_id
```
```
dashboard_elements.look.folder.parent_id = folders.looks.folder.parent_id
```
```
dashboard_elements.look.folder_id = folders.looks.folder.parent_id
```
```
dashboard_elements.look.folder.id = folders.parent_id
```
```
dashboard_elements.look.folder.parent_id = folders.parent_id
```
```
dashboard_elements.look.folder_id = folders.parent_id
```
```
dashboard_elements.look.id = folders.looks.id
```
```
dashboard_elements.look_id = folders.looks.id
```
```
dashboard_elements.look.model.id = folders.dashboards.model.id
```
```
dashboard_elements.look.model.id = folders.looks.model.id
```
```
dashboard_elements.look.query.id = folders.looks.query_id
```
```
dashboard_elements.look.query_id = folders.looks.query_id
```
```
dashboard_elements.query.id = folders.looks.query_id
```
```
dashboard_elements.query_id = folders.looks.query_id
```
```
dashboard_elements.result_maker.query.id = folders.looks.query_id
```
```
dashboard_elements.result_maker.query_id = folders.looks.query_id
```
```
dashboard_elements.look.space.id = folders.dashboards.space.id
```
```
dashboard_elements.look.space.parent_id = folders.dashboards.space.id
```
```
dashboard_elements.look.space.id = folders.dashboards.space.parent_id
```
```
dashboard_elements.look.space.parent_id = folders.dashboards.space.parent_id
```
```
dashboard_elements.look.space.id = folders.looks.space.id
```
```
dashboard_elements.look.space.parent_id = folders.looks.space.id
```
```
dashboard_elements.look.space.id = folders.looks.space.parent_id
```
```
dashboard_elements.look.space.parent_id = folders.looks.space.parent_id
```
```
dashboard_elements.look.space.id = folders.looks.space_id
```
```
dashboard_elements.look.space.parent_id = folders.looks.space_id
```
```
dashboard_elements.look.deleter_id = folders.creator_id
```
```
dashboard_elements.look.folder.creator_id = folders.creator_id
```
```
dashboard_elements.look.last_updater_id = folders.creator_id
```
```
dashboard_elements.look.space.creator_id = folders.creator_id
```
```
dashboard_elements.look.user.id = folders.creator_id
```
```
dashboard_elements.look.user_id = folders.creator_id
```
```
dashboard_elements.look.deleter_id = folders.dashboards.user_id
```
```
dashboard_elements.look.folder.creator_id = folders.dashboards.user_id
```
```
dashboard_elements.look.last_updater_id = folders.dashboards.user_id
```
```
dashboard_elements.look.space.creator_id = folders.dashboards.user_id
```
```
dashboard_elements.look.user.id = folders.dashboards.user_id
```
```
dashboard_elements.look.user_id = folders.dashboards.user_id
```
```
dashboard_elements.look.deleter_id = folders.dashboards.folder.creator_id
```
```
dashboard_elements.look.folder.creator_id = folders.dashboards.folder.creator_id
```
```
dashboard_elements.look.last_updater_id = folders.dashboards.folder.creator_id
```
```
dashboard_elements.look.space.creator_id = folders.dashboards.folder.creator_id
```
```
dashboard_elements.look.user.id = folders.dashboards.folder.creator_id
```
```
dashboard_elements.look.user_id = folders.dashboards.folder.creator_id
```
```
dashboard_elements.look.deleter_id = folders.dashboards.space.creator_id
```
```
dashboard_elements.look.folder.creator_id = folders.dashboards.space.creator_id
```
```
dashboard_elements.look.last_updater_id = folders.dashboards.space.creator_id
```
```
dashboard_elements.look.space.creator_id = folders.dashboards.space.creator_id
```
```
dashboard_elements.look.user.id = folders.dashboards.space.creator_id
```
```
dashboard_elements.look.user_id = folders.dashboards.space.creator_id
```
```
dashboard_elements.look.deleter_id = folders.looks.deleter_id
```
```
dashboard_elements.look.folder.creator_id = folders.looks.deleter_id
```
```
dashboard_elements.look.last_updater_id = folders.looks.deleter_id
```
```
dashboard_elements.look.space.creator_id = folders.looks.deleter_id
```
```
dashboard_elements.look.user.id = folders.looks.deleter_id
```
```
dashboard_elements.look.user_id = folders.looks.deleter_id
```
```
dashboard_elements.look.deleter_id = folders.looks.last_updater_id
```
```
dashboard_elements.look.folder.creator_id = folders.looks.last_updater_id
```
```
dashboard_elements.look.last_updater_id = folders.looks.last_updater_id
```
```
dashboard_elements.look.space.creator_id = folders.looks.last_updater_id
```
```
dashboard_elements.look.user.id = folders.looks.last_updater_id
```
```
dashboard_elements.look.user_id = folders.looks.last_updater_id
```
```
dashboard_elements.look.deleter_id = folders.looks.user.id
```
```
dashboard_elements.look.folder.creator_id = folders.looks.user.id
```
```
dashboard_elements.look.last_updater_id = folders.looks.user.id
```
```
dashboard_elements.look.space.creator_id = folders.looks.user.id
```
```
dashboard_elements.look.user.id = folders.looks.user.id
```
```
dashboard_elements.look.user_id = folders.looks.user.id
``` |
| [lookml_dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#lookml-dashboards) | ```
dashboard_elements.look.content_favorite_id = lookml_dashboards.content_favorite_id
```
```
dashboard_elements.look.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
dashboard_elements.look.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
dashboard_elements.look.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
dashboard_elements.look.folder.id = lookml_dashboards.folder.id
```
```
dashboard_elements.look.folder.parent_id = lookml_dashboards.folder.id
```
```
dashboard_elements.look.folder_id = lookml_dashboards.folder.id
```
```
dashboard_elements.look.folder.id = lookml_dashboards.folder.parent_id
```
```
dashboard_elements.look.folder.parent_id = lookml_dashboards.folder.parent_id
```
```
dashboard_elements.look.folder_id = lookml_dashboards.folder.parent_id
```
```
dashboard_elements.look.model.id = lookml_dashboards.model.id
```
```
dashboard_elements.look.space.id = lookml_dashboards.space.id
```
```
dashboard_elements.look.space.parent_id = lookml_dashboards.space.id
```
```
dashboard_elements.look.space.id = lookml_dashboards.space.parent_id
```
```
dashboard_elements.look.space.parent_id = lookml_dashboards.space.parent_id
```
```
dashboard_elements.look.deleter_id = lookml_dashboards.folder.creator_id
```
```
dashboard_elements.look.folder.creator_id = lookml_dashboards.folder.creator_id
```
```
dashboard_elements.look.last_updater_id = lookml_dashboards.folder.creator_id
```
```
dashboard_elements.look.space.creator_id = lookml_dashboards.folder.creator_id
```
```
dashboard_elements.look.user.id = lookml_dashboards.folder.creator_id
```
```
dashboard_elements.look.user_id = lookml_dashboards.folder.creator_id
```
```
dashboard_elements.look.deleter_id = lookml_dashboards.space.creator_id
```
```
dashboard_elements.look.folder.creator_id = lookml_dashboards.space.creator_id
```
```
dashboard_elements.look.last_updater_id = lookml_dashboards.space.creator_id
```
```
dashboard_elements.look.space.creator_id = lookml_dashboards.space.creator_id
```
```
dashboard_elements.look.user.id = lookml_dashboards.space.creator_id
```
```
dashboard_elements.look.user_id = lookml_dashboards.space.creator_id
```
```
dashboard_elements.look.deleter_id = lookml_dashboards.user_id
```
```
dashboard_elements.look.folder.creator_id = lookml_dashboards.user_id
```
```
dashboard_elements.look.last_updater_id = lookml_dashboards.user_id
```
```
dashboard_elements.look.space.creator_id = lookml_dashboards.user_id
```
```
dashboard_elements.look.user.id = lookml_dashboards.user_id
```
```
dashboard_elements.look.user_id = lookml_dashboards.user_id
``` |
| [looks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#looks) | ```
dashboard_elements.look.content_favorite_id = looks.content_favorite_id
```
```
dashboard_elements.look.content_metadata_id = looks.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = looks.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = looks.content_metadata_id
```
```
dashboard_elements.look.folder.id = looks.folder.id
```
```
dashboard_elements.look.folder.parent_id = looks.folder.id
```
```
dashboard_elements.look.folder_id = looks.folder.id
```
```
dashboard_elements.look.folder.id = looks.folder_id
```
```
dashboard_elements.look.folder.parent_id = looks.folder_id
```
```
dashboard_elements.look.folder_id = looks.folder_id
```
```
dashboard_elements.look.folder.id = looks.folder.parent_id
```
```
dashboard_elements.look.folder.parent_id = looks.folder.parent_id
```
```
dashboard_elements.look.folder_id = looks.folder.parent_id
```
```
dashboard_elements.look.id = looks.id
```
```
dashboard_elements.look_id = looks.id
```
```
dashboard_elements.look.model.id = looks.model.id
```
```
dashboard_elements.look.query.id = looks.query_id
```
```
dashboard_elements.look.query_id = looks.query_id
```
```
dashboard_elements.query.id = looks.query_id
```
```
dashboard_elements.query_id = looks.query_id
```
```
dashboard_elements.result_maker.query.id = looks.query_id
```
```
dashboard_elements.result_maker.query_id = looks.query_id
```
```
dashboard_elements.look.space.id = looks.space.id
```
```
dashboard_elements.look.space.parent_id = looks.space.id
```
```
dashboard_elements.look.space.id = looks.space.parent_id
```
```
dashboard_elements.look.space.parent_id = looks.space.parent_id
```
```
dashboard_elements.look.space.id = looks.space_id
```
```
dashboard_elements.look.space.parent_id = looks.space_id
```
```
dashboard_elements.look.deleter_id = looks.deleter_id
```
```
dashboard_elements.look.folder.creator_id = looks.deleter_id
```
```
dashboard_elements.look.last_updater_id = looks.deleter_id
```
```
dashboard_elements.look.space.creator_id = looks.deleter_id
```
```
dashboard_elements.look.user.id = looks.deleter_id
```
```
dashboard_elements.look.user_id = looks.deleter_id
```
```
dashboard_elements.look.deleter_id = looks.folder.creator_id
```
```
dashboard_elements.look.folder.creator_id = looks.folder.creator_id
```
```
dashboard_elements.look.last_updater_id = looks.folder.creator_id
```
```
dashboard_elements.look.space.creator_id = looks.folder.creator_id
```
```
dashboard_elements.look.user.id = looks.folder.creator_id
```
```
dashboard_elements.look.user_id = looks.folder.creator_id
```
```
dashboard_elements.look.deleter_id = looks.user.id
```
```
dashboard_elements.look.folder.creator_id = looks.user.id
```
```
dashboard_elements.look.last_updater_id = looks.user.id
```
```
dashboard_elements.look.space.creator_id = looks.user.id
```
```
dashboard_elements.look.user.id = looks.user.id
```
```
dashboard_elements.look.user_id = looks.user.id
```
```
dashboard_elements.look.deleter_id = looks.user_id
```
```
dashboard_elements.look.folder.creator_id = looks.user_id
```
```
dashboard_elements.look.last_updater_id = looks.user_id
```
```
dashboard_elements.look.space.creator_id = looks.user_id
```
```
dashboard_elements.look.user.id = looks.user_id
```
```
dashboard_elements.look.user_id = looks.user_id
``` |
| [content_metadata](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata) | ```
dashboard_elements.look.content_metadata_id = content_metadata.id
```
```
dashboard_elements.look.folder.content_metadata_id = content_metadata.id
```
```
dashboard_elements.look.space.content_metadata_id = content_metadata.id
```
```
dashboard_elements.look.content_metadata_id = content_metadata.parent_id
```
```
dashboard_elements.look.folder.content_metadata_id = content_metadata.parent_id
```
```
dashboard_elements.look.space.content_metadata_id = content_metadata.parent_id
```
```
dashboard_elements.dashboard_id = content_metadata.dashboard_id
```
```
dashboard_elements.look.id = content_metadata.look_id
```
```
dashboard_elements.look_id = content_metadata.look_id
```
```
dashboard_elements.look.space.id = content_metadata.space_id
```
```
dashboard_elements.look.space.parent_id = content_metadata.space_id
``` |
| [content_metadata_access](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata-access) | ```
dashboard_elements.look.content_metadata_id = content_metadata_access.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = content_metadata_access.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = content_metadata_access.content_metadata_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
dashboard_elements.look.content_metadata_id = content_views.content_metadata_id
```
```
dashboard_elements.look.folder.content_metadata_id = content_views.content_metadata_id
```
```
dashboard_elements.look.space.content_metadata_id = content_views.content_metadata_id
```
```
dashboard_elements.dashboard_id = content_views.dashboard_id
```
```
dashboard_elements.look.id = content_views.look_id
```
```
dashboard_elements.look_id = content_views.look_id
```
```
dashboard_elements.look.deleter_id = content_views.user_id
```
```
dashboard_elements.look.folder.creator_id = content_views.user_id
```
```
dashboard_elements.look.last_updater_id = content_views.user_id
```
```
dashboard_elements.look.space.creator_id = content_views.user_id
```
```
dashboard_elements.look.user.id = content_views.user_id
```
```
dashboard_elements.look.user_id = content_views.user_id
``` |
| [dashboard_filters](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-filters) | ```
dashboard_elements.dashboard_id = dashboard_filters.dashboard_id
``` |
| [dashboard_layouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-layouts) | ```
dashboard_elements.dashboard_id = dashboard_layouts.dashboard_id
```
```
dashboard_elements.id = dashboard_layouts.dashboard_layout_components.dashboard_element_id
``` |
| [scheduled_plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#scheduled-plans) | ```
dashboard_elements.dashboard_id = scheduled_plans.dashboard_id
```
```
dashboard_elements.look.id = scheduled_plans.look_id
```
```
dashboard_elements.look_id = scheduled_plans.look_id
```
```
dashboard_elements.look.query.id = scheduled_plans.query_id
```
```
dashboard_elements.look.query_id = scheduled_plans.query_id
```
```
dashboard_elements.query.id = scheduled_plans.query_id
```
```
dashboard_elements.query_id = scheduled_plans.query_id
```
```
dashboard_elements.result_maker.query.id = scheduled_plans.query_id
```
```
dashboard_elements.result_maker.query_id = scheduled_plans.query_id
```
```
dashboard_elements.look.deleter_id = scheduled_plans.user.id
```
```
dashboard_elements.look.folder.creator_id = scheduled_plans.user.id
```
```
dashboard_elements.look.last_updater_id = scheduled_plans.user.id
```
```
dashboard_elements.look.space.creator_id = scheduled_plans.user.id
```
```
dashboard_elements.look.user.id = scheduled_plans.user.id
```
```
dashboard_elements.look.user_id = scheduled_plans.user.id
```
```
dashboard_elements.look.deleter_id = scheduled_plans.user_id
```
```
dashboard_elements.look.folder.creator_id = scheduled_plans.user_id
```
```
dashboard_elements.look.last_updater_id = scheduled_plans.user_id
```
```
dashboard_elements.look.space.creator_id = scheduled_plans.user_id
```
```
dashboard_elements.look.user.id = scheduled_plans.user_id
```
```
dashboard_elements.look.user_id = scheduled_plans.user_id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
dashboard_elements.look.folder.id = users.home_folder_id
```
```
dashboard_elements.look.folder.parent_id = users.home_folder_id
```
```
dashboard_elements.look.folder_id = users.home_folder_id
```
```
dashboard_elements.look.folder.id = users.personal_folder_id
```
```
dashboard_elements.look.folder.parent_id = users.personal_folder_id
```
```
dashboard_elements.look.folder_id = users.personal_folder_id
```
```
dashboard_elements.look.space.id = users.home_space_id
```
```
dashboard_elements.look.space.parent_id = users.home_space_id
```
```
dashboard_elements.look.space.id = users.personal_space_id
```
```
dashboard_elements.look.space.parent_id = users.personal_space_id
```
```
dashboard_elements.look.deleter_id = users.id
```
```
dashboard_elements.look.folder.creator_id = users.id
```
```
dashboard_elements.look.last_updater_id = users.id
```
```
dashboard_elements.look.space.creator_id = users.id
```
```
dashboard_elements.look.user.id = users.id
```
```
dashboard_elements.look.user_id = users.id
``` |
| [roles](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#roles) | ```
dashboard_elements.look.model.id = roles.model_set.models
``` |
| [queries](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#queries) | ```
dashboard_elements.look.query.id = queries.id
```
```
dashboard_elements.look.query_id = queries.id
```
```
dashboard_elements.query.id = queries.id
```
```
dashboard_elements.query_id = queries.id
```
```
dashboard_elements.result_maker.query.id = queries.id
```
```
dashboard_elements.result_maker.query_id = queries.id
``` |
| [connections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#connections) | ```
dashboard_elements.look.deleter_id = connections.user_id
```
```
dashboard_elements.look.folder.creator_id = connections.user_id
```
```
dashboard_elements.look.last_updater_id = connections.user_id
```
```
dashboard_elements.look.space.creator_id = connections.user_id
```
```
dashboard_elements.look.user.id = connections.user_id
```
```
dashboard_elements.look.user_id = connections.user_id
``` |
| [user_login_lockouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-login-lockouts) | ```
dashboard_elements.look.deleter_id = user_login_lockouts.user_id
```
```
dashboard_elements.look.folder.creator_id = user_login_lockouts.user_id
```
```
dashboard_elements.look.last_updater_id = user_login_lockouts.user_id
```
```
dashboard_elements.look.space.creator_id = user_login_lockouts.user_id
```
```
dashboard_elements.look.user.id = user_login_lockouts.user_id
```
```
dashboard_elements.look.user_id = user_login_lockouts.user_id
``` |
dashboard\_elements table schema
| **alert\_count**
INTEGER |
| --- |
| **body\_text**
STRING |
| **body\_text\_as\_html**
STRING |
| **dashboard\_id**
STRING |
| **edit\_uri**
STRING |
| **id**
STRING |
| **look**
OBJECT
This is a nested data structure:
- content_favorite_id: STRING
- content_metadata_id: STRING
- created_at: DATE-TIME
- deleted: BOOLEAN
- deleted_at: DATE-TIME
- deleter_id: STRING
- description: STRING
- embed_url: STRING
- excel_file_url: STRING
- favorite_count: INTEGER
- folder: OBJECT, which is also a nested data structure.
- child_count: INTEGER
- content_metadata_id: STRING
- creator_id: STRING
- external_id: STRING
- id: STRING
- is_embed: BOOLEAN
- is_embed_shared_root: BOOLEAN
- is_embed_users_root: BOOLEAN
- is_personal: BOOLEAN
- is_personal_descendant: BOOLEAN
- is_shared_root: BOOLEAN
- is_users_root: BOOLEAN
- name: STRING
- parent_id: STRING
- folder_id: STRING
- google_spreadsheet_formula: STRING
- id: STRING
- image_embed_url: STRING
- is_run_on_load: BOOLEAN
- last_accessed_at: DATE-TIME
- last_updater_id: STRING
- last_viewed_at: DATE-TIME
- model: OBJECT, which is also a nested data structure.
- public: BOOLEAN
- public_slug: STRING
- public_url: STRING
- query: OBJECT, which is also a nested data structure.
- client_id: STRING
- column_limit: STRING
- dynamic_fields: STRING
- expanded_share_url: STRING
- fields: ARRAY, which is also a nested data structure.
- fill_fields: ARRAY, which is also a nested data structure.
- filter_config: OBJECT, which is also a nested data structure.
- filter_expression: STRING
- filters: OBJECT, which is also a nested data structure.
- has_table_calculations: BOOLEAN
- id: STRING
- limit: STRING
- model: STRING
- pivots: ARRAY, which is also a nested data structure.
- query_timezone: STRING
- row_total: STRING
- runtime: NUMBER
- share_url: STRING
- slug: STRING
- sorts: ARRAY, which is also a nested data structure.
- subtotals: ARRAY, which is also a nested data structure.
- total: BOOLEAN
- url: STRING
- view: STRING
- vis_config: OBJECT, which is also a nested data structure.
- visible_ui_sections: STRING
- query_id: STRING
- short_url: STRING
- space: OBJECT, which is also a nested data structure.
- child_count: INTEGER
- content_metadata_id: STRING
- creator_id: STRING
- external_id: STRING
- id: STRING
- is_embed: BOOLEAN
- is_embed_shared_root: BOOLEAN
- is_embed_users_root: BOOLEAN
- is_personal: BOOLEAN
- is_personal_descendant: BOOLEAN
- is_shared_root: BOOLEAN
- is_users_root: BOOLEAN
- name: STRING
- parent_id: STRING
- space_id: STRING
- title: STRING
- updated_at: DATE-TIME
- url: STRING
- user: OBJECT, which is also a nested data structure.
- user_id: STRING
- view_count: INTEGER
|
| **look\_id**
STRING |
| **lookml\_link\_id**
STRING |
| **merge\_result\_id**
STRING |
| **note\_display**
STRING |
| **note\_state**
STRING |
| **note\_text**
STRING |
| **note\_text\_as\_html**
STRING |
| **query**
OBJECT
This is a nested data structure:
- client_id: STRING
- column_limit: STRING
- dynamic_fields: STRING
- expanded_share_url: STRING
- fields: ARRAY, which is also a nested data structure.
- fill_fields: ARRAY, which is also a nested data structure.
- filter_config: OBJECT, which is also a nested data structure.
- filter_expression: STRING
- filters: OBJECT, which is also a nested data structure.
- has_table_calculations: BOOLEAN
- id: STRING
- limit: STRING
- model: STRING
- pivots: ARRAY, which is also a nested data structure.
- query_timezone: STRING
- row_total: STRING
- runtime: NUMBER
- share_url: STRING
- slug: STRING
- sorts: ARRAY, which is also a nested data structure.
- subtotals: ARRAY, which is also a nested data structure.
- total: BOOLEAN
- url: STRING
- view: STRING
- vis_config: OBJECT, which is also a nested data structure.
- visible_ui_sections: STRING
|
| **query\_id**
STRING |
| **refresh\_interval**
STRING |
| **refresh\_interval\_to\_i**
INTEGER |
| **result\_maker**
OBJECT
This is a nested data structure:
- dynamic_fields: STRING
- filterables: ARRAY, which is also a nested data structure.
- listen: ARRAY, which is also a nested data structure.
- dashboard_filter_name: STRING
- field: STRING
- model: STRING
- name: STRING
- view: STRING
- id: STRING
- merge_result_id: STRING
- query: OBJECT, which is also a nested data structure.
- client_id: STRING
- column_limit: STRING
- dynamic_fields: STRING
- expanded_share_url: STRING
- fields: ARRAY, which is also a nested data structure.
- fill_fields: ARRAY, which is also a nested data structure.
- filter_config: OBJECT, which is also a nested data structure.
- filter_expression: STRING
- filters: OBJECT, which is also a nested data structure.
- has_table_calculations: BOOLEAN
- id: STRING
- limit: STRING
- model: STRING
- pivots: ARRAY, which is also a nested data structure.
- query_timezone: STRING
- row_total: STRING
- runtime: NUMBER
- share_url: STRING
- slug: STRING
- sorts: ARRAY, which is also a nested data structure.
- subtotals: ARRAY, which is also a nested data structure.
- total: BOOLEAN
- url: STRING
- view: STRING
- vis_config: OBJECT, which is also a nested data structure.
- visible_ui_sections: STRING
- query_id: STRING
- sorts: ARRAY, which is also a nested data structure.
- total: BOOLEAN
- vis_config: OBJECT, which is also a nested data structure.
|
| **result\_maker\_id**
STRING |
| **subtitle\_text**
STRING |
| **title**
STRING |
| **title\_hidden**
BOOLEAN |
| **title\_text**
STRING |
| **type**
STRING |
### dashboard\_filters
The `dashboard_filters` table contains information about all dashboard filters in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/dashboard#get_all_dashboard_filters "Opens in new tab: Looker API method") |
dashboard\_filters table foreign keys
| Join dashboard\_filters with | on |
| --- | --- |
| [content_favorites](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-favorites) | ```
dashboard_filters.dashboard_id = content_favorites.dashboard.id
```
```
dashboard_filters.dashboard_id = content_favorites.dashboard_id
``` |
| [content_metadata](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata) | ```
dashboard_filters.dashboard_id = content_metadata.dashboard_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
dashboard_filters.dashboard_id = content_views.dashboard_id
``` |
| [dashboard_elements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-elements) | ```
dashboard_filters.dashboard_id = dashboard_elements.dashboard_id
``` |
| [dashboard_layouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-layouts) | ```
dashboard_filters.dashboard_id = dashboard_layouts.dashboard_id
``` |
| [dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboards) | ```
dashboard_filters.dashboard_id = dashboards.id
``` |
| [folders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#folders) | ```
dashboard_filters.dashboard_id = folders.dashboards.id
``` |
| [scheduled_plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#scheduled-plans) | ```
dashboard_filters.dashboard_id = scheduled_plans.dashboard_id
``` |
dashboard\_filters table schema
| **allow\_multiple\_values**
BOOLEAN |
| --- |
| **dashboard\_id**
STRING |
| **default\_value**
STRING |
| **dimension**
STRING |
| **explore**
STRING |
| **field**
OBJECT
This is a nested data structure. |
| **id**
STRING |
| **listens\_to\_filters**
ARRAY
This is a nested data structure. |
| **model**
STRING |
| **name**
STRING |
| **required**
BOOLEAN |
| **row**
INTEGER |
| **title**
STRING |
| **type**
STRING |
| **ui\_config**
OBJECT
This is a nested data structure. |
### dashboard\_layouts
The `dashboard_layouts` table contains information about all dashboard layouts in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/dashboard#get_all_dashboardlayouts "Opens in new tab: Looker API method") |
dashboard\_layouts table foreign keys
| Join dashboard\_layouts with | on |
| --- | --- |
| [content_favorites](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-favorites) | ```
dashboard_layouts.dashboard_id = content_favorites.dashboard.id
```
```
dashboard_layouts.dashboard_id = content_favorites.dashboard_id
``` |
| [content_metadata](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata) | ```
dashboard_layouts.dashboard_id = content_metadata.dashboard_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
dashboard_layouts.dashboard_id = content_views.dashboard_id
``` |
| [dashboard_elements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-elements) | ```
dashboard_layouts.dashboard_id = dashboard_elements.dashboard_id
```
```
dashboard_layouts.dashboard_layout_components.dashboard_element_id = dashboard_elements.id
``` |
| [dashboard_filters](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-filters) | ```
dashboard_layouts.dashboard_id = dashboard_filters.dashboard_id
``` |
| [dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboards) | ```
dashboard_layouts.dashboard_id = dashboards.id
``` |
| [folders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#folders) | ```
dashboard_layouts.dashboard_id = folders.dashboards.id
``` |
| [scheduled_plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#scheduled-plans) | ```
dashboard_layouts.dashboard_id = scheduled_plans.dashboard_id
``` |
dashboard\_layouts table schema
| **active**
BOOLEAN |
| --- |
| **column\_width**
INTEGER |
| **dashboard\_id**
STRING |
| **dashboard\_layout\_components**
ARRAY
This is a nested data structure:
- column: INTEGER
- dashboard_element_id: STRING
- dashboard_layout_id: STRING
- deleted: BOOLEAN
- element_title: STRING
- element_title_hidden: BOOLEAN
- height: INTEGER
- id: STRING
- row: INTEGER
- vis_type: STRING
- width: INTEGER
|
| **dashboard\_title**
STRING |
| **deleted**
BOOLEAN |
| **id**
STRING |
| **type**
STRING |
| **width**
INTEGER |
### dashboards
The `dashboards` table contains information about all active dashboards in your Looker account.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/dashboard#get_all_dashboards "Opens in new tab: Looker API method") |
dashboards table foreign keys
| Join dashboards with | on |
| --- | --- |
| [content_favorites](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-favorites) | ```
dashboards.content_favorite_id = content_favorites.id
```
```
dashboards.content_favorite_id = content_favorites.dashboard.content_favorite_id
```
```
dashboards.content_metadata_id = content_favorites.content_metadata_id
```
```
dashboards.folder.content_metadata_id = content_favorites.content_metadata_id
```
```
dashboards.space.content_metadata_id = content_favorites.content_metadata_id
```
```
dashboards.content_metadata_id = content_favorites.dashboard.content_metadata_id
```
```
dashboards.folder.content_metadata_id = content_favorites.dashboard.content_metadata_id
```
```
dashboards.space.content_metadata_id = content_favorites.dashboard.content_metadata_id
```
```
dashboards.content_metadata_id = content_favorites.dashboard.folder.content_metadata_id
```
```
dashboards.folder.content_metadata_id = content_favorites.dashboard.folder.content_metadata_id
```
```
dashboards.space.content_metadata_id = content_favorites.dashboard.folder.content_metadata_id
```
```
dashboards.content_metadata_id = content_favorites.dashboard.space.content_metadata_id
```
```
dashboards.folder.content_metadata_id = content_favorites.dashboard.space.content_metadata_id
```
```
dashboards.space.content_metadata_id = content_favorites.dashboard.space.content_metadata_id
```
```
dashboards.content_metadata_id = content_favorites.look.content_metadata_id
```
```
dashboards.folder.content_metadata_id = content_favorites.look.content_metadata_id
```
```
dashboards.space.content_metadata_id = content_favorites.look.content_metadata_id
```
```
dashboards.id = content_favorites.dashboard.id
```
```
dashboards.id = content_favorites.dashboard_id
```
```
dashboards.folder.id = content_favorites.dashboard.folder.id
```
```
dashboards.folder.parent_id = content_favorites.dashboard.folder.id
```
```
dashboards.folder.id = content_favorites.dashboard.folder.parent_id
```
```
dashboards.folder.parent_id = content_favorites.dashboard.folder.parent_id
```
```
dashboards.model.id = content_favorites.dashboard.model.id
```
```
dashboards.space.id = content_favorites.dashboard.space.id
```
```
dashboards.space.parent_id = content_favorites.dashboard.space.id
```
```
dashboards.space.id = content_favorites.dashboard.space.parent_id
```
```
dashboards.space.parent_id = content_favorites.dashboard.space.parent_id
```
```
dashboards.space.creator_id = content_favorites.dashboard.folder.creator_id
```
```
dashboards.user_id = content_favorites.dashboard.folder.creator_id
```
```
dashboards.space.creator_id = content_favorites.dashboard.space.creator_id
```
```
dashboards.user_id = content_favorites.dashboard.space.creator_id
```
```
dashboards.space.creator_id = content_favorites.user_id
```
```
dashboards.user_id = content_favorites.user_id
``` |
| [dashboard_elements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-elements) | ```
dashboards.content_favorite_id = dashboard_elements.look.content_favorite_id
```
```
dashboards.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
dashboards.folder.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
dashboards.space.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
dashboards.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
dashboards.folder.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
dashboards.space.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
dashboards.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
dashboards.folder.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
dashboards.space.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
dashboards.id = dashboard_elements.dashboard_id
```
```
dashboards.folder.id = dashboard_elements.look.folder.id
```
```
dashboards.folder.parent_id = dashboard_elements.look.folder.id
```
```
dashboards.folder.id = dashboard_elements.look.folder.parent_id
```
```
dashboards.folder.parent_id = dashboard_elements.look.folder.parent_id
```
```
dashboards.folder.id = dashboard_elements.look.folder_id
```
```
dashboards.folder.parent_id = dashboard_elements.look.folder_id
```
```
dashboards.model.id = dashboard_elements.look.model.id
```
```
dashboards.space.id = dashboard_elements.look.space.id
```
```
dashboards.space.parent_id = dashboard_elements.look.space.id
```
```
dashboards.space.id = dashboard_elements.look.space.parent_id
```
```
dashboards.space.parent_id = dashboard_elements.look.space.parent_id
```
```
dashboards.space.creator_id = dashboard_elements.look.deleter_id
```
```
dashboards.user_id = dashboard_elements.look.deleter_id
```
```
dashboards.space.creator_id = dashboard_elements.look.folder.creator_id
```
```
dashboards.user_id = dashboard_elements.look.folder.creator_id
```
```
dashboards.space.creator_id = dashboard_elements.look.last_updater_id
```
```
dashboards.user_id = dashboard_elements.look.last_updater_id
```
```
dashboards.space.creator_id = dashboard_elements.look.space.creator_id
```
```
dashboards.user_id = dashboard_elements.look.space.creator_id
```
```
dashboards.space.creator_id = dashboard_elements.look.user.id
```
```
dashboards.user_id = dashboard_elements.look.user.id
```
```
dashboards.space.creator_id = dashboard_elements.look.user_id
```
```
dashboards.user_id = dashboard_elements.look.user_id
``` |
| [folders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#folders) | ```
dashboards.content_favorite_id = folders.dashboards.content_favorite_id
```
```
dashboards.content_favorite_id = folders.looks.content_favorite_id
```
```
dashboards.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
dashboards.folder.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
dashboards.space.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
dashboards.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
dashboards.folder.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
dashboards.space.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
dashboards.content_metadata_id = folders.looks.content_metadata_id
```
```
dashboards.folder.content_metadata_id = folders.looks.content_metadata_id
```
```
dashboards.space.content_metadata_id = folders.looks.content_metadata_id
```
```
dashboards.content_metadata_id = folders.looks.folder.content_metadata_id
```
```
dashboards.folder.content_metadata_id = folders.looks.folder.content_metadata_id
```
```
dashboards.space.content_metadata_id = folders.looks.folder.content_metadata_id
```
```
dashboards.id = folders.dashboards.id
```
```
dashboards.folder.id = folders.id
```
```
dashboards.folder.parent_id = folders.id
```
```
dashboards.folder.id = folders.dashboards.folder.id
```
```
dashboards.folder.parent_id = folders.dashboards.folder.id
```
```
dashboards.folder.id = folders.dashboards.folder.parent_id
```
```
dashboards.folder.parent_id = folders.dashboards.folder.parent_id
```
```
dashboards.folder.id = folders.looks.folder.id
```
```
dashboards.folder.parent_id = folders.looks.folder.id
```
```
dashboards.folder.id = folders.looks.folder.parent_id
```
```
dashboards.folder.parent_id = folders.looks.folder.parent_id
```
```
dashboards.folder.id = folders.parent_id
```
```
dashboards.folder.parent_id = folders.parent_id
```
```
dashboards.model.id = folders.dashboards.model.id
```
```
dashboards.model.id = folders.looks.model.id
```
```
dashboards.space.id = folders.dashboards.space.id
```
```
dashboards.space.parent_id = folders.dashboards.space.id
```
```
dashboards.space.id = folders.dashboards.space.parent_id
```
```
dashboards.space.parent_id = folders.dashboards.space.parent_id
```
```
dashboards.space.id = folders.looks.space.id
```
```
dashboards.space.parent_id = folders.looks.space.id
```
```
dashboards.space.id = folders.looks.space.parent_id
```
```
dashboards.space.parent_id = folders.looks.space.parent_id
```
```
dashboards.space.id = folders.looks.space_id
```
```
dashboards.space.parent_id = folders.looks.space_id
```
```
dashboards.space.creator_id = folders.creator_id
```
```
dashboards.user_id = folders.creator_id
```
```
dashboards.space.creator_id = folders.dashboards.user_id
```
```
dashboards.user_id = folders.dashboards.user_id
```
```
dashboards.space.creator_id = folders.dashboards.folder.creator_id
```
```
dashboards.user_id = folders.dashboards.folder.creator_id
```
```
dashboards.space.creator_id = folders.dashboards.space.creator_id
```
```
dashboards.user_id = folders.dashboards.space.creator_id
```
```
dashboards.space.creator_id = folders.looks.deleter_id
```
```
dashboards.user_id = folders.looks.deleter_id
```
```
dashboards.space.creator_id = folders.looks.last_updater_id
```
```
dashboards.user_id = folders.looks.last_updater_id
```
```
dashboards.space.creator_id = folders.looks.user.id
```
```
dashboards.user_id = folders.looks.user.id
``` |
| [lookml_dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#lookml-dashboards) | ```
dashboards.content_favorite_id = lookml_dashboards.content_favorite_id
```
```
dashboards.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
dashboards.folder.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
dashboards.space.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
dashboards.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
dashboards.folder.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
dashboards.space.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
dashboards.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
dashboards.folder.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
dashboards.space.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
dashboards.folder.id = lookml_dashboards.folder.id
```
```
dashboards.folder.parent_id = lookml_dashboards.folder.id
```
```
dashboards.folder.id = lookml_dashboards.folder.parent_id
```
```
dashboards.folder.parent_id = lookml_dashboards.folder.parent_id
```
```
dashboards.model.id = lookml_dashboards.model.id
```
```
dashboards.space.id = lookml_dashboards.space.id
```
```
dashboards.space.parent_id = lookml_dashboards.space.id
```
```
dashboards.space.id = lookml_dashboards.space.parent_id
```
```
dashboards.space.parent_id = lookml_dashboards.space.parent_id
```
```
dashboards.space.creator_id = lookml_dashboards.folder.creator_id
```
```
dashboards.user_id = lookml_dashboards.folder.creator_id
```
```
dashboards.space.creator_id = lookml_dashboards.space.creator_id
```
```
dashboards.user_id = lookml_dashboards.space.creator_id
```
```
dashboards.space.creator_id = lookml_dashboards.user_id
```
```
dashboards.user_id = lookml_dashboards.user_id
``` |
| [looks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#looks) | ```
dashboards.content_favorite_id = looks.content_favorite_id
```
```
dashboards.content_metadata_id = looks.content_metadata_id
```
```
dashboards.folder.content_metadata_id = looks.content_metadata_id
```
```
dashboards.space.content_metadata_id = looks.content_metadata_id
```
```
dashboards.folder.id = looks.folder.id
```
```
dashboards.folder.parent_id = looks.folder.id
```
```
dashboards.folder.id = looks.folder_id
```
```
dashboards.folder.parent_id = looks.folder_id
```
```
dashboards.folder.id = looks.folder.parent_id
```
```
dashboards.folder.parent_id = looks.folder.parent_id
```
```
dashboards.model.id = looks.model.id
```
```
dashboards.space.id = looks.space.id
```
```
dashboards.space.parent_id = looks.space.id
```
```
dashboards.space.id = looks.space.parent_id
```
```
dashboards.space.parent_id = looks.space.parent_id
```
```
dashboards.space.id = looks.space_id
```
```
dashboards.space.parent_id = looks.space_id
```
```
dashboards.space.creator_id = looks.deleter_id
```
```
dashboards.user_id = looks.deleter_id
```
```
dashboards.space.creator_id = looks.folder.creator_id
```
```
dashboards.user_id = looks.folder.creator_id
```
```
dashboards.space.creator_id = looks.user.id
```
```
dashboards.user_id = looks.user.id
```
```
dashboards.space.creator_id = looks.user_id
```
```
dashboards.user_id = looks.user_id
``` |
| [content_metadata](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata) | ```
dashboards.content_metadata_id = content_metadata.id
```
```
dashboards.folder.content_metadata_id = content_metadata.id
```
```
dashboards.space.content_metadata_id = content_metadata.id
```
```
dashboards.content_metadata_id = content_metadata.parent_id
```
```
dashboards.folder.content_metadata_id = content_metadata.parent_id
```
```
dashboards.space.content_metadata_id = content_metadata.parent_id
```
```
dashboards.id = content_metadata.dashboard_id
```
```
dashboards.space.id = content_metadata.space_id
```
```
dashboards.space.parent_id = content_metadata.space_id
``` |
| [content_metadata_access](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata-access) | ```
dashboards.content_metadata_id = content_metadata_access.content_metadata_id
```
```
dashboards.folder.content_metadata_id = content_metadata_access.content_metadata_id
```
```
dashboards.space.content_metadata_id = content_metadata_access.content_metadata_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
dashboards.content_metadata_id = content_views.content_metadata_id
```
```
dashboards.folder.content_metadata_id = content_views.content_metadata_id
```
```
dashboards.space.content_metadata_id = content_views.content_metadata_id
```
```
dashboards.id = content_views.dashboard_id
```
```
dashboards.space.creator_id = content_views.user_id
```
```
dashboards.user_id = content_views.user_id
``` |
| [dashboard_filters](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-filters) | ```
dashboards.id = dashboard_filters.dashboard_id
``` |
| [dashboard_layouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-layouts) | ```
dashboards.id = dashboard_layouts.dashboard_id
``` |
| [scheduled_plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#scheduled-plans) | ```
dashboards.id = scheduled_plans.dashboard_id
```
```
dashboards.space.creator_id = scheduled_plans.user.id
```
```
dashboards.user_id = scheduled_plans.user.id
```
```
dashboards.space.creator_id = scheduled_plans.user_id
```
```
dashboards.user_id = scheduled_plans.user_id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
dashboards.folder.id = users.home_folder_id
```
```
dashboards.folder.parent_id = users.home_folder_id
```
```
dashboards.folder.id = users.personal_folder_id
```
```
dashboards.folder.parent_id = users.personal_folder_id
```
```
dashboards.space.id = users.home_space_id
```
```
dashboards.space.parent_id = users.home_space_id
```
```
dashboards.space.id = users.personal_space_id
```
```
dashboards.space.parent_id = users.personal_space_id
```
```
dashboards.space.creator_id = users.id
```
```
dashboards.user_id = users.id
``` |
| [roles](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#roles) | ```
dashboards.model.id = roles.model_set.models
``` |
| [connections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#connections) | ```
dashboards.space.creator_id = connections.user_id
```
```
dashboards.user_id = connections.user_id
``` |
| [user_login_lockouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-login-lockouts) | ```
dashboards.space.creator_id = user_login_lockouts.user_id
```
```
dashboards.user_id = user_login_lockouts.user_id
``` |
dashboards table schema
| **content\_favorite\_id**
STRING |
| --- |
| **content\_metadata\_id**
STRING |
| **description**
STRING |
| **folder**
OBJECT
This is a nested data structure:
- child_count: INTEGER
- content_metadata_id: STRING
- creator_id: STRING
- external_id: STRING
- id: STRING
- is_embed: BOOLEAN
- is_embed_shared_root: BOOLEAN
- is_embed_users_root: BOOLEAN
- is_personal: BOOLEAN
- is_personal_descendant: BOOLEAN
- is_shared_root: BOOLEAN
- is_users_root: BOOLEAN
- name: STRING
- parent_id: STRING
|
| **hidden**
BOOLEAN |
| **id**
STRING |
| **model**
OBJECT
This is a nested data structure:
|
| **query\_timezone**
STRING |
| **readonly**
BOOLEAN |
| **refresh\_interval**
STRING |
| **refresh\_interval\_to\_i**
INTEGER |
| **space**
OBJECT
This is a nested data structure:
- child_count: INTEGER
- content_metadata_id: STRING
- creator_id: STRING
- external_id: STRING
- id: STRING
- is_embed: BOOLEAN
- is_embed_shared_root: BOOLEAN
- is_embed_users_root: BOOLEAN
- is_personal: BOOLEAN
- is_personal_descendant: BOOLEAN
- is_shared_root: BOOLEAN
- is_users_root: BOOLEAN
- name: STRING
- parent_id: STRING
|
| **title**
STRING |
| **user\_id**
STRING |
### datagroups
The `datagroups` table contains information about all datagroups in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/datagroup#get_all_datagroups "Opens in new tab: Looker API method") |
datagroups table schema
| **created\_at**
INTEGER |
| --- |
| **id**
STRING |
| **model\_name**
STRING |
| **name**
STRING |
| **stale\_before**
INTEGER |
| **trigger\_check\_at**
INTEGER |
| **trigger\_error**
STRING |
| **trigger\_value**
STRING |
| **triggered\_at**
INTEGER |
### explores
The `explores` table contains information about LookML model explores in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/lookml-model#get_lookml_model_explore "Opens in new tab: Looker API method") |
explores table schema
| **access\_filter\_fields**
ARRAY
This is a nested data structure. |
| --- |
| **access\_filters**
ARRAY
This is a nested data structure:
- field: STRING
- user_attribute: STRING
|
| **aliases**
ARRAY
This is a nested data structure:
- name: STRING
- value: STRING
|
| **always\_filter**
ARRAY
This is a nested data structure:
- name: STRING
- value: STRING
|
| **can\_explain**
BOOLEAN |
| **can\_pivot\_in\_db**
BOOLEAN |
| **can\_save**
BOOLEAN |
| **can\_subtotal**
BOOLEAN |
| **can\_total**
BOOLEAN |
| **conditionally\_filter**
ARRAY
This is a nested data structure:
- name: STRING
- value: STRING
|
| **connection\_name**
STRING |
| **description**
STRING |
| **errors**
ARRAY
This is a nested data structure:
- details: ANY
- error_pos: STRING
- field_error: BOOLEAN
- message: STRING
|
| **fields**
OBJECT
This is a nested data structure:
- dimensions: ARRAY, which is also a nested data structure.
- align: STRING
- can_filter: BOOLEAN
- can_time_filter: BOOLEAN
- category: STRING
- default_filter_value: STRING
- description: STRING
- dynamic: BOOLEAN
- enumerations: ARRAY, which is also a nested data structure.
- label: STRING
- value: STRING
- error: STRING
- field_group_label: STRING
- field_group_variant: STRING
- fill_style: STRING
- fiscal_month_offset: INTEGER
- has_allowed_values: BOOLEAN
- hidden: BOOLEAN
- is_filter: BOOLEAN
- is_fiscal: BOOLEAN
- is_numeric: BOOLEAN
- is_timeframe: BOOLEAN
- label: STRING
- label_from_parameter: STRING
- label_short: STRING
- lookml_link: STRING
- map_layer: OBJECT, which is also a nested data structure.
- extents_json_url: STRING
- feature_key: STRING
- format: STRING
- max_zoom_level: INTEGER
- min_zoom_level: INTEGER
- name: STRING
- projection: STRING
- property_key: STRING
- property_label_key: STRING
- url: STRING
- measure: BOOLEAN
- name: STRING
- parameter: BOOLEAN
- permanent: BOOLEAN
- primary_key: BOOLEAN
- project_name: STRING
- requires_refresh_on_sort: BOOLEAN
- scope: STRING
- sortable: BOOLEAN
- source_file: STRING
- source_file_path: STRING
- sql: STRING
- sql_case: ARRAY, which is also a nested data structure.
- condition: STRING
- value: STRING
- strict_value_format: BOOLEAN
- suggest_dimension: STRING
- suggest_explore: STRING
- suggestable: BOOLEAN
- suggestions: ARRAY, which is also a nested data structure.
- tags: ARRAY, which is also a nested data structure.
- time_interval: OBJECT, which is also a nested data structure.
- count: STRING
- name: STRING
- type: STRING
- user_attribute_filter_types: ARRAY, which is also a nested data structure.
- value_format: STRING
- view: STRING
- view_label: STRING
- week_start_day: STRING
- filters: ARRAY, which is also a nested data structure.
- align: STRING
- can_filter: BOOLEAN
- can_time_filter: BOOLEAN
- category: STRING
- default_filter_value: STRING
- description: STRING
- dynamic: BOOLEAN
- enumerations: ARRAY, which is also a nested data structure.
- label: STRING
- value: STRING
- error: STRING
- field_group_label: STRING
- field_group_variant: STRING
- fill_style: STRING
- fiscal_month_offset: INTEGER
- has_allowed_values: BOOLEAN
- hidden: BOOLEAN
- is_filter: BOOLEAN
- is_fiscal: BOOLEAN
- is_numeric: BOOLEAN
- is_timeframe: BOOLEAN
- label: STRING
- label_from_parameter: STRING
- label_short: STRING
- lookml_link: STRING
- map_layer: OBJECT, which is also a nested data structure.
- extents_json_url: STRING
- feature_key: STRING
- format: STRING
- max_zoom_level: INTEGER
- min_zoom_level: INTEGER
- name: STRING
- projection: STRING
- property_key: STRING
- property_label_key: STRING
- url: STRING
- measure: BOOLEAN
- name: STRING
- parameter: BOOLEAN
- permanent: BOOLEAN
- primary_key: BOOLEAN
- project_name: STRING
- requires_refresh_on_sort: BOOLEAN
- scope: STRING
- sortable: BOOLEAN
- source_file: STRING
- source_file_path: STRING
- sql: STRING
- sql_case: ARRAY, which is also a nested data structure.
- condition: STRING
- value: STRING
- strict_value_format: BOOLEAN
- suggest_dimension: STRING
- suggest_explore: STRING
- suggestable: BOOLEAN
- suggestions: ARRAY, which is also a nested data structure.
- tags: ARRAY, which is also a nested data structure.
- time_interval: OBJECT, which is also a nested data structure.
- count: STRING
- name: STRING
- type: STRING
- user_attribute_filter_types: ARRAY, which is also a nested data structure.
- value_format: STRING
- view: STRING
- view_label: STRING
- week_start_day: STRING
- measures: ARRAY, which is also a nested data structure.
- align: STRING
- can_filter: BOOLEAN
- can_time_filter: BOOLEAN
- category: STRING
- default_filter_value: STRING
- description: STRING
- dynamic: BOOLEAN
- enumerations: ARRAY, which is also a nested data structure.
- label: STRING
- value: STRING
- error: STRING
- field_group_label: STRING
- field_group_variant: STRING
- fill_style: STRING
- fiscal_month_offset: INTEGER
- has_allowed_values: BOOLEAN
- hidden: BOOLEAN
- is_filter: BOOLEAN
- is_fiscal: BOOLEAN
- is_numeric: BOOLEAN
- is_timeframe: BOOLEAN
- label: STRING
- label_from_parameter: STRING
- label_short: STRING
- lookml_link: STRING
- map_layer: OBJECT, which is also a nested data structure.
- extents_json_url: STRING
- feature_key: STRING
- format: STRING
- max_zoom_level: INTEGER
- min_zoom_level: INTEGER
- name: STRING
- projection: STRING
- property_key: STRING
- property_label_key: STRING
- url: STRING
- measure: BOOLEAN
- name: STRING
- parameter: BOOLEAN
- permanent: BOOLEAN
- primary_key: BOOLEAN
- project_name: STRING
- requires_refresh_on_sort: BOOLEAN
- scope: STRING
- sortable: BOOLEAN
- source_file: STRING
- source_file_path: STRING
- sql: STRING
- sql_case: ARRAY, which is also a nested data structure.
- condition: STRING
- value: STRING
- strict_value_format: BOOLEAN
- suggest_dimension: STRING
- suggest_explore: STRING
- suggestable: BOOLEAN
- suggestions: ARRAY, which is also a nested data structure.
- tags: ARRAY, which is also a nested data structure.
- time_interval: OBJECT, which is also a nested data structure.
- count: STRING
- name: STRING
- type: STRING
- user_attribute_filter_types: ARRAY, which is also a nested data structure.
- value_format: STRING
- view: STRING
- view_label: STRING
- week_start_day: STRING
- parameters: ARRAY, which is also a nested data structure.
- align: STRING
- can_filter: BOOLEAN
- can_time_filter: BOOLEAN
- category: STRING
- default_filter_value: STRING
- description: STRING
- dynamic: BOOLEAN
- enumerations: ARRAY, which is also a nested data structure.
- label: STRING
- value: STRING
- error: STRING
- field_group_label: STRING
- field_group_variant: STRING
- fill_style: STRING
- fiscal_month_offset: INTEGER
- has_allowed_values: BOOLEAN
- hidden: BOOLEAN
- is_filter: BOOLEAN
- is_fiscal: BOOLEAN
- is_numeric: BOOLEAN
- is_timeframe: BOOLEAN
- label: STRING
- label_from_parameter: STRING
- label_short: STRING
- lookml_link: STRING
- map_layer: OBJECT, which is also a nested data structure.
- extents_json_url: STRING
- feature_key: STRING
- format: STRING
- max_zoom_level: INTEGER
- min_zoom_level: INTEGER
- name: STRING
- projection: STRING
- property_key: STRING
- property_label_key: STRING
- url: STRING
- measure: BOOLEAN
- name: STRING
- parameter: BOOLEAN
- permanent: BOOLEAN
- primary_key: BOOLEAN
- project_name: STRING
- requires_refresh_on_sort: BOOLEAN
- scope: STRING
- sortable: BOOLEAN
- source_file: STRING
- source_file_path: STRING
- sql: STRING
- sql_case: ARRAY, which is also a nested data structure.
- condition: STRING
- value: STRING
- strict_value_format: BOOLEAN
- suggest_dimension: STRING
- suggest_explore: STRING
- suggestable: BOOLEAN
- suggestions: ARRAY, which is also a nested data structure.
- tags: ARRAY, which is also a nested data structure.
- time_interval: OBJECT, which is also a nested data structure.
- count: STRING
- name: STRING
- type: STRING
- user_attribute_filter_types: ARRAY, which is also a nested data structure.
- value_format: STRING
- view: STRING
- view_label: STRING
- week_start_day: STRING
|
| **files**
ARRAY
This is a nested data structure. |
| **group\_label**
STRING |
| **has\_timezone\_support**
BOOLEAN |
| **hidden**
BOOLEAN |
| **id**
STRING |
| **index\_fields**
ARRAY
This is a nested data structure. |
| **joins**
ARRAY
This is a nested data structure:
- dependent_fields: ARRAY, which is also a nested data structure.
- fields: ARRAY, which is also a nested data structure.
- foreign_key: STRING
- from: STRING
- name: STRING
- outer_only: BOOLEAN
- relationship: STRING
- required_joins: ARRAY, which is also a nested data structure.
- sql_foreign_key: STRING
- sql_on: STRING
- sql_table_name: STRING
- type: STRING
- view_label: STRING
|
| **label**
STRING |
| **model\_name**
STRING |
| **name**
STRING |
| **null\_sort\_treatment**
STRING |
| **project\_name**
STRING |
| **scopes**
ARRAY
This is a nested data structure. |
| **sets**
ARRAY
This is a nested data structure:
- name: STRING
- value: ARRAY, which is also a nested data structure.
|
| **source\_file**
STRING |
| **sql\_table\_name**
STRING |
| **supported\_measure\_types**
ARRAY
This is a nested data structure:
- dimension_type: STRING
- measure_types: ARRAY, which is also a nested data structure.
|
| **supports\_cost\_estimate**
BOOLEAN |
| **tags**
ARRAY
This is a nested data structure. |
| **view\_name**
STRING |
### folders
The `folders` table contains information about all folders in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/folder#get_all_folders "Opens in new tab: Looker API method") |
folders table foreign keys
| Join folders with | on |
| --- | --- |
| [content_favorites](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-favorites) | ```
folders.dashboards.content_favorite_id = content_favorites.id
```
```
folders.looks.content_favorite_id = content_favorites.id
```
```
folders.dashboards.content_favorite_id = content_favorites.dashboard.content_favorite_id
```
```
folders.looks.content_favorite_id = content_favorites.dashboard.content_favorite_id
```
```
folders.dashboards.folder.content_metadata_id = content_favorites.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = content_favorites.content_metadata_id
```
```
folders.looks.content_metadata_id = content_favorites.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = content_favorites.content_metadata_id
```
```
folders.dashboards.folder.content_metadata_id = content_favorites.dashboard.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = content_favorites.dashboard.content_metadata_id
```
```
folders.looks.content_metadata_id = content_favorites.dashboard.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = content_favorites.dashboard.content_metadata_id
```
```
folders.dashboards.folder.content_metadata_id = content_favorites.dashboard.folder.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = content_favorites.dashboard.folder.content_metadata_id
```
```
folders.looks.content_metadata_id = content_favorites.dashboard.folder.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = content_favorites.dashboard.folder.content_metadata_id
```
```
folders.dashboards.folder.content_metadata_id = content_favorites.dashboard.space.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = content_favorites.dashboard.space.content_metadata_id
```
```
folders.looks.content_metadata_id = content_favorites.dashboard.space.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = content_favorites.dashboard.space.content_metadata_id
```
```
folders.dashboards.folder.content_metadata_id = content_favorites.look.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = content_favorites.look.content_metadata_id
```
```
folders.looks.content_metadata_id = content_favorites.look.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = content_favorites.look.content_metadata_id
```
```
folders.dashboards.id = content_favorites.dashboard.id
```
```
folders.dashboards.id = content_favorites.dashboard_id
```
```
folders.id = content_favorites.dashboard.folder.id
```
```
folders.dashboards.folder.id = content_favorites.dashboard.folder.id
```
```
folders.dashboards.folder.parent_id = content_favorites.dashboard.folder.id
```
```
folders.looks.folder.id = content_favorites.dashboard.folder.id
```
```
folders.looks.folder.parent_id = content_favorites.dashboard.folder.id
```
```
folders.parent_id = content_favorites.dashboard.folder.id
```
```
folders.id = content_favorites.dashboard.folder.parent_id
```
```
folders.dashboards.folder.id = content_favorites.dashboard.folder.parent_id
```
```
folders.dashboards.folder.parent_id = content_favorites.dashboard.folder.parent_id
```
```
folders.looks.folder.id = content_favorites.dashboard.folder.parent_id
```
```
folders.looks.folder.parent_id = content_favorites.dashboard.folder.parent_id
```
```
folders.parent_id = content_favorites.dashboard.folder.parent_id
```
```
folders.looks.id = content_favorites.look_id
```
```
folders.looks.id = content_favorites.look.id
```
```
folders.dashboards.model.id = content_favorites.dashboard.model.id
```
```
folders.looks.model.id = content_favorites.dashboard.model.id
```
```
folders.dashboards.space.id = content_favorites.dashboard.space.id
```
```
folders.dashboards.space.parent_id = content_favorites.dashboard.space.id
```
```
folders.looks.space.id = content_favorites.dashboard.space.id
```
```
folders.looks.space.parent_id = content_favorites.dashboard.space.id
```
```
folders.looks.space_id = content_favorites.dashboard.space.id
```
```
folders.dashboards.space.id = content_favorites.dashboard.space.parent_id
```
```
folders.dashboards.space.parent_id = content_favorites.dashboard.space.parent_id
```
```
folders.looks.space.id = content_favorites.dashboard.space.parent_id
```
```
folders.looks.space.parent_id = content_favorites.dashboard.space.parent_id
```
```
folders.looks.space_id = content_favorites.dashboard.space.parent_id
```
```
folders.creator_id = content_favorites.dashboard.folder.creator_id
```
```
folders.dashboards.user_id = content_favorites.dashboard.folder.creator_id
```
```
folders.dashboards.folder.creator_id = content_favorites.dashboard.folder.creator_id
```
```
folders.dashboards.space.creator_id = content_favorites.dashboard.folder.creator_id
```
```
folders.looks.deleter_id = content_favorites.dashboard.folder.creator_id
```
```
folders.looks.last_updater_id = content_favorites.dashboard.folder.creator_id
```
```
folders.looks.user.id = content_favorites.dashboard.folder.creator_id
```
```
folders.creator_id = content_favorites.dashboard.space.creator_id
```
```
folders.dashboards.user_id = content_favorites.dashboard.space.creator_id
```
```
folders.dashboards.folder.creator_id = content_favorites.dashboard.space.creator_id
```
```
folders.dashboards.space.creator_id = content_favorites.dashboard.space.creator_id
```
```
folders.looks.deleter_id = content_favorites.dashboard.space.creator_id
```
```
folders.looks.last_updater_id = content_favorites.dashboard.space.creator_id
```
```
folders.looks.user.id = content_favorites.dashboard.space.creator_id
```
```
folders.creator_id = content_favorites.user_id
```
```
folders.dashboards.user_id = content_favorites.user_id
```
```
folders.dashboards.folder.creator_id = content_favorites.user_id
```
```
folders.dashboards.space.creator_id = content_favorites.user_id
```
```
folders.looks.deleter_id = content_favorites.user_id
```
```
folders.looks.last_updater_id = content_favorites.user_id
```
```
folders.looks.user.id = content_favorites.user_id
``` |
| [dashboard_elements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-elements) | ```
folders.dashboards.content_favorite_id = dashboard_elements.look.content_favorite_id
```
```
folders.looks.content_favorite_id = dashboard_elements.look.content_favorite_id
```
```
folders.dashboards.folder.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
folders.looks.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
folders.dashboards.folder.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
folders.looks.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
folders.dashboards.folder.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
folders.looks.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
folders.dashboards.id = dashboard_elements.dashboard_id
```
```
folders.id = dashboard_elements.look.folder.id
```
```
folders.dashboards.folder.id = dashboard_elements.look.folder.id
```
```
folders.dashboards.folder.parent_id = dashboard_elements.look.folder.id
```
```
folders.looks.folder.id = dashboard_elements.look.folder.id
```
```
folders.looks.folder.parent_id = dashboard_elements.look.folder.id
```
```
folders.parent_id = dashboard_elements.look.folder.id
```
```
folders.id = dashboard_elements.look.folder.parent_id
```
```
folders.dashboards.folder.id = dashboard_elements.look.folder.parent_id
```
```
folders.dashboards.folder.parent_id = dashboard_elements.look.folder.parent_id
```
```
folders.looks.folder.id = dashboard_elements.look.folder.parent_id
```
```
folders.looks.folder.parent_id = dashboard_elements.look.folder.parent_id
```
```
folders.parent_id = dashboard_elements.look.folder.parent_id
```
```
folders.id = dashboard_elements.look.folder_id
```
```
folders.dashboards.folder.id = dashboard_elements.look.folder_id
```
```
folders.dashboards.folder.parent_id = dashboard_elements.look.folder_id
```
```
folders.looks.folder.id = dashboard_elements.look.folder_id
```
```
folders.looks.folder.parent_id = dashboard_elements.look.folder_id
```
```
folders.parent_id = dashboard_elements.look.folder_id
```
```
folders.looks.id = dashboard_elements.look.id
```
```
folders.looks.id = dashboard_elements.look_id
```
```
folders.dashboards.model.id = dashboard_elements.look.model.id
```
```
folders.looks.model.id = dashboard_elements.look.model.id
```
```
folders.looks.query_id = dashboard_elements.look.query.id
```
```
folders.looks.query_id = dashboard_elements.look.query_id
```
```
folders.looks.query_id = dashboard_elements.query.id
```
```
folders.looks.query_id = dashboard_elements.query_id
```
```
folders.looks.query_id = dashboard_elements.result_maker.query.id
```
```
folders.looks.query_id = dashboard_elements.result_maker.query_id
```
```
folders.dashboards.space.id = dashboard_elements.look.space.id
```
```
folders.dashboards.space.parent_id = dashboard_elements.look.space.id
```
```
folders.looks.space.id = dashboard_elements.look.space.id
```
```
folders.looks.space.parent_id = dashboard_elements.look.space.id
```
```
folders.looks.space_id = dashboard_elements.look.space.id
```
```
folders.dashboards.space.id = dashboard_elements.look.space.parent_id
```
```
folders.dashboards.space.parent_id = dashboard_elements.look.space.parent_id
```
```
folders.looks.space.id = dashboard_elements.look.space.parent_id
```
```
folders.looks.space.parent_id = dashboard_elements.look.space.parent_id
```
```
folders.looks.space_id = dashboard_elements.look.space.parent_id
```
```
folders.creator_id = dashboard_elements.look.deleter_id
```
```
folders.dashboards.user_id = dashboard_elements.look.deleter_id
```
```
folders.dashboards.folder.creator_id = dashboard_elements.look.deleter_id
```
```
folders.dashboards.space.creator_id = dashboard_elements.look.deleter_id
```
```
folders.looks.deleter_id = dashboard_elements.look.deleter_id
```
```
folders.looks.last_updater_id = dashboard_elements.look.deleter_id
```
```
folders.looks.user.id = dashboard_elements.look.deleter_id
```
```
folders.creator_id = dashboard_elements.look.folder.creator_id
```
```
folders.dashboards.user_id = dashboard_elements.look.folder.creator_id
```
```
folders.dashboards.folder.creator_id = dashboard_elements.look.folder.creator_id
```
```
folders.dashboards.space.creator_id = dashboard_elements.look.folder.creator_id
```
```
folders.looks.deleter_id = dashboard_elements.look.folder.creator_id
```
```
folders.looks.last_updater_id = dashboard_elements.look.folder.creator_id
```
```
folders.looks.user.id = dashboard_elements.look.folder.creator_id
```
```
folders.creator_id = dashboard_elements.look.last_updater_id
```
```
folders.dashboards.user_id = dashboard_elements.look.last_updater_id
```
```
folders.dashboards.folder.creator_id = dashboard_elements.look.last_updater_id
```
```
folders.dashboards.space.creator_id = dashboard_elements.look.last_updater_id
```
```
folders.looks.deleter_id = dashboard_elements.look.last_updater_id
```
```
folders.looks.last_updater_id = dashboard_elements.look.last_updater_id
```
```
folders.looks.user.id = dashboard_elements.look.last_updater_id
```
```
folders.creator_id = dashboard_elements.look.space.creator_id
```
```
folders.dashboards.user_id = dashboard_elements.look.space.creator_id
```
```
folders.dashboards.folder.creator_id = dashboard_elements.look.space.creator_id
```
```
folders.dashboards.space.creator_id = dashboard_elements.look.space.creator_id
```
```
folders.looks.deleter_id = dashboard_elements.look.space.creator_id
```
```
folders.looks.last_updater_id = dashboard_elements.look.space.creator_id
```
```
folders.looks.user.id = dashboard_elements.look.space.creator_id
```
```
folders.creator_id = dashboard_elements.look.user.id
```
```
folders.dashboards.user_id = dashboard_elements.look.user.id
```
```
folders.dashboards.folder.creator_id = dashboard_elements.look.user.id
```
```
folders.dashboards.space.creator_id = dashboard_elements.look.user.id
```
```
folders.looks.deleter_id = dashboard_elements.look.user.id
```
```
folders.looks.last_updater_id = dashboard_elements.look.user.id
```
```
folders.looks.user.id = dashboard_elements.look.user.id
```
```
folders.creator_id = dashboard_elements.look.user_id
```
```
folders.dashboards.user_id = dashboard_elements.look.user_id
```
```
folders.dashboards.folder.creator_id = dashboard_elements.look.user_id
```
```
folders.dashboards.space.creator_id = dashboard_elements.look.user_id
```
```
folders.looks.deleter_id = dashboard_elements.look.user_id
```
```
folders.looks.last_updater_id = dashboard_elements.look.user_id
```
```
folders.looks.user.id = dashboard_elements.look.user_id
``` |
| [dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboards) | ```
folders.dashboards.content_favorite_id = dashboards.content_favorite_id
```
```
folders.looks.content_favorite_id = dashboards.content_favorite_id
```
```
folders.dashboards.folder.content_metadata_id = dashboards.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = dashboards.content_metadata_id
```
```
folders.looks.content_metadata_id = dashboards.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = dashboards.content_metadata_id
```
```
folders.dashboards.folder.content_metadata_id = dashboards.folder.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = dashboards.folder.content_metadata_id
```
```
folders.looks.content_metadata_id = dashboards.folder.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = dashboards.folder.content_metadata_id
```
```
folders.dashboards.folder.content_metadata_id = dashboards.space.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = dashboards.space.content_metadata_id
```
```
folders.looks.content_metadata_id = dashboards.space.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = dashboards.space.content_metadata_id
```
```
folders.dashboards.id = dashboards.id
```
```
folders.id = dashboards.folder.id
```
```
folders.dashboards.folder.id = dashboards.folder.id
```
```
folders.dashboards.folder.parent_id = dashboards.folder.id
```
```
folders.looks.folder.id = dashboards.folder.id
```
```
folders.looks.folder.parent_id = dashboards.folder.id
```
```
folders.parent_id = dashboards.folder.id
```
```
folders.id = dashboards.folder.parent_id
```
```
folders.dashboards.folder.id = dashboards.folder.parent_id
```
```
folders.dashboards.folder.parent_id = dashboards.folder.parent_id
```
```
folders.looks.folder.id = dashboards.folder.parent_id
```
```
folders.looks.folder.parent_id = dashboards.folder.parent_id
```
```
folders.parent_id = dashboards.folder.parent_id
```
```
folders.dashboards.model.id = dashboards.model.id
```
```
folders.looks.model.id = dashboards.model.id
```
```
folders.dashboards.space.id = dashboards.space.id
```
```
folders.dashboards.space.parent_id = dashboards.space.id
```
```
folders.looks.space.id = dashboards.space.id
```
```
folders.looks.space.parent_id = dashboards.space.id
```
```
folders.looks.space_id = dashboards.space.id
```
```
folders.dashboards.space.id = dashboards.space.parent_id
```
```
folders.dashboards.space.parent_id = dashboards.space.parent_id
```
```
folders.looks.space.id = dashboards.space.parent_id
```
```
folders.looks.space.parent_id = dashboards.space.parent_id
```
```
folders.looks.space_id = dashboards.space.parent_id
```
```
folders.creator_id = dashboards.space.creator_id
```
```
folders.dashboards.user_id = dashboards.space.creator_id
```
```
folders.dashboards.folder.creator_id = dashboards.space.creator_id
```
```
folders.dashboards.space.creator_id = dashboards.space.creator_id
```
```
folders.looks.deleter_id = dashboards.space.creator_id
```
```
folders.looks.last_updater_id = dashboards.space.creator_id
```
```
folders.looks.user.id = dashboards.space.creator_id
```
```
folders.creator_id = dashboards.user_id
```
```
folders.dashboards.user_id = dashboards.user_id
```
```
folders.dashboards.folder.creator_id = dashboards.user_id
```
```
folders.dashboards.space.creator_id = dashboards.user_id
```
```
folders.looks.deleter_id = dashboards.user_id
```
```
folders.looks.last_updater_id = dashboards.user_id
```
```
folders.looks.user.id = dashboards.user_id
``` |
| [lookml_dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#lookml-dashboards) | ```
folders.dashboards.content_favorite_id = lookml_dashboards.content_favorite_id
```
```
folders.looks.content_favorite_id = lookml_dashboards.content_favorite_id
```
```
folders.dashboards.folder.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
folders.looks.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
folders.dashboards.folder.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
folders.looks.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
folders.dashboards.folder.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
folders.looks.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
folders.id = lookml_dashboards.folder.id
```
```
folders.dashboards.folder.id = lookml_dashboards.folder.id
```
```
folders.dashboards.folder.parent_id = lookml_dashboards.folder.id
```
```
folders.looks.folder.id = lookml_dashboards.folder.id
```
```
folders.looks.folder.parent_id = lookml_dashboards.folder.id
```
```
folders.parent_id = lookml_dashboards.folder.id
```
```
folders.id = lookml_dashboards.folder.parent_id
```
```
folders.dashboards.folder.id = lookml_dashboards.folder.parent_id
```
```
folders.dashboards.folder.parent_id = lookml_dashboards.folder.parent_id
```
```
folders.looks.folder.id = lookml_dashboards.folder.parent_id
```
```
folders.looks.folder.parent_id = lookml_dashboards.folder.parent_id
```
```
folders.parent_id = lookml_dashboards.folder.parent_id
```
```
folders.dashboards.model.id = lookml_dashboards.model.id
```
```
folders.looks.model.id = lookml_dashboards.model.id
```
```
folders.dashboards.space.id = lookml_dashboards.space.id
```
```
folders.dashboards.space.parent_id = lookml_dashboards.space.id
```
```
folders.looks.space.id = lookml_dashboards.space.id
```
```
folders.looks.space.parent_id = lookml_dashboards.space.id
```
```
folders.looks.space_id = lookml_dashboards.space.id
```
```
folders.dashboards.space.id = lookml_dashboards.space.parent_id
```
```
folders.dashboards.space.parent_id = lookml_dashboards.space.parent_id
```
```
folders.looks.space.id = lookml_dashboards.space.parent_id
```
```
folders.looks.space.parent_id = lookml_dashboards.space.parent_id
```
```
folders.looks.space_id = lookml_dashboards.space.parent_id
```
```
folders.creator_id = lookml_dashboards.folder.creator_id
```
```
folders.dashboards.user_id = lookml_dashboards.folder.creator_id
```
```
folders.dashboards.folder.creator_id = lookml_dashboards.folder.creator_id
```
```
folders.dashboards.space.creator_id = lookml_dashboards.folder.creator_id
```
```
folders.looks.deleter_id = lookml_dashboards.folder.creator_id
```
```
folders.looks.last_updater_id = lookml_dashboards.folder.creator_id
```
```
folders.looks.user.id = lookml_dashboards.folder.creator_id
```
```
folders.creator_id = lookml_dashboards.space.creator_id
```
```
folders.dashboards.user_id = lookml_dashboards.space.creator_id
```
```
folders.dashboards.folder.creator_id = lookml_dashboards.space.creator_id
```
```
folders.dashboards.space.creator_id = lookml_dashboards.space.creator_id
```
```
folders.looks.deleter_id = lookml_dashboards.space.creator_id
```
```
folders.looks.last_updater_id = lookml_dashboards.space.creator_id
```
```
folders.looks.user.id = lookml_dashboards.space.creator_id
```
```
folders.creator_id = lookml_dashboards.user_id
```
```
folders.dashboards.user_id = lookml_dashboards.user_id
```
```
folders.dashboards.folder.creator_id = lookml_dashboards.user_id
```
```
folders.dashboards.space.creator_id = lookml_dashboards.user_id
```
```
folders.looks.deleter_id = lookml_dashboards.user_id
```
```
folders.looks.last_updater_id = lookml_dashboards.user_id
```
```
folders.looks.user.id = lookml_dashboards.user_id
``` |
| [looks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#looks) | ```
folders.dashboards.content_favorite_id = looks.content_favorite_id
```
```
folders.looks.content_favorite_id = looks.content_favorite_id
```
```
folders.dashboards.folder.content_metadata_id = looks.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = looks.content_metadata_id
```
```
folders.looks.content_metadata_id = looks.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = looks.content_metadata_id
```
```
folders.id = looks.folder.id
```
```
folders.dashboards.folder.id = looks.folder.id
```
```
folders.dashboards.folder.parent_id = looks.folder.id
```
```
folders.looks.folder.id = looks.folder.id
```
```
folders.looks.folder.parent_id = looks.folder.id
```
```
folders.parent_id = looks.folder.id
```
```
folders.id = looks.folder_id
```
```
folders.dashboards.folder.id = looks.folder_id
```
```
folders.dashboards.folder.parent_id = looks.folder_id
```
```
folders.looks.folder.id = looks.folder_id
```
```
folders.looks.folder.parent_id = looks.folder_id
```
```
folders.parent_id = looks.folder_id
```
```
folders.id = looks.folder.parent_id
```
```
folders.dashboards.folder.id = looks.folder.parent_id
```
```
folders.dashboards.folder.parent_id = looks.folder.parent_id
```
```
folders.looks.folder.id = looks.folder.parent_id
```
```
folders.looks.folder.parent_id = looks.folder.parent_id
```
```
folders.parent_id = looks.folder.parent_id
```
```
folders.looks.id = looks.id
```
```
folders.dashboards.model.id = looks.model.id
```
```
folders.looks.model.id = looks.model.id
```
```
folders.looks.query_id = looks.query_id
```
```
folders.dashboards.space.id = looks.space.id
```
```
folders.dashboards.space.parent_id = looks.space.id
```
```
folders.looks.space.id = looks.space.id
```
```
folders.looks.space.parent_id = looks.space.id
```
```
folders.looks.space_id = looks.space.id
```
```
folders.dashboards.space.id = looks.space.parent_id
```
```
folders.dashboards.space.parent_id = looks.space.parent_id
```
```
folders.looks.space.id = looks.space.parent_id
```
```
folders.looks.space.parent_id = looks.space.parent_id
```
```
folders.looks.space_id = looks.space.parent_id
```
```
folders.dashboards.space.id = looks.space_id
```
```
folders.dashboards.space.parent_id = looks.space_id
```
```
folders.looks.space.id = looks.space_id
```
```
folders.looks.space.parent_id = looks.space_id
```
```
folders.looks.space_id = looks.space_id
```
```
folders.creator_id = looks.deleter_id
```
```
folders.dashboards.user_id = looks.deleter_id
```
```
folders.dashboards.folder.creator_id = looks.deleter_id
```
```
folders.dashboards.space.creator_id = looks.deleter_id
```
```
folders.looks.deleter_id = looks.deleter_id
```
```
folders.looks.last_updater_id = looks.deleter_id
```
```
folders.looks.user.id = looks.deleter_id
```
```
folders.creator_id = looks.folder.creator_id
```
```
folders.dashboards.user_id = looks.folder.creator_id
```
```
folders.dashboards.folder.creator_id = looks.folder.creator_id
```
```
folders.dashboards.space.creator_id = looks.folder.creator_id
```
```
folders.looks.deleter_id = looks.folder.creator_id
```
```
folders.looks.last_updater_id = looks.folder.creator_id
```
```
folders.looks.user.id = looks.folder.creator_id
```
```
folders.creator_id = looks.user.id
```
```
folders.dashboards.user_id = looks.user.id
```
```
folders.dashboards.folder.creator_id = looks.user.id
```
```
folders.dashboards.space.creator_id = looks.user.id
```
```
folders.looks.deleter_id = looks.user.id
```
```
folders.looks.last_updater_id = looks.user.id
```
```
folders.looks.user.id = looks.user.id
```
```
folders.creator_id = looks.user_id
```
```
folders.dashboards.user_id = looks.user_id
```
```
folders.dashboards.folder.creator_id = looks.user_id
```
```
folders.dashboards.space.creator_id = looks.user_id
```
```
folders.looks.deleter_id = looks.user_id
```
```
folders.looks.last_updater_id = looks.user_id
```
```
folders.looks.user.id = looks.user_id
``` |
| [content_metadata](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata) | ```
folders.dashboards.folder.content_metadata_id = content_metadata.id
```
```
folders.dashboards.space.content_metadata_id = content_metadata.id
```
```
folders.looks.content_metadata_id = content_metadata.id
```
```
folders.looks.folder.content_metadata_id = content_metadata.id
```
```
folders.dashboards.folder.content_metadata_id = content_metadata.parent_id
```
```
folders.dashboards.space.content_metadata_id = content_metadata.parent_id
```
```
folders.looks.content_metadata_id = content_metadata.parent_id
```
```
folders.looks.folder.content_metadata_id = content_metadata.parent_id
```
```
folders.dashboards.id = content_metadata.dashboard_id
```
```
folders.looks.id = content_metadata.look_id
```
```
folders.dashboards.space.id = content_metadata.space_id
```
```
folders.dashboards.space.parent_id = content_metadata.space_id
```
```
folders.looks.space.id = content_metadata.space_id
```
```
folders.looks.space.parent_id = content_metadata.space_id
```
```
folders.looks.space_id = content_metadata.space_id
``` |
| [content_metadata_access](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata-access) | ```
folders.dashboards.folder.content_metadata_id = content_metadata_access.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = content_metadata_access.content_metadata_id
```
```
folders.looks.content_metadata_id = content_metadata_access.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = content_metadata_access.content_metadata_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
folders.dashboards.folder.content_metadata_id = content_views.content_metadata_id
```
```
folders.dashboards.space.content_metadata_id = content_views.content_metadata_id
```
```
folders.looks.content_metadata_id = content_views.content_metadata_id
```
```
folders.looks.folder.content_metadata_id = content_views.content_metadata_id
```
```
folders.dashboards.id = content_views.dashboard_id
```
```
folders.looks.id = content_views.look_id
```
```
folders.creator_id = content_views.user_id
```
```
folders.dashboards.user_id = content_views.user_id
```
```
folders.dashboards.folder.creator_id = content_views.user_id
```
```
folders.dashboards.space.creator_id = content_views.user_id
```
```
folders.looks.deleter_id = content_views.user_id
```
```
folders.looks.last_updater_id = content_views.user_id
```
```
folders.looks.user.id = content_views.user_id
``` |
| [dashboard_filters](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-filters) | ```
folders.dashboards.id = dashboard_filters.dashboard_id
``` |
| [dashboard_layouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-layouts) | ```
folders.dashboards.id = dashboard_layouts.dashboard_id
``` |
| [scheduled_plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#scheduled-plans) | ```
folders.dashboards.id = scheduled_plans.dashboard_id
```
```
folders.looks.id = scheduled_plans.look_id
```
```
folders.looks.query_id = scheduled_plans.query_id
```
```
folders.creator_id = scheduled_plans.user.id
```
```
folders.dashboards.user_id = scheduled_plans.user.id
```
```
folders.dashboards.folder.creator_id = scheduled_plans.user.id
```
```
folders.dashboards.space.creator_id = scheduled_plans.user.id
```
```
folders.looks.deleter_id = scheduled_plans.user.id
```
```
folders.looks.last_updater_id = scheduled_plans.user.id
```
```
folders.looks.user.id = scheduled_plans.user.id
```
```
folders.creator_id = scheduled_plans.user_id
```
```
folders.dashboards.user_id = scheduled_plans.user_id
```
```
folders.dashboards.folder.creator_id = scheduled_plans.user_id
```
```
folders.dashboards.space.creator_id = scheduled_plans.user_id
```
```
folders.looks.deleter_id = scheduled_plans.user_id
```
```
folders.looks.last_updater_id = scheduled_plans.user_id
```
```
folders.looks.user.id = scheduled_plans.user_id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
folders.id = users.home_folder_id
```
```
folders.dashboards.folder.id = users.home_folder_id
```
```
folders.dashboards.folder.parent_id = users.home_folder_id
```
```
folders.looks.folder.id = users.home_folder_id
```
```
folders.looks.folder.parent_id = users.home_folder_id
```
```
folders.parent_id = users.home_folder_id
```
```
folders.id = users.personal_folder_id
```
```
folders.dashboards.folder.id = users.personal_folder_id
```
```
folders.dashboards.folder.parent_id = users.personal_folder_id
```
```
folders.looks.folder.id = users.personal_folder_id
```
```
folders.looks.folder.parent_id = users.personal_folder_id
```
```
folders.parent_id = users.personal_folder_id
```
```
folders.dashboards.space.id = users.home_space_id
```
```
folders.dashboards.space.parent_id = users.home_space_id
```
```
folders.looks.space.id = users.home_space_id
```
```
folders.looks.space.parent_id = users.home_space_id
```
```
folders.looks.space_id = users.home_space_id
```
```
folders.dashboards.space.id = users.personal_space_id
```
```
folders.dashboards.space.parent_id = users.personal_space_id
```
```
folders.looks.space.id = users.personal_space_id
```
```
folders.looks.space.parent_id = users.personal_space_id
```
```
folders.looks.space_id = users.personal_space_id
```
```
folders.creator_id = users.id
```
```
folders.dashboards.user_id = users.id
```
```
folders.dashboards.folder.creator_id = users.id
```
```
folders.dashboards.space.creator_id = users.id
```
```
folders.looks.deleter_id = users.id
```
```
folders.looks.last_updater_id = users.id
```
```
folders.looks.user.id = users.id
``` |
| [roles](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#roles) | ```
folders.dashboards.model.id = roles.model_set.models
```
```
folders.looks.model.id = roles.model_set.models
``` |
| [queries](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#queries) | ```
folders.looks.query_id = queries.id
``` |
| [connections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#connections) | ```
folders.creator_id = connections.user_id
```
```
folders.dashboards.user_id = connections.user_id
```
```
folders.dashboards.folder.creator_id = connections.user_id
```
```
folders.dashboards.space.creator_id = connections.user_id
```
```
folders.looks.deleter_id = connections.user_id
```
```
folders.looks.last_updater_id = connections.user_id
```
```
folders.looks.user.id = connections.user_id
``` |
| [user_login_lockouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-login-lockouts) | ```
folders.creator_id = user_login_lockouts.user_id
```
```
folders.dashboards.user_id = user_login_lockouts.user_id
```
```
folders.dashboards.folder.creator_id = user_login_lockouts.user_id
```
```
folders.dashboards.space.creator_id = user_login_lockouts.user_id
```
```
folders.looks.deleter_id = user_login_lockouts.user_id
```
```
folders.looks.last_updater_id = user_login_lockouts.user_id
```
```
folders.looks.user.id = user_login_lockouts.user_id
``` |
folders table schema
| **child\_count**
INTEGER |
| --- |
| **content\_metadata\_id**
STRING |
| **creator\_id**
STRING |
| **dashboards**
ARRAY
This is a nested data structure:
- content_favorite_id: STRING
- content_metadata_id: STRING
- description: STRING
- folder: OBJECT, which is also a nested data structure.
- child_count: INTEGER
- content_metadata_id: STRING
- creator_id: STRING
- external_id: STRING
- id: STRING
- is_embed: BOOLEAN
- is_embed_shared_root: BOOLEAN
- is_embed_users_root: BOOLEAN
- is_personal: BOOLEAN
- is_personal_descendant: BOOLEAN
- is_shared_root: BOOLEAN
- is_users_root: BOOLEAN
- name: STRING
- parent_id: STRING
- hidden: BOOLEAN
- id: STRING
- model: OBJECT, which is also a nested data structure.
- query_timezone: STRING
- readonly: BOOLEAN
- refresh_interval: STRING
- refresh_interval_to_i: INTEGER
- space: OBJECT, which is also a nested data structure.
- child_count: INTEGER
- content_metadata_id: STRING
- creator_id: STRING
- external_id: STRING
- id: STRING
- is_embed: BOOLEAN
- is_embed_shared_root: BOOLEAN
- is_embed_users_root: BOOLEAN
- is_personal: BOOLEAN
- is_personal_descendant: BOOLEAN
- is_shared_root: BOOLEAN
- is_users_root: BOOLEAN
- name: STRING
- parent_id: STRING
- title: STRING
- user_id: STRING
|
| **external\_id**
STRING |
| **id**
STRING |
| **is\_embed**
BOOLEAN |
| **is\_embed\_shared\_root**
BOOLEAN |
| **is\_embed\_users\_root**
BOOLEAN |
| **is\_personal**
BOOLEAN |
| **is\_personal\_descendant**
BOOLEAN |
| **is\_shared\_root**
BOOLEAN |
| **is\_users\_root**
BOOLEAN |
| **looks**
ARRAY
This is a nested data structure:
- content_favorite_id: STRING
- content_metadata_id: STRING
- created_at: DATE-TIME
- dashboards: ARRAY, which is also a nested data structure.
- content_favorite_id: STRING
- content_metadata_id: STRING
- description: STRING
- folder: OBJECT, which is also a nested data structure.
- child_count: INTEGER
- content_metadata_id: STRING
- creator_id: STRING
- external_id: STRING
- id: STRING
- is_embed: BOOLEAN
- is_embed_shared_root: BOOLEAN
- is_embed_users_root: BOOLEAN
- is_personal: BOOLEAN
- is_personal_descendant: BOOLEAN
- is_shared_root: BOOLEAN
- is_users_root: BOOLEAN
- name: STRING
- parent_id: STRING
- hidden: BOOLEAN
- id: STRING
- model: OBJECT, which is also a nested data structure.
- query_timezone: STRING
- readonly: BOOLEAN
- refresh_interval: STRING
- refresh_interval_to_i: INTEGER
- space: OBJECT, which is also a nested data structure.
- child_count: INTEGER
- content_metadata_id: STRING
- creator_id: STRING
- external_id: STRING
- id: STRING
- is_embed: BOOLEAN
- is_embed_shared_root: BOOLEAN
- is_embed_users_root: BOOLEAN
- is_personal: BOOLEAN
- is_personal_descendant: BOOLEAN
- is_shared_root: BOOLEAN
- is_users_root: BOOLEAN
- name: STRING
- parent_id: STRING
- title: STRING
- user_id: STRING
- deleted: BOOLEAN
- deleted_at: DATE-TIME
- deleter_id: STRING
- description: STRING
- embed_url: STRING
- excel_file_url: STRING
- favorite_count: INTEGER
- folder: OBJECT, which is also a nested data structure.
- child_count: INTEGER
- content_metadata_id: STRING
- creator_id: STRING
- external_id: STRING
- id: STRING
- is_embed: BOOLEAN
- is_embed_shared_root: BOOLEAN
- is_embed_users_root: BOOLEAN
- is_personal: BOOLEAN
- is_personal_descendant: BOOLEAN
- is_shared_root: BOOLEAN
- is_users_root: BOOLEAN
- name: STRING
- parent_id: STRING
- folder_id: STRING
- google_spreadsheet_formula: STRING
- id: STRING
- image_embed_url: STRING
- is_run_on_load: BOOLEAN
- last_accessed_at: DATE-TIME
- last_updater_id: STRING
- last_viewed_at: DATE-TIME
- model: OBJECT, which is also a nested data structure.
- public: BOOLEAN
- public_slug: STRING
- public_url: STRING
- query_id: STRING
- short_url: STRING
- space: OBJECT, which is also a nested data structure.
- child_count: INTEGER
- content_metadata_id: STRING
- creator_id: STRING
- external_id: STRING
- id: STRING
- is_embed: BOOLEAN
- is_embed_shared_root: BOOLEAN
- is_embed_users_root: BOOLEAN
- is_personal: BOOLEAN
- is_personal_descendant: BOOLEAN
- is_shared_root: BOOLEAN
- is_users_root: BOOLEAN
- name: STRING
- parent_id: STRING
- space_id: STRING
- title: STRING
- updated_at: DATE-TIME
- user: OBJECT, which is also a nested data structure.
- user_id: STRING
- view_count: INTEGER
|
| **name**
STRING |
| **parent\_id**
STRING |
### git\_branches
The `git_branches` table contains info about the git branches associated with projects in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Keys** | name
project\_id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/project#get_all_git_branches "Opens in new tab: Looker API method") |
git\_branches table foreign keys
| Join git\_branches with | on |
| --- | --- |
| [project_files](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#project-files) | ```
git_branches.project_id = project_files.project_id
``` |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#projects) | ```
git_branches.project_id = projects.id
``` |
| [workspaces](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#workspaces) | ```
git_branches.project_id = workspaces.projects.id
``` |
git\_branches table schema
| **ahead\_count**
INTEGER |
| --- |
| **behind\_count**
INTEGER |
| **commit\_at**
INTEGER |
| **error**
STRING |
| **is\_local**
BOOLEAN |
| **is\_production**
BOOLEAN |
| **is\_remote**
BOOLEAN |
| **message**
STRING |
| **name**
STRING |
| **owner\_name**
STRING |
| **personal**
BOOLEAN |
| **project\_id**
STRING |
| **readonly**
BOOLEAN |
| **ref**
STRING |
| **remote**
STRING |
| **remote\_name**
STRING |
| **remote\_ref**
STRING |
### groups
The `groups` table contains information about all groups in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/group#get_all_groups "Opens in new tab: Looker API method") |
groups table foreign keys
| Join groups with | on |
| --- | --- |
| [content_metadata_access](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata-access) | ```
groups.id = content_metadata_access.group_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
groups.id = content_views.group_id
``` |
| [groups_in_group](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#groups-in-group) | ```
groups.id = groups_in_group.id
```
```
groups.id = groups_in_group.parent_group_id
``` |
| [user_attribute_group_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-attribute-group-values) | ```
groups.id = user_attribute_group_values.group_id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
groups.id = users.group_ids
``` |
groups table schema
| **can\_add\_to\_content\_metadata**
BOOLEAN |
| --- |
| **contains\_current\_user**
BOOLEAN |
| **external\_group\_id**
STRING |
| **externally\_managed**
BOOLEAN |
| **id**
STRING |
| **include\_by\_default**
BOOLEAN |
| **name**
STRING |
| **user\_count**
INTEGER |
### groups\_in\_group
The `groups_in_group` table contains info about the groups contained within groups in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/group#get_all_groups_in_group "Opens in new tab: Looker API method") |
groups\_in\_group table foreign keys
| Join groups\_in\_group with | on |
| --- | --- |
| [content_metadata_access](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata-access) | ```
groups_in_group.id = content_metadata_access.group_id
```
```
groups_in_group.parent_group_id = content_metadata_access.group_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
groups_in_group.id = content_views.group_id
```
```
groups_in_group.parent_group_id = content_views.group_id
``` |
| [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#groups) | ```
groups_in_group.id = groups.id
```
```
groups_in_group.parent_group_id = groups.id
``` |
| [user_attribute_group_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-attribute-group-values) | ```
groups_in_group.id = user_attribute_group_values.group_id
```
```
groups_in_group.parent_group_id = user_attribute_group_values.group_id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
groups_in_group.id = users.group_ids
```
```
groups_in_group.parent_group_id = users.group_ids
``` |
groups\_in\_group table schema
| **can\_add\_to\_content\_metadata**
BOOLEAN |
| --- |
| **contains\_current\_user**
BOOLEAN |
| **external\_group\_id**
STRING |
| **externally\_managed**
BOOLEAN |
| **id**
STRING |
| **include\_by\_default**
BOOLEAN |
| **name**
STRING |
| **parent\_group\_id**
STRING |
| **user\_count**
INTEGER |
### integration\_hubs
The `integration_hubs` table contains information about Integration Hubs in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/integration#get_all_integration_hubs "Opens in new tab: Looker API method") |
integration\_hubs table foreign keys
| Join integration\_hubs with | on |
| --- | --- |
| [integrations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#integrations) | ```
integration_hubs.id = integrations.integration_hub_id
``` |
integration\_hubs table schema
| **authorization\_token**
STRING |
| --- |
| **fetch\_error\_message**
STRING |
| **has\_authorization\_token**
BOOLEAN |
| **id**
STRING |
| **label**
STRING |
| **legal\_agreement\_required**
BOOLEAN |
| **legal\_agreement\_signed**
BOOLEAN |
| **legal\_agreement\_text**
STRING |
| **official**
BOOLEAN |
| **url**
STRING |
### integrations
The `integrations` table contains information about all integrations in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/integration#get_all_integrations "Opens in new tab: Looker API method") |
integrations table foreign keys
| Join integrations with | on |
| --- | --- |
| [integration_hubs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#integration-hubs) | ```
integrations.integration_hub_id = integration_hubs.id
``` |
integrations table schema
| **delegate\_oauth**
BOOLEAN |
| --- |
| **description**
STRING |
| **enabled**
BOOLEAN |
| **icon\_url**
STRING |
| **id**
STRING |
| **installed\_delegate\_oauth**
STRING |
| **integration\_hub\_id**
STRING |
| **label**
STRING |
| **params**
ARRAY
This is a nested data structure:
- delegate_oauth_url: STRING
- description: STRING
- has_value: BOOLEAN
- label: STRING
- name: STRING
- per_user: BOOLEAN
- required: BOOLEAN
- sensitive: BOOLEAN
- user_attribute_name: STRING
- value: STRING
|
| **required\_fields**
ARRAY
This is a nested data structure:
- all_tags: ARRAY, which is also a nested data structure.
- any_tag: ARRAY, which is also a nested data structure.
- tag: STRING
|
| **supported\_action\_types**
ARRAY
This is a nested data structure. |
| **supported\_download\_settings**
ARRAY
This is a nested data structure. |
| **supported\_formats**
ARRAY
This is a nested data structure. |
| **supported\_formattings**
ARRAY
This is a nested data structure. |
| **supported\_visualization\_formattings**
ARRAY
This is a nested data structure. |
| **uses\_oauth**
BOOLEAN |
### lookml\_dashboards
The `lookml_dashboards` table contains information about LookML dashboards in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/dashboard#get_all_dashboards "Opens in new tab: Looker API method") |
lookml\_dashboards table foreign keys
| Join lookml\_dashboards with | on |
| --- | --- |
| [content_favorites](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-favorites) | ```
lookml_dashboards.content_favorite_id = content_favorites.id
```
```
lookml_dashboards.content_favorite_id = content_favorites.dashboard.content_favorite_id
```
```
lookml_dashboards.content_metadata_id = content_favorites.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = content_favorites.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = content_favorites.content_metadata_id
```
```
lookml_dashboards.content_metadata_id = content_favorites.dashboard.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = content_favorites.dashboard.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = content_favorites.dashboard.content_metadata_id
```
```
lookml_dashboards.content_metadata_id = content_favorites.dashboard.folder.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = content_favorites.dashboard.folder.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = content_favorites.dashboard.folder.content_metadata_id
```
```
lookml_dashboards.content_metadata_id = content_favorites.dashboard.space.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = content_favorites.dashboard.space.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = content_favorites.dashboard.space.content_metadata_id
```
```
lookml_dashboards.content_metadata_id = content_favorites.look.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = content_favorites.look.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = content_favorites.look.content_metadata_id
```
```
lookml_dashboards.folder.id = content_favorites.dashboard.folder.id
```
```
lookml_dashboards.folder.parent_id = content_favorites.dashboard.folder.id
```
```
lookml_dashboards.folder.id = content_favorites.dashboard.folder.parent_id
```
```
lookml_dashboards.folder.parent_id = content_favorites.dashboard.folder.parent_id
```
```
lookml_dashboards.model.id = content_favorites.dashboard.model.id
```
```
lookml_dashboards.space.id = content_favorites.dashboard.space.id
```
```
lookml_dashboards.space.parent_id = content_favorites.dashboard.space.id
```
```
lookml_dashboards.space.id = content_favorites.dashboard.space.parent_id
```
```
lookml_dashboards.space.parent_id = content_favorites.dashboard.space.parent_id
```
```
lookml_dashboards.folder.creator_id = content_favorites.dashboard.folder.creator_id
```
```
lookml_dashboards.space.creator_id = content_favorites.dashboard.folder.creator_id
```
```
lookml_dashboards.user_id = content_favorites.dashboard.folder.creator_id
```
```
lookml_dashboards.folder.creator_id = content_favorites.dashboard.space.creator_id
```
```
lookml_dashboards.space.creator_id = content_favorites.dashboard.space.creator_id
```
```
lookml_dashboards.user_id = content_favorites.dashboard.space.creator_id
```
```
lookml_dashboards.folder.creator_id = content_favorites.user_id
```
```
lookml_dashboards.space.creator_id = content_favorites.user_id
```
```
lookml_dashboards.user_id = content_favorites.user_id
``` |
| [dashboard_elements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-elements) | ```
lookml_dashboards.content_favorite_id = dashboard_elements.look.content_favorite_id
```
```
lookml_dashboards.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
lookml_dashboards.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
lookml_dashboards.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
lookml_dashboards.folder.id = dashboard_elements.look.folder.id
```
```
lookml_dashboards.folder.parent_id = dashboard_elements.look.folder.id
```
```
lookml_dashboards.folder.id = dashboard_elements.look.folder.parent_id
```
```
lookml_dashboards.folder.parent_id = dashboard_elements.look.folder.parent_id
```
```
lookml_dashboards.folder.id = dashboard_elements.look.folder_id
```
```
lookml_dashboards.folder.parent_id = dashboard_elements.look.folder_id
```
```
lookml_dashboards.model.id = dashboard_elements.look.model.id
```
```
lookml_dashboards.space.id = dashboard_elements.look.space.id
```
```
lookml_dashboards.space.parent_id = dashboard_elements.look.space.id
```
```
lookml_dashboards.space.id = dashboard_elements.look.space.parent_id
```
```
lookml_dashboards.space.parent_id = dashboard_elements.look.space.parent_id
```
```
lookml_dashboards.folder.creator_id = dashboard_elements.look.deleter_id
```
```
lookml_dashboards.space.creator_id = dashboard_elements.look.deleter_id
```
```
lookml_dashboards.user_id = dashboard_elements.look.deleter_id
```
```
lookml_dashboards.folder.creator_id = dashboard_elements.look.folder.creator_id
```
```
lookml_dashboards.space.creator_id = dashboard_elements.look.folder.creator_id
```
```
lookml_dashboards.user_id = dashboard_elements.look.folder.creator_id
```
```
lookml_dashboards.folder.creator_id = dashboard_elements.look.last_updater_id
```
```
lookml_dashboards.space.creator_id = dashboard_elements.look.last_updater_id
```
```
lookml_dashboards.user_id = dashboard_elements.look.last_updater_id
```
```
lookml_dashboards.folder.creator_id = dashboard_elements.look.space.creator_id
```
```
lookml_dashboards.space.creator_id = dashboard_elements.look.space.creator_id
```
```
lookml_dashboards.user_id = dashboard_elements.look.space.creator_id
```
```
lookml_dashboards.folder.creator_id = dashboard_elements.look.user.id
```
```
lookml_dashboards.space.creator_id = dashboard_elements.look.user.id
```
```
lookml_dashboards.user_id = dashboard_elements.look.user.id
```
```
lookml_dashboards.folder.creator_id = dashboard_elements.look.user_id
```
```
lookml_dashboards.space.creator_id = dashboard_elements.look.user_id
```
```
lookml_dashboards.user_id = dashboard_elements.look.user_id
``` |
| [dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboards) | ```
lookml_dashboards.content_favorite_id = dashboards.content_favorite_id
```
```
lookml_dashboards.content_metadata_id = dashboards.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = dashboards.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = dashboards.content_metadata_id
```
```
lookml_dashboards.content_metadata_id = dashboards.folder.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = dashboards.folder.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = dashboards.folder.content_metadata_id
```
```
lookml_dashboards.content_metadata_id = dashboards.space.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = dashboards.space.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = dashboards.space.content_metadata_id
```
```
lookml_dashboards.folder.id = dashboards.folder.id
```
```
lookml_dashboards.folder.parent_id = dashboards.folder.id
```
```
lookml_dashboards.folder.id = dashboards.folder.parent_id
```
```
lookml_dashboards.folder.parent_id = dashboards.folder.parent_id
```
```
lookml_dashboards.model.id = dashboards.model.id
```
```
lookml_dashboards.space.id = dashboards.space.id
```
```
lookml_dashboards.space.parent_id = dashboards.space.id
```
```
lookml_dashboards.space.id = dashboards.space.parent_id
```
```
lookml_dashboards.space.parent_id = dashboards.space.parent_id
```
```
lookml_dashboards.folder.creator_id = dashboards.space.creator_id
```
```
lookml_dashboards.space.creator_id = dashboards.space.creator_id
```
```
lookml_dashboards.user_id = dashboards.space.creator_id
```
```
lookml_dashboards.folder.creator_id = dashboards.user_id
```
```
lookml_dashboards.space.creator_id = dashboards.user_id
```
```
lookml_dashboards.user_id = dashboards.user_id
``` |
| [folders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#folders) | ```
lookml_dashboards.content_favorite_id = folders.dashboards.content_favorite_id
```
```
lookml_dashboards.content_favorite_id = folders.looks.content_favorite_id
```
```
lookml_dashboards.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
lookml_dashboards.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
lookml_dashboards.content_metadata_id = folders.looks.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = folders.looks.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = folders.looks.content_metadata_id
```
```
lookml_dashboards.content_metadata_id = folders.looks.folder.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = folders.looks.folder.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = folders.looks.folder.content_metadata_id
```
```
lookml_dashboards.folder.id = folders.id
```
```
lookml_dashboards.folder.parent_id = folders.id
```
```
lookml_dashboards.folder.id = folders.dashboards.folder.id
```
```
lookml_dashboards.folder.parent_id = folders.dashboards.folder.id
```
```
lookml_dashboards.folder.id = folders.dashboards.folder.parent_id
```
```
lookml_dashboards.folder.parent_id = folders.dashboards.folder.parent_id
```
```
lookml_dashboards.folder.id = folders.looks.folder.id
```
```
lookml_dashboards.folder.parent_id = folders.looks.folder.id
```
```
lookml_dashboards.folder.id = folders.looks.folder.parent_id
```
```
lookml_dashboards.folder.parent_id = folders.looks.folder.parent_id
```
```
lookml_dashboards.folder.id = folders.parent_id
```
```
lookml_dashboards.folder.parent_id = folders.parent_id
```
```
lookml_dashboards.model.id = folders.dashboards.model.id
```
```
lookml_dashboards.model.id = folders.looks.model.id
```
```
lookml_dashboards.space.id = folders.dashboards.space.id
```
```
lookml_dashboards.space.parent_id = folders.dashboards.space.id
```
```
lookml_dashboards.space.id = folders.dashboards.space.parent_id
```
```
lookml_dashboards.space.parent_id = folders.dashboards.space.parent_id
```
```
lookml_dashboards.space.id = folders.looks.space.id
```
```
lookml_dashboards.space.parent_id = folders.looks.space.id
```
```
lookml_dashboards.space.id = folders.looks.space.parent_id
```
```
lookml_dashboards.space.parent_id = folders.looks.space.parent_id
```
```
lookml_dashboards.space.id = folders.looks.space_id
```
```
lookml_dashboards.space.parent_id = folders.looks.space_id
```
```
lookml_dashboards.folder.creator_id = folders.creator_id
```
```
lookml_dashboards.space.creator_id = folders.creator_id
```
```
lookml_dashboards.user_id = folders.creator_id
```
```
lookml_dashboards.folder.creator_id = folders.dashboards.user_id
```
```
lookml_dashboards.space.creator_id = folders.dashboards.user_id
```
```
lookml_dashboards.user_id = folders.dashboards.user_id
```
```
lookml_dashboards.folder.creator_id = folders.dashboards.folder.creator_id
```
```
lookml_dashboards.space.creator_id = folders.dashboards.folder.creator_id
```
```
lookml_dashboards.user_id = folders.dashboards.folder.creator_id
```
```
lookml_dashboards.folder.creator_id = folders.dashboards.space.creator_id
```
```
lookml_dashboards.space.creator_id = folders.dashboards.space.creator_id
```
```
lookml_dashboards.user_id = folders.dashboards.space.creator_id
```
```
lookml_dashboards.folder.creator_id = folders.looks.deleter_id
```
```
lookml_dashboards.space.creator_id = folders.looks.deleter_id
```
```
lookml_dashboards.user_id = folders.looks.deleter_id
```
```
lookml_dashboards.folder.creator_id = folders.looks.last_updater_id
```
```
lookml_dashboards.space.creator_id = folders.looks.last_updater_id
```
```
lookml_dashboards.user_id = folders.looks.last_updater_id
```
```
lookml_dashboards.folder.creator_id = folders.looks.user.id
```
```
lookml_dashboards.space.creator_id = folders.looks.user.id
```
```
lookml_dashboards.user_id = folders.looks.user.id
``` |
| [looks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#looks) | ```
lookml_dashboards.content_favorite_id = looks.content_favorite_id
```
```
lookml_dashboards.content_metadata_id = looks.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = looks.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = looks.content_metadata_id
```
```
lookml_dashboards.folder.id = looks.folder.id
```
```
lookml_dashboards.folder.parent_id = looks.folder.id
```
```
lookml_dashboards.folder.id = looks.folder_id
```
```
lookml_dashboards.folder.parent_id = looks.folder_id
```
```
lookml_dashboards.folder.id = looks.folder.parent_id
```
```
lookml_dashboards.folder.parent_id = looks.folder.parent_id
```
```
lookml_dashboards.model.id = looks.model.id
```
```
lookml_dashboards.space.id = looks.space.id
```
```
lookml_dashboards.space.parent_id = looks.space.id
```
```
lookml_dashboards.space.id = looks.space.parent_id
```
```
lookml_dashboards.space.parent_id = looks.space.parent_id
```
```
lookml_dashboards.space.id = looks.space_id
```
```
lookml_dashboards.space.parent_id = looks.space_id
```
```
lookml_dashboards.folder.creator_id = looks.deleter_id
```
```
lookml_dashboards.space.creator_id = looks.deleter_id
```
```
lookml_dashboards.user_id = looks.deleter_id
```
```
lookml_dashboards.folder.creator_id = looks.folder.creator_id
```
```
lookml_dashboards.space.creator_id = looks.folder.creator_id
```
```
lookml_dashboards.user_id = looks.folder.creator_id
```
```
lookml_dashboards.folder.creator_id = looks.user.id
```
```
lookml_dashboards.space.creator_id = looks.user.id
```
```
lookml_dashboards.user_id = looks.user.id
```
```
lookml_dashboards.folder.creator_id = looks.user_id
```
```
lookml_dashboards.space.creator_id = looks.user_id
```
```
lookml_dashboards.user_id = looks.user_id
``` |
| [content_metadata](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata) | ```
lookml_dashboards.content_metadata_id = content_metadata.id
```
```
lookml_dashboards.folder.content_metadata_id = content_metadata.id
```
```
lookml_dashboards.space.content_metadata_id = content_metadata.id
```
```
lookml_dashboards.content_metadata_id = content_metadata.parent_id
```
```
lookml_dashboards.folder.content_metadata_id = content_metadata.parent_id
```
```
lookml_dashboards.space.content_metadata_id = content_metadata.parent_id
```
```
lookml_dashboards.space.id = content_metadata.space_id
```
```
lookml_dashboards.space.parent_id = content_metadata.space_id
``` |
| [content_metadata_access](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata-access) | ```
lookml_dashboards.content_metadata_id = content_metadata_access.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = content_metadata_access.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = content_metadata_access.content_metadata_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
lookml_dashboards.content_metadata_id = content_views.content_metadata_id
```
```
lookml_dashboards.folder.content_metadata_id = content_views.content_metadata_id
```
```
lookml_dashboards.space.content_metadata_id = content_views.content_metadata_id
```
```
lookml_dashboards.folder.creator_id = content_views.user_id
```
```
lookml_dashboards.space.creator_id = content_views.user_id
```
```
lookml_dashboards.user_id = content_views.user_id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
lookml_dashboards.folder.id = users.home_folder_id
```
```
lookml_dashboards.folder.parent_id = users.home_folder_id
```
```
lookml_dashboards.folder.id = users.personal_folder_id
```
```
lookml_dashboards.folder.parent_id = users.personal_folder_id
```
```
lookml_dashboards.space.id = users.home_space_id
```
```
lookml_dashboards.space.parent_id = users.home_space_id
```
```
lookml_dashboards.space.id = users.personal_space_id
```
```
lookml_dashboards.space.parent_id = users.personal_space_id
```
```
lookml_dashboards.folder.creator_id = users.id
```
```
lookml_dashboards.space.creator_id = users.id
```
```
lookml_dashboards.user_id = users.id
``` |
| [scheduled_plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#scheduled-plans) | ```
lookml_dashboards.id = scheduled_plans.lookml_dashboard_id
```
```
lookml_dashboards.folder.creator_id = scheduled_plans.user.id
```
```
lookml_dashboards.space.creator_id = scheduled_plans.user.id
```
```
lookml_dashboards.user_id = scheduled_plans.user.id
```
```
lookml_dashboards.folder.creator_id = scheduled_plans.user_id
```
```
lookml_dashboards.space.creator_id = scheduled_plans.user_id
```
```
lookml_dashboards.user_id = scheduled_plans.user_id
``` |
| [roles](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#roles) | ```
lookml_dashboards.model.id = roles.model_set.models
``` |
| [connections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#connections) | ```
lookml_dashboards.folder.creator_id = connections.user_id
```
```
lookml_dashboards.space.creator_id = connections.user_id
```
```
lookml_dashboards.user_id = connections.user_id
``` |
| [user_login_lockouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-login-lockouts) | ```
lookml_dashboards.folder.creator_id = user_login_lockouts.user_id
```
```
lookml_dashboards.space.creator_id = user_login_lockouts.user_id
```
```
lookml_dashboards.user_id = user_login_lockouts.user_id
``` |
lookml\_dashboards table schema
| **content\_favorite\_id**
STRING |
| --- |
| **content\_metadata\_id**
STRING |
| **description**
STRING |
| **folder**
OBJECT
This is a nested data structure:
- child_count: INTEGER
- content_metadata_id: STRING
- creator_id: STRING
- external_id: STRING
- id: STRING
- is_embed: BOOLEAN
- is_embed_shared_root: BOOLEAN
- is_embed_users_root: BOOLEAN
- is_personal: BOOLEAN
- is_personal_descendant: BOOLEAN
- is_shared_root: BOOLEAN
- is_users_root: BOOLEAN
- name: STRING
- parent_id: STRING
|
| **hidden**
BOOLEAN |
| **id**
STRING |
| **model**
OBJECT
This is a nested data structure:
|
| **query\_timezone**
STRING |
| **readonly**
BOOLEAN |
| **refresh\_interval**
STRING |
| **refresh\_interval\_to\_i**
INTEGER |
| **space**
OBJECT
This is a nested data structure:
- child_count: INTEGER
- content_metadata_id: STRING
- creator_id: STRING
- external_id: STRING
- id: STRING
- is_embed: BOOLEAN
- is_embed_shared_root: BOOLEAN
- is_embed_users_root: BOOLEAN
- is_personal: BOOLEAN
- is_personal_descendant: BOOLEAN
- is_shared_root: BOOLEAN
- is_users_root: BOOLEAN
- name: STRING
- parent_id: STRING
|
| **title**
STRING |
| **user\_id**
STRING |
### lookml\_models
The `lookml_models` table contains information about all LookML models in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Keys** | name
project\_name |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/lookml-model#get_all_lookml_models "Opens in new tab: Looker API method") |
lookml\_models table schema
| **allowed\_db\_connection\_names**
ARRAY |
| --- |
| **explores**
ARRAY
This is a nested data structure:
- description: STRING
- group_label: STRING
- hidden: BOOLEAN
- label: STRING
- name: STRING
|
| **has\_content**
BOOLEAN |
| **label**
STRING |
| **name**
STRING |
| **project\_name**
STRING |
| **unlimited\_db\_connections**
BOOLEAN |
### looks
The `looks` table contains information about all active looks in your Looker account. **Note**: Based on Looker’s documentation, this table doesn’t include soft-deleted looks.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/look#get_all_looks "Opens in new tab: Looker API method") |
looks table foreign keys
| Join looks with | on |
| --- | --- |
| [content_favorites](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-favorites) | ```
looks.content_favorite_id = content_favorites.id
```
```
looks.content_favorite_id = content_favorites.dashboard.content_favorite_id
```
```
looks.content_metadata_id = content_favorites.content_metadata_id
```
```
looks.content_metadata_id = content_favorites.dashboard.content_metadata_id
```
```
looks.content_metadata_id = content_favorites.dashboard.folder.content_metadata_id
```
```
looks.content_metadata_id = content_favorites.dashboard.space.content_metadata_id
```
```
looks.content_metadata_id = content_favorites.look.content_metadata_id
```
```
looks.folder.id = content_favorites.dashboard.folder.id
```
```
looks.folder_id = content_favorites.dashboard.folder.id
```
```
looks.folder.parent_id = content_favorites.dashboard.folder.id
```
```
looks.folder.id = content_favorites.dashboard.folder.parent_id
```
```
looks.folder_id = content_favorites.dashboard.folder.parent_id
```
```
looks.folder.parent_id = content_favorites.dashboard.folder.parent_id
```
```
looks.id = content_favorites.look_id
```
```
looks.id = content_favorites.look.id
```
```
looks.model.id = content_favorites.dashboard.model.id
```
```
looks.space.id = content_favorites.dashboard.space.id
```
```
looks.space.parent_id = content_favorites.dashboard.space.id
```
```
looks.space_id = content_favorites.dashboard.space.id
```
```
looks.space.id = content_favorites.dashboard.space.parent_id
```
```
looks.space.parent_id = content_favorites.dashboard.space.parent_id
```
```
looks.space_id = content_favorites.dashboard.space.parent_id
```
```
looks.deleter_id = content_favorites.dashboard.folder.creator_id
```
```
looks.folder.creator_id = content_favorites.dashboard.folder.creator_id
```
```
looks.user.id = content_favorites.dashboard.folder.creator_id
```
```
looks.user_id = content_favorites.dashboard.folder.creator_id
```
```
looks.deleter_id = content_favorites.dashboard.space.creator_id
```
```
looks.folder.creator_id = content_favorites.dashboard.space.creator_id
```
```
looks.user.id = content_favorites.dashboard.space.creator_id
```
```
looks.user_id = content_favorites.dashboard.space.creator_id
```
```
looks.deleter_id = content_favorites.user_id
```
```
looks.folder.creator_id = content_favorites.user_id
```
```
looks.user.id = content_favorites.user_id
```
```
looks.user_id = content_favorites.user_id
``` |
| [dashboard_elements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-elements) | ```
looks.content_favorite_id = dashboard_elements.look.content_favorite_id
```
```
looks.content_metadata_id = dashboard_elements.look.content_metadata_id
```
```
looks.content_metadata_id = dashboard_elements.look.folder.content_metadata_id
```
```
looks.content_metadata_id = dashboard_elements.look.space.content_metadata_id
```
```
looks.folder.id = dashboard_elements.look.folder.id
```
```
looks.folder_id = dashboard_elements.look.folder.id
```
```
looks.folder.parent_id = dashboard_elements.look.folder.id
```
```
looks.folder.id = dashboard_elements.look.folder.parent_id
```
```
looks.folder_id = dashboard_elements.look.folder.parent_id
```
```
looks.folder.parent_id = dashboard_elements.look.folder.parent_id
```
```
looks.folder.id = dashboard_elements.look.folder_id
```
```
looks.folder_id = dashboard_elements.look.folder_id
```
```
looks.folder.parent_id = dashboard_elements.look.folder_id
```
```
looks.id = dashboard_elements.look.id
```
```
looks.id = dashboard_elements.look_id
```
```
looks.model.id = dashboard_elements.look.model.id
```
```
looks.query_id = dashboard_elements.look.query.id
```
```
looks.query_id = dashboard_elements.look.query_id
```
```
looks.query_id = dashboard_elements.query.id
```
```
looks.query_id = dashboard_elements.query_id
```
```
looks.query_id = dashboard_elements.result_maker.query.id
```
```
looks.query_id = dashboard_elements.result_maker.query_id
```
```
looks.space.id = dashboard_elements.look.space.id
```
```
looks.space.parent_id = dashboard_elements.look.space.id
```
```
looks.space_id = dashboard_elements.look.space.id
```
```
looks.space.id = dashboard_elements.look.space.parent_id
```
```
looks.space.parent_id = dashboard_elements.look.space.parent_id
```
```
looks.space_id = dashboard_elements.look.space.parent_id
```
```
looks.deleter_id = dashboard_elements.look.deleter_id
```
```
looks.folder.creator_id = dashboard_elements.look.deleter_id
```
```
looks.user.id = dashboard_elements.look.deleter_id
```
```
looks.user_id = dashboard_elements.look.deleter_id
```
```
looks.deleter_id = dashboard_elements.look.folder.creator_id
```
```
looks.folder.creator_id = dashboard_elements.look.folder.creator_id
```
```
looks.user.id = dashboard_elements.look.folder.creator_id
```
```
looks.user_id = dashboard_elements.look.folder.creator_id
```
```
looks.deleter_id = dashboard_elements.look.last_updater_id
```
```
looks.folder.creator_id = dashboard_elements.look.last_updater_id
```
```
looks.user.id = dashboard_elements.look.last_updater_id
```
```
looks.user_id = dashboard_elements.look.last_updater_id
```
```
looks.deleter_id = dashboard_elements.look.space.creator_id
```
```
looks.folder.creator_id = dashboard_elements.look.space.creator_id
```
```
looks.user.id = dashboard_elements.look.space.creator_id
```
```
looks.user_id = dashboard_elements.look.space.creator_id
```
```
looks.deleter_id = dashboard_elements.look.user.id
```
```
looks.folder.creator_id = dashboard_elements.look.user.id
```
```
looks.user.id = dashboard_elements.look.user.id
```
```
looks.user_id = dashboard_elements.look.user.id
```
```
looks.deleter_id = dashboard_elements.look.user_id
```
```
looks.folder.creator_id = dashboard_elements.look.user_id
```
```
looks.user.id = dashboard_elements.look.user_id
```
```
looks.user_id = dashboard_elements.look.user_id
``` |
| [dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboards) | ```
looks.content_favorite_id = dashboards.content_favorite_id
```
```
looks.content_metadata_id = dashboards.content_metadata_id
```
```
looks.content_metadata_id = dashboards.folder.content_metadata_id
```
```
looks.content_metadata_id = dashboards.space.content_metadata_id
```
```
looks.folder.id = dashboards.folder.id
```
```
looks.folder_id = dashboards.folder.id
```
```
looks.folder.parent_id = dashboards.folder.id
```
```
looks.folder.id = dashboards.folder.parent_id
```
```
looks.folder_id = dashboards.folder.parent_id
```
```
looks.folder.parent_id = dashboards.folder.parent_id
```
```
looks.model.id = dashboards.model.id
```
```
looks.space.id = dashboards.space.id
```
```
looks.space.parent_id = dashboards.space.id
```
```
looks.space_id = dashboards.space.id
```
```
looks.space.id = dashboards.space.parent_id
```
```
looks.space.parent_id = dashboards.space.parent_id
```
```
looks.space_id = dashboards.space.parent_id
```
```
looks.deleter_id = dashboards.space.creator_id
```
```
looks.folder.creator_id = dashboards.space.creator_id
```
```
looks.user.id = dashboards.space.creator_id
```
```
looks.user_id = dashboards.space.creator_id
```
```
looks.deleter_id = dashboards.user_id
```
```
looks.folder.creator_id = dashboards.user_id
```
```
looks.user.id = dashboards.user_id
```
```
looks.user_id = dashboards.user_id
``` |
| [folders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#folders) | ```
looks.content_favorite_id = folders.dashboards.content_favorite_id
```
```
looks.content_favorite_id = folders.looks.content_favorite_id
```
```
looks.content_metadata_id = folders.dashboards.folder.content_metadata_id
```
```
looks.content_metadata_id = folders.dashboards.space.content_metadata_id
```
```
looks.content_metadata_id = folders.looks.content_metadata_id
```
```
looks.content_metadata_id = folders.looks.folder.content_metadata_id
```
```
looks.folder.id = folders.id
```
```
looks.folder_id = folders.id
```
```
looks.folder.parent_id = folders.id
```
```
looks.folder.id = folders.dashboards.folder.id
```
```
looks.folder_id = folders.dashboards.folder.id
```
```
looks.folder.parent_id = folders.dashboards.folder.id
```
```
looks.folder.id = folders.dashboards.folder.parent_id
```
```
looks.folder_id = folders.dashboards.folder.parent_id
```
```
looks.folder.parent_id = folders.dashboards.folder.parent_id
```
```
looks.folder.id = folders.looks.folder.id
```
```
looks.folder_id = folders.looks.folder.id
```
```
looks.folder.parent_id = folders.looks.folder.id
```
```
looks.folder.id = folders.looks.folder.parent_id
```
```
looks.folder_id = folders.looks.folder.parent_id
```
```
looks.folder.parent_id = folders.looks.folder.parent_id
```
```
looks.folder.id = folders.parent_id
```
```
looks.folder_id = folders.parent_id
```
```
looks.folder.parent_id = folders.parent_id
```
```
looks.id = folders.looks.id
```
```
looks.model.id = folders.dashboards.model.id
```
```
looks.model.id = folders.looks.model.id
```
```
looks.query_id = folders.looks.query_id
```
```
looks.space.id = folders.dashboards.space.id
```
```
looks.space.parent_id = folders.dashboards.space.id
```
```
looks.space_id = folders.dashboards.space.id
```
```
looks.space.id = folders.dashboards.space.parent_id
```
```
looks.space.parent_id = folders.dashboards.space.parent_id
```
```
looks.space_id = folders.dashboards.space.parent_id
```
```
looks.space.id = folders.looks.space.id
```
```
looks.space.parent_id = folders.looks.space.id
```
```
looks.space_id = folders.looks.space.id
```
```
looks.space.id = folders.looks.space.parent_id
```
```
looks.space.parent_id = folders.looks.space.parent_id
```
```
looks.space_id = folders.looks.space.parent_id
```
```
looks.space.id = folders.looks.space_id
```
```
looks.space.parent_id = folders.looks.space_id
```
```
looks.space_id = folders.looks.space_id
```
```
looks.deleter_id = folders.creator_id
```
```
looks.folder.creator_id = folders.creator_id
```
```
looks.user.id = folders.creator_id
```
```
looks.user_id = folders.creator_id
```
```
looks.deleter_id = folders.dashboards.user_id
```
```
looks.folder.creator_id = folders.dashboards.user_id
```
```
looks.user.id = folders.dashboards.user_id
```
```
looks.user_id = folders.dashboards.user_id
```
```
looks.deleter_id = folders.dashboards.folder.creator_id
```
```
looks.folder.creator_id = folders.dashboards.folder.creator_id
```
```
looks.user.id = folders.dashboards.folder.creator_id
```
```
looks.user_id = folders.dashboards.folder.creator_id
```
```
looks.deleter_id = folders.dashboards.space.creator_id
```
```
looks.folder.creator_id = folders.dashboards.space.creator_id
```
```
looks.user.id = folders.dashboards.space.creator_id
```
```
looks.user_id = folders.dashboards.space.creator_id
```
```
looks.deleter_id = folders.looks.deleter_id
```
```
looks.folder.creator_id = folders.looks.deleter_id
```
```
looks.user.id = folders.looks.deleter_id
```
```
looks.user_id = folders.looks.deleter_id
```
```
looks.deleter_id = folders.looks.last_updater_id
```
```
looks.folder.creator_id = folders.looks.last_updater_id
```
```
looks.user.id = folders.looks.last_updater_id
```
```
looks.user_id = folders.looks.last_updater_id
```
```
looks.deleter_id = folders.looks.user.id
```
```
looks.folder.creator_id = folders.looks.user.id
```
```
looks.user.id = folders.looks.user.id
```
```
looks.user_id = folders.looks.user.id
``` |
| [lookml_dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#lookml-dashboards) | ```
looks.content_favorite_id = lookml_dashboards.content_favorite_id
```
```
looks.content_metadata_id = lookml_dashboards.content_metadata_id
```
```
looks.content_metadata_id = lookml_dashboards.folder.content_metadata_id
```
```
looks.content_metadata_id = lookml_dashboards.space.content_metadata_id
```
```
looks.folder.id = lookml_dashboards.folder.id
```
```
looks.folder_id = lookml_dashboards.folder.id
```
```
looks.folder.parent_id = lookml_dashboards.folder.id
```
```
looks.folder.id = lookml_dashboards.folder.parent_id
```
```
looks.folder_id = lookml_dashboards.folder.parent_id
```
```
looks.folder.parent_id = lookml_dashboards.folder.parent_id
```
```
looks.model.id = lookml_dashboards.model.id
```
```
looks.space.id = lookml_dashboards.space.id
```
```
looks.space.parent_id = lookml_dashboards.space.id
```
```
looks.space_id = lookml_dashboards.space.id
```
```
looks.space.id = lookml_dashboards.space.parent_id
```
```
looks.space.parent_id = lookml_dashboards.space.parent_id
```
```
looks.space_id = lookml_dashboards.space.parent_id
```
```
looks.deleter_id = lookml_dashboards.folder.creator_id
```
```
looks.folder.creator_id = lookml_dashboards.folder.creator_id
```
```
looks.user.id = lookml_dashboards.folder.creator_id
```
```
looks.user_id = lookml_dashboards.folder.creator_id
```
```
looks.deleter_id = lookml_dashboards.space.creator_id
```
```
looks.folder.creator_id = lookml_dashboards.space.creator_id
```
```
looks.user.id = lookml_dashboards.space.creator_id
```
```
looks.user_id = lookml_dashboards.space.creator_id
```
```
looks.deleter_id = lookml_dashboards.user_id
```
```
looks.folder.creator_id = lookml_dashboards.user_id
```
```
looks.user.id = lookml_dashboards.user_id
```
```
looks.user_id = lookml_dashboards.user_id
``` |
| [content_metadata](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata) | ```
looks.content_metadata_id = content_metadata.id
```
```
looks.content_metadata_id = content_metadata.parent_id
```
```
looks.id = content_metadata.look_id
```
```
looks.space.id = content_metadata.space_id
```
```
looks.space.parent_id = content_metadata.space_id
```
```
looks.space_id = content_metadata.space_id
``` |
| [content_metadata_access](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata-access) | ```
looks.content_metadata_id = content_metadata_access.content_metadata_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
looks.content_metadata_id = content_views.content_metadata_id
```
```
looks.id = content_views.look_id
```
```
looks.deleter_id = content_views.user_id
```
```
looks.folder.creator_id = content_views.user_id
```
```
looks.user.id = content_views.user_id
```
```
looks.user_id = content_views.user_id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
looks.folder.id = users.home_folder_id
```
```
looks.folder_id = users.home_folder_id
```
```
looks.folder.parent_id = users.home_folder_id
```
```
looks.folder.id = users.personal_folder_id
```
```
looks.folder_id = users.personal_folder_id
```
```
looks.folder.parent_id = users.personal_folder_id
```
```
looks.space.id = users.home_space_id
```
```
looks.space.parent_id = users.home_space_id
```
```
looks.space_id = users.home_space_id
```
```
looks.space.id = users.personal_space_id
```
```
looks.space.parent_id = users.personal_space_id
```
```
looks.space_id = users.personal_space_id
```
```
looks.deleter_id = users.id
```
```
looks.folder.creator_id = users.id
```
```
looks.user.id = users.id
```
```
looks.user_id = users.id
``` |
| [scheduled_plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#scheduled-plans) | ```
looks.id = scheduled_plans.look_id
```
```
looks.query_id = scheduled_plans.query_id
```
```
looks.deleter_id = scheduled_plans.user.id
```
```
looks.folder.creator_id = scheduled_plans.user.id
```
```
looks.user.id = scheduled_plans.user.id
```
```
looks.user_id = scheduled_plans.user.id
```
```
looks.deleter_id = scheduled_plans.user_id
```
```
looks.folder.creator_id = scheduled_plans.user_id
```
```
looks.user.id = scheduled_plans.user_id
```
```
looks.user_id = scheduled_plans.user_id
``` |
| [roles](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#roles) | ```
looks.model.id = roles.model_set.models
``` |
| [queries](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#queries) | ```
looks.query_id = queries.id
``` |
| [connections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#connections) | ```
looks.deleter_id = connections.user_id
```
```
looks.folder.creator_id = connections.user_id
```
```
looks.user.id = connections.user_id
```
```
looks.user_id = connections.user_id
``` |
| [user_login_lockouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-login-lockouts) | ```
looks.deleter_id = user_login_lockouts.user_id
```
```
looks.folder.creator_id = user_login_lockouts.user_id
```
```
looks.user.id = user_login_lockouts.user_id
```
```
looks.user_id = user_login_lockouts.user_id
``` |
looks table schema
| **content\_favorite\_id**
STRING |
| --- |
| **content\_metadata\_id**
STRING |
| **created\_at**
DATE-TIME |
| **deleted**
BOOLEAN |
| **deleted\_at**
DATE-TIME |
| **deleter\_id**
STRING |
| **description**
STRING |
| **embed\_url**
STRING |
| **excel\_file\_url**
STRING |
| **favorite\_count**
INTEGER |
| **folder**
OBJECT
This is a nested data structure:
- child_count: INTEGER
- content_metadata_id: STRING
- creator_id: STRING
- external_id: STRING
- id: STRING
- is_embed: BOOLEAN
- is_embed_shared_root: BOOLEAN
- is_embed_users_root: BOOLEAN
- is_personal: BOOLEAN
- is_personal_descendant: BOOLEAN
- is_shared_root: BOOLEAN
- is_users_root: BOOLEAN
- name: STRING
- parent_id: STRING
|
| **folder\_id**
STRING |
| **google\_spreadsheet\_formula**
STRING |
| **id**
STRING |
| **image\_embed\_url**
STRING |
| **is\_run\_on\_load**
BOOLEAN |
| **last\_accessed\_at**
DATE-TIME |
| **last\_updater\_id**
STRING |
| **last\_viewed\_at**
DATE-TIME |
| **model**
OBJECT
This is a nested data structure:
|
| **public**
BOOLEAN |
| **public\_slug**
STRING |
| **public\_url**
STRING |
| **query\_id**
STRING |
| **short\_url**
STRING |
| **space**
OBJECT
This is a nested data structure:
- child_count: INTEGER
- content_metadata_id: STRING
- creator_id: STRING
- external_id: STRING
- id: STRING
- is_embed: BOOLEAN
- is_embed_shared_root: BOOLEAN
- is_embed_users_root: BOOLEAN
- is_personal: BOOLEAN
- is_personal_descendant: BOOLEAN
- is_shared_root: BOOLEAN
- is_users_root: BOOLEAN
- name: STRING
- parent_id: STRING
|
| **space\_id**
STRING |
| **title**
STRING |
| **updated\_at**
DATE-TIME |
| **user**
OBJECT
This is a nested data structure:
|
| **user\_id**
STRING |
| **view\_count**
INTEGER |
### merge\_queries
The `merge_queries` table contains info about the merge queries in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/query#get_merge_query "Opens in new tab: Looker API method") |
merge\_queries table schema
| **column\_limit**
STRING |
| --- |
| **dynamic\_fields**
STRING |
| **id**
STRING |
| **pivots**
ARRAY
This is a nested data structure. |
| **result\_maker\_id**
STRING |
| **sorts**
ARRAY
This is a nested data structure. |
| **source\_queries**
ARRAY
This is a nested data structure:
- merge_fields: ARRAY, which is also a nested data structure.
- field_name: STRING
- source_field_name: STRING
- name: STRING
- query_id: STRING
|
| **total**
BOOLEAN |
| **vis\_config**
OBJECT
This is a nested data structure. |
### model\_sets
The `model_sets` table contains info about the role model sets in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/role#get_all_model_sets "Opens in new tab: Looker API method") |
model\_sets table foreign keys
| Join model\_sets with | on |
| --- | --- |
| [roles](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#roles) | ```
model_sets.id = roles.model_set.id
```
```
model_sets.id = roles.model_set_id
``` |
model\_sets table schema
| **all\_access**
BOOLEAN |
| --- |
| **built\_in**
BOOLEAN |
| **id**
STRING |
| **models**
ARRAY
This is a nested data structure. |
| **name**
STRING |
| **url**
STRING |
### models
The `models` table contains information about individual models in your Looker account.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Keys** | name
project\_name |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/lookml-model#get_lookml_model "Opens in new tab: Looker API method") |
models table schema
| **allowed\_db\_connection\_names**
ARRAY
This is a nested data structure. |
| --- |
| **explores**
ARRAY
This is a nested data structure:
- description: STRING
- group_label: STRING
- hidden: BOOLEAN
- label: STRING
- name: STRING
|
| **has\_content**
BOOLEAN |
| **label**
STRING |
| **name**
STRING |
| **project\_name**
STRING |
| **unlimited\_db\_connections**
BOOLEAN |
### permission\_sets
The `permission_sets` table contains info about the role permission sets in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/role#get_all_permission_sets "Opens in new tab: Looker API method") |
permission\_sets table foreign keys
| Join permission\_sets with | on |
| --- | --- |
| [roles](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#roles) | ```
permission_sets.id = roles.permission_set_id
```
```
permission_sets.id = roles.id
``` |
permission\_sets table schema
| **all\_access**
BOOLEAN |
| --- |
| **built\_in**
BOOLEAN |
| **id**
STRING |
| **name**
STRING |
| **permissions**
ARRAY
This is a nested data structure. |
| **url**
STRING |
### permissions
The `permissions` table contains info about the permissions listed in your Looker account.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | permission |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/role#get_all_permissions "Opens in new tab: Looker API method") |
permissions table schema
| **description**
STRING |
| --- |
| **parent**
STRING |
| **permission**
STRING |
### project\_files
The `project_files` table contains info about the files associated with projects in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/project#get_all_project_files "Opens in new tab: Looker API method") |
project\_files table foreign keys
| Join project\_files with | on |
| --- | --- |
| [git_branches](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#git-branches) | ```
project_files.project_id = git_branches.project_id
``` |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#projects) | ```
project_files.project_id = projects.id
``` |
| [workspaces](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#workspaces) | ```
project_files.project_id = workspaces.projects.id
``` |
project\_files table schema
| **editable**
BOOLEAN |
| --- |
| **extension**
STRING |
| **git\_status**
OBJECT
This is a nested data structure:
- action: STRING
- conflict: BOOLEAN
- revertable: BOOLEAN
- text: STRING
|
| **id**
STRING |
| **mime\_type**
STRING |
| **path**
STRING |
| **project\_id**
STRING |
| **title**
STRING |
| **type**
STRING |
### projects
The `projects` table contains info about the projects in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/project#get_all_projects "Opens in new tab: Looker API method") |
projects table foreign keys
| Join projects with | on |
| --- | --- |
| [git_branches](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#git-branches) | ```
projects.id = git_branches.project_id
``` |
| [project_files](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#project-files) | ```
projects.id = project_files.project_id
``` |
| [workspaces](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#workspaces) | ```
projects.id = workspaces.projects.id
``` |
projects table schema
| **allow\_warnings**
BOOLEAN |
| --- |
| **deploy\_secret**
STRING |
| **folders\_enabled**
BOOLEAN |
| **git\_password**
STRING |
| **git\_password\_user\_attribute**
STRING |
| **git\_remote\_url**
STRING |
| **git\_service\_name**
STRING |
| **git\_username**
STRING |
| **git\_username\_user\_attribute**
STRING |
| **id**
STRING |
| **is\_example**
BOOLEAN |
| **name**
STRING |
| **pull\_request\_mode**
STRING |
| **unset\_deploy\_secret**
BOOLEAN |
| **uses\_git**
BOOLEAN |
| **validation\_required**
BOOLEAN |
### queries
The `queries` table contains info about the queries that exist in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/query#get_query "Opens in new tab: Looker API method") |
queries table foreign keys
| Join queries with | on |
| --- | --- |
| [dashboard_elements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-elements) | ```
queries.id = dashboard_elements.look.query.id
```
```
queries.id = dashboard_elements.look.query_id
```
```
queries.id = dashboard_elements.query.id
```
```
queries.id = dashboard_elements.query_id
```
```
queries.id = dashboard_elements.result_maker.query.id
```
```
queries.id = dashboard_elements.result_maker.query_id
``` |
| [folders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#folders) | ```
queries.id = folders.looks.query_id
``` |
| [looks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#looks) | ```
queries.id = looks.query_id
``` |
| [scheduled_plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#scheduled-plans) | ```
queries.id = scheduled_plans.query_id
``` |
queries table schema
| **client\_id**
STRING |
| --- |
| **column\_limit**
STRING |
| **dynamic\_fields**
STRING |
| **expanded\_share\_url**
STRING |
| **fields**
ARRAY
This is a nested data structure. |
| **fill\_fields**
ARRAY
This is a nested data structure. |
| **filter\_config**
OBJECT
This is a nested data structure. |
| **filter\_expression**
STRING |
| **filters**
OBJECT
This is a nested data structure. |
| **has\_table\_calculations**
BOOLEAN |
| **id**
STRING |
| **limit**
STRING |
| **model**
STRING |
| **pivots**
ARRAY
This is a nested data structure. |
| **query\_timezone**
STRING |
| **row\_total**
STRING |
| **runtime**
NUMBER |
| **share\_url**
STRING |
| **slug**
STRING |
| **sorts**
ARRAY
This is a nested data structure. |
| **subtotals**
ARRAY
This is a nested data structure. |
| **total**
BOOLEAN |
| **url**
STRING |
| **view**
STRING |
| **vis\_config**
OBJECT
This is a nested data structure. |
| **visible\_ui\_sections**
STRING |
### query\_history
The `query_history` table contains query history data pulled from Looker’s [History Explore](https://docs.looker.com/admin-options/tutorials/i__looker), or `i__looker` database, for queries run in the past seven days.
To extract this data, a query will be submitted to the Looker API. The results of query are then extracted and replicated to your destination.
**Note**: Looker integration only replicates the **past seven days** of query history at any given time.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Keys** | dims\_hash\_key
history\_created\_date
query\_id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/query#run_inline_query "Opens in new tab: Looker API method") |
query\_history table schema
| **dashboard\_id**
STRING |
| --- |
| **dims\_hash\_key**
STRING |
| **history\_created\_date**
STRING |
| **history\_query\_run\_count**
INTEGER |
| **history\_total\_runtime**
NUMBER |
| **look\_id**
STRING |
| **query\_id**
STRING |
| **query\_model**
STRING |
| **query\_view**
STRING |
| **space\_id**
STRING |
| **user\_id**
STRING |
### role\_groups
The `role_groups` table contains info about the role groups in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/role#get_role_groups "Opens in new tab: Looker API method") |
role\_groups table foreign keys
| Join role\_groups with | on |
| --- | --- |
| [roles](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#roles) | ```
role_groups.role_id = roles.id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
role_groups.role_id = users.role_ids
``` |
role\_groups table schema
| **can\_add\_to\_content\_metadata**
BOOLEAN |
| --- |
| **contains\_current\_user**
BOOLEAN |
| **external\_group\_id**
STRING |
| **externally\_managed**
BOOLEAN |
| **id**
STRING |
| **include\_by\_default**
BOOLEAN |
| **name**
STRING |
| **role\_id**
STRING |
| **user\_count**
INTEGER |
### roles
The `roles` table contains info about the user roles in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/role#get_all_roles "Opens in new tab: Looker API method") |
roles table foreign keys
| Join roles with | on |
| --- | --- |
| [model_sets](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#model-sets) | ```
roles.model_set.id = model_sets.id
```
```
roles.model_set_id = model_sets.id
``` |
| [content_favorites](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-favorites) | ```
roles.model_set.models = content_favorites.dashboard.model.id
``` |
| [dashboard_elements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-elements) | ```
roles.model_set.models = dashboard_elements.look.model.id
``` |
| [dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboards) | ```
roles.model_set.models = dashboards.model.id
``` |
| [folders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#folders) | ```
roles.model_set.models = folders.dashboards.model.id
```
```
roles.model_set.models = folders.looks.model.id
``` |
| [lookml_dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#lookml-dashboards) | ```
roles.model_set.models = lookml_dashboards.model.id
``` |
| [looks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#looks) | ```
roles.model_set.models = looks.model.id
``` |
| [permission_sets](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#permission-sets) | ```
roles.permission_set_id = permission_sets.id
```
```
roles.id = permission_sets.id
``` |
| [role_groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#role-groups) | ```
roles.id = role_groups.role_id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
roles.id = users.role_ids
``` |
roles table schema
| **id**
STRING |
| --- |
| **model\_set**
OBJECT
This is a nested data structure:
- all_access: BOOLEAN
- built_in: BOOLEAN
- id: STRING
- models: ARRAY, which is also a nested data structure.
- name: STRING
- url: STRING
|
| **model\_set\_id**
STRING |
| **name**
STRING |
| **permission\_set**
OBJECT
This is a nested data structure:
- all_access: BOOLEAN
- built_in: BOOLEAN
- id: STRING
- name: STRING
- permissions: ARRAY, which is also a nested data structure.
- url: STRING
|
| **permission\_set\_id**
STRING |
| **url**
STRING |
| **users\_url**
STRING |
### scheduled\_plans
The `scheduled_plans` table contains info about all scheduled plans in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/scheduled-plan#get_all_scheduled_plans "Opens in new tab: Looker API method") |
scheduled\_plans table foreign keys
| Join scheduled\_plans with | on |
| --- | --- |
| [content_favorites](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-favorites) | ```
scheduled_plans.dashboard_id = content_favorites.dashboard.id
```
```
scheduled_plans.dashboard_id = content_favorites.dashboard_id
```
```
scheduled_plans.look_id = content_favorites.look_id
```
```
scheduled_plans.look_id = content_favorites.look.id
```
```
scheduled_plans.user.id = content_favorites.dashboard.folder.creator_id
```
```
scheduled_plans.user_id = content_favorites.dashboard.folder.creator_id
```
```
scheduled_plans.user.id = content_favorites.dashboard.space.creator_id
```
```
scheduled_plans.user_id = content_favorites.dashboard.space.creator_id
```
```
scheduled_plans.user.id = content_favorites.user_id
```
```
scheduled_plans.user_id = content_favorites.user_id
``` |
| [content_metadata](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata) | ```
scheduled_plans.dashboard_id = content_metadata.dashboard_id
```
```
scheduled_plans.look_id = content_metadata.look_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
scheduled_plans.dashboard_id = content_views.dashboard_id
```
```
scheduled_plans.look_id = content_views.look_id
```
```
scheduled_plans.user.id = content_views.user_id
```
```
scheduled_plans.user_id = content_views.user_id
``` |
| [dashboard_elements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-elements) | ```
scheduled_plans.dashboard_id = dashboard_elements.dashboard_id
```
```
scheduled_plans.look_id = dashboard_elements.look.id
```
```
scheduled_plans.look_id = dashboard_elements.look_id
```
```
scheduled_plans.query_id = dashboard_elements.look.query.id
```
```
scheduled_plans.query_id = dashboard_elements.look.query_id
```
```
scheduled_plans.query_id = dashboard_elements.query.id
```
```
scheduled_plans.query_id = dashboard_elements.query_id
```
```
scheduled_plans.query_id = dashboard_elements.result_maker.query.id
```
```
scheduled_plans.query_id = dashboard_elements.result_maker.query_id
```
```
scheduled_plans.user.id = dashboard_elements.look.deleter_id
```
```
scheduled_plans.user_id = dashboard_elements.look.deleter_id
```
```
scheduled_plans.user.id = dashboard_elements.look.folder.creator_id
```
```
scheduled_plans.user_id = dashboard_elements.look.folder.creator_id
```
```
scheduled_plans.user.id = dashboard_elements.look.last_updater_id
```
```
scheduled_plans.user_id = dashboard_elements.look.last_updater_id
```
```
scheduled_plans.user.id = dashboard_elements.look.space.creator_id
```
```
scheduled_plans.user_id = dashboard_elements.look.space.creator_id
```
```
scheduled_plans.user.id = dashboard_elements.look.user.id
```
```
scheduled_plans.user_id = dashboard_elements.look.user.id
```
```
scheduled_plans.user.id = dashboard_elements.look.user_id
```
```
scheduled_plans.user_id = dashboard_elements.look.user_id
``` |
| [dashboard_filters](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-filters) | ```
scheduled_plans.dashboard_id = dashboard_filters.dashboard_id
``` |
| [dashboard_layouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-layouts) | ```
scheduled_plans.dashboard_id = dashboard_layouts.dashboard_id
``` |
| [dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboards) | ```
scheduled_plans.dashboard_id = dashboards.id
```
```
scheduled_plans.user.id = dashboards.space.creator_id
```
```
scheduled_plans.user_id = dashboards.space.creator_id
```
```
scheduled_plans.user.id = dashboards.user_id
```
```
scheduled_plans.user_id = dashboards.user_id
``` |
| [folders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#folders) | ```
scheduled_plans.dashboard_id = folders.dashboards.id
```
```
scheduled_plans.look_id = folders.looks.id
```
```
scheduled_plans.query_id = folders.looks.query_id
```
```
scheduled_plans.user.id = folders.creator_id
```
```
scheduled_plans.user_id = folders.creator_id
```
```
scheduled_plans.user.id = folders.dashboards.user_id
```
```
scheduled_plans.user_id = folders.dashboards.user_id
```
```
scheduled_plans.user.id = folders.dashboards.folder.creator_id
```
```
scheduled_plans.user_id = folders.dashboards.folder.creator_id
```
```
scheduled_plans.user.id = folders.dashboards.space.creator_id
```
```
scheduled_plans.user_id = folders.dashboards.space.creator_id
```
```
scheduled_plans.user.id = folders.looks.deleter_id
```
```
scheduled_plans.user_id = folders.looks.deleter_id
```
```
scheduled_plans.user.id = folders.looks.last_updater_id
```
```
scheduled_plans.user_id = folders.looks.last_updater_id
```
```
scheduled_plans.user.id = folders.looks.user.id
```
```
scheduled_plans.user_id = folders.looks.user.id
``` |
| [looks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#looks) | ```
scheduled_plans.look_id = looks.id
```
```
scheduled_plans.query_id = looks.query_id
```
```
scheduled_plans.user.id = looks.deleter_id
```
```
scheduled_plans.user_id = looks.deleter_id
```
```
scheduled_plans.user.id = looks.folder.creator_id
```
```
scheduled_plans.user_id = looks.folder.creator_id
```
```
scheduled_plans.user.id = looks.user.id
```
```
scheduled_plans.user_id = looks.user.id
```
```
scheduled_plans.user.id = looks.user_id
```
```
scheduled_plans.user_id = looks.user_id
``` |
| [lookml_dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#lookml-dashboards) | ```
scheduled_plans.lookml_dashboard_id = lookml_dashboards.id
```
```
scheduled_plans.user.id = lookml_dashboards.folder.creator_id
```
```
scheduled_plans.user_id = lookml_dashboards.folder.creator_id
```
```
scheduled_plans.user.id = lookml_dashboards.space.creator_id
```
```
scheduled_plans.user_id = lookml_dashboards.space.creator_id
```
```
scheduled_plans.user.id = lookml_dashboards.user_id
```
```
scheduled_plans.user_id = lookml_dashboards.user_id
``` |
| [queries](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#queries) | ```
scheduled_plans.query_id = queries.id
``` |
| [connections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#connections) | ```
scheduled_plans.user.id = connections.user_id
```
```
scheduled_plans.user_id = connections.user_id
``` |
| [user_login_lockouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-login-lockouts) | ```
scheduled_plans.user.id = user_login_lockouts.user_id
```
```
scheduled_plans.user_id = user_login_lockouts.user_id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
scheduled_plans.user.id = users.id
```
```
scheduled_plans.user_id = users.id
``` |
scheduled\_plans table schema
| **color\_theme**
STRING |
| --- |
| **created\_at**
DATE-TIME |
| **crontab**
STRING |
| **dashboard\_filters**
STRING |
| **dashboard\_id**
STRING |
| **datagroup**
STRING |
| **embed**
BOOLEAN |
| **enabled**
BOOLEAN |
| **filters\_string**
STRING |
| **id**
STRING |
| **include\_links**
BOOLEAN |
| **last\_run\_at**
DATE-TIME |
| **long\_tables**
BOOLEAN |
| **look\_id**
STRING |
| **lookml\_dashboard\_id**
STRING |
| **name**
STRING |
| **next\_run\_at**
DATE-TIME |
| **pdf\_landscape**
BOOLEAN |
| **pdf\_paper\_size**
STRING |
| **query\_id**
STRING |
| **require\_change**
BOOLEAN |
| **require\_no\_results**
BOOLEAN |
| **require\_results**
BOOLEAN |
| **run\_as\_recipient**
BOOLEAN |
| **run\_once**
BOOLEAN |
| **scheduled\_plan\_destination**
ARRAY
This is a nested data structure:
- address: STRING
- apply_formatting: BOOLEAN
- apply_vis: BOOLEAN
- format: STRING
- id: STRING
- looker_recipient: BOOLEAN
- message: STRING
- parameters: STRING
- scheduled_plan_id: STRING
- secret_parameters: STRING
- type: STRING
|
| **send\_all\_results**
BOOLEAN |
| **timezone**
STRING |
| **title**
STRING |
| **updated\_at**
DATE-TIME |
| **user**
OBJECT
This is a nested data structure:
- avatar_url: STRING
- display_name: STRING
- first_name: STRING
- id: STRING
- last_name: STRING
- url: STRING
|
| **user\_id**
STRING |
### themes
The `themes` table contains info about the themes in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/theme#get_all_themes "Opens in new tab: Looker API method") |
themes table foreign keys
| Join themes with | on |
| --- | --- |
| [color_collections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#color-collections) | ```
themes.settings.color_collection_id = color_collections.id
``` |
themes table schema
| **begin\_at**
DATE-TIME |
| --- |
| **end\_at**
DATE-TIME |
| **id**
STRING |
| **name**
STRING |
| **settings**
OBJECT
This is a nested data structure:
- background_color: STRING
- base_font_size: STRING
- color_collection_id: STRING
- font_color: STRING
- font_family: STRING
- font_source: STRING
- info_button_color: STRING
- primary_button_color: STRING
- show_filters_bar: BOOLEAN
- show_title: BOOLEAN
- text_tile_text_color: STRING
- tile_background_color: STRING
- tile_text_color: STRING
- title_color: STRING
- warn_button_color: STRING
|
### user\_attribute\_group\_values
The `user_attribute_group_values` table contains info about the values of user attributes defined by user groups in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/user-attribute#get_user_attribute_group_values "Opens in new tab: Looker API method") |
user\_attribute\_group\_values table foreign keys
| Join user\_attribute\_group\_values with | on |
| --- | --- |
| [content_metadata_access](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata-access) | ```
user_attribute_group_values.group_id = content_metadata_access.group_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
user_attribute_group_values.group_id = content_views.group_id
``` |
| [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#groups) | ```
user_attribute_group_values.group_id = groups.id
``` |
| [groups_in_group](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#groups-in-group) | ```
user_attribute_group_values.group_id = groups_in_group.id
```
```
user_attribute_group_values.group_id = groups_in_group.parent_group_id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
user_attribute_group_values.group_id = users.group_ids
``` |
| [user_attributes](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-attributes) | ```
user_attribute_group_values.user_attribute_id = user_attributes.id
``` |
user\_attribute\_group\_values table schema
| **group\_id**
STRING |
| --- |
| **id**
STRING |
| **rank**
INTEGER |
| **user\_attribute\_id**
STRING |
| **value**
STRING |
| **value\_is\_hidden**
BOOLEAN |
### user\_attribute\_values
The `user_attribute_values` table contains info about the values for user attributes defined in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Keys** | user\_attribute\_id
user\_id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/user#get_user_attribute_values "Opens in new tab: Looker API method") |
user\_attribute\_values table schema
| **hidden\_value\_domain\_whitelist**
STRING |
| --- |
| **label**
STRING |
| **name**
STRING |
| **rank**
INTEGER |
| **source**
STRING |
| **user\_attribute\_id**
STRING |
| **user\_can\_edit**
BOOLEAN |
| **user\_id**
STRING |
| **value**
STRING |
| **value\_is\_hidden**
BOOLEAN |
### user\_attributes
The `user_attributes` table contains info about user attributes in your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/user-attribute#get_all_user_attributes "Opens in new tab: Looker API method") |
user\_attributes table foreign keys
| Join user\_attributes with | on |
| --- | --- |
| [user_attribute_group_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-attribute-group-values) | ```
user_attributes.id = user_attribute_group_values.user_attribute_id
``` |
user\_attributes table schema
| **default\_value**
STRING |
| --- |
| **hidden\_value\_domain\_whitelist**
STRING |
| **id**
STRING |
| **is\_permanent**
BOOLEAN |
| **is\_system**
BOOLEAN |
| **label**
STRING |
| **name**
STRING |
| **type**
STRING |
| **user\_can\_edit**
BOOLEAN |
| **user\_can\_view**
BOOLEAN |
| **value\_is\_hidden**
BOOLEAN |
### user\_login\_lockouts
The `user_login_lockouts` table contains info about lockouts for user logins associated with your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | key |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/auth#get_all_user_login_lockouts "Opens in new tab: Looker API method") |
user\_login\_lockouts table foreign keys
| Join user\_login\_lockouts with | on |
| --- | --- |
| [connections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#connections) | ```
user_login_lockouts.user_id = connections.user_id
``` |
| [content_favorites](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-favorites) | ```
user_login_lockouts.user_id = content_favorites.dashboard.folder.creator_id
```
```
user_login_lockouts.user_id = content_favorites.dashboard.space.creator_id
```
```
user_login_lockouts.user_id = content_favorites.user_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
user_login_lockouts.user_id = content_views.user_id
``` |
| [dashboard_elements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-elements) | ```
user_login_lockouts.user_id = dashboard_elements.look.deleter_id
```
```
user_login_lockouts.user_id = dashboard_elements.look.folder.creator_id
```
```
user_login_lockouts.user_id = dashboard_elements.look.last_updater_id
```
```
user_login_lockouts.user_id = dashboard_elements.look.space.creator_id
```
```
user_login_lockouts.user_id = dashboard_elements.look.user.id
```
```
user_login_lockouts.user_id = dashboard_elements.look.user_id
``` |
| [dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboards) | ```
user_login_lockouts.user_id = dashboards.space.creator_id
```
```
user_login_lockouts.user_id = dashboards.user_id
``` |
| [folders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#folders) | ```
user_login_lockouts.user_id = folders.creator_id
```
```
user_login_lockouts.user_id = folders.dashboards.user_id
```
```
user_login_lockouts.user_id = folders.dashboards.folder.creator_id
```
```
user_login_lockouts.user_id = folders.dashboards.space.creator_id
```
```
user_login_lockouts.user_id = folders.looks.deleter_id
```
```
user_login_lockouts.user_id = folders.looks.last_updater_id
```
```
user_login_lockouts.user_id = folders.looks.user.id
``` |
| [lookml_dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#lookml-dashboards) | ```
user_login_lockouts.user_id = lookml_dashboards.folder.creator_id
```
```
user_login_lockouts.user_id = lookml_dashboards.space.creator_id
```
```
user_login_lockouts.user_id = lookml_dashboards.user_id
``` |
| [looks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#looks) | ```
user_login_lockouts.user_id = looks.deleter_id
```
```
user_login_lockouts.user_id = looks.folder.creator_id
```
```
user_login_lockouts.user_id = looks.user.id
```
```
user_login_lockouts.user_id = looks.user_id
``` |
| [scheduled_plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#scheduled-plans) | ```
user_login_lockouts.user_id = scheduled_plans.user.id
```
```
user_login_lockouts.user_id = scheduled_plans.user_id
``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
user_login_lockouts.user_id = users.id
``` |
user\_login\_lockouts table schema
| **auth\_type**
STRING |
| --- |
| **email**
STRING |
| **fail\_count**
INTEGER |
| **full\_name**
STRING |
| **ip**
STRING |
| **key**
STRING |
| **lockout\_at**
DATE-TIME |
| **remote\_id**
STRING |
| **user\_id**
STRING |
### user\_sessions
The `user_sessions` table contains info about user web login sessions associated with your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/user#get_all_web_login_sessions "Opens in new tab: Looker API method") |
user\_sessions table foreign keys
| Join user\_sessions with | on |
| --- | --- |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
user_sessions.id = users.sessions.id
``` |
user\_sessions table schema
| **browser**
STRING |
| --- |
| **city**
STRING |
| **country**
STRING |
| **created\_at**
STRING |
| **credentials\_type**
STRING |
| **expires\_at**
STRING |
| **extended\_at**
STRING |
| **extended\_count**
INTEGER |
| **id**
STRING |
| **ip\_address**
STRING |
| **operating\_system**
STRING |
| **state**
STRING |
| **sudo\_user\_id**
STRING |
| **url**
STRING |
### users
The `users` table contains info about users associated with your Looker account.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/user#get_all_users "Opens in new tab: Looker API method") |
users table foreign keys
| Join users with | on |
| --- | --- |
| [content_favorites](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-favorites) | ```
users.home_folder_id = content_favorites.dashboard.folder.id
```
```
users.personal_folder_id = content_favorites.dashboard.folder.id
```
```
users.home_folder_id = content_favorites.dashboard.folder.parent_id
```
```
users.personal_folder_id = content_favorites.dashboard.folder.parent_id
```
```
users.home_space_id = content_favorites.dashboard.space.id
```
```
users.personal_space_id = content_favorites.dashboard.space.id
```
```
users.home_space_id = content_favorites.dashboard.space.parent_id
```
```
users.personal_space_id = content_favorites.dashboard.space.parent_id
```
```
users.id = content_favorites.dashboard.folder.creator_id
```
```
users.id = content_favorites.dashboard.space.creator_id
```
```
users.id = content_favorites.user_id
``` |
| [dashboard_elements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboard-elements) | ```
users.home_folder_id = dashboard_elements.look.folder.id
```
```
users.personal_folder_id = dashboard_elements.look.folder.id
```
```
users.home_folder_id = dashboard_elements.look.folder.parent_id
```
```
users.personal_folder_id = dashboard_elements.look.folder.parent_id
```
```
users.home_folder_id = dashboard_elements.look.folder_id
```
```
users.personal_folder_id = dashboard_elements.look.folder_id
```
```
users.home_space_id = dashboard_elements.look.space.id
```
```
users.personal_space_id = dashboard_elements.look.space.id
```
```
users.home_space_id = dashboard_elements.look.space.parent_id
```
```
users.personal_space_id = dashboard_elements.look.space.parent_id
```
```
users.id = dashboard_elements.look.deleter_id
```
```
users.id = dashboard_elements.look.folder.creator_id
```
```
users.id = dashboard_elements.look.last_updater_id
```
```
users.id = dashboard_elements.look.space.creator_id
```
```
users.id = dashboard_elements.look.user.id
```
```
users.id = dashboard_elements.look.user_id
``` |
| [dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#dashboards) | ```
users.home_folder_id = dashboards.folder.id
```
```
users.personal_folder_id = dashboards.folder.id
```
```
users.home_folder_id = dashboards.folder.parent_id
```
```
users.personal_folder_id = dashboards.folder.parent_id
```
```
users.home_space_id = dashboards.space.id
```
```
users.personal_space_id = dashboards.space.id
```
```
users.home_space_id = dashboards.space.parent_id
```
```
users.personal_space_id = dashboards.space.parent_id
```
```
users.id = dashboards.space.creator_id
```
```
users.id = dashboards.user_id
``` |
| [folders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#folders) | ```
users.home_folder_id = folders.id
```
```
users.personal_folder_id = folders.id
```
```
users.home_folder_id = folders.dashboards.folder.id
```
```
users.personal_folder_id = folders.dashboards.folder.id
```
```
users.home_folder_id = folders.dashboards.folder.parent_id
```
```
users.personal_folder_id = folders.dashboards.folder.parent_id
```
```
users.home_folder_id = folders.looks.folder.id
```
```
users.personal_folder_id = folders.looks.folder.id
```
```
users.home_folder_id = folders.looks.folder.parent_id
```
```
users.personal_folder_id = folders.looks.folder.parent_id
```
```
users.home_folder_id = folders.parent_id
```
```
users.personal_folder_id = folders.parent_id
```
```
users.home_space_id = folders.dashboards.space.id
```
```
users.personal_space_id = folders.dashboards.space.id
```
```
users.home_space_id = folders.dashboards.space.parent_id
```
```
users.personal_space_id = folders.dashboards.space.parent_id
```
```
users.home_space_id = folders.looks.space.id
```
```
users.personal_space_id = folders.looks.space.id
```
```
users.home_space_id = folders.looks.space.parent_id
```
```
users.personal_space_id = folders.looks.space.parent_id
```
```
users.home_space_id = folders.looks.space_id
```
```
users.personal_space_id = folders.looks.space_id
```
```
users.id = folders.creator_id
```
```
users.id = folders.dashboards.user_id
```
```
users.id = folders.dashboards.folder.creator_id
```
```
users.id = folders.dashboards.space.creator_id
```
```
users.id = folders.looks.deleter_id
```
```
users.id = folders.looks.last_updater_id
```
```
users.id = folders.looks.user.id
``` |
| [lookml_dashboards](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#lookml-dashboards) | ```
users.home_folder_id = lookml_dashboards.folder.id
```
```
users.personal_folder_id = lookml_dashboards.folder.id
```
```
users.home_folder_id = lookml_dashboards.folder.parent_id
```
```
users.personal_folder_id = lookml_dashboards.folder.parent_id
```
```
users.home_space_id = lookml_dashboards.space.id
```
```
users.personal_space_id = lookml_dashboards.space.id
```
```
users.home_space_id = lookml_dashboards.space.parent_id
```
```
users.personal_space_id = lookml_dashboards.space.parent_id
```
```
users.id = lookml_dashboards.folder.creator_id
```
```
users.id = lookml_dashboards.space.creator_id
```
```
users.id = lookml_dashboards.user_id
``` |
| [looks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#looks) | ```
users.home_folder_id = looks.folder.id
```
```
users.personal_folder_id = looks.folder.id
```
```
users.home_folder_id = looks.folder_id
```
```
users.personal_folder_id = looks.folder_id
```
```
users.home_folder_id = looks.folder.parent_id
```
```
users.personal_folder_id = looks.folder.parent_id
```
```
users.home_space_id = looks.space.id
```
```
users.personal_space_id = looks.space.id
```
```
users.home_space_id = looks.space.parent_id
```
```
users.personal_space_id = looks.space.parent_id
```
```
users.home_space_id = looks.space_id
```
```
users.personal_space_id = looks.space_id
```
```
users.id = looks.deleter_id
```
```
users.id = looks.folder.creator_id
```
```
users.id = looks.user.id
```
```
users.id = looks.user_id
``` |
| [content_metadata_access](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata-access) | ```
users.group_ids = content_metadata_access.group_id
``` |
| [content_views](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-views) | ```
users.group_ids = content_views.group_id
```
```
users.id = content_views.user_id
``` |
| [groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#groups) | ```
users.group_ids = groups.id
``` |
| [groups_in_group](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#groups-in-group) | ```
users.group_ids = groups_in_group.id
```
```
users.group_ids = groups_in_group.parent_group_id
``` |
| [user_attribute_group_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-attribute-group-values) | ```
users.group_ids = user_attribute_group_values.group_id
``` |
| [versions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#versions) | ```
users.looker_versions = versions.looker_release_version
```
```
users.looker_versions = versions.current_version.full_version
```
```
users.looker_versions = versions.supported_versions.full_version
``` |
| [role_groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#role-groups) | ```
users.role_ids = role_groups.role_id
``` |
| [roles](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#roles) | ```
users.role_ids = roles.id
``` |
| [content_metadata](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#content-metadata) | ```
users.home_space_id = content_metadata.space_id
```
```
users.personal_space_id = content_metadata.space_id
``` |
| [user_sessions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-sessions) | ```
users.sessions.id = user_sessions.id
``` |
| [connections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#connections) | ```
users.id = connections.user_id
``` |
| [scheduled_plans](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#scheduled-plans) | ```
users.id = scheduled_plans.user.id
```
```
users.id = scheduled_plans.user_id
``` |
| [user_login_lockouts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#user-login-lockouts) | ```
users.id = user_login_lockouts.user_id
``` |
users table schema
| **avatar\_url**
STRING |
| --- |
| **avatar\_url\_without\_sizing**
STRING |
| **credentials\_api3**
ARRAY
This is a nested data structure:
- client_id: STRING
- created_at: STRING
- id: STRING
- is_disabled: BOOLEAN
- type: STRING
- url: STRING
|
| **credentials\_email**
OBJECT
This is a nested data structure:
- created_at: STRING
- email: STRING
- forced_password_reset_at_next_login: BOOLEAN
- is_disabled: BOOLEAN
- logged_in_at: STRING
- password_reset_url: STRING
- type: STRING
- url: STRING
- user_url: STRING
|
| **credentials\_embed**
ARRAY
This is a nested data structure:
- created_at: STRING
- external_group_id: STRING
- external_user_id: STRING
- id: STRING
- is_disabled: BOOLEAN
- logged_in_at: STRING
- type: STRING
- url: STRING
|
| **credentials\_google**
OBJECT
This is a nested data structure:
- created_at: STRING
- domain: STRING
- email: STRING
- google_user_id: STRING
- is_disabled: BOOLEAN
- logged_in_at: STRING
- type: STRING
- url: STRING
|
| **credentials\_ldap**
OBJECT
This is a nested data structure:
- created_at: STRING
- email: STRING
- is_disabled: BOOLEAN
- ldap_dn: STRING
- ldap_id: STRING
- logged_in_at: STRING
- type: STRING
- url: STRING
|
| **credentials\_looker\_openid**
OBJECT
This is a nested data structure:
- created_at: STRING
- email: STRING
- is_disabled: BOOLEAN
- logged_in_at: STRING
- logged_in_ip: STRING
- type: STRING
- url: STRING
- user_url: STRING
|
| **credentials\_oidc**
OBJECT
This is a nested data structure:
- created_at: STRING
- email: STRING
- is_disabled: BOOLEAN
- logged_in_at: STRING
- oidc_user_id: STRING
- type: STRING
- url: STRING
|
| **credentials\_saml**
OBJECT
This is a nested data structure:
- created_at: STRING
- email: STRING
- is_disabled: BOOLEAN
- logged_in_at: STRING
- saml_user_id: STRING
- type: STRING
- url: STRING
|
| **credentials\_totp**
OBJECT
This is a nested data structure:
- created_at: STRING
- is_disabled: BOOLEAN
- type: STRING
- url: STRING
- verified: BOOLEAN
|
| **display\_name**
STRING |
| **email**
STRING |
| **embed\_group\_space\_id**
STRING |
| **first\_name**
STRING |
| **group\_ids**
ARRAY
This is a nested data structure. |
| **home\_folder\_id**
STRING |
| **home\_space\_id**
STRING |
| **id**
STRING |
| **is\_disabled**
BOOLEAN |
| **last\_name**
STRING |
| **locale**
STRING |
| **looker\_versions**
ARRAY
This is a nested data structure. |
| **models\_dir\_validated**
BOOLEAN |
| **personal\_folder\_id**
STRING |
| **personal\_space\_id**
STRING |
| **presumed\_looker\_employee**
BOOLEAN |
| **role\_ids**
ARRAY
This is a nested data structure. |
| **roles\_externally\_managed**
BOOLEAN |
| **sessions**
ARRAY
This is a nested data structure:
- browser: STRING
- city: STRING
- country: STRING
- created_at: STRING
- credentials_type: STRING
- expires_at: STRING
- extended_at: STRING
- extended_count: INTEGER
- id: STRING
- ip_address: STRING
- operating_system: STRING
- state: STRING
- sudo_user_id: STRING
- url: STRING
|
| **ui\_state**
OBJECT
This is a nested data structure. |
| **url**
STRING |
| **verified\_looker\_employee**
BOOLEAN |
### versions
The `versions` table contains info about the API versions supported by your Looker instance.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | looker\_release\_version |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/config#get_apiversion "Opens in new tab: Looker API method") |
versions table foreign keys
| Join versions with | on |
| --- | --- |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#users) | ```
versions.looker_release_version = users.looker_versions
```
```
versions.current_version.full_version = users.looker_versions
```
```
versions.supported_versions.full_version = users.looker_versions
``` |
versions table schema
| **current\_version**
OBJECT
This is a nested data structure:
- full_version: STRING
- status: STRING
- swagger_url: STRING
- version: STRING
|
| --- |
| **looker\_release\_version**
STRING |
| **supported\_versions**
ARRAY
This is a nested data structure:
- full_version: STRING
- status: STRING
- swagger_url: STRING
- version: STRING
|
### workspaces
The `workspaces` table contains info about the workspaces available to the user who authorized the Looker integration in Stitch.
| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [Looker API method](https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/workspace#get_all_workspaces "Opens in new tab: Looker API method") |
workspaces table foreign keys
| Join workspaces with | on |
| --- | --- |
| [git_branches](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#git-branches) | ```
workspaces.projects.id = git_branches.project_id
``` |
| [project_files](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#project-files) | ```
workspaces.projects.id = project_files.project_id
``` |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Looker.htm#projects) | ```
workspaces.projects.id = projects.id
``` |
workspaces table schema
| **id**
STRING |
| --- |
| **projects**
ARRAY
This is a nested data structure:
- allow_warnings: BOOLEAN
- deploy_secret: STRING
- folders_enabled: BOOLEAN
- git_password: STRING
- git_password_user_attribute: STRING
- git_remote_url: STRING
- git_service_name: STRING
- git_username: STRING
- git_username_user_attribute: STRING
- id: STRING
- is_example: BOOLEAN
- name: STRING
- pull_request_mode: STRING
- unset_deploy_secret: BOOLEAN
- uses_git: BOOLEAN
- validation_required: BOOLEAN
|