Build a DATA LOADER on Streamlit for Snowflake in ONLY 5 minutes
Channel: Better Presales with Sasha
Date: 2023-04-06

Crafting a User-Friendly Snowflake Data Loader App in ONLY 5 minutes🚀 | Ultimate Streamlit Guide!

In this video I’ve built a basic data loader app for Snowflake using Streamlit, that everyone immediately understands and is able to use. 

It took me only 5 minutes and exactly 20 lines of code to build this app. Then, I spent another 15 minutes providing meaningful information about the loaded data, so a business user can decide on the data quality with just a quick glance.

Embark on a journey of data empowerment as I dive into an extraordinary task: creating a Snowflake data loader app that even non-tech-savvy folks, the 'grandmas' of business users, can navigate. In this video, I take up the challenge to build a drag-and-drop data loader for Snowflake using Streamlit, all in a mere five minutes! Join me on this whirlwind adventure and uncover how to seamlessly create a user-friendly data loader app that bridges the gap between the technical and the non-technical.

🔥 Highlights of the Tutorial:
- Learn how to build a Python environment for Streamlit with the right packages for a smooth development experience.
- Effortlessly connect to Snowflake from Streamlit using secure credentials and establish a strong data foundation.
- Craft a sleek drag-and-drop UI in Streamlit for CSV files, making data loading a breeze.
- Explore the power of Pandas data frames for processing and loading data into Snowflake effortlessly.
- Empower business users to analyze data seamlessly with their preferred BI tools, like Tableau.

📚 In the video description, find a link to the GitHub repository for the complete code and installation instructions.

Whether you're a data enthusiast, analyst, or business user, this tutorial equips you with the tools to simplify data loading and drive insightful analysis. Say goodbye to complex SQL queries and hello to a user-friendly data loader that anyone can master. Don't forget to hit that thumbs-up button and subscribe to the channel for more exciting tutorials and data adventures.

Stay curious, stay data-driven, and stay tuned for more empowering content! 💼📊📈"

You’ll find the code for this app and instructions on how to install and use it in this GitHub repo:
https://github.com/sashamitrovich/snowshovel

Connect with me on LinkedIn to continue this conversation:
https://www.linkedin.com/in/sashamitrovich/

MY GEAR:
iPhone 13 Pro https://amzn.to/3Clj8kP 
Sony Alpha ZV-E10L https://amzn.to/3NnNb1m 
Canon D77 https://amzn.to/3X0tRue
Sigma 16mm F1,4 DC DN Contemporary https://amzn.to/43ULspY 
Canon EF 50mm F1.8 STM https://amzn.to/43wRBc4 
SYNCO Lavalier https://amzn.to/42DJl8G 
Rode VidMic Go https://amzn.to/3Pc0mUF 
RØDE Wireless Go II https://amzn.to/3qDYUQF 
Sony ECM-W2BT Wireless https://amzn.to/45RWSfX 
14” MacBook Pro https://amzn.to/3N3FMmq

Explore this topic further by watching my other videos:

A REAL Day in the Life of a Sales Engineer (Working From Home) | Sales Engineering
https://youtu.be/TdnzbTv4lFc

Stuck learning Python? Make it fun with Streamlit!
https://youtu.be/1qTQWATaywI

How to LAND a TECH JOB in 2023 (Hint: not by sending out job applications)👩🏾‍💻 🧑🏻‍💻 📈
https://youtu.be/pNTukdxCVvU

#dataengineering #datascience #snowflake
00:00 Why build a data loader app for Snowflake?
00:29 What you'll see in this video
00:40 About me
00:55 What a business user wants
01:21 Steps to build this app
01:41 Keep wathcing for bonus content!
01:54 Create a virtual Python environment
02:26 Connect to Snowflake
02:41 Create a simple drag&drop 
03:12 Win a beverage of your choice!
04:49 Showcase the app (+Tableau!)
05:07 Bonus: add data quality checks on load
05:53 Summary: what we build in 5 minutes
06:07 Find the app on the GitHub repository