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

No data

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');