Handling TYPE_NOT_FOUND: Unknown type: row

According to the documentation[1][2], can you try manually specifying the lambda function name and database name, and see if it works?

For example: SELECT * FROM "lambda:<lambda name>".<database_name>.<table_name> LIMIT 10

If the issue persists, I'd recommend to open a support ticket with AWS Athena support, so that we can look into more detailed logs from Athena and relevant lambda connector logs to continue troubleshoot.

Ref: [1] https://catalog.us-east-1.prod.workshops.aws/workshops/464d6c17-9faa-4fef-ac9f-dd49610174d3/en-US/change-streams/querydocdbwithathena [2] https://docs.aws.amazon.com/athena/latest/ug/connectors-docdb.html