Question

Trouble Getting Started with Model/View/Explore

  • 5 February 2020
  • 1 reply
  • 283 views

Userlevel 2

I’m brand new to Looker. Been reading the docs and watching tutorials. I got to a point where I wanted to setup a Looker Project and do some hands-on experimenting. I have a DB connection and can query it using SQL Runner. So I created a Project and started with a clean Model. I created a View from a Table. But I cannot create an Explore from that Table. The View file name is:


users.view.lkml


Looker does not let me change the extension from “.view.lkml”. If I include “*.view.lkml”, I get the message:



This include does not match any files.



(Oddly enough, “*.model.lkml” does indeed match the Model file. But the View is there. I see it under “Views”. It has LookML in it. I can even rename it but just cannot rename/remove the “.view.lkml”)


If I include “*.lkml” that message goes away. But then I get:



Unknown view “users” referenced by explore “users”



Of course, I cannot put a dot (.) in the view name. And any of the following tell me it cannot find the view named…


explore: users {
label: "Users"
from: users.view.lkml
}

explore: users {
label: "Users"
from: users.view
}

explore: users {
label: "Users"
from: users
}

Any pointers would be appreciated. Thank you.


1 reply

Userlevel 4

If your view is in a folder, you need to include the folder name in the include. Try this include:


include: “/Views/*.view”


You can see an example that has this here: https://docs.looker.com/data-modeling/getting-started/ide-folders

Reply