☕️ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲:
To support the channel and encourage new videos, please consider buying me a coffee here:
https://ko-fi.com/bugbytes
Top Data Engineer Courses:
📊 Data Engineer in Python - https://datacamp.pxf.io/jeZX5v
⭐ Top resource to learn Python - https://datacamp.pxf.io/kOjKkV ⭐
In this video, we'll look at connecting to and querying Snowflake from Django and FastAPI applications. Snowflake is a data warehouse solution designed for storage of large volumes of analytical data. We'll look at querying with the Django ORM, and with the Snowflake Python connector, as well as integrating Pydantic and FastAPI dependencies.
📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
00:00 Intro
00:48 Snowflake Database
01:12 Setting up Django-snowflake
03:48 Loading Snowflake password with Django-environ
06:35 Querying database with Django ORM
08:07 Connecting Django to existing Snowflake warehouse with inspectdb command
09:31 FastAPI and Snowflake integration
11:29 Loading Snowflake password with python-dotenv
12:20 Querying Snowflake from FastAPI route
14:49 Modelling table data with Pydantic Model
16:12 Creating FastAPI dependency for Snowflake connection
𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:
📖 Blog: https://bugbytes.io/posts/
👾 Github: https://github.com/bugbytes-io/
📚 𝗙𝘂𝗿𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗶𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻:
Snowflake Connector for Python: https://docs.snowflake.com/en/develop...
FastAPI Dependency: https://fastapi.tiangolo.com/tutorial...
#python #dataengineering #datascience #data
