Metabase Athena Policy

policy.json

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "VisualEditor0",
            "Effect": "Allow",
            "Action": [
                "athena:StartQueryExecution",
                "athena:ListDataCatalogs",
                "glue:GetTableVersions",
                "glue:GetPartitions",
                "athena:GetQueryResults",
                "athena:ListWorkGroups",
                "athena:DeletePreparedStatement",
                "athena:GetNamedQuery",
                "athena:ListQueryExecutions",
                "athena:GetWorkGroup",
                "glue:GetTableVersion",
                "athena:StopQueryExecution",
                "athena:CreatePreparedStatement",
                "athena:GetQueryResultsStream",
                "glue:GetTables",
                "glue:BatchGetPartition",
                "glue:GetDatabases",
                "athena:GetPreparedStatement",
                "athena:ListTagsForResource",
                "glue:GetTable",
                "athena:ListNamedQueries",
                "glue:GetDatabase",
                "glue:GetPartition",
                "athena:ListDatabases",
                "athena:GetQueryExecution",
                "athena:BatchGetNamedQuery",
                "athena:ListTableMetadata",
                "athena:BatchGetQueryExecution"
            ],
            "Resource": "*"
        },
        {
            "Sid": "VisualEditor1",
            "Effect": "Allow",
            "Action": [
                "s3:GetObject",
                "s3:ListBucket",
                "s3:GetBucketLocation"
            ],
            "Resource": [
                "arn:aws:s3:::x-athena-queries",
                "arn:aws:s3:::x-athena-queries/*"
            ]
        },
        {
            "Sid": "VisualEditor2",
            "Effect": "Allow",
            "Action": [
                "s3:PutObject",
                "s3:GetObject",
                "s3:AbortMultipartUpload",
                "s3:ListBucket",
                "s3:GetBucketLocation"
            ],
            "Resource": [
                "arn:aws:s3:::x-athena-queries",
                "arn:aws:s3:::x-athena-queries/*"
            ]
        },
        {
            "Sid": "VisualEditor3",
            "Effect": "Allow",
            "Action": [
                "s3:GetObject",
                "s3:ListBucket",
                "s3:GetBucketLocation"
            ],
            "Resource": [
                "arn:aws:s3:::x-ads-events/*",
                "arn:aws:s3:::x-ads-events"
            ]
        }
    ]
}