Page History

...

The daily_update_circ_demographics_metadb task is set up to execute the update_circsnapshot4.sql query daily at 7am, 11am, 2pm, 5pm, and 9pm. The update_circ_snapshot4_metadb.sql query (in the LOCAL_AUTOMATED folder in DBeaver) runs the following code on Metadb using the z_slm5 user account, which uses the INSERT function to get the new checkouts and add them to the sm_local_shared.circsnapshot4 table daily automatically. The sm_local_shared.circsnapshot4 table is used in circulation queries to generate reports that need the PII data that is removed everyday from circulation data in the FOLIO system. 

The metadb version of the query was revised to NOT use derived tables. This will ensure the retrieval of all changes to records when the update query appends new data to the local_shared sm_circ_snapshot4 table.

...

The permissions for the local_shared.sm_circ_snapshot4 table are set to RW for z_slm5 and RO for all other users. Reporting team member user accounts have read/write access to the sm_circsnapshot4 table. The z_metadbuser_cornell user account has read-only access to the sm_circsnapshot4 table.

For instructions on setting permissions, see Setting Permissions for Schema Tables in Metadb. 

...

The update_circ_snapshot4_metadb.sql query is automated to run daily at the following times:

• 7am
• 11am
• 2pm
• 5pm
• 9pm

Testing Results

To test that the sm_circsnashot4 file is getting updated