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

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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
  • 738 views
  • 0 likes
  • 2 in conversation