Coming Soon! We’re launching a new sub-community within the Google Cloud Community dedicated to cloud security: The Google Cloud Security Community. In preparation for the launch, this site will be in read only mode from 22 September 12am PST - 23 September 7pm PST

How does an incorrect relationship affect queries?

Knowledge Drop

Last tested: March 2021

The relationship parameter only tells Looker whether or not to use symmetric aggregates. So, the worst case scenario from an incorrect relationship is that Looker does not apply symmetric aggregates when it really needs to. Thus, you can have fanout and potentially incorrect data.

If you leave the "relationship" parameter blank, then Looker will apply "many_to_one".

If you don't know the what the relationship is, "many_to_many" is the safest choice. The worst it will do is add unnecessary symmetric aggregates, which may cause slower queries but guarantees that fanout will not cause incorrect data.

This content is subject to limited support.                

Version history
Last update:
‎04-05-2021 09:00 AM
Updated by: