Patrick cpdough

## CLAUDE.md

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
            
              
                
                0 comments
              
            
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                cpdough
                / CLAUDE.md
            
            
              Created
              September 4, 2025 16:35
            
              
                Claude Code <> Snowflake CLI instructions for CLAUDE.md
              
          
        
      
        
  
      
    Snowflake CLI Testing

Use the Snowflake CLI (snow) with connection "sf" for testing and validation:
SQL Validation and Testing:
# Validate SQL syntax without creating objects
snow sql -q "SELECT * FROM STAGE_DB.MDM.PIPELINE LIMIT 10" --connection sf

# Execute SQL from transformation files for testing
snow sql -f transformations/base/pipeline.sql --connection sf