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.
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