The debug component
Visualize any set of values as JSON. Can be used to display all the parameters passed to the component. Useful for debugging: just replace the name of the component you want to debug with 'debug', and see all the top-level and row-level parameters that are passed to it, and their types.
Top-level parameters
Example 1
At any time, if you are confused about what data you are passing to a component, just replace the component name with 'debug' to see all the parameters that are passed to it.
select
'debug' as component,
TRUE as my_top_level_property;
select
'y' as x,
42 as z;
select
'b' as a,
NULL as c;Result
Debug output
{"component":"debug","my_top_level_property":true}
{"x":"y","z":42}
{"a":"b","c":null}
Examples
Show the result of a SQLPage function:
select 'debug' as component, sqlpage.environment_variable('HOME');