This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
      Learn more about bidirectional Unicode characters
    
  
  
    
  | -- ==================================================================================== | |
| -- 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 |