You can’t actually select from a table within a Redshift function. From the documentation:

SQL_clause
A SQL SELECT clause.
The SELECT clause can’t include any of the following types of clauses:

• FROM
• INTO
• WHERE
• GROUP BY
• ORDER BY
• LIMIT

Seriously… how useful is that?