reecestart

SELECT a.aws_account_id, a.name, a.description, a.refreshed, a.status
FROM
    athenatableforcsvs AS a
INNER JOIN
    athenatableforcsvs AS b
        ON a.aws_account_id = b.aws_account_id AND a.description = b.description
WHERE
    a.status <> b.status
GROUP BY a.aws_account_id, a.name, a.description, a.refreshed, a.status
ORDER BY 1, 2, 3, 4, 5;

reecestart

CREATE EXTERNAL TABLE IF NOT EXISTS athenadatabaseforcsvs.athenatableforcsvs (
  aws_account_id string,
  name string,
  email string,
  status string,
  category string,
  description string,
  refreshed string,
  processed string,
  flagged string,