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 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

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