Skip to main content
interface AggregateUnpivotRequest
column_names: string[];
encoding?: string;
options?: Record<string, string>;
pivoted_columns: string[];
table_name: string;
value_column_name?: string;
variable_column_name?: string;
column_names encoding? options? pivoted_columns table_name value_column_name? variable_column_name?
column_names: string[]

List of column names or expressions. A wildcard ’*’ can be used to include all the non-pivoted columns from the source table.

encoding?: string

Specifies the encoding for returned records.

options?: Record<string, string>

Optional parameters.

pivoted_columns: string[]

List of one or more values typically the column names of the input table. All the columns in the source table must have the same data type.

table_name: string

Name of the table on which the operation will be performed. Must be an existing table/view, in [schema_name.]table_name format, using standard name resolution rules.

value_column_name?: string

Specifies the value column name.

variable_column_name?: string

Specifies the variable/parameter column name.