Skip to main content

Using Data Shaping Query Language

Data Shaping Query Language allows you to create queries to transform your data.

A query is a series of clauses that allow you to define the output data to return. It can contain a single block or multiple blocks separated by the UNION ALL keywords. These allow you to combine the results of several query blocks, with conditions if needed.

A query block can be a single SELECT clause or a combination of a SELECT clause and a FROM WHERE clause, which can contain UNNEST clauses, followed by a JOIN clause if needed.

The result of a query block can be:
  • A single value.
  • A record, or object, which contains a sequence of key-value pairs.
  • An array, which can contains several values, records, or arrays.

When the result is an array, it can be modified by output modifiers such as the ORDER BY clause.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!