I think this blog is helpful for your use case. It use Amazon Data Firehose to help you maintain fresh, analytics-ready data in data lake without implementing complex ETL processes or managing infrastructure.
Near Real-Time Database Replication to Apache Iceberg Table on S3 Using Amazon Data Firehose