Design and Implement Snowflake Data Applications with ChatGPT 4
What you will learn
Programmatically use the latest GPT-4 Turbo LLM from Snowflake apps
Access ChatGPT from all sorts of Snowflake data applications
Access the OpenAI Chat Completion API through Python and REST calls
Use external functions and external access integrations to call ChatGPT
Configure Visual Studio Code with plugins for Snowflake and ChatGPT
Create local Streamlit web apps and Streamlit in Snowflake Apps with ChatGPT
Description
Who I Am
- World-Class Expert in Snowflake.
- Former Snowflake “Data Superhero” and SnowPro Certification Subject Matter Expert.
- SnowPro Exams in Core, Architect, Data Engineer, and Data Analyst Certifications.
- Multiple Certifications in Data Science and Machine Learning.
- Seasoned Data Architect, Data Engineer, Machine Learning Engineer…
What Integrations We Will Build or Configure
- App #1: Configure ChatGPT as a Coding Assistant for Snowflake in VSCode
- App #2: Generate Snowflake Sample Databases with ChatGPT from VSCode
- App #3: Snowflake Metadata Inspector in Natural Language
- App #4: Interactive Data Analysis with ChatGPT Bot Agent
- App #5: Instant Charts with the Advanced Data Analysis Plugin
- App #6: Generate a Usage Monitoring Dashboard for Snowflake Account
- App #7: Data Enrichment with an External Integration of ChatGPT
- App #8: ChatGPT with LlamaIndex on Personal Documents
- App #9: ChatGPT SQL Agent with LangChain
- App #10: Snowflake Query Analyzer and Optimizer
Snowflake Technologies You Will Learn More About
- DDL and SQL Queries
- Querying Data through the Snowsight web UI or a VSCode plugin
- Local Streamlit web applications connected to Snowflake
- Streamlit apps deployed in Streamlit Community Cloud
- Streamlit in Snowflake Apps
- External Functions
- External Access Integrations
- Generating Synthetic Data
- Data Enrichment
- Information Schema and Account Usage metadata
- Data Analysis
- Monitoring Dashboards
- Using Public Datasets from the Marketplace
- Query Analysis and Performance Optimization
ChatGPT Technologies You Will Learn More About
- Use cases of the most recent GPT-4 Turbo model
- Using the OpenAI Chat Completions API
- Access the OpenAI API from Python and curl
- Instant Data Analysis on Uploaded Documents with GPT-4 Plus
- Indexing Custom Content with LlamaIndex and RAG
- Automatic SQL Query Generation with LangChain
What This Course Will NOT Teach You
- In-depth knowledge of Snowflake and its ecosystem
- In-depth knowledge of ChatGPT and other OpenAI products
- APIs other than ChatGPT Chat Completion API (vision, embeddings…)
- Connecting to Azure Open AI service
- Bing Chat with Copilot (or any other Microsoft service)
- Data Science and Machine Learning with Snowflake or ChatGPT
== Enroll today, you’ll not regret it! ==
English
language
Content
Introduction
Promo Clip
Quick Presentation of the 10 Integrations
Best Ways to Benefit from this Course
App #1: Configure ChatGPT as a Coding Assistant for Snowflake in VSCode
Introduction to Snowflake and ChatGPT
Configure VSCode for our GitHub Project
Create a Free Trial Snowflake Account
Create ChatGPT API and ChatGPT Plus Accounts
Install Snowflake and ChatGPT VSCode Plugins
Review of Snowflake and ChatGPT
App #2: Generate Snowflake Sample Databases with ChatGPT from VSCode
Introduction to Snowflake Sample Data
Generate and Run Sample DDL Script
Generate Fake but Realistic Data in Python
Generate Synthetic Data in SQL
Generate and Run Python Code for Web Data Scraping
Generate SQL Queries for Specific Tables
Review of Snowflake Sample Data
App #3: Snowflake Metadata Inspector in Natural Language
Introduction to Snowflake Metadata
Create a Simple Q&A Interface with ChatGPT
Generate and Run Metadata Queries
Create a Streamlit Web App with Tab Control
Create a Streamlit Web App with Chat Controls
Review of Snowflake Metadata
App #4: Interactive Data Analysis with ChatGPT Bot Agent
Introduction to Interactive Data Analysis
Get Public Datasets from Snowflake Marketplace
Extract Metadata for Snowflake Objects
Custom Data Analysis using Natural Language
Create a Generic ChatGPT Bot
Create a Data Analysis ChatGPT Bot Inspector
Review of Interactive Data Analysis
App #5: Instant Charts with the Advanced Data Analysis Plugin
Introduction to Generated Data Analysis
Create Tables with the Regular ChatGPT Subscription
Exploratory Data Analysis with the ChatGPT Plus Subscription
Generate Charts and Graphs for Data Analysis
Generate Cluster Analysis (as a Data Science Experiment)
Review of Generated Data Analysis
App #6: Generate a Usage Monitoring Dashboard for Snowflake Account
Introduction to Usage Monitoring Dashboards
Extract Usage Queries and Charts with ChatGPT
Dashboard as a Streamlit Web App on a Single Page
Tab-Based Dashboard as a Streamlit Web App
Dashboard as a Multi-Page Streamlit Web App
Review of Usage Monitoring Dashboards
App #7: Data Enrichment with an External Integration of ChatGPT
Introduction to calling ChatGPT from within Snowflake
Call ChatGPT through the OpenAI REST API
Snowflake Function with External Access Integration
Create a Simple Streamlit in Snowflake App calling ChatGPT
Snowflake External Functions for API and Lambda (Obsolete)
Review of calling ChatGPT from within Snowflake
App #8: ChatGPT with LlamaIndex on Personal Documents
Introduction to LlamaIndex and RAG
Collect Personal and Custom Content
Create a Knowledge Base with LlamaIndex
Query ChatGPT with the Indexed Custom Content
Review of LlamaIndex and RAG
App #9: ChatGPT SQL Generator with LangChain
Introduction to LangChain SQL Generation
Create & Run a Jupyter Notebook with LangChain
Implement a SQL Generator as a Local Streamlit Web App
Deploy the SQL Generator in the Streamlit Community Cloud
Review of LangChain SQL Generation
App #10: Snowflake Query Analyzer and Optimizer
Introduction to Query Analysis and Performance Optimization
Experiment Interactively in VSCode
Create a Query Analyzer as a Local Streamlit Web App
Create a Query Analyzer as a Streamlit App calling a UDF
Review of Query Analysis and Performance Optimization
Conclusion
System Architectures
Final Thoughts
Test Your Knowledge
Congratulations, You Made It!