# Looker (v1) Information note **Looker is in beta** Looker is currently in beta. The info in this guide is subject to change. Information note **Looker is supported by the Singer community** This integration is powered by [Singer's](https://www.singer.io/) Looker tap. For support, [visit the GitHub repo](https://github.com/singer-io/tap-looker) or [join the Singer Slack](https://singer-slackin.herokuapp.com/). ## Looker integration summary Stitch’s Looker integration replicates data using the [Looker v4 API](https://developers.looker.com/api/explorer/4.0). Refer to the [Schema](https://help.qlik.com/en-US/stitch/integrations/saas/looker#schema) section for a list of objects available for replication. ## Looker feature snapshot A high-level look at Stitch's Looker (v1) integration, including release status, useful links, and the features supported in Stitch. | **STITCH** | | | | | --- | --- | --- | --- | | **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Beta | **Supported by**

the Info icon

Indicates if the integration is supported by Stitch or the Singer community. | [Singer Community](https://www.singer.io/) | | **Stitch plan**

the Info icon

The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**

the Info icon

Indicates if the integration is available as a source in Stitch Connect. | the Success icon

This version of the integration is available via the API.


Available | | **Singer GitHub repository** | [singer-io/tap-looker](https://github.com/singer-io/tap-looker) | | | | **REPLICATION SETTINGS** | | | | | **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)**

the Info icon

A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. | the Success icon

This feature is supported for this version of the integration.


Supported | **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)**

the Info icon

A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. | the Success icon

This feature is supported for this version of the integration.


Supported | | **Table-level reset**

the Info icon

Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. | the Remove icon

Table-level resets are not supported for this integration. Resets are only supported at the integration level.


Unsupported | **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)**

the Info icon

Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon

Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.


Unsupported | | **DATA SELECTION** | | | | | **Table selection**

the Info icon

The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. | the Success icon

This feature is supported for this version of the integration.


Supported | **Column selection**

the Info icon

The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Success icon

This feature is supported for this version of the integration.


Supported | | **Select all**

the Info icon

Indicates if the integration supports selecting all available tables and columns. | the Success icon

Supported


Supported | | | | **TRANSPARENCY** | | | | | **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)**

the Info icon

Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.


Supported | **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)**

the Info icon

Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.


Supported | ## Connecting Looker ### Looker setup requirements To set up Looker in Stitch, you need: * **Looker Admin privileges.** Admin privileges in Looker are required to generate credentials for Stitch. ### Step 1: Generate Looker API credentials for Stitch Information note **Note**: This step requires Admin privileges in Looker. 1. Sign into your Looker account. 2. Navigate to the **Edit Users** page. 3. Click the **Edit Keys** button. This will take you to the **Edit User API3 Keys** page. 4. Click the **New API3 key** button to generate a new key. 5. Copy your Client ID and Client Secret. Keep it readily available for the next step. ### Step 2: Add Looker as a Stitch data source 1. [Sign into your Stitch account](https://app.stitchdata.com/). 2. On the Stitch Dashboard page, click the **Add Integration** button. 3. Click the **Looker** icon. 4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination. For example, the name “Stitch Looker” would create a schema called `stitch_looker` in the destination. **Note**: Schema names cannot be changed after you save the integration. 5. In the **API Port** field, enter your API Port number. **Note**: This value is usually `19999` unless you host Looker internally. If hosting internally, use your internal API Port value. 6. In the **Client ID** field, paste the Client ID that you copied in [Step 1](https://help.qlik.com/en-US/stitch/integrations/saas/looker#api3-keys). 7. In the **Client Secret** field, paste the Client Secret that you copied in [Step 1](https://help.qlik.com/en-US/stitch/integrations/saas/looker#api3-keys). 8. In the **Domain** field, enter your Looker account domain. It’s typically `looker.com`, unless you use a white-labeled URL. 9. In the **Subdomain** field, enter your Looker account subdomain. Your subdomain is the leading part of your Looker URL. For example: If the URL is `https://stitch.looker.com`, the value for this field would be `stitch`. ### Step 3: Define the historical replication start date The Sync Historical Data setting defines the starting date for your Looker integration. This means that data **equal to or newer than this date** will be replicated to your data warehouse. Change this setting if you want to replicate data beyond Looker’s default setting of **1 year**. For a detailed look at historical replication jobs, check out the [Syncing Historical SaaS Data](https://help.qlik.com/en-US/stitch/replication/syncing-historical-saas-data-resetting-replication-keys) guide. ### Step 4: Create a replication schedule Information note Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the [Replication Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling) documentation for more information. In the **Replication Frequency** section, you’ll create the integration’s [replication schedule](https://help.qlik.com/en-US/stitch/replication/replication-scheduling). An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins. Looker integrations support the following replication scheduling methods: * [Replication Frequency](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/replication-frequency) * [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling) * [Advanced Scheduling using Cron](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling) (Advanced or Premium plans only) To keep your row usage low, consider setting the integration to replicate less frequently. See the [Understanding and Reducing Your Row Usage guide](https://help.qlik.com/en-US/stitch/getting-started/understanding-stitch-usage) for tips on reducing your usage. ### Step 5: Set objects to replicate Information note **Is an object missing or not replicating?** Verify that the object meets the requirements for [selection](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#selection-requirements) and [replication](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#replication-requirements). The last step is to select the tables and columns you want to replicate. [Learn about the available tables for this integration.](https://help.qlik.com/en-US/stitch/integrations/saas/looker#schema) **Note**: If a replication job is currently in progress, new selections won’t be used until the next job starts. * Selection options * Individual tables and columns * All tables and columns For Looker integrations, you can select: 1. **Individual tables and columns** 2. **All tables and columns** Click the tabs to view instructions for each selection method. 1. In the integration’s **Tables to Replicate tab**, locate a table you want to replicate. 2. To track a table, click the **checkbox** next to the table’s name. A blue checkmark means the table is set to replicate. 3. To track a column, click the **checkbox** next to the column’s name. A blue checkmark means the column is set to replicate. 4. Repeat this process for all the tables and columns you want to replicate. 5. When finished, click the **Finalize Your Selections** button at the bottom of the screen to save your selections. Information note **Important**: Using the **Select All** feature will overwrite any previous selections. However, selections aren’t final until **Finalize Your Selections** is clicked. Clicking **Cancel** will restore your previous selections. Refer to the [Select All guide](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#set-all-data-to-replicate) for more info about this feature. 1. Click into the integration from the Stitch Dashboard page. 2. Click the **Tables to Replicate** tab. 3. In the list of tables, click the box next to the **Table Names** column. 4. In the menu that displays, click **Track all Tables and Fields**: ![The Track all Tables and Fields menu in the Tables to Replicate tab](https://help.qlik.com/en-US/stitch/images/replication/select-all-tables-menu.png)The Track all Tables and Fields menu in the Tables to Replicate tabThe Track all Tables and Fields menu in the Tables to Replicate tab 5. Click the **Finalize Your Selections** button at the bottom of the page to save your data selections. ### Initial and historical replication jobs After you finish setting up Looker, its **Sync Status** may show as **Pending** on either the Stitch Dashboard or in the Integration Details page. For a new integration, a **Pending** status indicates that Stitch is in the process of scheduling the initial replication job for the integration. **This may take some time to complete.** Information note **Initial replication jobs with Anchor Scheduling** If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling#job-scheduling-and-anchor-times) documentation for more information. #### Free historical data loads The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota. Information note **Replication will continue after the seven days are over**. If you’re no longer interested in this source, be sure to **pause** or **delete** the integration to prevent unwanted usage. ## Looker table reference Information note **Schemas and versioning** Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing. The schema and info displayed below is for **version 1** of this integration. This is the latest version of the Looker integration. Information note **Table and column names in your destination** Depending on your destination, table and column names may not appear as they are outlined below. For example: Object names are lowercased in Redshift (`CusTomERs` > `customers`), while case is maintained in PostgreSQL destinations (`CusTomERs` > `CusTomERs`). Refer to the [Loading Guide](https://help.qlik.com/en-US/stitch/replication/loading/destination-guides) for your destination for more info. ### color\_collections The `color_collections` table contains information about color collections in your Looker account. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [color_collections schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/color_collections.json "Opens in new tab: color_collections schema on GitHub")


[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/stitch/integrations/saas/looker#themes) | ```
color_collections.id = themes.settings.color_collection_id
``` | color\_collections table schema | **categoricalPalettes**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand categoricalPalettes

colors

ARRAY

id

STRING

label

STRING

type

STRING

| | --- | | **divergingPalettes**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand divergingPalettes

id

STRING

label

STRING

stops

ARRAY

color

STRING

offset

NUMBER

type

STRING

| | **id**


STRING | | **label**


STRING | | **sequentialPalettes**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand sequentialPalettes

id

STRING

label

STRING

stops

ARRAY

color

STRING

offset

NUMBER

type

STRING

| ### connections The `connections` table contains information about connections in your Looker account. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | name | | **Useful links** | [connections schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/connections.json "Opens in new tab: connections schema on GitHub")


[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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#content-views) | ```
connections.user_id = content_views.user_id
``` | | [dashboard_elements](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#dashboards) | ```
connections.user_id = dashboards.space.creator_id
```

```
connections.user_id = dashboards.user_id
``` | | [folders](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#user-login-lockouts) | ```
connections.user_id = user_login_lockouts.user_id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand dialect

automatically_run_sql_runner_snippets

BOOLEAN

connection_tests

ARRAY

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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand pdt\_context\_override

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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand snippets

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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [content_favorites schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/content_favorites.json "Opens in new tab: content_favorites schema on GitHub")


[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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#roles) | ```
content_favorites.dashboard.model.id = roles.model_set.models
``` | | [connections](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand dashboard

content_favorite_id

STRING

content_metadata_id

STRING

description

STRING

folder

OBJECT

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

id

STRING

label

STRING

query_timezone

STRING

readonly

BOOLEAN

refresh_interval

STRING

refresh_interval_to_i

INTEGER

space

OBJECT

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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand look

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [content_metadata schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/content_metadata.json "Opens in new tab: content_metadata schema on GitHub")


[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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#dashboard-filters) | ```
content_metadata.dashboard_id = dashboard_filters.dashboard_id
``` | | [dashboard_layouts](https://help.qlik.com/en-US/stitch/integrations/saas/looker#dashboard-layouts) | ```
content_metadata.dashboard_id = dashboard_layouts.dashboard_id
``` | | [scheduled_plans](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [content_metadata_access schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/content_metadata_access.json "Opens in new tab: content_metadata_access schema on GitHub")


[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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#looks) | ```
content_metadata_access.content_metadata_id = looks.content_metadata_id
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/looker#groups) | ```
content_metadata_access.group_id = groups.id
``` | | [groups_in_group](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#user-attribute-group-values) | ```
content_metadata_access.group_id = user_attribute_group_values.group_id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [content_views schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/content_views.json "Opens in new tab: content_views schema on GitHub")


[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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#dashboard-filters) | ```
content_views.dashboard_id = dashboard_filters.dashboard_id
``` | | [dashboard_layouts](https://help.qlik.com/en-US/stitch/integrations/saas/looker#dashboard-layouts) | ```
content_views.dashboard_id = dashboard_layouts.dashboard_id
``` | | [scheduled_plans](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#groups) | ```
content_views.group_id = groups.id
``` | | [groups_in_group](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#user-attribute-group-values) | ```
content_views.group_id = user_attribute_group_values.group_id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/looker#users) | ```
content_views.group_id = users.group_ids
```

```
content_views.user_id = users.id
``` | | [connections](https://help.qlik.com/en-US/stitch/integrations/saas/looker#connections) | ```
content_views.user_id = connections.user_id
``` | | [user_login_lockouts](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [dashboard_elements schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/dashboard_elements.json "Opens in new tab: dashboard_elements schema on GitHub")


[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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#dashboard-filters) | ```
dashboard_elements.dashboard_id = dashboard_filters.dashboard_id
``` | | [dashboard_layouts](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#roles) | ```
dashboard_elements.look.model.id = roles.model_set.models
``` | | [queries](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand look

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

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

id

STRING

label

STRING

public

BOOLEAN

public_slug

STRING

public_url

STRING

query

OBJECT

client_id

STRING

column_limit

STRING

dynamic_fields

STRING

expanded_share_url

STRING

fields

ARRAY

fill_fields

ARRAY

filter_config

OBJECT

filter_expression

STRING

filters

OBJECT

has_table_calculations

BOOLEAN

id

STRING

limit

STRING

model

STRING

pivots

ARRAY

query_timezone

STRING

row_total

STRING

runtime

NUMBER

share_url

STRING

slug

STRING

sorts

ARRAY

subtotals

ARRAY

total

BOOLEAN

url

STRING

view

STRING

vis_config

OBJECT

visible_ui_sections

STRING

query_id

STRING

short_url

STRING

space

OBJECT

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

id

STRING

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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand query

client_id

STRING

column_limit

STRING

dynamic_fields

STRING

expanded_share_url

STRING

fields

ARRAY

fill_fields

ARRAY

filter_config

OBJECT

filter_expression

STRING

filters

OBJECT

has_table_calculations

BOOLEAN

id

STRING

limit

STRING

model

STRING

pivots

ARRAY

query_timezone

STRING

row_total

STRING

runtime

NUMBER

share_url

STRING

slug

STRING

sorts

ARRAY

subtotals

ARRAY

total

BOOLEAN

url

STRING

view

STRING

vis_config

OBJECT

visible_ui_sections

STRING

| | **query\_id**


STRING | | **refresh\_interval**


STRING | | **refresh\_interval\_to\_i**


INTEGER | | **result\_maker**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand result\_maker

dynamic_fields

STRING

filterables

ARRAY

listen

ARRAY

dashboard_filter_name

STRING

field

STRING

model

STRING

name

STRING

view

STRING

id

STRING

merge_result_id

STRING

query

OBJECT

client_id

STRING

column_limit

STRING

dynamic_fields

STRING

expanded_share_url

STRING

fields

ARRAY

fill_fields

ARRAY

filter_config

OBJECT

filter_expression

STRING

filters

OBJECT

has_table_calculations

BOOLEAN

id

STRING

limit

STRING

model

STRING

pivots

ARRAY

query_timezone

STRING

row_total

STRING

runtime

NUMBER

share_url

STRING

slug

STRING

sorts

ARRAY

subtotals

ARRAY

total

BOOLEAN

url

STRING

view

STRING

vis_config

OBJECT

visible_ui_sections

STRING

query_id

STRING

sorts

ARRAY

total

BOOLEAN

vis_config

OBJECT

| | **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [dashboard_filters schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/dashboard_filters.json "Opens in new tab: dashboard_filters schema on GitHub")


[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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#content-metadata) | ```
dashboard_filters.dashboard_id = content_metadata.dashboard_id
``` | | [content_views](https://help.qlik.com/en-US/stitch/integrations/saas/looker#content-views) | ```
dashboard_filters.dashboard_id = content_views.dashboard_id
``` | | [dashboard_elements](https://help.qlik.com/en-US/stitch/integrations/saas/looker#dashboard-elements) | ```
dashboard_filters.dashboard_id = dashboard_elements.dashboard_id
``` | | [dashboard_layouts](https://help.qlik.com/en-US/stitch/integrations/saas/looker#dashboard-layouts) | ```
dashboard_filters.dashboard_id = dashboard_layouts.dashboard_id
``` | | [dashboards](https://help.qlik.com/en-US/stitch/integrations/saas/looker#dashboards) | ```
dashboard_filters.dashboard_id = dashboards.id
``` | | [folders](https://help.qlik.com/en-US/stitch/integrations/saas/looker#folders) | ```
dashboard_filters.dashboard_id = folders.dashboards.id
``` | | [scheduled_plans](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **id**


STRING | | **listens\_to\_filters**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **model**


STRING | | **name**


STRING | | **required**


BOOLEAN | | **row**


INTEGER | | **title**


STRING | | **type**


STRING | | **ui\_config**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | ### dashboard\_layouts The `dashboard_layouts` table contains information about all dashboard layouts in your Looker instance. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [dashboard_layouts schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/dashboard_layouts.json "Opens in new tab: dashboard_layouts schema on GitHub")


[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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#content-metadata) | ```
dashboard_layouts.dashboard_id = content_metadata.dashboard_id
``` | | [content_views](https://help.qlik.com/en-US/stitch/integrations/saas/looker#content-views) | ```
dashboard_layouts.dashboard_id = content_views.dashboard_id
``` | | [dashboard_elements](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#dashboard-filters) | ```
dashboard_layouts.dashboard_id = dashboard_filters.dashboard_id
``` | | [dashboards](https://help.qlik.com/en-US/stitch/integrations/saas/looker#dashboards) | ```
dashboard_layouts.dashboard_id = dashboards.id
``` | | [folders](https://help.qlik.com/en-US/stitch/integrations/saas/looker#folders) | ```
dashboard_layouts.dashboard_id = folders.dashboards.id
``` | | [scheduled_plans](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand dashboard\_layout\_components

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [dashboards schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/dashboards.json "Opens in new tab: dashboards schema on GitHub")


[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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#dashboard-filters) | ```
dashboards.id = dashboard_filters.dashboard_id
``` | | [dashboard_layouts](https://help.qlik.com/en-US/stitch/integrations/saas/looker#dashboard-layouts) | ```
dashboards.id = dashboard_layouts.dashboard_id
``` | | [scheduled_plans](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#roles) | ```
dashboards.model.id = roles.model_set.models
``` | | [connections](https://help.qlik.com/en-US/stitch/integrations/saas/looker#connections) | ```
dashboards.space.creator_id = connections.user_id
```

```
dashboards.user_id = connections.user_id
``` | | [user_login_lockouts](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand folder

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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand model

id

STRING

label

STRING

| | **query\_timezone**


STRING | | **readonly**


BOOLEAN | | **refresh\_interval**


STRING | | **refresh\_interval\_to\_i**


INTEGER | | **space**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand space

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [datagroups schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/datagroups.json "Opens in new tab: datagroups schema on GitHub")


[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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [explores schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/explores.json "Opens in new tab: explores schema on GitHub")


[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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | --- | | **access\_filters**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand access\_filters

field

STRING

user_attribute

STRING

| | **aliases**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand aliases

name

STRING

value

STRING

| | **always\_filter**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand always\_filter

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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand conditionally\_filter

name

STRING

value

STRING

| | **connection\_name**


STRING | | **description**


STRING | | **errors**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand errors

details

ANY

error_pos

STRING

field_error

BOOLEAN

message

STRING

| | **fields**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand fields

dimensions

ARRAY

align

STRING

can_filter

BOOLEAN

can_time_filter

BOOLEAN

category

STRING

default_filter_value

STRING

description

STRING

dynamic

BOOLEAN

enumerations

ARRAY

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

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

condition

STRING

value

STRING

strict_value_format

BOOLEAN

suggest_dimension

STRING

suggest_explore

STRING

suggestable

BOOLEAN

suggestions

ARRAY

tags

ARRAY

time_interval

OBJECT

count

STRING

name

STRING

type

STRING

user_attribute_filter_types

ARRAY

value_format

STRING

view

STRING

view_label

STRING

week_start_day

STRING

filters

ARRAY

align

STRING

can_filter

BOOLEAN

can_time_filter

BOOLEAN

category

STRING

default_filter_value

STRING

description

STRING

dynamic

BOOLEAN

enumerations

ARRAY

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

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

condition

STRING

value

STRING

strict_value_format

BOOLEAN

suggest_dimension

STRING

suggest_explore

STRING

suggestable

BOOLEAN

suggestions

ARRAY

tags

ARRAY

time_interval

OBJECT

count

STRING

name

STRING

type

STRING

user_attribute_filter_types

ARRAY

value_format

STRING

view

STRING

view_label

STRING

week_start_day

STRING

measures

ARRAY

align

STRING

can_filter

BOOLEAN

can_time_filter

BOOLEAN

category

STRING

default_filter_value

STRING

description

STRING

dynamic

BOOLEAN

enumerations

ARRAY

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

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

condition

STRING

value

STRING

strict_value_format

BOOLEAN

suggest_dimension

STRING

suggest_explore

STRING

suggestable

BOOLEAN

suggestions

ARRAY

tags

ARRAY

time_interval

OBJECT

count

STRING

name

STRING

type

STRING

user_attribute_filter_types

ARRAY

value_format

STRING

view

STRING

view_label

STRING

week_start_day

STRING

parameters

ARRAY

align

STRING

can_filter

BOOLEAN

can_time_filter

BOOLEAN

category

STRING

default_filter_value

STRING

description

STRING

dynamic

BOOLEAN

enumerations

ARRAY

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

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

condition

STRING

value

STRING

strict_value_format

BOOLEAN

suggest_dimension

STRING

suggest_explore

STRING

suggestable

BOOLEAN

suggestions

ARRAY

tags

ARRAY

time_interval

OBJECT

count

STRING

name

STRING

type

STRING

user_attribute_filter_types

ARRAY

value_format

STRING

view

STRING

view_label

STRING

week_start_day

STRING

| | **files**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **group\_label**


STRING | | **has\_timezone\_support**


BOOLEAN | | **hidden**


BOOLEAN | | **id**


STRING | | **index\_fields**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **joins**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand joins

dependent_fields

ARRAY

fields

ARRAY

foreign_key

STRING

from

STRING

name

STRING

outer_only

BOOLEAN

relationship

STRING

required_joins

ARRAY

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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **sets**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand sets

name

STRING

value

ARRAY

| | **source\_file**


STRING | | **sql\_table\_name**


STRING | | **supported\_measure\_types**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand supported\_measure\_types

dimension_type

STRING

measure_types

ARRAY

| | **supports\_cost\_estimate**


BOOLEAN | | **tags**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **view\_name**


STRING | ### folders The `folders` table contains information about all folders in your Looker instance. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [folders schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/folders.json "Opens in new tab: folders schema on GitHub")


[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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#dashboard-filters) | ```
folders.dashboards.id = dashboard_filters.dashboard_id
``` | | [dashboard_layouts](https://help.qlik.com/en-US/stitch/integrations/saas/looker#dashboard-layouts) | ```
folders.dashboards.id = dashboard_layouts.dashboard_id
``` | | [scheduled_plans](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#roles) | ```
folders.dashboards.model.id = roles.model_set.models
```

```
folders.looks.model.id = roles.model_set.models
``` | | [queries](https://help.qlik.com/en-US/stitch/integrations/saas/looker#queries) | ```
folders.looks.query_id = queries.id
``` | | [connections](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand dashboards

content_favorite_id

STRING

content_metadata_id

STRING

description

STRING

folder

OBJECT

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

id

STRING

label

STRING

query_timezone

STRING

readonly

BOOLEAN

refresh_interval

STRING

refresh_interval_to_i

INTEGER

space

OBJECT

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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand looks

content_favorite_id

STRING

content_metadata_id

STRING

created_at

DATE-TIME

dashboards

ARRAY

content_favorite_id

STRING

content_metadata_id

STRING

description

STRING

folder

OBJECT

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

id

STRING

label

STRING

query_timezone

STRING

readonly

BOOLEAN

refresh_interval

STRING

refresh_interval_to_i

INTEGER

space

OBJECT

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

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

id

STRING

label

STRING

public

BOOLEAN

public_slug

STRING

public_url

STRING

query_id

STRING

short_url

STRING

space

OBJECT

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

id

STRING

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | name

project\_id | | **Useful links** | [git_branches schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/git_branches.json "Opens in new tab: git_branches schema on GitHub")


[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/stitch/integrations/saas/looker#project-files) | ```
git_branches.project_id = project_files.project_id
``` | | [projects](https://help.qlik.com/en-US/stitch/integrations/saas/looker#projects) | ```
git_branches.project_id = projects.id
``` | | [workspaces](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [groups schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/groups.json "Opens in new tab: groups schema on GitHub")


[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/stitch/integrations/saas/looker#content-metadata-access) | ```
groups.id = content_metadata_access.group_id
``` | | [content_views](https://help.qlik.com/en-US/stitch/integrations/saas/looker#content-views) | ```
groups.id = content_views.group_id
``` | | [groups_in_group](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#user-attribute-group-values) | ```
groups.id = user_attribute_group_values.group_id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [groups_in_group schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/groups_in_group.json "Opens in new tab: groups_in_group schema on GitHub")


[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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [integration_hubs schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/integration_hubs.json "Opens in new tab: integration_hubs schema on GitHub")


[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/stitch/integrations/saas/looker#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [integrations schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/integrations.json "Opens in new tab: integrations schema on GitHub")


[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/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand params

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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand required\_fields

all_tags

ARRAY

any_tag

ARRAY

tag

STRING

| | **supported\_action\_types**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **supported\_download\_settings**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **supported\_formats**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **supported\_formattings**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **supported\_visualization\_formattings**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **uses\_oauth**


BOOLEAN | ### lookml\_dashboards The `lookml_dashboards` table contains information about LookML dashboards in your Looker instance. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [lookml_dashboards schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/lookml_dashboards.json "Opens in new tab: lookml_dashboards schema on GitHub")


[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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#roles) | ```
lookml_dashboards.model.id = roles.model_set.models
``` | | [connections](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand folder

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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand model

id

STRING

label

STRING

| | **query\_timezone**


STRING | | **readonly**


BOOLEAN | | **refresh\_interval**


STRING | | **refresh\_interval\_to\_i**


INTEGER | | **space**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand space

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | name

project\_name | | **Useful links** | [lookml_models schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/lookml_models.json "Opens in new tab: lookml_models schema on GitHub")


[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

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | --- | | **explores**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand explores

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](https://help.qlik.com/en-US/stitch/integrations/saas/looker), this table doesn’t include soft-deleted looks. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [looks schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/looks.json "Opens in new tab: looks schema on GitHub")


[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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#content-metadata-access) | ```
looks.content_metadata_id = content_metadata_access.content_metadata_id
``` | | [content_views](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#roles) | ```
looks.model.id = roles.model_set.models
``` | | [queries](https://help.qlik.com/en-US/stitch/integrations/saas/looker#queries) | ```
looks.query_id = queries.id
``` | | [connections](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand folder

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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand model

id

STRING

label

STRING

| | **public**


BOOLEAN | | **public\_slug**


STRING | | **public\_url**


STRING | | **query\_id**


STRING | | **short\_url**


STRING | | **space**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand space

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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand user

id

STRING

| | **user\_id**


STRING | | **view\_count**


INTEGER | ### merge\_queries The `merge_queries` table contains info about the merge queries in your Looker instance. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [merge_queries schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/merge_queries.json "Opens in new tab: merge_queries schema on GitHub")


[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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **result\_maker\_id**


STRING | | **sorts**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **source\_queries**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand source\_queries

merge_fields

ARRAY

field_name

STRING

source_field_name

STRING

name

STRING

query_id

STRING

| | **total**


BOOLEAN | | **vis\_config**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | ### model\_sets The `model_sets` table contains info about the role model sets in your Looker instance. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [model_sets schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/model_sets.json "Opens in new tab: model_sets schema on GitHub")


[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/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **name**


STRING | | **url**


STRING | ### models The `models` table contains information about individual models in your Looker account. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | name

project\_name | | **Useful links** | [models schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/models.json "Opens in new tab: models schema on GitHub")


[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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | --- | | **explores**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand explores

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [permission_sets schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/permission_sets.json "Opens in new tab: permission_sets schema on GitHub")


[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/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **url**


STRING | ### permissions The `permissions` table contains info about the permissions listed in your Looker account. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | permission | | **Useful links** | [permissions schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/permissions.json "Opens in new tab: permissions schema on GitHub")


[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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [project_files schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/project_files.json "Opens in new tab: project_files schema on GitHub")


[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/stitch/integrations/saas/looker#git-branches) | ```
project_files.project_id = git_branches.project_id
``` | | [projects](https://help.qlik.com/en-US/stitch/integrations/saas/looker#projects) | ```
project_files.project_id = projects.id
``` | | [workspaces](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand git\_status

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [projects schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/projects.json "Opens in new tab: projects schema on GitHub")


[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/stitch/integrations/saas/looker#git-branches) | ```
projects.id = git_branches.project_id
``` | | [project_files](https://help.qlik.com/en-US/stitch/integrations/saas/looker#project-files) | ```
projects.id = project_files.project_id
``` | | [workspaces](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [queries schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/queries.json "Opens in new tab: queries schema on GitHub")


[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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#folders) | ```
queries.id = folders.looks.query_id
``` | | [looks](https://help.qlik.com/en-US/stitch/integrations/saas/looker#looks) | ```
queries.id = looks.query_id
``` | | [scheduled_plans](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **fill\_fields**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **filter\_config**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **filter\_expression**


STRING | | **filters**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **has\_table\_calculations**


BOOLEAN | | **id**


STRING | | **limit**


STRING | | **model**


STRING | | **pivots**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **query\_timezone**


STRING | | **row\_total**


STRING | | **runtime**


NUMBER | | **share\_url**


STRING | | **slug**


STRING | | **sorts**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **subtotals**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **total**


BOOLEAN | | **url**


STRING | | **view**


STRING | | **vis\_config**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **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, Sttich will submit a query with [the properties in this file](https://github.com/singer-io/tap-looker/blob/master/tap_looker/streams.py#L363) to the Looker API. The results of Stitch’s query are then extracted and replicated to your destination. **Note**: Stitch’s Looker integration only replicates the **past seven days** of query history at any given time. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | dims\_hash\_key

history\_created\_date

query\_id | | **Useful links** | [query_history schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/query_history.json "Opens in new tab: query_history schema on GitHub")


[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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [role_groups schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/role_groups.json "Opens in new tab: role_groups schema on GitHub")


[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/stitch/integrations/saas/looker#roles) | ```
role_groups.role_id = roles.id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [roles schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/roles.json "Opens in new tab: roles schema on GitHub")


[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/stitch/integrations/saas/looker#model-sets) | ```
roles.model_set.id = model_sets.id
```

```
roles.model_set_id = model_sets.id
``` | | [content_favorites](https://help.qlik.com/en-US/stitch/integrations/saas/looker#content-favorites) | ```
roles.model_set.models = content_favorites.dashboard.model.id
``` | | [dashboard_elements](https://help.qlik.com/en-US/stitch/integrations/saas/looker#dashboard-elements) | ```
roles.model_set.models = dashboard_elements.look.model.id
``` | | [dashboards](https://help.qlik.com/en-US/stitch/integrations/saas/looker#dashboards) | ```
roles.model_set.models = dashboards.model.id
``` | | [folders](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#lookml-dashboards) | ```
roles.model_set.models = lookml_dashboards.model.id
``` | | [looks](https://help.qlik.com/en-US/stitch/integrations/saas/looker#looks) | ```
roles.model_set.models = looks.model.id
``` | | [permission_sets](https://help.qlik.com/en-US/stitch/integrations/saas/looker#permission-sets) | ```
roles.permission_set_id = permission_sets.id
```

```
roles.id = permission_sets.id
``` | | [role_groups](https://help.qlik.com/en-US/stitch/integrations/saas/looker#role-groups) | ```
roles.id = role_groups.role_id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/looker#users) | ```
roles.id = users.role_ids
``` | roles table schema | **id**


STRING | | --- | | **model\_set**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand model\_set

all_access

BOOLEAN

built_in

BOOLEAN

id

STRING

models

ARRAY

name

STRING

url

STRING

| | **model\_set\_id**


STRING | | **name**


STRING | | **permission\_set**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand permission\_set

all_access

BOOLEAN

built_in

BOOLEAN

id

STRING

name

STRING

permissions

ARRAY

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [scheduled_plans schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/scheduled_plans.json "Opens in new tab: scheduled_plans schema on GitHub")


[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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#dashboard-filters) | ```
scheduled_plans.dashboard_id = dashboard_filters.dashboard_id
``` | | [dashboard_layouts](https://help.qlik.com/en-US/stitch/integrations/saas/looker#dashboard-layouts) | ```
scheduled_plans.dashboard_id = dashboard_layouts.dashboard_id
``` | | [dashboards](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#queries) | ```
scheduled_plans.query_id = queries.id
``` | | [connections](https://help.qlik.com/en-US/stitch/integrations/saas/looker#connections) | ```
scheduled_plans.user.id = connections.user_id
```

```
scheduled_plans.user_id = connections.user_id
``` | | [user_login_lockouts](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand scheduled\_plan\_destination

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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand user

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [themes schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/themes.json "Opens in new tab: themes schema on GitHub")


[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/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand settings

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [user_attribute_group_values schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/user_attribute_group_values.json "Opens in new tab: user_attribute_group_values schema on GitHub")


[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/stitch/integrations/saas/looker#content-metadata-access) | ```
user_attribute_group_values.group_id = content_metadata_access.group_id
``` | | [content_views](https://help.qlik.com/en-US/stitch/integrations/saas/looker#content-views) | ```
user_attribute_group_values.group_id = content_views.group_id
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/looker#groups) | ```
user_attribute_group_values.group_id = groups.id
``` | | [groups_in_group](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#users) | ```
user_attribute_group_values.group_id = users.group_ids
``` | | [user_attributes](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | user\_attribute\_id

user\_id | | **Useful links** | [user_attribute_values schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/user_attribute_values.json "Opens in new tab: user_attribute_values schema on GitHub")


[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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [user_attributes schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/user_attributes.json "Opens in new tab: user_attributes schema on GitHub")


[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/stitch/integrations/saas/looker#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | key | | **Useful links** | [user_login_lockouts schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/user_login_lockouts.json "Opens in new tab: user_login_lockouts schema on GitHub")


[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/stitch/integrations/saas/looker#connections) | ```
user_login_lockouts.user_id = connections.user_id
``` | | [content_favorites](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#content-views) | ```
user_login_lockouts.user_id = content_views.user_id
``` | | [dashboard_elements](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [user_sessions schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/user_sessions.json "Opens in new tab: user_sessions schema on GitHub")


[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/stitch/integrations/saas/looker#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [users schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/users.json "Opens in new tab: users schema on GitHub")


[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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#content-metadata-access) | ```
users.group_ids = content_metadata_access.group_id
``` | | [content_views](https://help.qlik.com/en-US/stitch/integrations/saas/looker#content-views) | ```
users.group_ids = content_views.group_id
```

```
users.id = content_views.user_id
``` | | [groups](https://help.qlik.com/en-US/stitch/integrations/saas/looker#groups) | ```
users.group_ids = groups.id
``` | | [groups_in_group](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#user-attribute-group-values) | ```
users.group_ids = user_attribute_group_values.group_id
``` | | [versions](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#role-groups) | ```
users.role_ids = role_groups.role_id
``` | | [roles](https://help.qlik.com/en-US/stitch/integrations/saas/looker#roles) | ```
users.role_ids = roles.id
``` | | [content_metadata](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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/stitch/integrations/saas/looker#user-sessions) | ```
users.sessions.id = user_sessions.id
``` | | [connections](https://help.qlik.com/en-US/stitch/integrations/saas/looker#connections) | ```
users.id = connections.user_id
``` | | [scheduled_plans](https://help.qlik.com/en-US/stitch/integrations/saas/looker#scheduled-plans) | ```
users.id = scheduled_plans.user.id
```

```
users.id = scheduled_plans.user_id
``` | | [user_login_lockouts](https://help.qlik.com/en-US/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand credentials\_api3

client_id

STRING

created_at

STRING

id

STRING

is_disabled

BOOLEAN

type

STRING

url

STRING

| | **credentials\_email**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand credentials\_email

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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand credentials\_embed

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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand credentials\_google

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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand credentials\_ldap

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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand credentials\_looker\_openid

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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand credentials\_oidc

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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand credentials\_saml

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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand credentials\_totp

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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **roles\_externally\_managed**


BOOLEAN | | **sessions**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand sessions

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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **url**


STRING | | **verified\_looker\_employee**


BOOLEAN | ### versions The `versions` table contains info about the API versions supported by your Looker instance. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | looker\_release\_version | | **Useful links** | [versions schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/versions.json "Opens in new tab: versions schema on GitHub")


[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/stitch/integrations/saas/looker#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand current\_version

full_version

STRING

status

STRING

swagger_url

STRING

version

STRING

| | --- | | **looker\_release\_version**


STRING | | **supported\_versions**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand supported\_versions

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [workspaces schema on GitHub](https://github.com/singer-io/tap-looker/blob/master/tap_looker/schemas/workspaces.json "Opens in new tab: workspaces schema on GitHub")


[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/stitch/integrations/saas/looker#git-branches) | ```
workspaces.projects.id = git_branches.project_id
``` | | [project_files](https://help.qlik.com/en-US/stitch/integrations/saas/looker#project-files) | ```
workspaces.projects.id = project_files.project_id
``` | | [projects](https://help.qlik.com/en-US/stitch/integrations/saas/looker#projects) | ```
workspaces.projects.id = projects.id
``` | workspaces table schema | **id**


STRING | | --- | | **projects**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand projects

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

|