Categories / snowflake-cloud-data-platform
Flattening Avro Files for Efficient Querying on Snowflake: A Better Approach than UNNEST
Converting Snowflake Timestamps to Floating-Point Date Serial Numbers
Parsing Lists Within Tables in Snowflake Using SQL: A Practical Guide
Converting Dates in Snowflake: A Deep Dive into TO_VARCHAR and DATE_TRUNC functions
Get Latest and Earliest Transactions by Date with SQL Window Functions
Optimizing Window Function Queries in Snowflake: Alternative Approaches to Change Value Identification
Joining Tables Based on Common Columns While Ensuring One Recent Row per Group