🚀 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
На этой странице сайта вы можете посмотреть видео онлайн How to integrate api data using python & dlt | API | Data Load Tool | ETL | Python | Postgres длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь BI Insights Inc 25 Июнь 2024, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 4,092 раз и оно понравилось 82 зрителям. Приятного просмотра!