Cannot use native derived table "NDT_name" with "bind_all_filters" outside of its source explore "source_explore_name"

Knowledge Drop

Last tested: Sep 22, 2020
 

The Problem

I have an NDT using bind_all_filters but get error:

Cannot use native derived table

"NDT_name" with "bind_all_filters"

outside of its source explore

"source_explore_name"

This might be that:

  1. You have joined/explored view "NDT_name" without joining the view "source_explore_name" in too. An NDT with bind_all_filters: yes must be joined into the same Explore that is specified in the NDT’s explore_source parameter. If you want to use the NDT in a different Explore, use the bind_filters parameter instead https://docs.looker.com/reference/view-params/explore_source#bind_all_filters_example
  2. You are extending the explore with the NDT in it which we currently can't do:

This content is subject to limited support.                

Version history
Last update:
‎07-07-2021 01:13 PM
Updated by: