Looker
  • Looker Connect Training
  • Help Center
  • Documentation
  • Community
  • Cloud Certifications

Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

      • Forum overview
      • Recently active topics
      • Unanswered questions
      • Welcome
      • Getting started212
      • News & announcements138
      • Who's hiring457
      • Release notes (archive)63
      • Lesson Comments17
      • Challenge9
      • Looker development
      • LookML2205
      • SQL360
      • Exploring & curating data
      • Explores664
      • Dashboards & looks1913
      • Application development
      • Embedding Looker / Powered by Looker196
      • Open source projects58
      • Looker API443
      • Administration
      • User access & management100
      • General Looker administration521
      • Data science & analytics
      • Got a question?121
      • Share your best practices19
      • The Kitchen Table
      • Technical Tips & Tricks1744
      • Common Account Questions14
      • Blog Archives347
      • DCL Mic Drops5
      • Video Tutorials 🎥5
      • コミュニティフォーラム (Japanese)
      • ニュースと告知56
      • ヘルプとサポート19
      • コラム81
      • Knowledge base
      • Community Resources
      • Using the Community3
      • Account Info & Registration4
      • Community Feedback1
  • Product Announcements
  • Events
  • Groups
  • Community
  • The Kitchen Table
  • Technical Tips & Tricks
  • Selected articles about SQL use cases in Looker
Sticky

Selected articles about SQL use cases in Looker

  • 1 year ago
    27 May 2021
  • 0 replies
  • 575 views
Selected articles about SQL use cases in Looker
Department of Customer Love
Rank
Userlevel 5
  • Department of Customer Love Looker Staff
  • Looker Staff
  • 0 replies

Selected articles about SQL use cases in Looker

 

We have gathered a list of community and help center articles organised in different topics. Hope this makes it easier for you to search and navigate.

 

Troubleshooting

Common SQL error troubleshooting tips in Looker

 

Calendar table

How to combine a retail calendar with retail sales data

Generate Date Series/ Create a calendar view of future dates

Generating a sequence of numbers or dates

How to Set Multiple Week Definitions in Looker

 

Conditional join

CASE in sql_on: Conditional Joins when field = value

 

Datagroup

PDT trigger value at a specific time and day of week, once a week

How to trigger datagroup/PDT rebuilds X minutes past each hour between certain hours of the day

 

Parsing data

Parsing JSON data in Looker

Using Postgres and JSON Functions and Operators to Parse JSON Fields

Defining JSON Objects as LookML Dimensions

 

Query performance

EXPLAIN function

A (Hitchhiker’s) Guide to Query Performance in Looker

 

SQL in LookML fields

Case when lookml vs. sql

case when on yes/no fields

Dynamic rolling week buckets

 

Subqueries

Can I put a subquery in a dimension?

 

Unnesting data

Unnesting in BQ sql

Unnesting in general

 

Window functions

Window Functions in Looker

SQL examples for Window Functions

  • sql
  • Like
  • Quote
  • Share

0 replies

Be the first to reply!

Reply


Powered by inSided
Terms of Service

Sign up

Already have an account? Login

Social Login

or

Login to the community

No account yet? Create an account

Social Login

or
Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK
© 2022 Google. All rights reserved.
Privacy | Terms | Community Guidelines