4335 pull from staging

maybe generate this dict first and then update with the column types? this feels a bit ugly as a constructor