Does the constituent query view from the datawarehouse have site security in place?
Yes, the query view will not show users constituent records that they do not have access to via the datawarehouse query view. However if the user (who is non-admin) has the "Run queries as admin" feature permission enabled in their role then they will be able to view the records just not open them.
Steps to Duplicate
1. Log in to CRM with a user that has site security attached to their role 2. Create Ad-Hoc Query based on constituent query view 3. Search for a constituent that different site security applied to their record 4. Notice no results are found, with the exception if the user searching has the "Run queries as admin" feature permission enabled on their role