SQL Trigger Value - First Week of Year
Hi there!I’m finding the SQL Trigger Value logic a bit confusing. I’m working in Amazon Redshift, and looking ...
Modeling
Building a healthy project - and keeping it that way. Share your stumpers and successes with data management, performance optimization, SQL, LookML, caching, and more.
Forum Posts
Min/Max of a Timstamp Breaks Timezone Conversion
In our looker instance, we have a view that takes the min/max of a datetime:view: view_name { derived_table: {...
Finding closest matches by name in BigQuery
We’ve all been there before: someone gives you a dataset without ID’s, keyed only by name. You either file it ...
NDTs and first day of the month
I have an issue for an NDT I created. I have a filter in its creation which states as follows: filters: { fiel...
Is there a way to set session context to the SQL code generated by Looker?
Hi there,I need to set session context before the SQL code to be able to retrieve results from the DB.sp_set_s...
Best practice: writing views in BigQuery vs Looker
We have a daily data feed to BigQuery for most of our data tables. In the past we used SQL Runner in Looker to...
Star schema tables to Looker model
Hi, we’ve been using Looker for 2+ years without any previous experience with this tool. We have all data stor...
Can you build utility functions in liquid?
We have a requirement which will cause us to have to conditionally format the HTML dynamically for currency va...
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...
SQL Error: 0 when scheduling looks to google sheets
Hi All,I have created a look (that has pivoted date columns) that I have scheduled to update google sheets. Af...
Validation Failed error while creating new connection
As looker UI part is updated at database connection. I am trying to create bigquery connection to looker while...
3 month rolling COUNT using lookml
Does anyone know how can i get this ?I want to create rolling 3 month count of a measure .So basically if i wa...
Does Looker no longer produce the `non-uniqe primary key` error when a pk is not unique?
I wanted to demonstrate how symmetric aggregates work, and how, if the designated primary keys are not, in fac...
How to update case statement in join to use aliasing instead?
I have a report that’s running off an Explore in my model, but one of the joins to a view needs to be updated ...
Suck in validation loop
I click "validate LookML", get the spinning icon that looks like its validating errors, then it quickly stops ...
Convert String ($1,234.50) to Number field
I have a string field that contains a dollar figure of total cost. It is a string field but I need it to be nu...
Convert String (yyyy-mm-dd) to Date field
I have a field in my database that is a string field but it contains dates in the following format: “yyyy-mm-d...
SQL Runner and Explore return different visualization
I want to add “funnel” visualization to my dashboard. I tested the query and visualization under SQL Runner en...
Active explore uses seemingly non-existent model
One of our clients set up an explore in their instance. It looks like they created it in some really non-stand...
Dynamic Dates with Liquid
It is common for date/time series tiles in a dashboard to be easily switched between date/week/month etc. This...
How to direct off a PDT?
Can anyone tell me how to direct off a PDT in looker?
Datagroup Status: "Waiting for Trigger Checks". PDT's won't automatically rebuild
I set up a new Datagroup Trigger but the trigger check does not seem to be running. In my PDT Maintenance sche...
Custom HTML coloring for bar colors
I have html formatting for a number that color codes the number based on ranges of values. When I plot this to...
Custom drill down involving table calculations
HiI am attempting to create a custom view when drilling into a value in my dashboard, however, despite definin...
Create an "Other" bucket in a chart
April 2016 Update: You can also add an “Other” bucket [using Table Calculations] https://community.looker.com/...
Cannot view table calculations in custom viz
We have made a custom viz similar to the Single Value viz in looker. The Table Calculations are not visible in...
Implement the JOIN condition while using DRUID Database Connection in LOOKML
Hello Everyone,Is anyone having idea on how to join two views in LookML model while using the apache druid dat...
Go to LookML destination for extended dimension
Let’s say we have view A and view B. View B is an extension of view AFor reasons that probably aren’t worth th...
A quick flowchart beyond simple LookML
Hi,I have been dabbled around Looker for years and this community helps a lot.This time I try to make some con...
Getting Extended Views to work
I’m experimenting with extending views but haven’t been able to get the dimensions/measures from the extended ...
