...
--need to re-import table into local_shared, set permissions so that all users have Read Only permissions to use it, and set data types more accurately using metadb LDP data types as a guide
The daily_update_circ_demographics_metadb task is set up to execute the update_circsnapshot4.sql query daily at 7am. The update_circ_snapshot4_metadb.sql query (in the LOCAL_AUTOMATED folder in DBeaver) runs the following code on Metadb, which uses the INSERT function to get the new checkouts and add them to the sm_local_core.circsnapshot4 table daily automatically. The sm_local_core.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.
...