The SQL produced for Athena uses the wrong SQL syntax - it needs to use coalesce not ifnull
SELECT MIN(CHAR_LENGTH("last outcome category")) FROM "datalake"."fact_crimes" WHERE ("last outcome category" IS NOT NULL ) AND (TRIM(IFNULL("last outcome category",'NULL TALEND')) <> '' )
I tried to raise a jira, but I don't have an account and can't see where to register for one?
Other than that, the SQL in the DQ tool all works so this would be a pretty minor tweak to be able to add some significant support! Once you have Athena you (by definition) also have presto too.
PS: Blog coming soon on this!
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to enable Data Governance
Take a peek at the definitive guide to Government Data Quality