ASOF JOINs are the most efficient way to relate the timestamp of one table with the timestamp of another table, even when those timestamps don't match exactly.
Feel free to skip
If you've ever written a SQL query, chances are you've encountered a query that had you twiddling your thumbs. Learning how to read Snowflake's Query Profile is
Snowflake recently released a new feature for granular cost attribution down to individual queries through the QUERY_ATTRIBUTION_HISTORY view in ACCOUNT_USAGE. As a company focused on SQL optimization, we at Greybeam
When it comes to managing your Snowflake expenses, understanding how compute costs are calculated and optimized is crucial. In this comprehensive guide, we’ll break down the intricacies of Snowflake’s billing model
Arsham and I attended an optimization presentation at Snowflake's San Mateo office last week. Maneesh (VP Value Engineering @ Snowflake) painted the picture of optimization with an interesting analogy that I thought