▲ 1 r/snowflake
Snowflake High Compilation
The Query Profile shows compilation taking 7–10 seconds while execution is under a second. We suspect the compilation overhead may be related to multiple cross-database joins combined with Row Access Policies and masking policies, but we'd like to understand whether others have observed similar behavior. Any solutions to reduce the compilation time?
u/NewtCultural2693 — 12 hours ago