Unable to select Count(Distinct) in the Query Builder (4246419)

When  connecting to  a Teradata database with ODBC, in the Query Builder it's not possible to select Count(Distinct) from a table, using the 'Aggregate Function' dropdown.

This is due to the connection being made with ODBC rather than native.

With an ODBC connection, the count(distinct) option will not show here because ODBC is generic across many database types. Where one database will allow count(distinct), another one may not.

WORKAROUND:
Manually amend the query script to include Select Count(Distinct)

STATUS:
Enhancement request ER 66863 has been submitted to Development for consideration in a future release of Toad for Data Analysts.