Is it possible to know when a CAS table (loaded to memory) was last accessed/used?

[EyalGonen]

Hi all,

I would like to create a process which automatically unloads tables from CAS based on their last accessed time.

So for example, if a CAS table loaded to memory was not accessed in 48 hours then unload it from memory.

Is this possible? Anyone did anything like this?

Thanks

[gwootton · Accepted solution]

Take a look at the built in Sample unload job's "unloadAccessThreshold" parameter:

CAS Table State Management - Unloading Data
https://go.documentation.sas.com/doc/en/sasadmincdc/v_069/caldatamgmtcas/n150v9svjp42ron1hn9r496xj49...

Edit: To fully answer the question of generally how to determine the last accessed time for a CAS table, this is an attribute of the table so can be retrieved using:

• The tableInfo table CAS action (Accessed column in result) https://go.documentation.sas.com/doc/en/pgmsascdc/default/caspg/cas-table-tableinfo.htm
• The casManagement REST API (/casManagement/servers/cas-shared-default/caslibs/<caslib>/tables/<table-name>) (lastAccessed attribute of the table) https://developer.sas.com/rest-apis/casManagement/getTable
• The sas-viya CLI's CAS plugin's table command's show-info subcommand (https://go.documentation.sas.com/doc/en/sasadmincdc/default/calcli/p0qtbwd62xzzidn1laisd446t33e.htm#...)

[EyalGonen]

Thanks @gwootton  - you're always a great help!