BigQuery dimension group datetime datatype time timeframe issues
We have a datetime dimension being read from BigQuery, the problem is on Looker it converts the time value to ...
Forum Posts
Date Parameter In a LookML View
I have a LookML that is powered by a big query view where the dataset that I am pulling from is partitioned on...
BigQuery clustering in non-case sensitive models
I am working on a model connected to BigQuery where our users also require non-case sensitive filters. In orde...
BigQuery Data Transfer Service for Google Ads Partitioned Table Joins
Hello,I’m utilizing BigQuery Data Transfer Service for Google Ads to pull Google Ads Data then bringing the ta...
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...
Using a BigQuery Array in drill down Look ML
Hello,I have a bigquery field with the following schema:Where as endpoint is a key and it has a array with uni...
Bug when generating SQL for BigQuery in function EXTRACT_DAYS()
Something very weird has been discovered by one of my colleagues. They were trying to plot some data with day ...
BigQuery Machine Learning (BQML): LookML Syntax Explanation
Hi all,BigQuery Machine Learning (BQML) is a BigQuery’s feature that allows users to create and execute machin...
Count the number of days beween two purchases
Hello,I have a table with the dates customers made purchases.Please I would like to calculate the number of da...
Cleaner where conditions with dates with Bigquery Explore
Hey everyone!I’m a data scientist/engineer who is pretty new to Looker. Currently I’m trying to use Looker Exp...
Implementing UNION on distinct partitioned tables
Hi all,ContextWe have several distinct apps that we track with Firebase. We connected Firebase to Google BigQu...
How do I stop Looker from modifying queries?!?!
Hi. I have Google BigQuery queries that run perfectly fine in the sql runner, but will not run in production b...
How to Query from one Project and Write PDTs to Another with BQ
Hi all,I have gotten question about writing PDTs to a separate BQ project, but we want to able to query tables...
percentage of subtotals
Hello,I would like to calculate the percentage of Rev for each age group compared to its Brand (subtotal)Thank...
How to ignore null dimension value results
Hi, My use case is as follows:I am setting up an explore for a table in bigquery whose schema looks like below...
Automatically Refresh View when a Column is Added in GBQ Data Source Table
I've created views from underlying GBQ tables. I'd like to dynamically update the views every time a new colum...
“Resources exceeded during query execution” in BigQuery because of cartesian product
BigQuery charges per query based on how much data it has to scan. It then allocates server capacity to your qu...
PDT
Hello, please how to create the derived tables in our database to see the data they outside of our dashboards ...
Proper case for BigQuery
I was struggling trying to find a way to capitalize names in Looker with data coming from BigQuery, since BigQ...
error date filter
Hello, if I put a filter on the date field I have this errorinvalidQuery: No matching signature for operator >...
BigQuery + Looker: Timestamp vs Datetime
Hello, we have Looker on top of BigQuery. Currently there is a lot of mixed usage when it comes to dates and t...
problem of calculating measures in foreign views
Hello, I would like to calculate the total of a measure (sum_dig_total_ht) in a foreign table but the displaye...
bring field descriptions from BQ
Hi!I can’t find anything related to it and I am sure we should be able to do this.How can we bring the descrip...
Optimize sql query
Hi, please how to optimize my sql queries to get results faster. I have a model with only 2 joins but when I r...
high latency
Hi, please how to optimize my sql queries to get results faster. I have a model with only 2 joins but when I r...
caculate cumulative total month by month every year since 2010
Hello,Please I want to create a dashboard calculate :the turnover month by month and the cumulative total of t...
How to calculate Sum of averages for different level of detail?
We have information in a table with Sales by Invoice ID which is mapped to a Location and Area. Like below:Inv...
Rank
Hi, i want to calculate the rank and i have the error as you see in the screenshot.Thank you
error derived table
Please, I want to create a derived table and bigquery as the database and i have this error :Query execution f...
Rank
Hi,I would like to calculate the rank in LookMl (i don't want to use table calculation) of my dimension accord...