1

I have this view file in front of me and I want to query a couple of dimensions and measures from it. How do I find the explore(s) that contain this view?

Pandafreak
  • 109
  • 1
  • 12

2 Answers2

2

You can:

  1. Use the project find-and-replace to search for the name of the view
  2. Rename the view and see which explores have LookML validation errors
tconbeer
  • 4,570
  • 1
  • 9
  • 21
  • I tried 2. and it worked thank you!! Would you also be able to help me with this looker sql question? https://stackoverflow.com/questions/73215001/if-statement-and-case-when-statement-with-two-conditions-used-together?noredirect=1#comment129304882_73215001 – Pandafreak Aug 03 '22 at 00:36
  • What is wrong with Simeon's answer? https://stackoverflow.com/a/73215329/10813082 – tconbeer Aug 03 '22 at 15:41
0

Explores are only visible if it is declared in models.

Let's say you have a data_test.view in a project, you will need to declare an explore corresponding this view in the models file as follow:

explore: data_test {
from: data_test
label: "Data Test" 
}

Once you have validated the LookML with the new declaration, you should be able to find the Explore named "Data Test" in your browser and go nuts on the queries.

Hung Ho Phan
  • 86
  • 7
  • Thank you so much! Would you also be able to help me with this looker sql question? https://stackoverflow.com/questions/73215001/if-statement-and-case-when-statement-with-two-conditions-used-together?noredirect=1#comment129304882_73215001 – Pandafreak Aug 03 '22 at 00:37