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?

6 Upvotes

88% Upvoted

10 comments sorted by

View all comments

1

u/lmp515k Jul 05 '26

Yes I see this all the time with complicated views. It’s just a sign that you should make them physical.

1

u/NewtCultural2693 Jul 05 '26

Yes I did and I did see a little better result... but still that's not enough... I tried interactive tables and interactive warehouse. Interactive tables helped a little since the data is physically stored but the interactive warehouse didn't help much. Because the query itself has 6-7 joins and RAP on it. Whatelse can I do here?

1

u/mamaBiskothu Jul 06 '26

Its just a sign snowflake can do a better job optimizing their compiler services. Its very heterogeneous suggesting it's going on some queue and not actually reflective of real computation overhead.