<?xml version="1.0" encoding="UTF-8"?><oembed><type>video</type><version>1.0</version><html>&lt;iframe src=&quot;https://www.loom.com/embed/cf82e6a7ab824d8dbd572d9371ccf6dc&quot; frameborder=&quot;0&quot; width=&quot;1280&quot; height=&quot;960&quot; webkitallowfullscreen mozallowfullscreen allowfullscreen&gt;&lt;/iframe&gt;</html><height>960</height><width>1280</width><provider_name>Loom</provider_name><provider_url>https://www.loom.com</provider_url><thumbnail_height>960</thumbnail_height><thumbnail_width>1280</thumbnail_width><thumbnail_url>https://cdn.loom.com/sessions/thumbnails/cf82e6a7ab824d8dbd572d9371ccf6dc-1692117390401.gif</thumbnail_url><duration>300.16666666666686</duration><title>Investigating a Failing DBT Test Part 3: Confirm the nature of the problem</title><description>In this video, I analyze the issue of duplicate data in Air Table records. By examining the source record ID and URL, I confirm that the duplicates are caused by individual feeds pointing to multiple records. I also discover variations in the source record ID, some being null and others having different values. To understand the scale of the issue, I observe that most of the duplicates are from 2022, indicating that it is historical data. This suggests that it is not a recurring bug but rather a data handling challenge. I also explore the prevalence of the issue by checking the number of implicated feeds. Overall, this investigation helps us understand the nature and scope of the duplicate data problem.</description></oembed>