> ## Documentation Index
> Fetch the complete documentation index at: https://docs.pinkfish.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# looker-queries

> Looker Queries - Run queries, manage looks, and retrieve data

**Server path:** `/looker-queries` | **Type:** Application | **PCID required:** Yes

## Tools

| Tool                                                                                    | Description                      |
| --------------------------------------------------------------------------------------- | -------------------------------- |
| [`looker_queries_all_looks`](#looker_queries_all_looks)                                 | Get All Looks                    |
| [`looker_queries_all_running_queries`](#looker_queries_all_running_queries)             | Get All Running Queries          |
| [`looker_queries_copy_look`](#looker_queries_copy_look)                                 | Copy Look                        |
| [`looker_queries_create_look`](#looker_queries_create_look)                             | Create Look                      |
| [`looker_queries_create_merge_query`](#looker_queries_create_merge_query)               | Create Merge Query               |
| [`looker_queries_create_query`](#looker_queries_create_query)                           | Create Query                     |
| [`looker_queries_create_query_task`](#looker_queries_create_query_task)                 | Run Query Async                  |
| [`looker_queries_create_sql_query`](#looker_queries_create_sql_query)                   | Create SQL Runner Query          |
| [`looker_queries_delete_look`](#looker_queries_delete_look)                             | Delete Look                      |
| [`looker_queries_kill_query`](#looker_queries_kill_query)                               | Kill Running Query               |
| [`looker_queries_look`](#looker_queries_look)                                           | Get Look                         |
| [`looker_queries_merge_query`](#looker_queries_merge_query)                             | Get Merge Query                  |
| [`looker_queries_move_look`](#looker_queries_move_look)                                 | Move Look                        |
| [`looker_queries_query`](#looker_queries_query)                                         | Get Query                        |
| [`looker_queries_query_for_slug`](#looker_queries_query_for_slug)                       | Get Query for Slug               |
| [`looker_queries_query_task`](#looker_queries_query_task)                               | Get Async Query Info             |
| [`looker_queries_query_task_multi_results`](#looker_queries_query_task_multi_results)   | Get Multiple Async Query Results |
| [`looker_queries_query_task_results`](#looker_queries_query_task_results)               | Get Async Query Results          |
| [`looker_queries_run_inline_query`](#looker_queries_run_inline_query)                   | Run Inline Query                 |
| [`looker_queries_run_look`](#looker_queries_run_look)                                   | Run Look                         |
| [`looker_queries_run_query`](#looker_queries_run_query)                                 | Run Query                        |
| [`looker_queries_run_sql_query`](#looker_queries_run_sql_query)                         | Run SQL Runner Query             |
| [`looker_queries_run_url_encoded_query`](#looker_queries_run_url_encoded_query)         | Run Url Encoded Query            |
| [`looker_queries_search_looks`](#looker_queries_search_looks)                           | Search Looks                     |
| [`looker_queries_sql_query`](#looker_queries_sql_query)                                 | Get SQL Runner Query             |
| [`looker_queries_update_look`](#looker_queries_update_look)                             | Update Look                      |
| [`looker_queries_update_look_certification`](#looker_queries_update_look_certification) | Update Look Certification        |

***

## looker\_queries\_all\_looks

Get All Looks

**Parameters:**

| Parameter | Type   | Required | Default | Description       |
| --------- | ------ | -------- | ------- | ----------------- |
| `fields`  | string | No       | —       | Requested fields. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "fields": {
        "type": "string",
        "description": "Requested fields."
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_all\_running\_queries

Get All Running Queries

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_copy\_look

Copy Look

**Parameters:**

| Parameter   | Type   | Required | Default | Description           |
| ----------- | ------ | -------- | ------- | --------------------- |
| `look_id`   | string | Yes      | —       | Look id to copy.      |
| `folder_id` | string | No       | —       | Folder id to copy to. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "look_id": {
        "type": "string",
        "description": "Look id to copy."
      },
      "folder_id": {
        "type": "string",
        "description": "Folder id to copy to."
      }
    },
    "required": [
      "PCID",
      "look_id"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_create\_look

Create Look

**Parameters:**

| Parameter | Type   | Required | Default | Description       |
| --------- | ------ | -------- | ------- | ----------------- |
| `fields`  | string | No       | —       | Requested fields. |
| `body`    | object | Yes      | —       | Look              |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "fields": {
        "type": "string",
        "description": "Requested fields."
      },
      "body": {
        "description": "Look"
      }
    },
    "required": [
      "PCID",
      "body"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_create\_merge\_query

Create Merge Query

**Parameters:**

| Parameter | Type   | Required | Default | Description      |
| --------- | ------ | -------- | ------- | ---------------- |
| `fields`  | string | No       | —       | Requested fields |
| `body`    | object | No       | —       | Merge Query      |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "fields": {
        "type": "string",
        "description": "Requested fields"
      },
      "body": {
        "description": "Merge Query"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_create\_query

Create Query

**Parameters:**

| Parameter | Type   | Required | Default | Description       |
| --------- | ------ | -------- | ------- | ----------------- |
| `fields`  | string | No       | —       | Requested fields. |
| `body`    | object | Yes      | —       | Query             |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "fields": {
        "type": "string",
        "description": "Requested fields."
      },
      "body": {
        "description": "Query"
      }
    },
    "required": [
      "PCID",
      "body"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_create\_query\_task

Run Query Async

**Parameters:**

| Parameter              | Type    | Required | Default | Description                                                                                                                                                 |
| ---------------------- | ------- | -------- | ------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `limit`                | integer | No       | —       | Row limit (may override the limit in the saved query).                                                                                                      |
| `apply_formatting`     | boolean | No       | —       | Apply model-specified formatting to each result.                                                                                                            |
| `apply_vis`            | boolean | No       | —       | Apply visualization options to results.                                                                                                                     |
| `cache`                | boolean | No       | —       | Get results from cache if available.                                                                                                                        |
| `generate_drill_links` | boolean | No       | —       | Generate drill links (only applicable to 'json\_detail' format.                                                                                             |
| `force_production`     | boolean | No       | —       | Force use of production models even if the user is in development mode. Note that this flag being false does not guarantee development models will be used. |
| `cache_only`           | boolean | No       | —       | Retrieve any results from cache even if the results have expired.                                                                                           |
| `path_prefix`          | string  | No       | —       | Prefix to use for drill links (url encoded).                                                                                                                |
| `rebuild_pdts`         | boolean | No       | —       | Rebuild PDTS used in query.                                                                                                                                 |
| `server_table_calcs`   | boolean | No       | —       | Perform table calculations on query results                                                                                                                 |
| `fields`               | string  | No       | —       | Requested fields                                                                                                                                            |
| `body`                 | object  | Yes      | —       | Query parameters                                                                                                                                            |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "limit": {
        "type": "integer",
        "description": "Row limit (may override the limit in the saved query)."
      },
      "apply_formatting": {
        "type": "boolean",
        "description": "Apply model-specified formatting to each result."
      },
      "apply_vis": {
        "type": "boolean",
        "description": "Apply visualization options to results."
      },
      "cache": {
        "type": "boolean",
        "description": "Get results from cache if available."
      },
      "generate_drill_links": {
        "type": "boolean",
        "description": "Generate drill links (only applicable to 'json_detail' format."
      },
      "force_production": {
        "type": "boolean",
        "description": "Force use of production models even if the user is in development mode. Note that this flag being false does not guarantee development models will be used."
      },
      "cache_only": {
        "type": "boolean",
        "description": "Retrieve any results from cache even if the results have expired."
      },
      "path_prefix": {
        "type": "string",
        "description": "Prefix to use for drill links (url encoded)."
      },
      "rebuild_pdts": {
        "type": "boolean",
        "description": "Rebuild PDTS used in query."
      },
      "server_table_calcs": {
        "type": "boolean",
        "description": "Perform table calculations on query results"
      },
      "fields": {
        "type": "string",
        "description": "Requested fields"
      },
      "body": {
        "description": "Query parameters"
      }
    },
    "required": [
      "PCID",
      "body"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_create\_sql\_query

Create SQL Runner Query

**Parameters:**

| Parameter | Type   | Required | Default | Description      |
| --------- | ------ | -------- | ------- | ---------------- |
| `body`    | object | Yes      | —       | SQL Runner Query |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "body": {
        "description": "SQL Runner Query"
      }
    },
    "required": [
      "PCID",
      "body"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_delete\_look

Delete Look

**Parameters:**

| Parameter | Type   | Required | Default | Description |
| --------- | ------ | -------- | ------- | ----------- |
| `look_id` | string | Yes      | —       | Id of look  |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "look_id": {
        "type": "string",
        "description": "Id of look"
      }
    },
    "required": [
      "PCID",
      "look_id"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_kill\_query

Kill Running Query

**Parameters:**

| Parameter       | Type   | Required | Default | Description    |
| --------------- | ------ | -------- | ------- | -------------- |
| `query_task_id` | string | Yes      | —       | Query task id. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "query_task_id": {
        "type": "string",
        "description": "Query task id."
      }
    },
    "required": [
      "PCID",
      "query_task_id"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_look

Get Look

**Parameters:**

| Parameter | Type   | Required | Default | Description       |
| --------- | ------ | -------- | ------- | ----------------- |
| `look_id` | string | Yes      | —       | Id of look        |
| `fields`  | string | No       | —       | Requested fields. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "look_id": {
        "type": "string",
        "description": "Id of look"
      },
      "fields": {
        "type": "string",
        "description": "Requested fields."
      }
    },
    "required": [
      "PCID",
      "look_id"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_merge\_query

Get Merge Query

**Parameters:**

| Parameter        | Type   | Required | Default | Description      |
| ---------------- | ------ | -------- | ------- | ---------------- |
| `merge_query_id` | string | Yes      | —       | Merge Query Id   |
| `fields`         | string | No       | —       | Requested fields |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "merge_query_id": {
        "type": "string",
        "description": "Merge Query Id"
      },
      "fields": {
        "type": "string",
        "description": "Requested fields"
      }
    },
    "required": [
      "PCID",
      "merge_query_id"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_move\_look

Move Look

**Parameters:**

| Parameter   | Type   | Required | Default | Description           |
| ----------- | ------ | -------- | ------- | --------------------- |
| `look_id`   | string | Yes      | —       | Look id to move.      |
| `folder_id` | string | Yes      | —       | Folder id to move to. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "look_id": {
        "type": "string",
        "description": "Look id to move."
      },
      "folder_id": {
        "type": "string",
        "description": "Folder id to move to."
      }
    },
    "required": [
      "PCID",
      "look_id",
      "folder_id"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_query

Get Query

**Parameters:**

| Parameter  | Type   | Required | Default | Description       |
| ---------- | ------ | -------- | ------- | ----------------- |
| `query_id` | string | Yes      | —       | Id of query       |
| `fields`   | string | No       | —       | Requested fields. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "query_id": {
        "type": "string",
        "description": "Id of query"
      },
      "fields": {
        "type": "string",
        "description": "Requested fields."
      }
    },
    "required": [
      "PCID",
      "query_id"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_query\_for\_slug

Get Query for Slug

**Parameters:**

| Parameter | Type   | Required | Default | Description       |
| --------- | ------ | -------- | ------- | ----------------- |
| `slug`    | string | Yes      | —       | Slug of query     |
| `fields`  | string | No       | —       | Requested fields. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "slug": {
        "type": "string",
        "description": "Slug of query"
      },
      "fields": {
        "type": "string",
        "description": "Requested fields."
      }
    },
    "required": [
      "PCID",
      "slug"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_query\_task

Get Async Query Info

**Parameters:**

| Parameter       | Type   | Required | Default | Description          |
| --------------- | ------ | -------- | ------- | -------------------- |
| `query_task_id` | string | Yes      | —       | ID of the Query Task |
| `fields`        | string | No       | —       | Requested fields.    |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "query_task_id": {
        "type": "string",
        "description": "ID of the Query Task"
      },
      "fields": {
        "type": "string",
        "description": "Requested fields."
      }
    },
    "required": [
      "PCID",
      "query_task_id"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_query\_task\_multi\_results

Get Multiple Async Query Results

**Parameters:**

| Parameter        | Type      | Required | Default | Description            |
| ---------------- | --------- | -------- | ------- | ---------------------- |
| `query_task_ids` | string\[] | Yes      | —       | List of Query Task IDs |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "query_task_ids": {
        "type": "array",
        "items": {
          "type": "string"
        },
        "description": "List of Query Task IDs"
      }
    },
    "required": [
      "PCID",
      "query_task_ids"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_query\_task\_results

Get Async Query Results

**Parameters:**

| Parameter       | Type   | Required | Default | Description          |
| --------------- | ------ | -------- | ------- | -------------------- |
| `query_task_id` | string | Yes      | —       | ID of the Query Task |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "query_task_id": {
        "type": "string",
        "description": "ID of the Query Task"
      }
    },
    "required": [
      "PCID",
      "query_task_id"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_run\_inline\_query

Run Inline Query

**Parameters:**

| Parameter                     | Type    | Required | Default | Description                                                                                                                                                 |
| ----------------------------- | ------- | -------- | ------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `result_format`               | string  | Yes      | —       | Format of result                                                                                                                                            |
| `limit`                       | integer | No       | —       | Row limit (may override the limit in the saved query).                                                                                                      |
| `apply_formatting`            | boolean | No       | —       | Apply model-specified formatting to each result.                                                                                                            |
| `apply_vis`                   | boolean | No       | —       | Apply visualization options to results.                                                                                                                     |
| `cache`                       | boolean | No       | —       | Get results from cache if available.                                                                                                                        |
| `image_width`                 | integer | No       | —       | Render width for image formats.                                                                                                                             |
| `image_height`                | integer | No       | —       | Render height for image formats.                                                                                                                            |
| `generate_drill_links`        | boolean | No       | —       | Generate drill links (only applicable to 'json\_detail' format.                                                                                             |
| `force_production`            | boolean | No       | —       | Force use of production models even if the user is in development mode. Note that this flag being false does not guarantee development models will be used. |
| `cache_only`                  | boolean | No       | —       | Retrieve any results from cache even if the results have expired.                                                                                           |
| `path_prefix`                 | string  | No       | —       | Prefix to use for drill links (url encoded).                                                                                                                |
| `rebuild_pdts`                | boolean | No       | —       | Rebuild PDTS used in query.                                                                                                                                 |
| `server_table_calcs`          | boolean | No       | —       | Perform table calculations on query results                                                                                                                 |
| `enable_oauth_error_response` | boolean | No       | —       | Return a specialized OAuth error response if a database OAuth error occurs.                                                                                 |
| `body`                        | object  | Yes      | —       | inline query                                                                                                                                                |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "result_format": {
        "type": "string",
        "description": "Format of result"
      },
      "limit": {
        "type": "integer",
        "description": "Row limit (may override the limit in the saved query)."
      },
      "apply_formatting": {
        "type": "boolean",
        "description": "Apply model-specified formatting to each result."
      },
      "apply_vis": {
        "type": "boolean",
        "description": "Apply visualization options to results."
      },
      "cache": {
        "type": "boolean",
        "description": "Get results from cache if available."
      },
      "image_width": {
        "type": "integer",
        "description": "Render width for image formats."
      },
      "image_height": {
        "type": "integer",
        "description": "Render height for image formats."
      },
      "generate_drill_links": {
        "type": "boolean",
        "description": "Generate drill links (only applicable to 'json_detail' format."
      },
      "force_production": {
        "type": "boolean",
        "description": "Force use of production models even if the user is in development mode. Note that this flag being false does not guarantee development models will be used."
      },
      "cache_only": {
        "type": "boolean",
        "description": "Retrieve any results from cache even if the results have expired."
      },
      "path_prefix": {
        "type": "string",
        "description": "Prefix to use for drill links (url encoded)."
      },
      "rebuild_pdts": {
        "type": "boolean",
        "description": "Rebuild PDTS used in query."
      },
      "server_table_calcs": {
        "type": "boolean",
        "description": "Perform table calculations on query results"
      },
      "enable_oauth_error_response": {
        "type": "boolean",
        "description": "Return a specialized OAuth error response if a database OAuth error occurs."
      },
      "body": {
        "description": "inline query"
      }
    },
    "required": [
      "PCID",
      "result_format",
      "body"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_run\_look

Run Look

**Parameters:**

| Parameter              | Type    | Required | Default | Description                                                                                                                                                 |
| ---------------------- | ------- | -------- | ------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `look_id`              | string  | Yes      | —       | Id of look                                                                                                                                                  |
| `result_format`        | string  | Yes      | —       | Format of result                                                                                                                                            |
| `limit`                | integer | No       | —       | Row limit (may override the limit in the saved query).                                                                                                      |
| `apply_formatting`     | boolean | No       | —       | Apply model-specified formatting to each result.                                                                                                            |
| `apply_vis`            | boolean | No       | —       | Apply visualization options to results.                                                                                                                     |
| `cache`                | boolean | No       | —       | Get results from cache if available.                                                                                                                        |
| `image_width`          | integer | No       | —       | Render width for image formats.                                                                                                                             |
| `image_height`         | integer | No       | —       | Render height for image formats.                                                                                                                            |
| `generate_drill_links` | boolean | No       | —       | Generate drill links (only applicable to 'json\_detail' format.                                                                                             |
| `force_production`     | boolean | No       | —       | Force use of production models even if the user is in development mode. Note that this flag being false does not guarantee development models will be used. |
| `cache_only`           | boolean | No       | —       | Retrieve any results from cache even if the results have expired.                                                                                           |
| `path_prefix`          | string  | No       | —       | Prefix to use for drill links (url encoded).                                                                                                                |
| `rebuild_pdts`         | boolean | No       | —       | Rebuild PDTS used in query.                                                                                                                                 |
| `server_table_calcs`   | boolean | No       | —       | Perform table calculations on query results                                                                                                                 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "look_id": {
        "type": "string",
        "description": "Id of look"
      },
      "result_format": {
        "type": "string",
        "description": "Format of result"
      },
      "limit": {
        "type": "integer",
        "description": "Row limit (may override the limit in the saved query)."
      },
      "apply_formatting": {
        "type": "boolean",
        "description": "Apply model-specified formatting to each result."
      },
      "apply_vis": {
        "type": "boolean",
        "description": "Apply visualization options to results."
      },
      "cache": {
        "type": "boolean",
        "description": "Get results from cache if available."
      },
      "image_width": {
        "type": "integer",
        "description": "Render width for image formats."
      },
      "image_height": {
        "type": "integer",
        "description": "Render height for image formats."
      },
      "generate_drill_links": {
        "type": "boolean",
        "description": "Generate drill links (only applicable to 'json_detail' format."
      },
      "force_production": {
        "type": "boolean",
        "description": "Force use of production models even if the user is in development mode. Note that this flag being false does not guarantee development models will be used."
      },
      "cache_only": {
        "type": "boolean",
        "description": "Retrieve any results from cache even if the results have expired."
      },
      "path_prefix": {
        "type": "string",
        "description": "Prefix to use for drill links (url encoded)."
      },
      "rebuild_pdts": {
        "type": "boolean",
        "description": "Rebuild PDTS used in query."
      },
      "server_table_calcs": {
        "type": "boolean",
        "description": "Perform table calculations on query results"
      }
    },
    "required": [
      "PCID",
      "look_id",
      "result_format"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_run\_query

Run Query

**Parameters:**

| Parameter                     | Type    | Required | Default | Description                                                                                                                                                 |
| ----------------------------- | ------- | -------- | ------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `query_id`                    | string  | Yes      | —       | Id of query                                                                                                                                                 |
| `result_format`               | string  | Yes      | —       | Format of result                                                                                                                                            |
| `limit`                       | integer | No       | —       | Row limit (may override the limit in the saved query).                                                                                                      |
| `apply_formatting`            | boolean | No       | —       | Apply model-specified formatting to each result.                                                                                                            |
| `apply_vis`                   | boolean | No       | —       | Apply visualization options to results.                                                                                                                     |
| `cache`                       | boolean | No       | —       | Get results from cache if available.                                                                                                                        |
| `image_width`                 | integer | No       | —       | Render width for image formats.                                                                                                                             |
| `image_height`                | integer | No       | —       | Render height for image formats.                                                                                                                            |
| `generate_drill_links`        | boolean | No       | —       | Generate drill links (only applicable to 'json\_detail' format.                                                                                             |
| `force_production`            | boolean | No       | —       | Force use of production models even if the user is in development mode. Note that this flag being false does not guarantee development models will be used. |
| `cache_only`                  | boolean | No       | —       | Retrieve any results from cache even if the results have expired.                                                                                           |
| `path_prefix`                 | string  | No       | —       | Prefix to use for drill links (url encoded).                                                                                                                |
| `rebuild_pdts`                | boolean | No       | —       | Rebuild PDTS used in query.                                                                                                                                 |
| `server_table_calcs`          | boolean | No       | —       | Perform table calculations on query results                                                                                                                 |
| `source`                      | string  | No       | —       | Specifies the source of this call.                                                                                                                          |
| `enable_oauth_error_response` | boolean | No       | —       | Return a specialized OAuth error response if a database OAuth error occurs.                                                                                 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "query_id": {
        "type": "string",
        "description": "Id of query"
      },
      "result_format": {
        "type": "string",
        "description": "Format of result"
      },
      "limit": {
        "type": "integer",
        "description": "Row limit (may override the limit in the saved query)."
      },
      "apply_formatting": {
        "type": "boolean",
        "description": "Apply model-specified formatting to each result."
      },
      "apply_vis": {
        "type": "boolean",
        "description": "Apply visualization options to results."
      },
      "cache": {
        "type": "boolean",
        "description": "Get results from cache if available."
      },
      "image_width": {
        "type": "integer",
        "description": "Render width for image formats."
      },
      "image_height": {
        "type": "integer",
        "description": "Render height for image formats."
      },
      "generate_drill_links": {
        "type": "boolean",
        "description": "Generate drill links (only applicable to 'json_detail' format."
      },
      "force_production": {
        "type": "boolean",
        "description": "Force use of production models even if the user is in development mode. Note that this flag being false does not guarantee development models will be used."
      },
      "cache_only": {
        "type": "boolean",
        "description": "Retrieve any results from cache even if the results have expired."
      },
      "path_prefix": {
        "type": "string",
        "description": "Prefix to use for drill links (url encoded)."
      },
      "rebuild_pdts": {
        "type": "boolean",
        "description": "Rebuild PDTS used in query."
      },
      "server_table_calcs": {
        "type": "boolean",
        "description": "Perform table calculations on query results"
      },
      "source": {
        "type": "string",
        "description": "Specifies the source of this call."
      },
      "enable_oauth_error_response": {
        "type": "boolean",
        "description": "Return a specialized OAuth error response if a database OAuth error occurs."
      }
    },
    "required": [
      "PCID",
      "query_id",
      "result_format"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_run\_sql\_query

Run SQL Runner Query

**Parameters:**

| Parameter       | Type   | Required | Default | Description                                                                                                                                                                                          |
| --------------- | ------ | -------- | ------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `slug`          | string | Yes      | —       | slug of query                                                                                                                                                                                        |
| `result_format` | string | Yes      | —       | Format of result, options are: \["inline\_json", "json", "json\_detail", "json\_fe", "json\_bi", "csv", "html", "md", "txt", "xlsx", "gsxml", "sql", "odc", "json\_label"]                           |
| `download`      | string | No       | —       | Defaults to false. If set to true, the HTTP response will have content-disposition and other headers set to make the HTTP response behave as a downloadable attachment instead of as inline content. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "slug": {
        "type": "string",
        "description": "slug of query"
      },
      "result_format": {
        "type": "string",
        "description": "Format of result, options are: [\"inline_json\", \"json\", \"json_detail\", \"json_fe\", \"json_bi\", \"csv\", \"html\", \"md\", \"txt\", \"xlsx\", \"gsxml\", \"sql\", \"odc\", \"json_label\"]"
      },
      "download": {
        "type": "string",
        "description": "Defaults to false. If set to true, the HTTP response will have content-disposition and other headers set to make the HTTP response behave as a downloadable attachment instead of as inline content."
      }
    },
    "required": [
      "PCID",
      "slug",
      "result_format"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_run\_url\_encoded\_query

Run Url Encoded Query

**Parameters:**

| Parameter       | Type   | Required | Default | Description      |
| --------------- | ------ | -------- | ------- | ---------------- |
| `model_name`    | string | Yes      | —       | Model name       |
| `view_name`     | string | Yes      | —       | View name        |
| `result_format` | string | Yes      | —       | Format of result |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "model_name": {
        "type": "string",
        "description": "Model name"
      },
      "view_name": {
        "type": "string",
        "description": "View name"
      },
      "result_format": {
        "type": "string",
        "description": "Format of result"
      }
    },
    "required": [
      "PCID",
      "model_name",
      "view_name",
      "result_format"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_search\_looks

Search Looks

**Parameters:**

| Parameter             | Type    | Required | Default | Description                                                                                                                                                                                                                                                                                                                          |
| --------------------- | ------- | -------- | ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `id`                  | string  | No       | —       | Match look id.                                                                                                                                                                                                                                                                                                                       |
| `title`               | string  | No       | —       | Match Look title.                                                                                                                                                                                                                                                                                                                    |
| `description`         | string  | No       | —       | Match Look description.                                                                                                                                                                                                                                                                                                              |
| `content_favorite_id` | string  | No       | —       | Select looks with a particular content favorite id                                                                                                                                                                                                                                                                                   |
| `folder_id`           | string  | No       | —       | Select looks in a particular folder.                                                                                                                                                                                                                                                                                                 |
| `user_id`             | string  | No       | —       | Select looks created by a particular user.                                                                                                                                                                                                                                                                                           |
| `view_count`          | string  | No       | —       | Select looks with particular view\_count value                                                                                                                                                                                                                                                                                       |
| `deleted`             | boolean | No       | —       | Select soft-deleted looks                                                                                                                                                                                                                                                                                                            |
| `query_id`            | string  | No       | —       | Select looks that reference a particular query by query\_id                                                                                                                                                                                                                                                                          |
| `curate`              | boolean | No       | —       | Exclude items that exist only in personal spaces other than the users                                                                                                                                                                                                                                                                |
| `last_viewed_at`      | string  | No       | —       | Select looks based on when they were last viewed                                                                                                                                                                                                                                                                                     |
| `fields`              | string  | No       | —       | Requested fields.                                                                                                                                                                                                                                                                                                                    |
| `page`                | integer | No       | —       | DEPRECATED. Use limit and offset instead. Return only page N of paginated results                                                                                                                                                                                                                                                    |
| `per_page`            | integer | No       | —       | DEPRECATED. Use limit and offset instead. Return N rows of data per page                                                                                                                                                                                                                                                             |
| `limit`               | integer | No       | —       | Number of results to return. (used with offset and takes priority over page and per\_page)                                                                                                                                                                                                                                           |
| `offset`              | integer | No       | —       | Number of results to skip before returning any. (used with limit and takes priority over page and per\_page)                                                                                                                                                                                                                         |
| `sorts`               | string  | No       | —       | One or more fields to sort results by. Sortable fields: \[:title, :user\_id, :id, :created\_at, :space\_id, :folder\_id, :description, :updated\_at, :last\_updater\_id, :view\_count, :favorite\_count, :content\_favorite\_id, :deleted, :deleted\_at, :last\_viewed\_at, :last\_accessed\_at, :query\_id, :certification\_status] |
| `filter_or`           | boolean | No       | —       | Combine given search criteria in a boolean OR expression                                                                                                                                                                                                                                                                             |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "id": {
        "type": "string",
        "description": "Match look id."
      },
      "title": {
        "type": "string",
        "description": "Match Look title."
      },
      "description": {
        "type": "string",
        "description": "Match Look description."
      },
      "content_favorite_id": {
        "type": "string",
        "description": "Select looks with a particular content favorite id"
      },
      "folder_id": {
        "type": "string",
        "description": "Select looks in a particular folder."
      },
      "user_id": {
        "type": "string",
        "description": "Select looks created by a particular user."
      },
      "view_count": {
        "type": "string",
        "description": "Select looks with particular view_count value"
      },
      "deleted": {
        "type": "boolean",
        "description": "Select soft-deleted looks"
      },
      "query_id": {
        "type": "string",
        "description": "Select looks that reference a particular query by query_id"
      },
      "curate": {
        "type": "boolean",
        "description": "Exclude items that exist only in personal spaces other than the users"
      },
      "last_viewed_at": {
        "type": "string",
        "description": "Select looks based on when they were last viewed"
      },
      "fields": {
        "type": "string",
        "description": "Requested fields."
      },
      "page": {
        "type": "integer",
        "description": "DEPRECATED. Use limit and offset instead. Return only page N of paginated results"
      },
      "per_page": {
        "type": "integer",
        "description": "DEPRECATED. Use limit and offset instead. Return N rows of data per page"
      },
      "limit": {
        "type": "integer",
        "description": "Number of results to return. (used with offset and takes priority over page and per_page)"
      },
      "offset": {
        "type": "integer",
        "description": "Number of results to skip before returning any. (used with limit and takes priority over page and per_page)"
      },
      "sorts": {
        "type": "string",
        "description": "One or more fields to sort results by. Sortable fields: [:title, :user_id, :id, :created_at, :space_id, :folder_id, :description, :updated_at, :last_updater_id, :view_count, :favorite_count, :content_favorite_id, :deleted, :deleted_at, :last_viewed_at, :last_accessed_at, :query_id, :certification_status]"
      },
      "filter_or": {
        "type": "boolean",
        "description": "Combine given search criteria in a boolean OR expression"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_sql\_query

Get SQL Runner Query

**Parameters:**

| Parameter | Type   | Required | Default | Description   |
| --------- | ------ | -------- | ------- | ------------- |
| `slug`    | string | Yes      | —       | slug of query |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "slug": {
        "type": "string",
        "description": "slug of query"
      }
    },
    "required": [
      "PCID",
      "slug"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_update\_look

Update Look

**Parameters:**

| Parameter | Type   | Required | Default | Description       |
| --------- | ------ | -------- | ------- | ----------------- |
| `look_id` | string | Yes      | —       | Id of look        |
| `fields`  | string | No       | —       | Requested fields. |
| `body`    | object | Yes      | —       | Look              |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "look_id": {
        "type": "string",
        "description": "Id of look"
      },
      "fields": {
        "type": "string",
        "description": "Requested fields."
      },
      "body": {
        "description": "Look"
      }
    },
    "required": [
      "PCID",
      "look_id",
      "body"
    ]
  }
  ```
</Expandable>

***

## looker\_queries\_update\_look\_certification

Update Look Certification

**Parameters:**

| Parameter | Type   | Required | Default | Description                      |
| --------- | ------ | -------- | ------- | -------------------------------- |
| `look_id` | string | Yes      | —       | Look id to update certification. |
| `body`    | object | Yes      | —       | Certification Data               |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "look_id": {
        "type": "string",
        "description": "Look id to update certification."
      },
      "body": {
        "description": "Certification Data"
      }
    },
    "required": [
      "PCID",
      "look_id",
      "body"
    ]
  }
  ```
</Expandable>