How to connect to Postgres using Python | Query SQL Database | Pandas | Postgres
In this video we are covering how to connect to Postgres databases using Python. This is a common question that comes up in the ETL series. So, I decided to cover it and direct viewers to it if they are facing connectivity issues.
There are few prerequisites for this. We need the Postgres database installed and configured. Link: • How to install PostgreSQL on windows...
We use a Jupyter notebook to troubleshoot the database connection. Link to Jupyter Notebook installation: • Install Jupyter Notebook on Windows |...
Python build elt pipeline vidoe: • How to build an ETL pipeline with Pyt...
Link to Python ETL series: https://hnawaz007.github.io/etl.html
In addition, we use the SQLAlchemy and psycopg2 libraries. We can install them using a pip command.
Create Schema and User SQL script: https://github.com/hnawaz007/pythonda...
Link to Channel's site:
https://hnawaz007.github.io/
--------------------------------------------------------------
💥Subscribe to our channel:
/ haqnawaz
📌 Links
-----------------------------------------
#️⃣ Follow me on social media! #️⃣
🔗 GitHub: https://github.com/hnawaz007
📸 Instagram: / bi_insights_inc
📝 LinkedIn: / haq-nawaz
🔗 / hnawaz100
🚀 https://hnawaz007.github.io/
-----------------------------------------
#ETL #python #postgres
Topics in this video (click to jump around):
==================================
0:00 - Introduction postgres connection
0:19 - Prerequisites
0:43 - Install required libraries
0:55 - Import libraries
1:09 - Configure Database Secrets
1:26 - Postgres Data Source Connection
2:16 - SQL Query
2:48 - Query Postgres using Pandas
On this page of the site you can watch the video online How to connect to Postgres using Python | Query SQL Database | Pandas | Postgres with a duration of hours minute second in good quality, which was uploaded by the user BI Insights Inc 07 April 2024, share the link with friends and acquaintances, this video has already been watched 1,413 times on youtube and it was liked by 29 viewers. Enjoy your viewing!
