{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/ab906165ff08458a8dd7a31e7ebb2012\" frameborder=\"0\" width=\"1114\" height=\"835\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":835,"width":1114,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":835,"thumbnail_width":1114,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/ab906165ff08458a8dd7a31e7ebb2012-fe65cfb13fc0c1ad.gif","duration":187.516,"title":"Clinical Trial ETL Pipeline and Open Alex Integration Overview 🚀","description":"Hey everyone, in this video, I walk you through my project on the clinical trial ETL pipeline and the API for Open Alex integration. I successfully ingested half a million clinical trials with zero errors in about 5.9 minutes using Docker, while the live ingestion process took around 30-35 minutes on Render. I also share details about the architecture, daily cron jobs for fetching updated records, and the seven live API endpoints available for Open Alex. Please check out the GitHub links for the live API and let me know if you have any questions or feedback!"}