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