drops not needed; using create or replace in the perspectives.