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

# Bigquery: Actions/update Semantic Layer

> Validating and saving the active BigQuery semantic layer YAML for the organization. Includes inputs, outputs, SDK V2 examples, and Deepline cost.

Validating and saving the active BigQuery semantic layer YAML for the organization.

<Info>
  Tool ID: `bigquery_update_semantic_layer`
</Info>

## Run this action

Use the TypeScript SDK for a single call. Put `ctx.tools.execute(...)` inside a Play when the call should be durable, scheduled, or run across a CSV.

```ts theme={null}
import { Deepline } from 'deepline';

const deepline = await Deepline.connect();
const result = await deepline.tools.execute(
  'bigquery_update_semantic_layer',
  {
    "yaml": "example",
    "content": "Example message",
    "dryRun": false
  },
);

console.log(result.toolResponse.raw);
```

### CLI

```bash theme={null}
deepline tools execute bigquery_update_semantic_layer --input '{
  "yaml": "example",
  "content": "Example message",
  "dryRun": false
}' --json
```

## Example response

The SDK exposes this shape at `result.toolResponse.raw`. Values below are representative.

```json theme={null}
{
  "data": {
    "ok": true,
    "configured": true,
    "source": "convex",
    "provider": "bigquery",
    "contentHash": "example",
    "updatedAt": "2026-01-15T12:00:00Z",
    "tableCount": 123,
    "tables": [
      "example"
    ],
    "dryRun": true
  }
}
```

Use `deepline tools get bigquery_update_semantic_layer --json` for the latest machine-readable contract.

## Input reference

Validate and save the active BigQuery semantic layer for the organization.

| Name              | Type      | Required | Default | Details                                                                         |
| ----------------- | --------- | -------- | ------- | ------------------------------------------------------------------------------- |
| `payload.yaml`    | `string`  | No       | —       | Full BigQuery semantic layer YAML. Use either yaml or content.                  |
| `payload.content` | `string`  | No       | —       | Alias for yaml, useful for generic document upload callers.                     |
| `payload.dryRun`  | `boolean` | No       | `false` | Validate and return metadata without writing the semantic layer. Default false. |

<details>
  <summary>Show raw input schema</summary>

  ### Input JSON Schema

  ```json theme={null}
  {
    "type": "object",
    "description": "Validate and save the active BigQuery semantic layer for the organization.",
    "properties": {
      "yaml": {
        "type": "string",
        "description": "Full BigQuery semantic layer YAML. Use either yaml or content."
      },
      "content": {
        "type": "string",
        "description": "Alias for yaml, useful for generic document upload callers."
      },
      "dryRun": {
        "type": "boolean",
        "description": "Validate and return metadata without writing the semantic layer. Default false.",
        "default": false
      }
    },
    "additionalProperties": false
  }
  ```
</details>

## Output reference

BigQuery semantic layer update result.

| Name                      | Type             | Required | Default | Details                        |
| ------------------------- | ---------------- | -------- | ------- | ------------------------------ |
| `result.data`             | `object`         | Yes      | —       | Saved semantic layer metadata. |
| `result.data.ok`          | `boolean`        | Yes      | —       | —                              |
| `result.data.configured`  | `boolean`        | Yes      | —       | —                              |
| `result.data.source`      | `"convex"`       | Yes      | —       | Allowed: `convex`.             |
| `result.data.provider`    | `"bigquery"`     | Yes      | —       | —                              |
| `result.data.contentHash` | `string`         | Yes      | —       | —                              |
| `result.data.updatedAt`   | `string \| null` | Yes      | —       | —                              |
| `result.data.tableCount`  | `integer`        | Yes      | —       | —                              |
| `result.data.tables`      | `array`          | Yes      | —       | —                              |
| `result.data.dryRun`      | `boolean`        | Yes      | —       | —                              |

<details>
  <summary>Show raw output schema</summary>

  ### Output JSON Schema

  ```json theme={null}
  {
    "type": "object",
    "description": "BigQuery semantic layer update result.",
    "properties": {
      "data": {
        "type": "object",
        "description": "Saved semantic layer metadata.",
        "properties": {
          "ok": {
            "type": "boolean"
          },
          "configured": {
            "type": "boolean"
          },
          "source": {
            "type": "string",
            "enum": [
              "convex"
            ]
          },
          "provider": {
            "type": "string",
            "const": "bigquery"
          },
          "contentHash": {
            "type": "string"
          },
          "updatedAt": {
            "type": [
              "string",
              "null"
            ]
          },
          "tableCount": {
            "type": "integer"
          },
          "tables": {
            "type": "array",
            "items": {
              "type": "string"
            }
          },
          "dryRun": {
            "type": "boolean"
          }
        },
        "required": [
          "ok",
          "configured",
          "source",
          "provider",
          "contentHash",
          "updatedAt",
          "tableCount",
          "tables",
          "dryRun"
        ],
        "additionalProperties": false
      }
    },
    "required": [
      "data"
    ],
    "additionalProperties": false
  }
  ```
</details>

## Deepline cost

* Pricing model: `fixed` (per call).
* Estimated Deepline credits: `0` per pricing unit.
* Provider-native pricing may still exist outside Deepline credit billing.

## Related documentation

* [Bigquery provider guide](/docs/providers/bigquery/guide)
* [SDK V2 quickstart](/docs/sdk-v2/quickstart)
* [SDK reference](/docs/sdk-v2/sdk-reference)
* [Run tools across a CSV](/docs/sdk-v2/batch-csv)