Streamlit for Snowflake
Happy New Year, and it’s with a great pleasure that I announce the launch of my first video course about Snowflake:
Check here my current best price on all video courses and practice tests.
There is always a 30-day money back guarantee, but I truly believe the almost 9 hours of detailed free open-sourced video experiments will justify their value.
The course has four main sections, described here below. Scroll down at the end of this post, to watch the promo video…
(1) Testing Local Streamlit Web Apps
This first section is an end-to-end bootcamp on Streamlit!
All applications will be deployed and tested as local Streamlit web apps. I’ll focus on the front-end architecture and walk over all possible Streamlit controls and components you need to know about, including data caching and the session state.
I’ll teach everything anyone needs to know to be able to design and implement rapid simple data-driver applications, regardless of Snowflake or any other database.
(2) Sharing Streamlit Web Apps in Streamlit Cloud
Learn how to deploy and share local Streamlit web apps in the Streamlit Community Cloud.
I’ll show genuine ways to protect your private or pubic apps, and come-up with other generic examples.
No connection to Snowflake yet, but we’ll continue to expand and deploy an exciting Hierarchical Data Viewer app on CSV tabular data, that will contain most elements of any data-driven application.
(3) Connecting Streamlit Apps to Snowflake
I’ll introduce the different ways you can connect from Streamlit to Snowflake, including several specific examples on using each API:
- SnowSQL — with SQL script execution.
- Snowflake Connector for Python — with typical client applications.
- Snowpark for Python — with DataFrame API and stored proc decorators.
- Streamlit Connector for Snowflake — with secrets and login forms.
I’ll introduce genuine ways to extend Snowflake’s functionality, transforming its metadata into better visualizations. I’ll walk through data science applications from quick-starts, generating on-the-fly stored procedures and UDFs with Snowpark, for model training and serving. I’ll end-up with a funny ChatGPT integration as an agent generating SQL queries upon natural language instructions.
(4) Deploying Streamlit Apps to Snowflake
We’ll focus on the two major brand new and revolutionary frameworks in Snowflake, deploying several Streamlit apps in each of them:
- Streamlit in Snowflake Apps — in your Snowflake account.
- Snowflake Native Apps — shared with other Snowflake accounts.
I’ll go in depth into each of these frameworks, showing how you can automate the deployment process, grant privileges, protect your code and data, and solve other potential problems.
I will deploy data and metadata-based applications with both Streamlit and Snowflake as both Streamlit Apps, then Native Apps. I will enrich data using external Internet services. I’ll use a free open-source native app from the Marketplace and warn you about potential misuse.
My Promo Video
Check other free videos shared from my course on YouTube.
Check here my current best price on all video courses and practice tests.
