String to number in Look ML
Hey there! A google sheet I imported unfortunately shows all my values as strings instead of numbers in Looker...
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
How To: Smart Partition Key Filtering with Liquid
Problem: We have multiple partitioned tables, and are joining them into an explore. To improve query performan...
Missing pages/looker block code
Since the rebrand of this community, there are some pages that seem to have broken, especially from Looker blo...
How to use Regex Extract in SQL Runner
Let’s say I have a column “URL” which consists of URL paths. e.g. “https://community.looker.com/topic/new?fid=...
How do you add multiple liquid variables to a link in Looker?
I’ve followed this link https://docs.looker.com/reference/field-params/link on how to add a link to a dimensio...
How to create a measure to calculate max(date) per ID filtered by a value of dimension
Hey guys,I am trying to create a measure for date field. Below is the current view in my explore:Current ViewT...
JDBC Error: Cannot connect: connection refused: ... The connection attempt failed
This database connection error is often difficult to troubleshoot, given how non-descriptive and vague it is. ...
Date formatting
Hi,How to change the date format from ‘02-jan-20’ to ‘2020-01-02’ in the dimension?
SQL Exists, or IS IN functionality.
Wanted to get a list of customers who fit a certain criteria based upon an orderlines table.The table has a co...
Security Analytics - Brute Force Attack
SummaryLog, or machine, data can contain a wealth of information and be used for multiple use cases from Secur...
Self reference Filter value
Hello,With the hopes of restricting my result set based on a user entered value, I created a view filter with ...
What's the difference between sql_create: and sql: in LookML?
Both seem to work fine: for sql_create: I can add CREATE OR REPLACE TABLE ${SQL_TABLE_NAME} asThanks.
How can the admin assign the managed_models permission set to a developer?
What are the steps to assign the managed_models permission set to the developer role?
Can I do LookML development without being the Admin?
Currently, I have the user role assgigned to me and I was wondering if I can do LookML development without bei...
Results != SQL Runner Results
Hello,This one is a head scratcher.I have a table (VW_DATE) with one column (DATE) - Snowflake. The table is p...
Dynamic data tests
Hi all, looked around and couldn’t find a solution to this. Are we able to pass a second value from a differen...
Default Time Format (12 hour clock)
I’m trying to find a way to have all time dimensions be on a 12 hour clock (i.e seeing 8:00 PM instead of 20:0...
Looking for a Venn-Diagram
Hi Im Looking for a Venn-Diagram if anyone has one available. cant find anything in the blocks, and Google isn...
SQL Runner Module within View file in IDE
Feature: As a LookML developer, I spend a majority of my development time in SQL Runner and within a View with...
Advance text search
I have a field for a Chat Interaction that is called “Text” and I need to filer a specific text to export but ...
Mergin rows with the same value
Hello I’m building out a view that will show my companies three different target segments, their internal size...
View label doesn't work in refinements
I wanted to set view_label in a refinement: include "orders.view.lkml" view: +orders { view_label: "Special Or...
Error with value_format when value is 60 seconds
Hi Looker and Community, We’re trying to use value_format to nicely format a time value in seconds to m ss. We...
Max as a measure
Hi, I have a dataset where I want to aggregate a count by max. For example: Field1 Field2 Count A. B 10 A C 8 ...
Looker Snowflake session tagging
Hi, Within Snowflake, we can use session tagging to have gather insights on how user queries are performing. W...
Dynamic LookML based on User and/or Group
I am facing a scenario where different users may have different LookML requirements. Given this example: Base ...
Like to create filter for Week Over Week in looker and DB is snowflake. anybody has created WOW filter..please share thoughts
Like to create filter for Week Over Week in looker and DB is snowflake. anybody has created WOW filter…please ...
Overridable default filter
Hi. I’m wondering if there’s a way to set a default filter that is both overridable and removable. Not always_...
undefined method `inline' for nil:NilClass -- from referencing SQL_TABLE_NAME
Hi, is anybody familiar with the following error: undefined method `inline’ for nil:NilClass I get this when I...
Conditional JOIN BigQuery - equality of fields from both sides of the join error
I hate this error: Query execution failed: - LEFT OUTER JOIN cannot be used without a condition that is an equ...
