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. ...
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
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...
File names truncated
What’s with all this text truncation all of the sudden? There is no label on hover either and sometimes it’s i...
Liquid Boolean "not" Operator
Hi. I’m trying to use the Boolean “not” operator in Liquid. It’s not working as expected, and is documented as...
Integrating learn.looker.com with lookml
Hi, I have learn.looker.com instance and I would like to update the looker objects (Models/Views) using lookml...
Brainstorm: Reusing common views
I’ve been thinking about ways to simplify logical model of LookML and one of the main issues that come to mind...
Combine "FULL OUTER JOIN ON FALSE" with "Introducing bind_all_filters"
Hi. I read the article " Outer Join on False - or: How I learned to stop fanning-out and love the NULL and [An...
Dashboard panels show errors until reload
I’m seeing a transient error on some of the panels of our dashboard. Reloading the dashboard often clears the ...
