topic Re: Program to remove metadata registration for tables not loaded to memory in SAS Visual Analytics

Program to remove metadata registration for tables not loaded to memory

LarsEB — Wed, 17 Aug 2016 08:47:22 GMT

Hi experts

In our organisation some of the VAusers use the manuel import of data in the Data Exploration Tab a lot. Unfortunately they do not always remove data again when finish exploring. And a restart of the LASR-server wipes all manuel imported data resulting in growing amount of registered tables in the administraton tab in the VA hub. We also use Autoload.

I would like to create a SAS program that list all tables registered in a LASR server library and then check if they are loaded to memory in the LASR server and if not deletes the metadata registration for the table.

Have anyone already created a program to do something like that?

We are runnning VA 7.3 (SAS 9.4)

Thanks

Lars

Re: Program to remove metadata registration for tables not loaded to memory

BrunoMueller — Wed, 17 Aug 2016 10:17:12 GMT

How about using Proc METALIB, see below for an example.

I assume that the list of libraries user can add their data is limited and can be hardcoded in the code.

The NOEXEC will not run the update rule, but will report what would be done.

proc metalib;
   omr ( LIBRARY="Visual Analytics Public LASR" );
   update_rule = (delete noadd noupdate);
   report = ( type=summary );
   noexec;
run;

You need to have a connection to the Metadata Server in order to run this code.

Bruno

Re: Program to remove metadata registration for tables not loaded to memory

LarsEB — Wed, 17 Aug 2016 12:07:20 GMT

Hi Bruno,

Thanks for your reply. It solved my problem pretty easy 🙂