Extending multiple explores at the same time

kuopaz
Participant IV

I haven’t been able to find an example of this? The documentation only seems to say it is possible, but doesn’t show any joins to explain it.

0 5 848
5 REPLIES 5

kuopaz
Participant IV

I’m not sure it works.

kuopaz
Participant IV

Probably best to remove this from the documentation.

You can extend several explores, you will need to use a view_name parameter in your extended explore and a join. It will look like this:


Explore A {}


Explore B {}


Explore C {
extends: [A, B]
view_name: A
join: B {}
}

Hi Olga,

I have tried your method to extend explores and I get these errors:

>Unknown view "name_of_explore_a"

>Join name must match a view name, or the join must provide a 'from:'

Could you please give more details or documentation about this method?

Thanks a lot,

Bertrand

Sure, you can take a look at this documentation https://docs.looker.com/reference/explore-params/extends#example

The errors point us to the fact that the name of the explore (and the join)  you are using does not match the view which should be used for this explore and this join. 

In this case we should use additional syntax, like 

explore: explore_a_name {

extends: [explore a, explore b]

view_name: view_A_name

from: view_A_name

join: explore_b_name {

from: view_B_name

sql_on: ……. etc}

}

Top Labels in this Space
Top Solution Authors