본문으로 건너뛰기

SelectFilterTransform

Shared request and response schema. Request: Select-and-filter transform accepted as a pipeline step. Response: Select-and-filter transform returned as part of a pipeline step.

versionVersion (integer)
상수 값: 1
기본값: 1
opOp (string)필수
상수 값: select_filter
config object필수

Select-and-filter transform configuration accepted in a request. input is a pipeline port key, not a resource identifier; columns=null keeps every column, and where=null applies no predicate.

inputInput (string)필수

Input port key (a PipelineStep.inputs key)

columns object

Column names returned for this resource.

하나 이상(anyOf)
  • Array [
  • nameName (string)필수

    Source column name on the input

    alias object

    Output column name (defaults to name)

    하나 이상(anyOf)
    string
  • ]
  • where object

    Structured row predicate

    하나 이상(anyOf)
    kindKind (string)

    Possible values: [and, or]

    기본값: and
    conditions object[]

    Nested conditions (leaf RowFilterCondition or group RowFilter)

  • Array [
  • 하나 이상(anyOf)
    kindKind (string)
    상수 값: condition
    기본값: condition
    columnColumn (string)필수

    Column name to filter on

    operatorRowFilterOperator (string)필수

    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)
  • ]
  • SelectFilterTransform
    {
    "version": 1,
    "op": "select_filter",
    "config": {
    "input": "string",
    "columns": [
    {
    "name": "string",
    "alias": "string"
    }
    ],
    "where": {
    "kind": "and",
    "conditions": [
    {
    "kind": "condition",
    "column": "string",
    "operator": "eq"
    },
    null
    ]
    }
    }
    }