ShaunRyan1
New Contributor II

Hi.

From the docs

The JDBC table that should be read. Note that anything that is valid in a
FROM
clause of a SQL query can be used. For example, instead of a full table you could also use a subquery in parentheses.

So has to be a subquery or alternatively you can use table functions and to achieve the same as a stored procedure.