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
    • Knowledge base
    • Community ResourcesUsing the Community3Account Info & Registration4Community Feedback1
    • Community
    • WelcomeGetting started142News & announcements125Who's hiring493Release notes (archive)63Lesson Comments15Challenge10
    • Looker developmentLookML1830SQL319
    • Exploring & curating dataExplores558Dashboards & looks1563
    • Application developmentEmbedding Looker / Powered by Looker155Open source projects54Looker API376
    • AdministrationUser access & management70General Looker administration452
    • Data science & analyticsGot a question?83Share your best practices16
    • The Kitchen TableTechnical Tips & Tricks1739Common Account Questions14Blog Archives347DCL Mic Drops5Video Tutorials 🎥4
    • コミュニティフォーラム (Japanese)ニュースと告知50ヘルプとサポート14コラム69
  • Ask question / Create topic
  • Login
  • 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
  • 397 views
Selected articles about SQL use cases in Looker
Department of Customer Love
Rank
Userlevel 5
  • Department of Customer Love Moderator
  • Moderator
  • 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