Core concept

Static + dynamic (join with dim). Metadata-based.

Advertisement

How it works

Non-column filter (UDF) defeats. Cast on col defeats.

Advertisement

Trade-offs + gotchas

Every partitioned query.