-
This answer seems to be incorrect. According to Amazon PG tables exclusively reside on the leader node. In fact, the query specified in this question should not result in an error and is even the EXACT query used in the Redshift documentation showing that it works, and that both the PG table, along with current_schema() are both in fact run on the leader node. see this reference: https://docs.aws.amazon.com/redshift/latest/dg/c_sql-functions-leader-node.html
