SFTP Server Scheduled Delivery more than 5000 records
Hi,I created a Table chart and saved it as dashboard by using a database Table which comes from Google Big Que...
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
Add WK before Week Number
Hi Team, I am having week number column which is part of date dimension as 1,2,…. 52. Now my requirement is to...
Default filter selection on landing page
Hello,I have a filter in my dashboard from a field whose values looks like - ‘WK 20’ , ’Wk21’… so on. This is ...
Big Looker Explore vs Small
I have too many explores at my org at the moment which clutters the user experience. Are there best practices ...
Measure type of an amount of time
I have a dimension that represents the duration of a media in seconds, which is currently typed as a number.I ...
Run Initial SQL on Looker
Do we have any place in looker to Run the Initial query while connecting to the Database? Please help.I need t...
Run Initial SQL on new connection?
Hey all – I am wondering if there is a way to run a custom SQL statement for each connection . Specifically, I...
Get filter value from non-templated filter
Is there way to get a value from a filter that isn’t a templated filter and reference it in the `sql` paramete...
Database Limits
Hello,My client is currently using Amazon Athena for the database connection to Looker. Currently I have creat...
QA automation Looker reports
Hi,our organization has asked we QA to find a way to automate Looker reports. We use big query data in that.Ho...
Customizable drop downs using the HTML details
I'm trying to drop down Html with this code but it's not working measure: GROSS_PROFIT__Total { type: sum sql:...
How to capture date difference with liquid ml
I am attempting to use Liquid ML to adjust a table i am using for a look depending on the date range a user se...
Can't find the recorded bootcamp or webinar in the past?
Hi sir, I know there was used to have some recorded webinar or bootcamps in training.looker. But now those are...
Incremental SQL PDT not working
I’ve got this incremental PDT: derived_table: { increment_key: "last_update_time" increment_offset: 5 sql: WIT...
Trouble with Modeling nested Data 2 levels deep - Scalar subquery produced more than one element
I am trying to model what I consider to be nested nested data (2 levels deep) from a big query table and am ha...
How to create dimension from an array/struct in your table?
Hi all, I am relatively new to looker and have been learning my way on how to best utilise this platform. I cu...
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...
Looker Dashboard - Deployment
Please Imagine there are two different projects in Google Big Query as follows:ga3-lateral-boulder -301812 big...
Filter a Column using wildcards and LIKE
Hi,Filter a column based on wild card characters. I want to filter values ending with ‘ABC’ from Col A in View...
custom visualization options not working
hello i created a custom visualization and added a single option following the instructions from the following...
Median of total grouped by column filtered by timestamp interval
I have a table consisting of three columns:Timestamp User ID RevenueI want to create a visualization that, whe...
Removing an always_filter
I have an always_filter in my explore that I want to remove. How does that change affect existing looks that u...
AND Date Filter
Hello!I am using Looker to find our historical sales quantities for certain SKUs over a range of time periods....
Left Join vs Left Outer Join in LookerML
Hello,Is there any difference between Left Join and Left Outer Join in LookerML?I'm a completely noob and I'm ...
SSAS consumption options
Hi people! Thanks in advance for read or help me with this.Being brief, I have a SSAS tab model being consumed...
Define dimension from a sub table's column
I have a derived table on view, the sql goes like:with events AS ( select create_time, export_duration, upload...
Autoscale enable for Looker
Need Autoscale for Looker,
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/...
Primary key doesn't seem to be recognised
Has anyone dealt with this error before?I understand what it’s saying, but I have primary_key: yes defined in ...
Getting odd results when trying to commit a single change (multiple files listed that I have not changed)
We have a large, central data team that contains multiple subteams (data engineering, data governance etc.). T...
