Heroku aggregated data view from the Multi-org visibility for Work.com blog post

heroku_aggregated_data_view.sql

CREATE OR REPLACE VIEW global_assessment as
SELECT employeecrisisassessment.sfid AS id, 
employeecrisisassessment.assessment,
employeecrisisassessment.assessmentdate, 
employee.lastname, employee.firstname, 
'geo designation' AS geo 
FROM <schema name>.employeecrisisassessment, <schema name>.employee   
WHERE employeecrisisassessment.employeeid = employee.sfid
UNION [repeated select for each of our other schemas];