topic Re: Is it possible to know when a CAS table (loaded to memory) was last accessed/used? in Administration and Deployment

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

EyalGonen — Wed, 05 Nov 2025 11:04:22 GMT

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

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

gwootton — Wed, 05 Nov 2025 18:40:49 GMT

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/n150v9svjp42ron1hn9r496xj49m.htm#n18h0bb10gjeh6n1bltpkf8uk966

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#p0jzrmwrgal4dfn18sx3q9opsodw)

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

EyalGonen — Thu, 06 Nov 2025 05:40:31 GMT

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