Pushdown optimization stops at Source Qualifier transformation <transformation name> because it contains an SQL override, and view creation is not enabled.
You configured a session that contains an SQL override for pushdown optimization, but you did not configure the session to create a view.
When you configure the session containing an SQL override for pushdown optimization, ensure that you configure the session to create a view. You configure this setting on the Properties tab of the session properties.