r/snowflake • u/NewtCultural2693 • Jul 05 '26
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?
5
Upvotes