Powered by Snowflake Openflow and Cortex
Transform your Google Drive business documents into actionable strategic intelligence with the complete Openflow → Cortex Search → Snowflake Intelligence pipeline.
Complete setup guides, business-focused demos, and step-by-step tutorials
⚠️ IMPORTANT PREREQUISITE: This demo requires Snowflake Openflow, which is currently available only
for Enterprise accounts as BYOC (Bring Your Own Cloud) or SPCS (Snowpark Container Services)
Public Preview. Contact your Snowflake account team to enable Openflow access.
This demonstration showcases how Snowflake Intelligence with Cortex Search transforms unstructured business
documents from Google Drive into queryable strategic intelligence through Openflow data processing.
Business Impact: Convert scattered business documents (PDFs, presentations, Word docs, images) into a unified
intelligence platform that executives can query in natural language to make data-driven decisions.
ROI Highlight: Enable non-technical business users to extract insights from documents without SQL knowledge,
reducing time-to-insight by 90% and democratizing access to organizational knowledge.
📖 Professional Documentation with:
- Setup Guides - Prerequisites, database setup, Openflow configuration
- Business Demos - 4 category-specific presentations ready for different audiences
- AI Integration - Snowflake Intelligence agent setup for conversational queries
- Reference Materials - Sample questions, commands, troubleshooting
| Demo Category | Target Audience | Business Focus |
|---|---|---|
| 🎯 Strategic Planning | C-level executives, board members | Investment decisions, market expansion |
| 🔧 Operations Excellence | Operations managers, tech leaders | Process optimization, modernization |
| ⚖️ Compliance & Risk | Compliance officers, audit teams | Policy enforcement, regulatory adherence |
| 📚 Knowledge Management | HR teams, training managers | Staff development, knowledge sharing |
- ✅ Multi-Format Processing: PDF, DOCX, PPTX, JPG - all in one platform
- ✅ Natural Language Queries: "What are our 2025 expansion plans?" vs complex SQL
- ✅ Enterprise Security: Snowflake's enterprise-grade security for sensitive documents
- ✅ Scalable Intelligence: Handles thousands of documents with sub-second query response
- Visual setup guides with screenshots
- Business-focused demo presentations
- Copy-pasteable sample queries
- AI integration tutorials
For experienced users who want immediate setup:
# Run the provided setup script
snow -f sql/setup.sqlWhat the setup script creates:
- ✅ Role:
FESTIVAL_DEMO_ROLEwith appropriate permissions - ✅ Warehouse:
FESTIVAL_DEMO_Sfor compute resources - ✅ Database:
OPENFLOW_FESTIVAL_DEMOfor data storage - ✅ Schema:
FESTIVAL_OPSfor organized data structure
Alternative - Manual SQL:
-- Or run these commands individually in your Snowflake worksheet
CREATE ROLE IF NOT EXISTS FESTIVAL_DEMO_ROLE;
CREATE WAREHOUSE IF NOT EXISTS FESTIVAL_DEMO_S;
CREATE DATABASE IF NOT EXISTS OPENFLOW_FESTIVAL_DEMO;
CREATE SCHEMA IF NOT EXISTS OPENFLOW_FESTIVAL_DEMO.FESTIVAL_OPS;Next Steps:
- 📋 Prerequisites - Technical requirements
- ⚡ Quick Setup - 15-minute streamlined setup
- 🔧 Openflow Setup - Connector configuration
- 🎯 Demo Categories - Business presentations
Once your pipeline is set up, you can ask questions like:
🎯 Strategic: "What are our 2025 expansion strategies and expected ROI?"
🔧 Operations: "Find all technology modernization projects and their budgets"
⚖️ Compliance: "Show me current health and safety policies"
📚 Knowledge: "What training materials are available for staff development?"
End-to-End Architecture:
graph LR
A[📁 Google Drive] --> B[🔄 OpenFlow Pipeline]
B --> C[🔍 Cortex Search Service]
C --> D[🤖 Snowflake Intelligence]
D --> E[💬 Natural Language Queries]
E --> F[📊 Business Insights]
Core Components:
- ✅ Multi-format document processing (PDF, DOCX, PPTX, JPG)
- ✅ Automated Cortex Search service creation and indexing
- ✅ Business-focused demo categories for different stakeholders
- ✅ Optional AI agent for conversational document queries
- ✅ Production-ready setup with security and authentication
-
Strategic Planning: "What are our 2025 expansion plans and expected ROI?"
- Result: Instant access to strategy documents, financial projections, board decisions
-
Operational Excellence: "Show me all technology modernization projects and their budgets"
- Result: $2.8M sound system upgrade project with complete business case
-
Compliance & Risk: "What health and safety policies are currently in effect?"
- Result: Complete policy documentation with incident analysis
-
Knowledge Management: "Find all training materials and staff development programs"
- Result: Cross-department training resources with collaboration insights
- Cost Avoidance: Eliminate manual document searching (saves 2-3 hours/week per knowledge worker)
- Revenue Acceleration: Faster strategic decision-making enables quicker market responses
- Risk Reduction: Instant compliance documentation access reduces regulatory risks
- Scalability: Framework supports enterprise-wide knowledge management expansion
📁 Google Shared Drive → 🔄 OpenFlow (Google Drive Connector) → 🧠 Cortex Search → 📊 Snowflake Intelligence
Google Drive & Google Cloud Requirements:
- Google Admin Access: Super Admin permissions for your organization
- Google Cloud Project with Organization Policy Administrator & Organization Administrator roles
- Service Account Setup:
- Enable service account key creation (disabled by default)
- Create service account with JSON key download
- Configure domain-wide delegation with 6 required OAuth scopes
- Full setup guide: Google Drive connector documentation
Snowflake Requirements:
- Account: Enterprise Snowflake account in AWS Commercial Regions
- Openflow: Available only for Enterprise accounts as BYOC (Bring Your Own Cloud) or SPCS
(Snowpark Container Services) Public Preview- This demo requires Snowflake Openflow which is currently in Public Preview
- Contact your Snowflake account team to enable Openflow access
- Service User: SERVICE type user with key-pair authentication
- Secrets Manager: AWS/Azure/HashiCorp recommended for production
- Cortex Search: Enabled for document intelligence queries
Quick Start (5 minutes):
- Clone repository (all document formats included)
- Create Google Drive structure: Use Google Apps Script for automated folder creation
- Upload 16 demo documents per folder structure
- Configure Openflow Google Drive connector
- Execute natural language queries
16 Multi-Format Business Documents:
- 3 PDF: Formal contracts, policies, financial reports
- 2 PPTX: Training materials, executive presentations
- 2 DOCX: Collaborative meeting minutes, project documentation
- 9 JPG: Visual operational manuals, strategic planning diagrams
4 Business Intelligence Categories:
- Strategic & Executive Intelligence (25%)
- Operations Excellence & Technology (25%)
- Compliance & Risk Management (25%)
- Knowledge Management & Training (25%)
Natural language queries for Snowflake Intelligence after Openflow-Cortex Search integration:
-- Strategic Intelligence
"What are our 2025 expansion plans across all document formats?"
-- Operational Excellence
"Find all technology modernization projects and their business cases"
-- Cross-Format Analysis
"Show me comprehensive insights across all 16 documents - what patterns emerge?"These queries become available once Google Drive documents are processed through the Openflow
data pipeline and indexed by Cortex Search for intelligent document retrieval.
- Multi-Format Processing: Handles PDF text extraction, PPTX content parsing, DOCX collaboration data, JPG OCR
- Metadata Extraction: Document authors, versions, collaboration patterns, business categories
- Natural Language Processing: Cortex Search enables business user queries without SQL knowledge
- Scalability: Architecture supports thousands of documents with enterprise-grade performance
- Analytics Documentation - Complete business intelligence analysis and demo
execution guide - Demo Execution Guide - Step-by-step presenter guide with
Google Drive setup - Document Intelligence Analysis - Comprehensive analytics
opportunities and Cortex Search scenarios
- Google Drive Document Collection - 16 realistic business documents
across 4 formats - Document Metadata & Personas - Business context
and author personas
- SQL & Database - Cortex Search service definitions and supporting queries
- Configuration - Automated tasks for document processing and demo setup
- Taskfile Guide - Complete automation toolkit reference for demoers
- Scripts & Automation - Automated setup tools and utilities for demo preparation
| Audience | Start Here | Key Resource |
|---|---|---|
| Product Marketing | Business Use Cases | Analytics Overview |
| Executives | Business Impact | Demo Execution Guide |
| Technical Teams | Architecture | Document Collection |
🌐 Snowflake-labs.GitHub.io/Openflow-unstructured-data-pipeline-demo
The documentation site provides:
- 🔧 Technical Setup - Prerequisites, database setup, connector configuration
- 🎯 Business Demos - Ready-to-present category demonstrations
- 🤖 AI Integration - Snowflake Intelligence agent setup
- 📋 Reference Guides - Commands, sample questions, troubleshooting
- Getting Started - Complete setup workflow
- Demo Categories - Business-focused presentations
- AI Integration - Snowflake Intelligence setup
- Reference - Sample questions and commands
- Explore Document Intelligence Analysis for analytics
opportunities - Review Sample Queries
for business scenarios - Understand
Business Value Propositions
for stakeholder conversations
- Review Architecture and technical requirements
- Examine Sample Documents for data understanding
- Configure Cortex Search Service per Snowflake requirements
- Implement Openflow Google Drive connector with provided document collection
| Metric | Current State | With Document Intelligence | Improvement |
|---|---|---|---|
| Document Search Time | 30-60 minutes manual search | 5-second natural language query | 90% reduction |
| Cross-Format Analysis | Impossible without manual review | Instant insights across all formats | New capability |
| Executive Insight Access | Requires IT/analyst support | Self-service natural language queries | 100% democratization |
| Compliance Documentation | Hours of manual document location | Instant policy and regulation access | 95% time savings |
- Schedule Demo: Contact solution architect for live demonstration
- Assess Documents: Identify your organization's Google Drive document collection
- Plan Implementation: Review technical requirements and integration points
- ROI Planning: Calculate business value using provided metrics and your document volumes
- Pilot Program: Start with one department's document collection
- Scale Planning: Design enterprise-wide document intelligence architecture
- Integration Strategy: Connect with existing business systems and workflows
- Change Management: Train business users on natural language query capabilities
Ready to transform your unstructured business documents into strategic intelligence?
Copyright (c) Snowflake Inc. All rights reserved. Licensed under the Apache 2.0 license.