Deploying a Python Application in Snowflake Hands-On
What you'll learn
- How to properly deploy an application into the Snowflake AI Data Cloud in multiple ways.
- How to visualize the different building blocks of a data application.
- How to think in terms of system architecture, modularity and scalability, when building and deploying a data application.
- How to implement simple business logic in Python and get the code executed by the Snowflake SQL engine.
Requirements
- Basic Python programming skills
- Basic knowledge of SQL
- Some familiarity with the Snowflake platform
Description
This course will take one simple ETL/ELT piece of Python/SQL code and deploy it in over a dozen different ways, in Snowflake or connected to Snowflake. Each time describing the system architecture and the implications. On scalability, data protection and security, how close to the data the code runs.
Who this course is for
Python developers looking to extend their knowledge of Snowflake.
Aspiring Data Architects, with focus on Snowflake.
Solution Architects with a goal of understanding all sorts of Snowflake application development.
Data Engineers looking to move into Data Architecture.
Any technical person willing to better understand all sorts of architectures in Snowflake AI Data Cloud.
What you will learn
How to properly deploy an application into the Snowflake AI Data Cloud in multiple ways.
How to implement simple business logic in Python and get the code executed by the Snowflake SQL engine.
How to get from a simple Streamlit local web app to a complex Native App running in Snowflake Containers.
How to think in terms of system architecture, modularity and scalability, when building and deploying a data application.
How to visualize the different building blocks of a data application.
How to generate fake data with either built-in Snowflake functions or Python libraries.
What kind of architectures we'll present here
SQL Worksheets and Python Worksheets
Snowflake Connector for Python
Snowpark DataFrame API and Snowpark for stored procs
Pandas DataFrame API
Stored Procedures in Python and Execute as Caller
Jupyter Notebooks and Snowflake Notebooks
Streamlit Web Apps and Streamlit Community Cloud
Streamlit in Snowflake Applications
Secure Data Sharing
Snowflake Native Apps
Snowpark Container Services
VSCode Extensions for Snowflake and Jupyter
Who this course is for:
- Python developers looking to extend their knowledge of Snowflake.
- Aspiring Data Architects, with focus on Snowflake.
- Solution Architects with a goal of understanding all sorts of Snowflake application development.
- Data Engineers looking to move into Data Architecture.
- Any technical person willing to better understand all sorts of architectures in Snowflake AI Data Cloud.
Instructor
- 4.5 Instructor Rating
- 771 Reviews
- 17,445 Students
- 21 Courses
[English] In only half a year on Udemy, most of my video courses became best-sellers and highest rated.
World-class expert in Snowflake AI Data Cloud. Former Snowflake "Data Superhero" and SnowPro Certification SME (Subject Matter Expert). With eight SnowPro exams, all passed from the first attempt.
Over 40 proctored certification exams passed in the last 3-4 years alone, all from the first attempt. Dozens on certifications in AWS/Azure/GCP, in Data Science and Machine Learning.
Over three decades in the software industry, as a hands-on data and solutions architect, technical manager and team lead, software and data engineer. Successful entrepreneur and independent consultant. Former Microsoft employee (there is still code of mine in Microsoft SQL Server and Microsoft Windows).
---
[Français] En seulement six mois sur Udemy, la plupart de mes cours vidéo sont devenus des best-sellers et les mieux notés.
Expert de classe mondiale en Snowflake AI Data Cloud. Ancien "Super-Héro des Données" en Snowflake et SME (Subject Matter Expert) de la certification SnowPro. Avec huit examens SnowPro, tous réussis dès la première tentative.
Plus de 40 examens de certification passés au cours des 3-4 dernières années seulement, tous réussis dès la première tentative. Des dizaines de certifications en AWS/Azure/GCP, en science des données.
Plus de trois décennies dans l'industrie du logiciel, en tant qu'architecte de données et de solutions, directeur technique et chef d'équipe, ingénieur en logiciel et en données. Entrepreneur à succès et consultant indépendant. Ancien employé de Microsoft (j'ai encore du code dans Microsoft SQL Server et Microsoft Windows).
---
[Româna] În doar o jumătate de an pe Udemy, majoritatea cursurilor mele video au devenit best-seller-uri și cele mai bine cotate.
Expert de talie mondială în Snowflake AI Data Cloud. Fost Snowflake „Data Superhero” și expert recunoscut in certificările SnowPro.
Peste 40 de examene de certificare trecute doar în ultimii 3-4 ani, toate din prima încercare. Zeci pe certificări în AWS/Azure/GCP, în Data Science și Machine Learning.
Peste trei decenii în industria software, ca arhitect de date și soluții, manager tehnic și lider de echipă, inginer software și de date. Antreprenor de succes și consultant independent. Fost angajat Microsoft (există cod de-al meu încă în Microsoft SQL Server și Microsoft Windows).