LookML - bobbae/gcp GitHub Wiki

LookML โ€‹is a language for describing dimensions, aggregates, calculations, and data relationships in a SQL database. Looker uses a model written in LookML to construct SQL queries against a particular database.

https://docs.looker.com/data-modeling/learning-lookml

LookML tells Looker how to query data, so everyone in the organization can create easy-to-read reports and dashboards to explore patterns of data. Looker offers additional features for creating custom data applications and experiences.

https://docs.looker.com/data-modeling/learning-lookml/lookml-intro

https://www.youtube.com/playlist?app=desktop&list=PL2rFVcDw2yVoXlI3onYS7Ecufjg2ODI9u

Concepts

https://docs.looker.com/data-modeling/learning-lookml/lookml-terms-and-concepts

How Looker generates SQL from LookML

https://docs.looker.com/data-modeling/learning-lookml/how-looker-generates-sql

Looker development foundations

https://training.looker.com/looker-development-foundations

Looker and BigQuery

https://cloud.google.com/bigquery/docs/looker

Symmetric Aggregation

Symmetric aggregates prevent analysts from accidentally miscalculating aggregates.

Maintainable LookML Authoring

https://help.looker.com/hc/en-us/articles/360001784587-Best-Practice-Writing-Sustainable-Maintainable-LookML

Certification

https://cloud.google.com/certification/guides/lookml-developer

dbt

dbt tutorial with BigQuery

https://docs.getdbt.com/tutorial/setting-up

How do you decide what to model in dbt vs LookML

https://blog.getdbt.com/-how-do-you-decide-what-to-model-in-dbt-vs-lookml--/

Dbt vs. Matillion vs. LookML

https://www.stephenlevin.co/data-modeling-layer-startup-analytics-dbt-vs-matillion-vs-lookml/

Examples

KPI control chart

https://medium.com/data-cookbook/looker-and-bigquery-ml-create-control-charts-for-your-kpis-3d9ad6ee99f7

Qwiklabs

Understanding LookML in Looker

https://www.qwiklabs.com/quests/170

Creating LookML Dashboards

https://looker.qwiklabs.com/focuses/18351?parent=catalog