BookmarkSubscribeRSS Feed
JeroenPotgieter
Calcite | Level 5

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

 

 

1 REPLY 1
LinusH
Tourmaline | Level 20

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?

 

 

 

Data never sleeps

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 483 views
  • 0 likes
  • 2 in conversation