Pushdown optimization stops at the Source Qualifier transformation <transformation name> because SQL override is specified for some but not all partitions.
When you configure a session that contains an SQL override for pushdown optimization, you must configure the SQL override for all partitions in the session.
Configure an SQL override for all partitions in the session.