video1.0<iframe src="https://www.loom.com/embed/ffdd725445c541d5932f75fe6ce4a69a" frameborder="0" width="1310" height="982" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>9821310Loomhttps://www.loom.com9821310https://cdn.loom.com/sessions/thumbnails/ffdd725445c541d5932f75fe6ce4a69a-03f06dcc7cd2ecbe.gif222.4454In this video, I explain how we retrieve data from various EHR providers, highlighting the differences in file sizes and complexities. I discuss the use of multi-threading and resource URL checkpointing, particularly for eClinicalWorks, which handles many small files. I also touch on the importance of ensuring data freshness by merging and querying unprocessed rows. Please take note of the specifications for each EHR provider, as they can vary significantly. I would appreciate your feedback on this process.