Recommended Access mode for multiple users with R code functionality?

[peter_mcnally]

Hello,

I recently tried running R code in a notebook. The notebook is about a year old and was used in a different cluster that no longer exists. I received the message, 'Your administrator has only allowed sql and python commands on this cluster. This execution contained at least one disallowed language.'

I thought this was curious. As it turns out it is because I am attempting to run it on a cluster configured with 'Shared' access mode, which only supports SQL and python.

My two options for configuring a cluster that supports R are 'single user' or a 'no isolation shared' access modes. Can someone provide a concise difference between the two without pointing me to documentation about the Unity Catalog. An example for each option would help.

In this case there are only two users. I don't anticipate that changing. However, I would also like to know about guidelines for different use cases, with more users, as well.

Thanks!

Peter

[karthik_p]

@Peter McNally​ preferred is single user as, isolation won't support unity catalog. also, if you enable Isolation cluster mode, you need to enable few more settings related to admin restrictions

[peter_mcnally]

So, if there were 100 users, they would all need their own cluster to use R?

[peter_mcnally]

The response did not help.

[sccn_kcu]

There's a feature in preview available that allows configuring single user access mode clusters that support R, where the assigned single user is a service principal. You can bind multiple users to the service principal to achieve multiple user access to the R notebook. Reach out to your Databricks rep for more information.