Insert / Update / Delete on S3 With Amazon Athena and Apache Iceberg Tutorial

Dataset github.com/soumilshah1995/ath...
References :
• Insert / Update / Dele...
docs.aws.amazon.com/athena/la...
/ performing-insert-upda...

[@GiasoneP]

Repeat scenario: My manager tells me to use a tool that I’ve never used before… Search for it on RUclips… Oh wow, Soumil has a clear and succinct tutorial on this tool too 😂
Every time I want to learn anything in the DE space you are there for me. Thanks for all your work and effort.

[@SoumilShah]

Thanks man

[@user-el7qo3wf2k]

@@SoumilShah same for me.
i am fresher and working as DE-1 with no senior DE and just has to report to CTO, he just tell me the tool, i come to youtube and if you have video on that, then i feel little relax.😆

[@LMGaming0]

Let's say I want to keep my data lake updated every hour, do I need to do a insert into from an hourly table to keep my iceberg updated or is there any better approaches?

[@rajbhushan2687]

That doesn't change the original table right? i have to use that iceberg table if i need updated data?

[@tieduprightnowprcls]

I failed to create nested y/m/d partition for iceberg table in Athena, how to accomplish this?

[@denisa.637]

How big is this test table? Why is it taking so long to delete one record? I noticed it took 4-8 seconds...

[@ch.nageswararao2071]

How to drop or delete entire column in a existing table by using Athena editor?

[@nitinshah1034]

Great