2025 Snowflake Best Practices Flashcards
1
Q
What is the architecture behind Snowflake
A
Hybrid of Shared Disk and Share Nothing
2
Q
What can you do with your warehouse to handle complex queries
A
Scale up
3
Q
Where should ORDER BY be in a query with a subquery?
A
In the top-level select only
4
Q
Which is more performant, INSERT or COPY
A
COPY (Insert is row by row, copy is bulk)
5
Q
What columns should be preferred for deleting and inserting
A
DATE and NUMERIC
6
Q
Why would you presort your data before loading to Snowflake
A
Enables Snowflake to automatically partition based on natural ingestion order
