Qualify in LookML
Hi All,I am wondering if there any way to filter on row_number window function in Looker or using LookML. I am...
Forum Posts
How to fetch data from multiple databases of snowflake using single looker connection
I am trying to get the data from multiple databases of snowflake using single looker connection can anyone sug...
New LookML runtime issue with multiplication by constant
Our model has many measures calculating a percentage defined as:sql: 1.0 * ${gmv_variance_yoy_same_weekday_las...
How to Pass Data Value to where condition in Snow Flake
I have a requirement in which I need pass Current Date value to the where condition of a select statement.Belo...
Snowflake - Use ARRAY field without junction table
When I worked with BigQuery, I used this article to unnest repeated records: https://help.looker.com/hc/en-us/...
LISTAGG using different order columns within group
if we create a measure of type: list, is there a way to change the order by clause of the listagg in the query...
LookML and SQL to external database
Situation: I have a results table that shows whether a specific job has successfully run or errored. I have im...
Best practices for modeling in Snowflake vs LookML?
Hi everyone, I was talking with a former Looker user who asked me the pros and cons of modeling in LookML vs t...
LookML model join is using fields as numeric when they are both defiled as string
Hi All I am getting the following error in a LookML model on a join - it seems to be trying to join post codes...
The updated Period-over-Period Guide by Montreal Analytics
Hello Looker folks!The team @ Montreal Analytics has updated our popular Period-over-Period block!You can find...
Snowflake Usage Block
Hi All,I’m new to Looker but enjoying learning my way around.I would like to use this block - https://looker.c...
Using SPLIT_PART in dimension
I have a table in snowflake with a column that produces a string like this “144514490704288__LOOKUP__193333025...
Last Quarter data in new quarter
Hi, i need to get the data for the last date of quarter can someonehelp me here
How to calculating the median of a duration?
I’m at a loss as to how to do this as it’s throwing an error in looker … I have 2 dates were i’m calculating t...
Two WITHs
If I write a PDT whose SQL starts with with foo as and include in the PDT a reference to another non-persisten...
Seasonal Sales Forecasting
Scenario In a related post, I illustrated a pattern that allows for some lightweight linear forecasting of mea...