How to apply filter to derived data (sub-query expressions)

Derived-data is a way to generate multi-pass SQL within Arcadia. If you haven’t already watch our intro online training on derived data please watch.

The eventual SQL that’s generated is Multi-pass SQL, which would look like :

SQL1 (pass 1)
SQL2 referring to output of SQL1 (pass 2)

In most scenarios what you want is a way to dynamically filter SQL1 “pass1” using filter widgets in the dashboard. This way your eventual SQL2 uses the filtered result set.

You want to leverage parameters (watch this training video on intro of parameter basics)

2 Likes