Many APIs are JSON first. All APIs provide different types of JSON structures.

One of the super powers of a recipe is the ability to process and create any type of JSON using just SQL.

Public Recipe Library Examples

Querying JSON structures

You can query JSON using dot notation. To access nested array, you can convert them to tables using the inline(), explode() and explode_outer() functions. View the example recipe on the public recipe library.

Creating JSON structures

The struct(), named_struct() and collect_list() functions can be very helpful in creating the JSON structures needed for your file or API. View the example recipe on the public recipe library.