Question

Merge Row Limit Solution

  • 30 November 2020
  • 2 replies
  • 75 views

Is there any workaround for the 5,000 row limit for merged content?


2 replies

Userlevel 5

The only workaround I have found was to consider merge queries non-existent : )

Userlevel 7
Badge

Yup, there’s no workaround in general for the 5000 row limit for anything in-browser, and result merging happens in the browser. We’ve had some internal discussions about how to make Merge Results more useful with large queries but we don’t currently have any immediate plans.

 

If your databases are very similar (on the same SQL dialect, reside on the same physical machine, and are accessible from the same connection in Looker), you can use federated joins at the model level.

Reply