Looker workflow:
Develop concepts (see the develop tab):
-
LookML project -- Analagous to a git repo
-
place to store model / view code for Looker dashboards/explores
- describes relations between tables and how Looker should interpret them
-
you can create a bare repo if one in Azure has not been created to do initial development
-
LookML branch structure
-
one production branch (main for zookeepers) which users will see
- a personal branch which CANNOT be deleted in Looker
-
shared branches, etc
-
Model files determine db connection and the explores using it. An explore is like the
FROM
clause in SQL query. A model file determines which data tables are used (as views) and if/how they are joined -
A view file refers to a single table or derived table in your database
Develop References |
---|
Looker Docs on project files |
Pluralsight LookML Development |
Explore Concepts:
-
Create charts/queries/visuals from an existing project/dataset
-
Explore save options:
-
as a single look
- to an existing dashboard
- as a dashboard
-
to a folder
-
Dashboards can be edited without changing underlying model/view files.
-
If the underlying TABLE is changed, you will need to update views/models if new columns are added/old ones removed
Explore References |
---|
Looker Explore Docs |
Pluralsight Looker Explore/Viz Course |
|Syncing Looker Models from separate Version Control|
| --- |