This repository contains a collection of practical examples demonstrating how to leverage Snowflake's AISQL capabilities across various business domains. Each subfolder contains a complete sample application with notebooks, supporting files, and use case details.
Automated marketing lead screening and qualification
Demonstrate how Snowflake's marketing team uses AISQL to analyze, cleanse, and enrich incoming leads from web forms. The pipeline filters spam, scores leads on ICP fit, categorizes by seniority, and enables personalized outreach—accelerating sales cycles and increasing conversion rates.
Customer feedback analysis and response automation
Process large volumes of unstructured customer reviews to identify product issues, analyze sentiment, and automate response generation. This solution helps e-commerce companies understand customer concerns, prioritize product improvements, and scale customer service operations.
Image-based advertising optimization
Transform ad campaign performance by analyzing image content alongside traditional metrics. This solution demonstrates image classification, content-based filtering, tagline generation, and sentiment analysis—all using familiar SQL syntax without switching between specialized tools.
AI-powered promotion and feedback analysis for consumer goods
Unlock ROI from trade promotions by extracting actionable insights from customer feedback, social posts, and call center notes using AISQL. This use case demonstrates how to:
- Create synthetic tables for promotions and feedback
- Filter and classify feedback with AISQL functions
- Analyze sentiment and summarize campaign performance
- Detect competitor activity and generate improved marketing copy
Retail and CPG teams can leverage these techniques to optimize promotional spend, boost compliance, and drive real-time campaign improvements—all directly in SQL.
Multimodal healthcare data processing
Analyze diverse healthcare data including medical images, transcripts, and audio recordings using AI-powered SQL functions. This comprehensive solution supports clinical decision making, enhances population health management, and improves operational efficiency in healthcare organizations.
Automated financial document analysis and insight extraction
Streamline equity research workflows by processing PDF reports, extracting company mentions with sentiment analysis, and mapping to tradable tickers. This solution aggregates insights across multiple research documents and generates concise summaries for specific equities.
Each use case folder contains:
- A detailed README with specific information about the use case
- Jupyter notebooks with executable code samples
- Supporting files and sample data where applicable
- Explanations of business value and technical implementation
Contributions are welcome! Please feel free to submit a Pull Request. Please ensure to include:
- Notebook codes
- Underlying data
- README.md in explaining use cases