Here is some lookml : view: debug_test_1 { derived_table: { sql: SELECT '14d' as id UNION ALL SELECT '13d' as id ;; } dimension: id { sql: ${TABLE}.id ;; primary_key: yes } } view: debug_test_2 { derived_table: { sql: SELECT '14d' as id, 123456789012...

Until the Feb 2024 release of Looker, it was possible to use the liquid {% condition dimension_name %} dimension_name {% endcondition %} syntax, to work out if a row matches a user's filter independently of the main auto-generated query logic.This wa...

Use CasesA. Reverse ETL into CRM - e.g. I want to keep a list of companies in a Looker Look in sync with a list in my CRM including company id and some other columns such as a priority rating etc.B. Alert on Changes via email, e.g. I want to know if ...