Last tested: Jan 21, 2019
When you create an NDT (native derived table) that is
AND/OR
the NDT will build as a nested with clause subquery, such as:
WITH NDT as (WITH filtered_table AS (select statement))
(SELECT from filtered_table)
SELECT from NDT
This is because the NDT relies on the explore (and all its joins and filters) from which it is sourced, and those tables must be built alongside the NDT for it to resolve.
This content is subject to limited support.