Skip to content

Instantly share code, notes, and snippets.

View bburton5857's full-sized avatar

bburton5857

  • Joined Oct 27, 2025
View GitHub Profile
@bburton5857
bburton5857 / Beyond_Auto_Classification.js
Created October 27, 2025 19:47
Full JavaScript code for Beyond Auto-Classification Medium Article
-- ====================================================================================
-- HIGH-PRECISION PHONE NUMBER AUTO-TAGGING STORED PROCEDURE
-- ====================================================================================
-- Description: Automatically discovers and tags phone number columns using NPA/NXX validation
-- Author: Bruce Burton, Sr. Solutions Architect at Snowflake
-- Version: 1.0
--
-- Prerequisites:
-- 1. PII_MASKING_FOR_PHONE_NUMBER_NPA_NXX table populated with valid NPA/NXX combinations
-- 2. EXTRACT_NPANXX() Python UDF created