{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/4d63de8f8b744971a0e18f3dd246ec90\" frameborder=\"0\" width=\"2218\" height=\"1663\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1663,"width":2218,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1663,"thumbnail_width":2218,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/4d63de8f8b744971a0e18f3dd246ec90-d166d1ab0e318202.gif","duration":127.7097,"title":"AETL - SQL Before and After","description":"In this video, I demonstrate a special scenario in AETL where we run SQL statements before and after writing to a SQL database. I explain how to update our employee master data daily by truncating the existing data without any comparisons. Additionally, I show how to update employee codes in JSON format using a function. Please take a look at the execution log to see that everything was successful. I would appreciate your feedback on this process."}