Page History

...

Here is a screenshot of the local_shared.sm_circs_snapshot4 table in Metadb. 

Permissions

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.

...

Testing Results

To test that the sm_circsnashot4 circs_snapshot4 file is getting updated, run the query below. You should see daily updates to the file in the extract_date column, and a loan count total in the count_of_loans column.

select 
sm.extract_date::timestamp,
count (sm.loan_id) as count_of_loans

from local_shared.sm_circ_snapshot4 as sm
group by sm.extract_date::timestamp
order by sm.extract_date::timestamp desc