 --Gets the column id for a census variable given a human readable version of it
 -- Old: OBS_LOOKUP_CENSUS_HUMAN
 
-CREATE OR REPLACE FUNCTION OBS_LookupCensusHuman(
+CREATE OR REPLACE FUNCTION cdb_observatory.OBS_LookupCensusHuman(
   column_names text[],
   -- TODO: change variable name table_name to table_id
   table_name text DEFAULT '"us.census.acs".extract_block_group_5yr_2013_69b156927c'

  column_ids as (
    select row_number() over () as no, a.column_id as column_id from (select unnest($2) as column_id) a
  )
 SELECT array_agg(ROW(colname, tablename, aggregate)::OBS_ColumnData order by column_ids.no)
 FROM column_ids, observatory.OBS_column c, observatory.OBS_column_table ct, observatory.OBS_table t
 WHERE column_ids.column_id  = c.id
   AND c.id = ct.column_id


--Used to expand a column based response to a table based one. Give it the desired
--columns and it will return a partial query for rolling them out to a table.
CREATE OR REPLACE FUNCTION cdb_observatory.OBS_BuildSnapshotQuery(names text[])
RETURNS TEXT
AS $$
DECLARE
