menu
arrow_back

Caching and Datagroups with LookML

search share 加入 登录

Caching and Datagroups with LookML

1 个小时 免费

GSP893

Google Cloud Self-Paced Labs

Overview

Looker is a modern data platform in Google Cloud that lets you analyze and visualize your data interactively. You can use Looker to do in-depth data analysis, integrate insights across different data sources, build actionable data-driven workflows, and create custom data applications.

Looker is constantly generating SQL queries and sending them to the connected database. Whenever someone runs new a query in Looker, the SQL results are cached and stored in an encrypted file on the Looker instance.

caching-overview.png

Caching leverages the saved results from previously executed queries, so that the same query does not need to be run on the database each time. This helps to reduce database load.

A datagroup is the Looker term for a caching policy or rule. LookML developers use datagroups to manage caching on a Looker instance.

Caching is a useful feature that reduces database load and helps to optimize Looker performance. In this lab, you will learn how caching works in Looker and explore how to use LookML objects called datagroups to define caching policies.

加入 Qwiklabs 即可阅读本实验的剩余内容…以及更多精彩内容!

  • 获取对“Cloud Console”的临时访问权限。
  • 200 多项实验,从入门级实验到高级实验,应有尽有。
  • 内容短小精悍,便于您按照自己的节奏进行学习。
加入以开始此实验