I have a SQL script that works fine in Teradata SQL assistant, but when I try in bring it into Tableau custom SQL connection, I get a "All expressions in a derived table must have an explicit name" error. I *think* this has something to do with the FROM clause, but my chops are not good enough to be sure. Any help is greatly appreciated.
Try assigning alias names to the first column in your SELECT statement...
EXTRACT(MONTH FROM b.date_application_received) || '_' || EXTRACT(YEAR FROM b.date_application_received) as month_year,