Snowflake Integrations with ChatGPT - 2024 Hands-On!

Focused View

Cristian Scutaru

4:54:40

25 View

1. Introduction

1. Promo Clip.mp4

02:31

2. Quick Presentation of the 10 Integrations.mp4

08:05

3.1 GitHub Repository for this Course.html

3.2 My Medium Blog.html

3.3 Snowflake-ChatGPT-All-Slides.pdf

3. Best Ways to Benefit from this Course.mp4

02:45

2. App #1 Configure ChatGPT as a Coding Assistant for Snowflake in VSCode

1. Introduction to Snowflake and ChatGPT.mp4

01:15

2.1 GitHub repository with all demo source code for this course.html

2. Configure VSCode for our GitHub Project.mp4

04:48

3. Create a Free Trial Snowflake Account.mp4

10:27

4. Create ChatGPT API and ChatGPT Plus Accounts.mp4

03:56

5. Install Snowflake and ChatGPT VSCode Plugins.mp4

06:07

6.1 ChatGPT AI Genie VSCode Plugin.html

6.2 ChatGPT Chat Completions API.html

6.3 ChatGPT Playground.html

6.4 How I Won Singapore’s GPT-4 Prompt Engineering Competition (restricted).html

6.5 Snowflake Free Trial Account.html

6.6 Snowflake in a Nutshell ChatGPT.html

6. Review of Snowflake and ChatGPT.mp4

10:48

3. App #2 Generate Snowflake Sample Databases with ChatGPT from VSCode

1. Introduction to Snowflake Sample Data.mp4

01:19

2. Generate and Run Sample DDL Script.mp4

01:45

3. Generate Fake but Realistic Data in Python.mp4

04:36

4. Generate Synthetic Data in SQL.mp4

03:11

5. Generate and Run Python Code for Web Data Scraping.mp4

02:57

6. Generate SQL Queries for Specific Tables.mp4

01:42

7.1 ChatGPT The Key to Effortless Web Scraping (restricted).html

7.2 Collaborating with ChatGPT to generate a data warehouse.html

7.3 Generating Realistic Synthetic Data with ChatGPT.html

7.4 How to Use ChatGPT for Web Scraping in 2024.html

7.5 I Found a Loophole to (Successfully) Web Scrape Using ChatGPT. Here’s How it Works (restricted).html

7. Review of Snowflake Sample Data.mp4

03:27

4. App #3 Snowflake Metadata Inspector in Natural Language

1. Introduction to Snowflake Metadata.mp4

01:35

2. Create a Simple Q&A Interface with ChatGPT.mp4

11:27

3. Generate and Run Metadata Queries.mp4

04:30

4. Create a Streamlit Web App with Tab Control.mp4

06:22

5. Create a Streamlit Web App with Chat Controls.mp4

05:26

6.1 Building An LLM-Powered Chat Interface In Snowflake Using Snowsight And Streamlit.html

6. Review of Snowflake Metadata.mp4

05:26

5. App #4 Interactive Data Analysis with ChatGPT Bot Agent

1. Introduction to Interactive Data Analysis.mp4

00:50

2. Get Public Datasets from Snowflake Marketplace.mp4

02:46

3. Extract Metadata for Snowflake Objects.mp4

05:03

4. Custom Data Analysis using Natural Language.mp4

05:23

5. Create a Generic ChatGPT Bot.mp4

03:46

6. Create a Data Analysis ChatGPT Bot Inspector.mp4

03:54

7.1 Frosty Build an LLM Chatbot in Streamlit on your Snowflake Data (quickstart).html

7.2 How to Talk to Your Data with ChatGPT, Snowflake, & dbt.html

7. Review of Interactive Data Analysis.mp4

03:33

6. App #5 Instant Charts with the Advanced Data Analysis Plugin

1. Introduction to Generated Data Analysis.mp4

01:36

2. Create Tables with the Regular ChatGPT Subscription.mp4

02:29

3. Exploratory Data Analysis with the ChatGPT Plus Subscription.mp4

06:45

4. Generate Charts and Graphs for Data Analysis.mp4

03:31

5. Generate Cluster Analysis (as a Data Science Experiment).mp4

03:55

6.1 How to use ChatGPT to make charts and tables.html

6.2 The Power of ChatGPT Code Interpreter Creating Data Visualizations Without Writing a Single Line of Code.html

6.3 Ways to Use ChatGPTs Data-Analysis Tool.html

6. Review of Generated Data Analysis.mp4

04:04

7. App #6 Generate a Usage Monitoring Dashboard for Snowflake Account

1. Introduction to Usage Monitoring Dashboards.mp4

01:08

2. Extract Usage Queries and Charts with ChatGPT.mp4

08:44

3. Dashboard as a Streamlit Web App on a Single Page.mp4

05:32

4. Tab-Based Dashboard as a Streamlit Web App.mp4

02:14

5. Dashboard as a Multi-Page Streamlit Web App.mp4

05:42

6.1 Monitoring Snowflake with Snowsight.html

6. Review of Usage Monitoring Dashboards.mp4

04:34

8. App #7 Data Enrichment with an External Integration of ChatGPT

1. Introduction to calling ChatGPT from within Snowflake.mp4

02:09

2. Call ChatGPT through the OpenAI REST API.mp4

04:42

3. Snowflake Function with External Access Integration.mp4

07:02

4. Create a Simple Streamlit in Snowflake App calling ChatGPT.mp4

02:10

5. Snowflake External Functions for API and Lambda (Obsolete).mp4

05:31

6.1 External access integration in practice 2 — calling OpenAI APIs (restricted).html

6.2 Getting Started with Generative AI in Snowflake and Streamlit (quickstart).html

6.3 Quick Tutorial How to call ChatGPT API Directly From Snowflake.html

6.4 Snowflake + ChatGPT Experience the Power of ChatGPT & GPT-4 in Snowflake DemoHub.Dev.html

6.5 Unlocking The Power Of OpenAI In Snowflake.html

6.6 Using Snowflake External Function to call OpenAI API (restricted).html

6. Review of calling ChatGPT from within Snowflake.mp4

08:21

9. App #8 ChatGPT with LlamaIndex on Personal Documents

1. Introduction to LlamaIndex and RAG.mp4

01:31

2. Collect Personal and Custom Content.mp4

05:36

3. Create a Knowledge Base with LlamaIndex.mp4

03:06

4. Query ChatGPT with the Indexed Custom Content.mp4

04:26

5.1 Announcing Streamlit for Snowflake My First Video Course on Udemy!.html

5.2 Build a Retrieval Augmented Generation(RAG) based LLM assistant using Streamlit, OpenAI and LlamaIndex (quickstart).html

5. Review of LlamaIndex and RAG.mp4

04:50

10. App #9 ChatGPT SQL Generator with LangChain

1. Introduction to LangChain SQL Generation.mp4

01:55

2. Create & Run a Jupyter Notebook with LangChain.mp4

07:51

3. Implement a SQL Generator as a Local Streamlit Web App.mp4

04:12

4. Deploy the SQL Generator in the Streamlit Community Cloud.mp4

06:26

5.1 Build your First SQL Database Agent with LangChain.html

5.2 Sample Data TPC-H.html

5.3 Snowflake + LangChain Generating SQL Queries from Natural Language Questions.html

5. Review of LangChain SQL Generation.mp4

04:40

11. App #10 Snowflake Query Analyzer and Optimizer

1. Introduction to Query Analysis and Performance Optimization.mp4

00:58

2. Experiment Interactively in VSCode.mp4

06:10

3. Create a Query Analyzer as a Local Streamlit Web App.mp4

06:07

4. Create a Query Analyzer as a Streamlit App calling a UDF.mp4

04:34

5.1 Sample Data TPC-H.html

5.2 Who here is using ChatGPT to help with SQL code.html

5. Review of Query Analysis and Performance Optimization.mp4

04:19

12. Conclusion

1. System Architectures.mp4

11:11

2. Final Thoughts.mp4

06:17

3. Test Your Knowledge.html

4. Congratulations, You Made It!.mp4

00:42

Description

Design and Implement Snowflake Data Applications with ChatGPT 4

What You'll 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

Who is this for?

Data Engineers willing to learn how to integrate Snowflake with ChatGPT

Software Developers looking at Snowflake and ChatGPT integrations

Data Architects willing to know about all ChatGPT-to-Snowflake configurations

Data Scientists looking for an overview of different ChatGPT-to-Snowflake architectures

Technical Managers who need an overview of possible integrations of Snowflake with ChatGPT

What You Need to Know?

Basic knowledge of Snowflake and Streamlit

Basic knowledge of SQL and Python

No prior knowledge of ChatGPT or OpenAI API required

More details

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! ==
Who this course is for:
Data Engineers willing to learn how to integrate Snowflake with ChatGPT
Software Developers looking at Snowflake and ChatGPT integrations
Data Architects willing to know about all ChatGPT-to-Snowflake configurations
Data Scientists looking for an overview of different ChatGPT-to-Snowflake architectures
Technical Managers who need an overview of possible integrations of Snowflake with ChatGPT

User Reviews

Rating

average 0

Total votes0

Focused display

Certified Solutions Architect in AWS/Azure/Google Cloud (20 total exams). Former Snowflake “Data Superhero” and SnowPro Certification SME. Certified in many NoSQL stores: Cassandra/Redis/Couchbase/Neo4j/TigerGraph...Decades of practical experience in software design and implementation. Former Microsoft employee. Architect of the Data Xtractor Suite - with a visual SQL editor, data visualization charts, data modeling... Former assistant professor at the "Polytechnica" University of Bucharest.I live in beautiful Vancouver/Canada.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.