SAS DI Studio : lock table with check-in/check-out functionality

JeroenPotgieter — Tue, 02 May 2023 11:08:06 GMT

Hi all, in SAS DI Studio we are testing the functionality of check-in/check-out. We found out that when a table is checked-out a other user can still execute data processing (for example : load data with table loader) on this table. We would expect a lock mechanism or something similair.

How can we prevent data processing on a (database) table when this table is check-out in SAD DI Studio.

Thanks for the advice, tips, .... etc

Re: SAS DI Studio : lock table with check-in/check-out functionality

LinusH — Tue, 02 May 2023 15:17:44 GMT

I can understand the need at some level.

But DI Studio is all about metadata, not "actual data".

AFAIK there is no standard functionality that you can perform to make this happen linked to check-out/check-in.

Also consider data in external datasets.

So the question is, how big of problem is this? Maybe it can be solved via communication in the development teams?

Also, locking down tables may halt other developers/testers that need to recreate the table for their job.

What I can think of is that you create OS script to change authorizations for checked out scripts. But who will execute that?

topic Re: SAS DI Studio : lock table with check-in/check-out functionality in SAS Data Management

SAS DI Studio : lock table with check-in/check-out functionality

Re: SAS DI Studio : lock table with check-in/check-out functionality