Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

corew
Schema NameSchema DescriptionPermissions
local_openautomationThis schema is a sandbox for all users who want to publish a file to a local schemafor internal use by the Automation Team.

r/w z_metadbuser_cornell user account

local_automationcoreThis schema is for internal use by the Automation Reporting Team.

r/w z_metadbuser_cornell user account

local_

derived*


*create this new schema after 4/1/25

This schema is for internal use by the Reporting Team. These tables are created by a script that runs nightly on the Metadb server. The script runs queries in the local_derived directory on cul-folio-analytics.

r/

o z_metadbuser_cornell user account

r/w reporting team user accounts

local_digpresThis schema is used by the HathiTrust team.

r/w z_metadbuser_cornell user account

local_hathitrustThis schema is used internally by the HathiTrust team.

r/w z_metadbuser_cornell user account

local_openThis schema is a sandbox for all users who want to publish a file to a local schema.

r/w z_metadbuser_cornell user account

local_protectedThis schema is used to store tables with protected data that is used internally by the Reporting Team.

r/o reporting team user accounts

r/w z_slm5, z_jl41

local_shared*


*rename this schema to local_static after 4/1/25

This schema is used to store local tables that are in queries used by all reporting users. All users can read the files here, but only reporting team members can post files here.

r/o z_metadbuser_cornell user account

r/w reporting team user accounts 

local_statisticsThis schema is for internal use by the Assessment and Planning team. 

r/o z_metadbuser_cornell user account

r/w z_lm15, z_slm5, z_vp25 

...