# \#performance

**URL:** https://discuss.google.dev/tag/performance/60.md

[Latest](https://discuss.google.dev/latest.md) · [Categories](https://discuss.google.dev/categories.md) · [Tags](https://discuss.google.dev/tags.md)

---

## [Dashboard rendering bottleneck: 1s Query execution but 10s "Processing" on a single table tile](https://discuss.google.dev/t/dashboard-rendering-bottleneck-1s-query-execution-but-10s-processing-on-a-single-table-tile/351677)

<div class="topic-metadata">

**Author:** [@Saty](https://discuss.google.dev/u/Saty)\
**Replies:** 0\
**Last updated:** [April 20, 2026, 12:09pm UTC](https://discuss.google.dev/t/dashboard-rendering-bottleneck-1s-query-execution-but-10s-processing-on-a-single-table-tile/351677 "2026-04-20T12:09:00Z")

</div>

I’m seeking advice on a performance bottleneck within a customer-facing dashboard. The dashboard contains 12 tiles, including merged results, cross-filters, and custom visualizations. I’ve identified a specific table vi…

---

## [Mastering the Hybrid Fact Pattern in Looker](https://discuss.google.dev/t/mastering-the-hybrid-fact-pattern-in-looker/344986)

<div class="topic-metadata">

**Author:** [@brett-guenther](https://discuss.google.dev/u/brett-guenther)\
**Replies:** 0\
**Last updated:** [March 31, 2026, 3:12am UTC](https://discuss.google.dev/t/mastering-the-hybrid-fact-pattern-in-looker/344986 "2026-03-31T03:12:27Z")

</div>

In retail and e-commerce, data usually falls into two buckets: Flow (Sales, Returns, Shipments) and Stock (Inventory on Hand, Warehouse Capacity). The “Hybrid Fact” challenge arises because these two data types behave d…

---

## [Conversation Analytics in Looker](https://discuss.google.dev/t/conversation-analytics-in-looker/341180)

<div class="topic-metadata">

**Author:** [@Agustina\_Bajko](https://discuss.google.dev/u/Agustina_Bajko)\
**Replies:** 0\
**Last updated:** [March 17, 2026, 11:00pm UTC](https://discuss.google.dev/t/conversation-analytics-in-looker/341180 "2026-03-17T23:00:04Z")

</div>

Anyone experiencing performance issues with Conversation Analytics in Looker?

---

## [A Guide to Looker Performance Optimization](https://discuss.google.dev/t/a-guide-to-looker-performance-optimization/327620)

<div class="topic-metadata">

**Author:** [@michael123](https://discuss.google.dev/u/michael123)\
**Replies:** 1\
**Last updated:** [February 4, 2026, 1:53pm UTC](https://discuss.google.dev/t/a-guide-to-looker-performance-optimization/327620 "2026-02-04T13:53:21Z")

</div>

Purpose: While many resources cover Looker performance, this guide synthesizes best practices into four key pillars: Understanding Looker’s philosophy Optimizing and simplifying execution Enforcing guardrails and limit…

---

## [How to measure the number of queries hitting aggregate tables](https://discuss.google.dev/t/how-to-measure-the-number-of-queries-hitting-aggregate-tables/318838)

<div class="topic-metadata">

**Author:** [@ruthc](https://discuss.google.dev/u/ruthc)\
**Replies:** 3\
**Last updated:** [January 14, 2026, 1:55pm UTC](https://discuss.google.dev/t/how-to-measure-the-number-of-queries-hitting-aggregate-tables/318838 "2026-01-14T13:55:17Z")

</div>

I am currently testing out aggregate tables, to see if we can optimise taxing dashboards by creating some strategic roll up tables. Just to get started with a simple use case, I have taken a single dashboard and added t…

---

## [Pulling in Google Ads PMax Search Terms into Looker](https://discuss.google.dev/t/pulling-in-google-ads-pmax-search-terms-into-looker/301206)

<div class="topic-metadata">

**Author:** [@Jeff\_Molitor](https://discuss.google.dev/u/Jeff_Molitor)\
**Replies:** 0\
**Last updated:** [December 28, 2025, 10:22pm UTC](https://discuss.google.dev/t/pulling-in-google-ads-pmax-search-terms-into-looker/301206 "2025-12-28T22:22:58Z")

</div>

i have google ads connected and can see the overall data for campaigns BUT i am only running Performance Max campaigns and would love to pull in Search Terms data from gAds into Looker - in researching I dont see any way…

---

## [Does the amount of Personal Folders affect instance performance?](https://discuss.google.dev/t/does-the-amount-of-personal-folders-affect-instance-performance/271589)

<div class="topic-metadata">

**Author:** [@schoolsofthough](https://discuss.google.dev/u/schoolsofthough)\
**Replies:** 1\
**Last updated:** [October 13, 2025, 3:25pm UTC](https://discuss.google.dev/t/does-the-amount-of-personal-folders-affect-instance-performance/271589 "2025-10-13T15:25:33Z")

</div>

When employees leave, we usually just disable the user in Looker instead of deleting them. Because of this it seems like a ton of empty Personal Folders still exist in our instance and i’m wondering if it’s worth the eff…

---

## [What is Source=api4 in Looker System Activity Explores?](https://discuss.google.dev/t/what-is-source-api4-in-looker-system-activity-explores/266027)

<div class="topic-metadata">

**Author:** [@schoolsofthough](https://discuss.google.dev/u/schoolsofthough)\
**Replies:** 1\
**Last updated:** [October 7, 2025, 8:48pm UTC](https://discuss.google.dev/t/what-is-source-api4-in-looker-system-activity-explores/266027 "2025-10-07T20:48:00Z")

</div>

Trying to find some information on what the values in the History Source field in explore/system\_\_activity/history Explore represent. Specifically want to know what it means Source=api4. I thought that would mean querie…

---

## [Using a dynamic Dimension by parameter / Problem: lot of joins](https://discuss.google.dev/t/using-a-dynamic-dimension-by-parameter-problem-lot-of-joins/189476)

<div class="topic-metadata">

**Author:** [@Maike1](https://discuss.google.dev/u/Maike1)\
**Replies:** 5\
**Last updated:** [July 16, 2025, 4:24pm UTC](https://discuss.google.dev/t/using-a-dynamic-dimension-by-parameter-problem-lot-of-joins/189476 "2025-07-16T16:24:55Z")

</div>

I use a parameter for selecting a field, i want to see in mey look/visualization like this: parameter: pardimVar { label: "\_DimensionSwitch" type: unquoted allowed\_value: {label: "BillingKind" value: "billingkind"} allo…

---

## [Want to use filter value in liquid IF in dimension SQL field](https://discuss.google.dev/t/want-to-use-filter-value-in-liquid-if-in-dimension-sql-field/136505)

<div class="topic-metadata">

**Author:** [@Bruce\_Krulwich](https://discuss.google.dev/u/Bruce_Krulwich)\
**Replies:** 1\
**Last updated:** [July 3, 2025, 2:40pm UTC](https://discuss.google.dev/t/want-to-use-filter-value-in-liquid-if-in-dimension-sql-field/136505 "2025-07-03T14:40:35Z")

</div>

I want to access the value of a filter on a dimension inside a liquid IF statement in a measure SQL line. I know I can do this if my filter is a PARAMETER and I know I can do this if I’m using a derived table, but I spe…

---

## [Looker Performance Optimization With Henry](https://discuss.google.dev/t/looker-performance-optimization-with-henry/191064)

<div class="topic-metadata">

**Author:** [@Dr\_Strangelove](https://discuss.google.dev/u/Dr_Strangelove)\
**Replies:** 0\
**Last updated:** [June 9, 2025, 1:16pm UTC](https://discuss.google.dev/t/looker-performance-optimization-with-henry/191064 "2025-06-09T13:16:30Z")

</div>

The number and complexity of LookML models has a lot to do with the responsiveness of Looker, as well as its usability. Every time the browser renders a screen, it downloads the list of models from Looker. Similarly when…

---

## [Filter derived table based on the id associated with the user entered value](https://discuss.google.dev/t/filter-derived-table-based-on-the-id-associated-with-the-user-entered-value/189329)

<div class="topic-metadata">

**Author:** [@jbernal](https://discuss.google.dev/u/jbernal)\
**Replies:** 4\
**Last updated:** [May 19, 2025, 7:09pm UTC](https://discuss.google.dev/t/filter-derived-table-based-on-the-id-associated-with-the-user-entered-value/189329 "2025-05-19T19:09:17Z")

</div>

We have a derived table that I would like to filter based on user’s input on the front end explore. The main goal is for the filter to improve the number of records scanned and thus performance. However, the improved per…

---

## [Need a way to incrementally build a PDT that's using create\_process](https://discuss.google.dev/t/need-a-way-to-incrementally-build-a-pdt-thats-using-create-process/185139)

<div class="topic-metadata">

**Author:** [@kt\_grist](https://discuss.google.dev/u/kt_grist)\
**Replies:** 3\
**Last updated:** [May 9, 2025, 9:06pm UTC](https://discuss.google.dev/t/need-a-way-to-incrementally-build-a-pdt-thats-using-create-process/185139 "2025-05-09T21:06:37Z")

</div>

Hi Everyone, We have a PDT that is built using create\_process and contains a few sql\_steps. This PDT is becoming large and very time-consuming to build fully every day. We want to build it incrementally but that is not…

---

## [YoY/PoP Implementation Help?](https://discuss.google.dev/t/yoy-pop-implementation-help/188676)

<div class="topic-metadata">

**Author:** [@Theodocius](https://discuss.google.dev/u/Theodocius)\
**Replies:** 1\
**Last updated:** [May 8, 2025, 7:48am UTC](https://discuss.google.dev/t/yoy-pop-implementation-help/188676 "2025-05-08T07:48:29Z")

</div>

Hello everybody, for the past two months, the bane of my existence has been trying to implement a PoP solution for dashboarding in Looker. I was excited for the new PoP feature that got added to Looker recently but when …

---

## [Cache Invalidation](https://discuss.google.dev/t/cache-invalidation/184202)

<div class="topic-metadata">

**Author:** [@beratsert41](https://discuss.google.dev/u/beratsert41)\
**Replies:** 8\
**Last updated:** [April 28, 2025, 2:17pm UTC](https://discuss.google.dev/t/cache-invalidation/184202 "2025-04-28T14:17:17Z")

</div>

Hi, In admin sections, I am reviewing Datagroups to monitor caching resets. However, although there is a cache invalidation in that datagroup, it is not reflecting there. Is there any where else that I can check? (I am …

---

## [URGENT - Semi Additive Measures - No LookML solution](https://discuss.google.dev/t/urgent-semi-additive-measures-no-lookml-solution/187732)

<div class="topic-metadata">

**Author:** [@Uday2](https://discuss.google.dev/u/Uday2)\
**Replies:** 0\
**Last updated:** [April 25, 2025, 8:06pm UTC](https://discuss.google.dev/t/urgent-semi-additive-measures-no-lookml-solution/187732 "2025-04-25T20:06:20Z")

</div>

Please provide a solution for Semi Additive Measures inside Look ML without any pre-calculation, derived table

---

## [Creating couple columns from a single nested field](https://discuss.google.dev/t/creating-couple-columns-from-a-single-nested-field/181622)

<div class="topic-metadata">

**Author:** [@beratsert41](https://discuss.google.dev/u/beratsert41)\
**Replies:** 1\
**Last updated:** [April 23, 2025, 3:05pm UTC](https://discuss.google.dev/t/creating-couple-columns-from-a-single-nested-field/181622 "2025-04-23T15:05:58Z")

</div>

Hi, We store event log properties in nested fields, as shown below: dimension: message\_number { type: number view\_label: "Event Properties" sql: ( select …

---

## [How to create a measure in LookML based on different views/explorers](https://discuss.google.dev/t/how-to-create-a-measure-in-lookml-based-on-different-views-explorers/150536)

<div class="topic-metadata">

**Author:** [@Des2907](https://discuss.google.dev/u/Des2907)\
**Replies:** 6\
**Last updated:** [April 15, 2025, 3:28am UTC](https://discuss.google.dev/t/how-to-create-a-measure-in-lookml-based-on-different-views-explorers/150536 "2025-04-15T03:28:58Z")

</div>

I have created two views from a table with some implemented measures. It’s something basic, illustrated as follows: view : view\_A { dimension: Time\_A {....} dimension: Value\_A {...} dimension: code\_B {..} measure: Tota…

---

## [Why are explores getting auto created in my model?](https://discuss.google.dev/t/why-are-explores-getting-auto-created-in-my-model/184406)

<div class="topic-metadata">

**Author:** [@ginandtobby](https://discuss.google.dev/u/ginandtobby)\
**Replies:** 2\
**Last updated:** [March 19, 2025, 4:40pm UTC](https://discuss.google.dev/t/why-are-explores-getting-auto-created-in-my-model/184406 "2025-03-19T16:40:01Z")

</div>

Hi Community! I have a View A defined in a view.lkml file, and I have defined an Explore A using View A in a model.lkml file under Model A. Then, I defined some explores in another model, Model B, in which I included so…

---

## [Help with combined data source](https://discuss.google.dev/t/help-with-combined-data-source/172443)

<div class="topic-metadata">

**Author:** [@FelipeMendes](https://discuss.google.dev/u/FelipeMendes)\
**Replies:** 1\
**Last updated:** [February 21, 2025, 7:22pm UTC](https://discuss.google.dev/t/help-with-combined-data-source/172443 "2025-02-21T19:22:43Z")

</div>

Hi everyone, how are you? I have a question and I hope to find help here! I’m creating a BI in Data Studio and I’ve run into a problem. I use Google Spreadsheets as a database. In this case, for this data set, I have …

---

## [Persist Data and Auto-Refresh](https://discuss.google.dev/t/persist-data-and-auto-refresh/131385)

<div class="topic-metadata">

**Author:** [@khartman2](https://discuss.google.dev/u/khartman2)\
**Replies:** 2\
**Last updated:** [February 7, 2025, 11:10am UTC](https://discuss.google.dev/t/persist-data-and-auto-refresh/131385 "2025-02-07T11:10:47Z")

</div>

I have some slow running models and have found adding persist\_for for 1440 minutes and scheduling the dashboard to refresh overnight everyday to be helpful. However, when users try to filter the dashboard, I find we stil…

---

## [How to Stop Automatic Date Conversion in Looker Filters](https://discuss.google.dev/t/how-to-stop-automatic-date-conversion-in-looker-filters/177840)

<div class="topic-metadata">

**Author:** [@lookeruser8888](https://discuss.google.dev/u/lookeruser8888)\
**Replies:** 3\
**Last updated:** [January 13, 2025, 4:03pm UTC](https://discuss.google.dev/t/how-to-stop-automatic-date-conversion-in-looker-filters/177840 "2025-01-13T16:03:12Z")

</div>

I have date dimension, and I have a filter based on date to get data earlier than certain date. However, I noticed that looker automatically use wrapper function (TO\_DATE) which prevents snowflake to leverage the index a…

---

## [Temporal Series Graphs - How to set a custom start date on the X-asis](https://discuss.google.dev/t/temporal-series-graphs-how-to-set-a-custom-start-date-on-the-x-asis/174191)

<div class="topic-metadata">

**Author:** [@Constanzartus](https://discuss.google.dev/u/Constanzartus)\
**Replies:** 1\
**Last updated:** [December 19, 2024, 6:19pm UTC](https://discuss.google.dev/t/temporal-series-graphs-how-to-set-a-custom-start-date-on-the-x-asis/174191 "2024-12-19T18:19:09Z")

</div>

Hello, I need assistance with a time series graph in Looker Studio. I’m trying to compare five different sales processes, and I need to be able to set a custom start date on the X-axis. My goal is to display a year-and-…

---

## [How to implement DatesYTD and DatesMTD  using LookML](https://discuss.google.dev/t/how-to-implement-datesytd-and-datesmtd-using-lookml/152351)

<div class="topic-metadata">

**Author:** [@salehaxsid](https://discuss.google.dev/u/salehaxsid)\
**Replies:** 4\
**Last updated:** [December 19, 2024, 5:55pm UTC](https://discuss.google.dev/t/how-to-implement-datesytd-and-datesmtd-using-lookml/152351 "2024-12-19T17:55:46Z")

</div>

Implementation of DatesYTD, DatesMTD using LookML is simple, you just have to create another explore with sql\_where condition of existing view that has transaction date. For Example: We have a view “Orders” and it has …

---

## [Does layered view structure slow down validate lookml](https://discuss.google.dev/t/does-layered-view-structure-slow-down-validate-lookml/176528)

<div class="topic-metadata">

**Author:** [@kendrickp](https://discuss.google.dev/u/kendrickp)\
**Replies:** 1\
**Last updated:** [December 18, 2024, 6:57pm UTC](https://discuss.google.dev/t/does-layered-view-structure-slow-down-validate-lookml/176528 "2024-12-18T18:57:31Z")

</div>

We have structured our lookml to have a raw DB view file that is not to be touched. Then we extend these view files into other files where we create our measures. Could this structure slow down the validate lookml?

---

## [Google's Connector can't find a particular account in my MCC](https://discuss.google.dev/t/googles-connector-cant-find-a-particular-account-in-my-mcc/173022)

<div class="topic-metadata">

**Author:** [@SandraC](https://discuss.google.dev/u/SandraC)\
**Replies:** 0\
**Last updated:** [November 14, 2024, 9:47am UTC](https://discuss.google.dev/t/googles-connector-cant-find-a-particular-account-in-my-mcc/173022 "2024-11-14T09:47:11Z")

</div>

Someone else has had this issue but there’s been no response. Google’s Ad connector in Looker Studio can find 99% of the accounts in my Google MCC. There is one that it can’t find. it is still in the MCC. It found it pr…

---

## [Looker merge is taking a long time to show in production](https://discuss.google.dev/t/looker-merge-is-taking-a-long-time-to-show-in-production/168658)

<div class="topic-metadata">

**Author:** [@Magen1](https://discuss.google.dev/u/Magen1)\
**Replies:** 4\
**Last updated:** [November 12, 2024, 10:36am UTC](https://discuss.google.dev/t/looker-merge-is-taking-a-long-time-to-show-in-production/168658 "2024-11-12T10:36:25Z")

</div>

Hi Looker Community We’re noticing that after merges in Looker, it is taking quite a long time to reflect in Production. Sometimes it may be around a few minutes, while other times it may take hours. Has anyone experi…

---

## [Convert Business Date to DOW](https://discuss.google.dev/t/convert-business-date-to-dow/172595)

<div class="topic-metadata">

**Author:** [@ChrisBrack83](https://discuss.google.dev/u/ChrisBrack83)\
**Replies:** 1\
**Last updated:** [November 11, 2024, 5:39pm UTC](https://discuss.google.dev/t/convert-business-date-to-dow/172595 "2024-11-11T17:39:43Z")

</div>

Hi All In Looker we have a business date dimension and I want to create a Custom Dimension which will convert the dates to the Day of Week EG 11th November 2024 = Monday Many Thanks

---

## [Same Datagroup in Multiple Projects](https://discuss.google.dev/t/same-datagroup-in-multiple-projects/170830)

<div class="topic-metadata">

**Author:** [@kwelshlmnd17](https://discuss.google.dev/u/kwelshlmnd17)\
**Replies:** 1\
**Last updated:** [October 31, 2024, 7:49pm UTC](https://discuss.google.dev/t/same-datagroup-in-multiple-projects/170830 "2024-10-31T19:49:48Z")

</div>

I have a question pertaining to an issue I’m encountering with PDTs in respect to datagroups and having multiple models: We have some identically named datagroups in multiple models that always ran off of one model. Star…

---

## [LookML - how to generate week number in LookML](https://discuss.google.dev/t/lookml-how-to-generate-week-number-in-lookml/170108)

<div class="topic-metadata">

**Author:** [@sysph](https://discuss.google.dev/u/sysph)\
**Replies:** 2\
**Last updated:** [October 17, 2024, 11:57am UTC](https://discuss.google.dev/t/lookml-how-to-generate-week-number-in-lookml/170108 "2024-10-17T11:57:46Z")

</div>

Hi there, i’m pretty new to Looker. Looking for some help please. Are we able to concatenate ‘week’ with CAST(WEEK(${TABLE}.“CREATED\_DATE”) AS STRING)) ;; to create week number. I would like to have 2 digits (eg. week00 …

[Next page](https://discuss.google.dev/tag/performance/60.md?match_all_tags=true&page=1&tags%5B%5D=performance)
