About lloydtabb

lloydtabb · 10-02-2018

Primary keys are essential for Looker’s symmetric aggregates to work. Sometimes you end up with a table without a primary key. The folks at BigQuery just announced a new function GENERATE_UUID() that will make one for you. If you have a table without...

lloydtabb · 07-14-2017

This article has been retired as the information is now in documentation on this page. If you reached here from the product, our apologies – we’re working on getting that link redirected to this LookML reference page.

lloydtabb · 03-01-2017

In some cases you will get an “Resources exceeded during query execution” error when trying to build a large derived table in BigQuery. Why this happens BigQuery is a distributed database. This means most queries execute on multiple nodes. But there ...

lloydtabb · 02-23-2017

BigQuery is a scanning database, which means it scans the entire table for the columns referenced in the query. Because BigQuery elastically scales up compute power as needed, queries never really get slow, but they can get expensive if you scan real...

lloydtabb · 02-05-2017

Looker has created this block to make analyzing data easier and more efficient. This Data Block is made available on an “as is” basis, meaning there will not be updates moving forward. Tags and Attributes Objects often have lists of attributes associ...

lloydtabb · 07-29-2019

@shankarr is this what you are looking for? [Analytic Block] Tags and Attributes (with and without Arrays) Analytical Patterns & Blocks Tags and Attributes Objects often have lists of attributes associated with them. Stackoverflow posts are tagged wi...

lloydtabb · 12-03-2018

Hi there. Probably the best general solution to this problem is to build a dimension on orders that is the sequence number for the transaction. The reason this is useful is that once sequence number is added to the model, you can look at the first, s...

lloydtabb · 08-18-2018

axjia: Just for reference, are there any plans or thoughts to either expand sql_preamble or deprecate it? The need for sql_preamble is really a BigQuery only feature and a pretty advanced one at that. Most other data abases just let you install UDFs ...

lloydtabb · 08-17-2018

It is ugly, but you can do this by putting all the functions in a view and using ${foo.SQL_TABLE_NAME}. Here is a working code example. The sql_preamble has been really difficult, especially when referencing derived tables from other derived tables a...

lloydtabb · 08-03-2018

Looker’s ‘advanced filter’ syntax lets you represent pretty complex expressions in the advanced filters section of the explore. The most interesting of these are the date expressions. You can say things like ‘1 day’ or ’ 2 weeks’ or ‘monday for 3 day...

Google Cloud Community

My Stats

lloydtabb's Bio

Badges lloydtabb Earned

Recent Activity

BigQuery tables without Primary Keys

[Retired] Using Native Derived Tables

"Resources exceeded during query execution" when building derived table in BigQuery

[Analytic Block] Partitioned Date Filters in BigQuery

[Analytic Block] Tags and Attributes (with and without Arrays)

Re: List Of Values

Re: How to implement partition by function in LookML

Re: BigQuery UDFs in Derived Tables (or sql_preamble in Native Derived Tables)

Re: BigQuery UDFs in Derived Tables (or sql_preamble in Native Derived Tables)

Re: Setting the current date as the default date filter