Data Serialization Functions for SQL and SOQL

SQL and SOQL serialization functions convert the data into the form expected by the query in which the interaction is inserted.

Returns a grouping as a string in a SQL or SOQL query. Can also return multiple groupings.

The input data must be a scalar or a one-dimensional array of groupings. Null or no results returns an ungrouped query.

Argument	Description
`SQLType`	(Required) Specify SQL or SOQL variant. Valid values are `dataset`, `snowflake`, and `sobject`.
`includeKeywords`	(Optional) The default value is `false`.

For SOQL, use sobject.

Let's look at some examples where the selection detemines the groupings in a SQL or SOQL-form query. These examples are based on the stepFoo source query. Assume that stepFoo.selection retrieves these rows from the query.

Function:

Output in standard or Snowflake live dataset:

Function:

Output in SOQL:

Function:

Output in standard or Snowflake live dataset:

Function:

Output in SOQL:

To make the interaction return multiple fields for the grouping, replace the cell interaction function with a column function and update the arguments.

Function:

Output in standard or Snowflake live dataset:

Function:

Output in SOQL:

Function:

Output in standard or Snowflake live dataset:

Function:

Output in SOQL:

Returns the grouped results for a SQL or SOQL query restricted by a conditional filter logic applied on aggregate functions. This function is similar to the asSQLWHERE function.

Argument	Description
`SQLType`	(Required) Specify SQL or SOQL variant. Valid values are `dataset`, `snowflake`, and `sobject`.
`includeKeywords`	(Optional) The default value is `false`.

For SOQL, use sobject.

These examples are based on the stepFoo source query.

The < and >=<= operators aren't supported.

Function:

Output in standard or Snowflake live dataset:

Function:

Output in SOQL:

Function:

Output in standard or Snowflake live dataset:

Output in SOQL:

Function:

Output in standard, Snowflake live dataset, or SOQL:

Returns the sort order as a string for a SQL or SOQL query.

The input data must be scalar, one-dimensional, or a two-dimensional array. A two-dimensional array is treated as a tuple of interactions.

Argument	Description
`SQLType`	(Required) Specify SQL or SOQL variant. Valid values are `dataset`, `snowflake`, and `sobject`.
`includeKeywords`	(Optional) The default value is `false`.

For SOQL, use sobject.

These examples are based on the stepFoo source query. Assume that stepFoo.selection retrieves these rows from the query.

Function:

Output in standard or Snowflake live dataset:

Function:

Output in SOQL:

Function:

Output in standard or Snowflake live dataset:

Function:

Output in SOQL:

Function:

Output in standard or Snowflake live dataset:

Function:

Output in SOQL:

Returns the SQL or SOQL expression and alias as a string that you can use to project a field in the query. The query expression determines the value of the field. The alias is the field label.

Argument	Description
`SQLType`	(Required) Specify SQL or SOQL variant. Valid values are `dataset`, `snowflake`, and `sobject`.

For SOQL, use sobject.

These examples are based on the stepFoo source query. Assume that stepFoo.selection retrieves these rows from the query.

Function:

Output in standard or Snowflake live dataset:

Function:

Output in SOQL:

Function:

Output in standard or Snowflake live dataset:

Function:

Output in SOQL:

Function:

Output in standard or Snowflake live dataset:

Function:

Output in SOQL:

Returns the SQL or SOQL query results restricted by a conditional filter logic applied on a measure, dimension, or date.

Argument	Description
`SQLType`	(Required) Specify SQL or SOQL variant. Valid values are `dataset`, `snowflake`, and `sobject`.
`includeKeywords`	(Optional) The default is false.

For SOQL, use sobject.

These examples are based on the stepFoo source query.

Function:

Output in standard dataset, Snowflake live dataset, or SOQL:

Function:

Output in standard or Snowflake live dataset:

Function:

Output in SOQL:

Function:

Output in standard or Snowflake live dataset:

Function:

Output in SOQL:

Multiple Filters

Function:

Output in standard or Snowflake live dataset:

Function:

Output in SOQL:

Function:

Output in standard dataset:

Function:

Output in Snowflake live dataset:

Function:

Output in SOQL:

Function:

Output in standard dataset:

Function:

Output in Snowflake live dataset:

Function:

Output in SOQL:

Function:

Output in standard dataset:

Function:

Output in Snowflake live dataset:

Function:

Output in SOQL:

Function:

Output in Snowflake live dataset:

Function:

Output in SOQL: