Using Amazon Redshift’s new Spectrum Feature
At the AWS Summit on Wednesday, April 19th, 2017, Amazon announced a new Redshift feature called Spectrum. You...
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
SQL Pattern: Summarizing entities with a start/end date over time
Do you have date tables in your model? If so, you’ve probably noticed performance issues around them, but may ...
Three ways to model EAV schemas and many-to-many relationships
Introduction The entity-attribute-value (EAV) schema is often encountered in business tools where the number o...
I need a Bi-Weekly Timeframe
Bi-Weekly timeframes can be really useful! For now, using SQL is the best way to achieve this. In Redshift, he...
Code Reusability: Extending Explores and Views (3.24+)
Release 3.24 will come with the ability to extend Explores and Views. These are key features in building reusa...
The New LookML IDE Shows New and Pre-Existing Parameters
In new LookML, the vast majority of parameters will be your old familiar friends. The new LookML IDE shows you...
[Analytic Block] Tags and Attributes (with and without Arrays)
Looker has created this block to make analyzing data easier and more efficient. This Data Block is made availa...
How to use Git in Looker
For information on using Git with Looker, see this page in our documentation. Looker uses Git to manage versio...
[RETIRED] How can I use compound primary keys in Looker?
The content of this article can be found in Looker’s technical documentation here.
[Analytic Block] BigQuery Table Date Range (Deprecated)
This method has been Deprecated, this method only works with Legacy SQL, Standard SQL is recommended. ##About ...
Using sql runner to test derived tables
To learn about SQL Runner, see this document page and choose release 4.16 or higher. If you see an error comin...
Using Google Images API in Looker
Adding images to your Looks and dashboards looks great, and is easy to do with the html LookML parameter. In t...
Distance between latitude/longitude coordinate pairs
##Howdy Good Lookers! ###Lucky for you Looker now has a built-in distance dimension that supports this use cas...
Using HTML and Liquid with Looker
What is Liquid? Liquid formatting is an open source Ruby-based template language built by Shopify (Liquid Docu...
Creating a type count measure for non-primary keys
###Quick Intro Looker natively translates a type: count measure into a COUNT(*). The sql: parameter has no eff...
Drill using a sparkline or other images
###Objective Add a nice sparkline to encourage users to link out to wherever the sparkline points. I’ve most o...
[Analytic Block] Sequencing Transactions
##About This Block Nearly all businesses want customers to come back. It’s often much easier to increase your ...
[Analytic Block] Derived Tables Pattern
About This Block Often times our database doesn’t store information optimally for analytics. Rather than writi...
[Analytic Block] Repeat Purchase Patterns
About This Block Repeat business is the key to success for most ecommerce companies. Figuring out behavioural ...
[Analytic Block] Creating Custom Cohort Analysis
Looker has created this block to make analyzing data easier and more efficient. This Data Block is made availa...
