Archive

All 32 posts, newest first.

2025-04-23 — Quick Sample of Fuzzy Matching in Snowflake
2022-06-23 — Converting camelCase and SNAKE_CASE
2021-01-22 — Running Dynamic SQL in Snowflake
2020-12-10 — Getting Snowflake's Current Timezone
2020-11-30 — Geolocation of IP Addresses in Snowflake — Part 3
2020-11-25 — Least Privilege Access to Monitor Snowflake Usage
2020-11-24 — Snowflake Version
2020-11-20 — Regex Non-Capturing Groups and Lookarounds in Snowflake
2020-07-29 — Getting Snowflake Primary Key Columns as a Table
2020-04-28 — Oracle to Snowflake Table DDL Conversion
2020-04-11 — Overloading JavaScript UDFs in Snowflake
2020-03-18 — Multi-Table Inserts with Good and Bad Row Tables
2020-03-16 — Helper Functions in Snowflake Stored Procedures
2020-02-21 — Getting a Complete List of User Privileges in Snowflake
2020-02-01 — Executing Multiple SQL Statements in a Stored Procedure - Part Deux
2020-01-17 — Connecting Microsoft Access to Snowflake
2020-01-14 — Snowflake UDF to Get Payment Card Type
2020-01-12 — Snowflake Relationships - Java Utilities
2020-01-12 — Snowflake Streams Made Simple
2020-01-08 — Field Comparisons Using Snowflake
2019-10-14 — Object Dependency Checking in Snowflake
2019-10-03 — Preserving Table Change History Indefinitely
2019-09-05 — Setting the Default Timezone for a Snowflake Account
2019-08-22 — Executing Multiple SQL Statements in a Stored Procedure
2019-08-01 — Capturing Audit Trails in Snowflake
2019-07-22 — CHAR Padding in Snowflake
2019-07-16 — Conditional Column Masking Based on Role
2019-07-16 — Creating a Hello World Stored Procedure in Snowflake
2019-07-12 — Geolocation of IP Addresses in Snowflake - Part 2
2019-05-30 — Geolocation of IP Addresses in Snowflake
2019-05-28 — Grouping Numbers in Snowflake - Part 2
2019-05-22 — Grouping Numbers in Snowflake