Ok, So I resolved this by deleting the policies and letting Quicksight recreate them. Now I can’t write to the spill bucket with the lambda.
| region: | ap-southeast-2 |
|---|---|
| timestamp: | 1726178800881 |
| requestId: | 111a8e4e-049f-4fb5-ba0b-2648974b2ee1 |
| sourceErrorCode: | 100071 |
| sourceErrorMessage: | [Simba]AthenaJDBC An error has been thrown from the AWS Athena client. GENERIC_USER_ERROR: Encountered an exception[java.lang.NullPointerException] from your LambdaFunction[arn:aws:lambda:ap-southeast-2:819603067923:function:dynamodbconnector] executed in context[S3SpillLocation{bucket=‘athena-spill-bucket-pr’, key=‘athena-spill/e1a16518-127d-4d3b-85db-c75bee602257/76eef42d-b349-478e-baac-28bdd8de61fd’, directory=true}] with message[java.lang.NullPointerException] [Execution ID: e1a16518-127d-4d3b-85db-c75bee602257] |
| sourceErrorState: | HY000 |
| sourceException: | java.sql.SQLException |
| sourceType: | ATHENA |