What's up with joining on date?

[LookerExperts]

Knowledge Drop

Last tested: Jan 21, 2019

We recommend against joining on date, because it is incredibly non performant.

However, if you wants to do it anyway, they need to use the raw timeframe to ensure that time zone conversion happens properly.

Merge results should alleviate most join-on-date use cases.

This content is subject to limited support.