ViewUpdate

Partial update for a view. name must match the current name; changing tables or joins also requires owner permission on every backing resource in the new table set.

name object

anyOf

• string
• null

string

alias object

anyOf

• string
• null

string

type object

anyOf

• string
• null

string

Possible values: [view, materialized]

collection_id object

anyOf

• string
• null

string

Possible values: non-empty

folder_id object

anyOf

• string
• null

string

tags object

anyOf

• string[]
• null

Array [

string

]

description object

anyOf

• string
• null

string

tables object

anyOf

• object[]
• null

Array [

aliasAlias (string)required

SQL alias used in column references

typeType (string)required

Backing resource category

Possible values: [dataset, source]

resourceResource (string)required

Identifier of the dataset or source used by this view table.

]

joins object

anyOf

• object[]
• null

Array [

targetTarget (string)required

alias of the ViewTable this join introduces

kindJoinKind (string)

Allowed Join Kind values. Values: inner, left, right, full.

Possible values: [inner, left, right, full]

Default value: inner

on object[]required

AND'd binary conditions

Array [

left objectrequired

Join condition operand. Exactly one of column / expression set.

column object

Backing column reference in 'alias.col' form

anyOf

• string
• null

string

expression object

SQL fragment when the operand is a computed expression

anyOf

• string
• null

string

right objectrequired

Join condition operand. Exactly one of column / expression set.

column object

Backing column reference in 'alias.col' form

anyOf

• string
• null

string

expression object

SQL fragment when the operand is a computed expression

anyOf

• string
• null

string

operatorJoinOperator (string)

Allowed Join Operator values. Values: eq, ne, gt, gte, lt, lte.

Possible values: [eq, ne, gt, gte, lt, lte]

Default value: eq

]

]

schema object

anyOf

• object
• null

object

column_masks object

anyOf

• object
• null

object

row_filters object

anyOf

• RowFilter
• null

kindKind (string)

Possible values: [and, or]

Default value: and

conditions object[]

Nested conditions (leaf RowFilterCondition or group RowFilter)

Array [

anyOf

• RowFilterCondition
• Option 2

kindKind (string)

Constant value: condition

Default value: condition

columnColumn (string)required

Column name to filter on

operatorRowFilterOperator (string)required

Allowed Row Filter Operator values. Values: eq, ne, gt, gte, lt, lte, in, not_in, and 4 more.

Possible values: [eq, ne, gt, gte, lt, lte, in, not_in, between, like, is_null, is_not_null]

value object

Filter value. Single value for scalar operators, list for 'in'/'not_in', 2-element list for 'between'. Omit for 'is_null'/'is_not_null'.

anyOf

• Option 1
• null

]

group_by object

anyOf

• string[]
• null

Array [

string

]

having object

anyOf

• RowFilter
• null

kindKind (string)

Possible values: [and, or]

Default value: and

conditions object[]

Nested conditions (leaf RowFilterCondition or group RowFilter)

Array [

anyOf

• RowFilterCondition
• Option 2

kindKind (string)

Constant value: condition

Default value: condition

columnColumn (string)required

Column name to filter on

operatorRowFilterOperator (string)required

Allowed Row Filter Operator values. Values: eq, ne, gt, gte, lt, lte, in, not_in, and 4 more.

Possible values: [eq, ne, gt, gte, lt, lte, in, not_in, between, like, is_null, is_not_null]

value object

Filter value. Single value for scalar operators, list for 'in'/'not_in', 2-element list for 'between'. Omit for 'is_null'/'is_not_null'.

anyOf

• Option 1
• null

]

order_by object

anyOf

• string[]
• null

Array [

string

]

partition_by object

anyOf

• string[]
• null

Array [

string

]

options object

anyOf

• object
• null

object

ViewUpdate

{
  "name": "string",
  "alias": "string",
  "type": "view",
  "collection_id": "string",
  "folder_id": "string",
  "tags": [
    "string"
  ],
  "description": "string",
  "tables": [
    {
      "alias": "string",
      "type": "dataset",
      "resource": "string"
    }
  ],
  "joins": [
    {
      "target": "string",
      "kind": "inner",
      "on": [
        {
          "left": {
            "column": "string",
            "expression": "string"
          },
          "right": {
            "column": "string",
            "expression": "string"
          },
          "operator": "eq"
        }
      ]
    }
  ],
  "schema": {},
  "column_masks": {},
  "row_filters": {
    "kind": "and",
    "conditions": [
      {
        "kind": "condition",
        "column": "string",
        "operator": "eq"
      },
      null
    ]
  },
  "group_by": [
    "string"
  ],
  "having": {
    "kind": "and",
    "conditions": [
      {
        "kind": "condition",
        "column": "string",
        "operator": "eq"
      },
      null
    ]
  },
  "order_by": [
    "string"
  ],
  "partition_by": [
    "string"
  ],
  "options": {}
}