How to integrate api data using python & dlt | API | Data Load Tool | ETL | Python | Postgres
🚀 Extract, Transform, Load (ETL) like a pro! using dlt.
In this video we load data from an Exchange Rate API into our Postgres database using Python and dlt! We extract the data from the API, transform it to fit our schema, and load it into our database using dlt pipeline.
We can get the data ready in minutes for analysis and visualization. Python and dlt combination makes this process a breeze. You can install and configure Postgres and dlt using the following vidoes:
Postgres installation video: • How to install PostgreSQL on windows | cr...
dlt tool installation: • how to build data pipelines with data load...
ExchangeRate API: https://www.exchangerate-api.com/
Link to GitHub repo: https://github.com/hnawaz007/pythonda...
#ETL #DataLoadTool #Postgres
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/
-----------------------------------------
Topics in this video (click to jump around):
==================================
0:00 - Introduction to API Data Pipeline
0:37 - FX Rate API Overview
1:05 - Prerequisites
1:23 - ETL Code
1:40 - Extract Data
1:57 - Tramsform Data
2:37 - Load Data
3:17 - Run the dlt pipeline
3:23 - Test pipelines results