Your database generated a SQL exception. This can be caused by query timeouts, resource constraints, unexpected DDL alterations before or during a query, and other database errors. Check your database settings and your query, and try again.
sourceErrorCode: GENERIC_SQL_EXCEPTION
sourceErrorMessage:[Simba]AthenaJDBC An error has been thrown from the AWS Athena client. Unable to verify/create output bucket bucket-data-lake [Execution ID not available]
Below is an existing post but no solution/ workaround provided.
Error when connecting to Athena Data Source - Question & Answer - Amazon QuickSight Community