Streamlit for Snowflake Masterclass 2024 Hands-On!

Focused View

Cristian Scutaru

8:34:33

5 View

1 - Introduction

1 - Course Structure and Content.mp4

02:07

2 - Best Ways to Benefit from this Course.mp4

02:57

3 - All Slides and Resources.mp4

01:26

3 - GitHub Repository for the Live Experiments from this Course.txt

3 - GitHub Repository for this Course.txt

3 - My Medium Blog on Snowflake published as well on the DSH blog.txt

3 - Snowflake Quick Starts on Streamlit.txt

3 - Streamlit-for-Snowflake.pdf

2 - Testing Local Streamlit Web Apps

5 - Introduction and Section Summary.mp4

03:05

6 - Build a Simple Hierarchical Data Viewer in Python.mp4

11:01

7 - Convert the Hierarchical Data Viewer to a Streamlit Web App.mp4

12:17

8 - Hierarchical Data Charts in Streamlit with Plotly.mp4

16:01

9 - Streamlit Layout Components.mp4

12:12

10 - Add Hierarchical Formats and Animation.mp4

10:38

11 - Improve Original Data Viewer App and Make It More Generic.mp4

08:54

12 - Use Streamlit Input Controls.mp4

15:13

13 - Cache Data Between Page Reruns.mp4

13:10

14 - Save State Data Between Page Reruns.mp4

06:31

15 - Use Control Callbacks on Page Reruns.mp4

13:27

16 - Finalize the Hierarchical Data Viewer as a Streamlit Web App.mp4

10:51

3 - Sharing Streamlit Web Apps in Streamlit Cloud

18 - Deploy Your Local Web App to Streamlit Cloud.mp4

14:07

19 - Use Data Caching with a Generated Session ID.mp4

03:59

20 - Make App Private and Protect Public App Access.mp4

09:00

21 - Data Analysis of RealEstate Properties with a BI Streamlit App.mp4

07:09

22 - ML Object Detection with a CNN Data Science Streamlit App.mp4

09:16

4 - Connecting Streamlit Apps to Snowflake

23 - Introduction and Section Summary.mp4

02:38

24 - Upload Data into a New Snowflake Account through the Web UI.mp4

07:41

25 - Connect to Snowflake with SnowSQL CLI.mp4

11:06

26 - Connect to Snowflake with the Connector for Python.mp4

10:26

27 - Connect to Snowflake with Snowpark for Python.mp4

12:54

28 - Build a Complex Query with the Python Client and Snowpark.mp4

07:05

29 - Build a Complex Query with the Snowpark DataFrame API.mp4

18:55

30 - Push Python Code as a Stored Procedure with Snowpark.mp4

13:13

31 - Connect to Snowflake with Streamlit Connector in MultiPage App.mp4

14:21

32 - Connect the Hierarchical Data Viewer to Snowflake.mp4

11:05

33 - Enhance the Hierarchical Data Viewer with Recursive Queries.mp4

11:55

34 - Deploy the Connected Hierarchical Data Viewer to Streamlit Cloud.mp4

06:35

35 - Create a Hierarchical Metadata Viewer as a Streamlit MultiPage App.mp4

19:46

36 - Create an EntityRelationship Diagram Viewer with Streamlit.mp4

11:21

37 - Create a NLP Sentiment Analysis App with the IMDB Reviews.mp4

18:48

38 - Integrate Snowflake with ChatGPT.mp4

20:16

5 - Deploying Streamlit Apps to Snowflake

39 - Introduction and Section Summary.mp4

03:48

40 - Create and Deploy a Streamlit in Snowflake App.mp4

15:05

41 - Deploy the Hierarchical Data Viewer in Snowflake as a Streamlit App.mp4

07:16

42 - Deploy the Hierarchical Metadata Viewer in Snowflake as a Streamlit App.mp4

05:06

43 - Create a MultiPage Dashboard with VegaLite Charts as a Streamlit App.mp4

09:38

44 - Create a MultiPage Dashboard with Altair Charts as a Streamlit App.mp4

07:31

45 - Train a Linear Regression ML Model and Predict with UDF.mp4

15:38

46 - Deploy the Hierarchical Metadata Viewer as a Snowflake Native App.mp4

18:58

47 - Deploy the Hierarchical Data Viewer as a Snowflake Native App.mp4

13:38

48 - Review the Snowflake Native App Framework.mp4

06:23

49 - Enrich IP Address Data with a Snowflake Native App.mp4

18:32

50 - Install and Run a Free Snowflake Native App from the Marketplace.mp4

10:24

51 - Thank You and Goodbye.mp4

01:10

Description

by World-Class Snowflake Expert, former Data Superhero and SnowPro Certification SME

What You'll Learn?

Build, debug and deploy data-driven applications with Streamlit
Deploy Streamlit web apps into Snowflake, as Streamlit in Snowflake Apps
Share and deploy Streamlit web apps as Snowflake Native Apps
Deploy Python code with Snowpark as Snowflake stored procedures and UDFs
Connect to Snowflake from a Streamlit web application
Build real-life applications with Streamlit and Snowflake
Design and deploy to Snowflake data science, data analysis and ML apps with Streamlit
Process and access hierarchical data and metadata in Snowflake

Who is this for?

Data Engineers looking to improve their programming skills with data-driven applications

Data Scientists looking to learn fast prototyping with Streamlit

Software Developers looking to learn a rapid data application development framework

Snowflake Admins looking to master the new Streamlit App and Snowflake Native App frameworks

Data Architects looking to learn about deploying Snowflake Native Apps with Streamlit

Data Analysts looking to learn about using Streamlit to build instant dashboards

Any other technical person looking to learn about using Streamlit to build Snowflake connected applications

Machine Learning Engineers looking for data science projects in Snowflake

What You Need to Know?

Basic knowledge of SQL and relational databases

Basic knowledge of Python programming

No prior knowledge of Streamlit or Snowflake is expected

Basic knowledge of working with a version-control code repository such as GitHub

No prior knowledge of data science, data analytics or machine learning is expected

More details

Description
Why You Can Trust Me
I was the only Snowflake technical expert from Canada selected for their Data Superhero program in Jan 2022.
Former SnowPro Certification SME (Subject Matter Expert) - many exam questions have been created by me.
Passed four SnowPro certification exams to date (with no retakes): Core, Architect, Data Engineer, Data Analyst.
Dozens of other certifications in Data Science and Machine Learning, Cloud Solution Architectures, Databases, etc.
Dozens of apps designed and implemented with Streamlit and Snowflake on my blog on Medium.
Specialized in Snowflake for several years, I served dozens of clients and implemented many real-life projects.

What You Will Learn
How to create simple to complex web applications in Streamlit.
How to deploy for free local Streamlit web apps to the Streamlit Community Cloud.
How to connect to Snowflake from Streamlit apps, through either the Python Connector or a Snowpark session.
How to use the DataFrame API and push Python code as stored procedure with Snowpark.
How to extend Snowflake's capabilities, with a hierarchical data viewer and a hierarchical metadata viewer.
How to prototype with Streamlit apps data science, machine learning and data analysis scenarios.
How to deploy a Streamlit web app as a Streamlit in Snowflake App.
How to deploy a Streamlit web app as a Snowflake Native App.
How to use the Snowflake Native App Framework to build or use apps with Streamlit.
We'll build several apps in Python from scratch, we'll then convert them to local single or multi-page Streamlit web apps, deploy and share them on the Streamlit Community Cloud, deploy them in Snowflake as stored procs or Streamlit Apps, share them as Native Apps with other Snowflake accounts...

What Streamlit Areas You Will Learn About
Input and Output Controls (Interactive Widgets, Display Text controls, etc.).
Layout Components (sidebar, container, expander, tabs, etc.) and Forms.
Events and Page Reruns.
Data Caching, Session State and Callbacks.
Theming and Configuration, TOML Secrets.
First half of the course will be an end-to-end complete Streamlit bootcamp, with everything you need to know about Streamlit.

What Snowflake Areas You Will Learn About
Creating a free Snowflake account and using the Snowflake web UI at the basic level.
Connecting to Snowflake with SnowSQL, and executing SQL scripts with this command-line interface.
Connecting to Snowflake with the Snowflake Connector for Python.
Connecting to Snowflake with Snowpark for Python.
Using Snowpark to push Python code as stored procedures.
Using Snowpark to generate SQL queries with the DataFrame API.
Writing and deploying Streamlit in Snowflake Apps.
Writing and deploying Snowflake Native Apps, with the Snowflake Native App Framework.
Integrating Snowflake with ChatGPT, external dashboards, data science and machine learning libraries.
Second half of the course will be all about Snowflake client apps, Snowpark, Streamlit in Snowflake Apps and Native Apps.

What is NOT Included in This Course
In-depth knowledge of Snowflake.
In-depth data science, data analytics and machine learning.
Programming in languages other than Python and SQL.
Main focus will be on all sorts of applications in Python using Streamlit, to connect and deploy the code to Streamlit Cloud or Snowflake in all possible ways.

Real-Life Applications You Will Learn To Build
Hierarchical Data Viewer, for CSV files and Snowflake tabular data, using JSON, graphs, animations, recursive queries.
Hierarchical Metadata Viewer, for Snowflake object dependencies and data lineage.
Entity-Relationship Diagram Viewer for Snowflake.
Chatbot Agent with OpenAI's ChatGPT, used as a SQL query generator for Snowflake Marketplace datasets.
Dashboards for Snowflake data, with Vega-Lite, Altair and Plotly charts.
Machine Learning scenarios, with Model Training and Predictions.
Data enrichment of IP addresses using external free services.
I sold tools similar to many of these to real-life clients and Snowflake partners!

Enroll today, to keep this course forever!
Who this course is for:
Data Engineers looking to improve their programming skills with data-driven applications
Data Scientists looking to learn fast prototyping with Streamlit
Software Developers looking to learn a rapid data application development framework
Snowflake Admins looking to master the new Streamlit App and Snowflake Native App frameworks
Data Architects looking to learn about deploying Snowflake Native Apps with Streamlit
Data Analysts looking to learn about using Streamlit to build instant dashboards
Any other technical person looking to learn about using Streamlit to build Snowflake connected applications
Machine Learning Engineers looking for data science projects in Snowflake

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.