topic Re: Recommended Access mode for multiple users with R code functionality? in Data Governance

Recommended Access mode for multiple users with R code functionality?

peter_mcnally — Thu, 17 Nov 2022 19:34:27 GMT

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

Re: Recommended Access mode for multiple users with R code functionality?

karthik_p — Fri, 18 Nov 2022 01:05:53 GMT

@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

Re: Recommended Access mode for multiple users with R code functionality?

peter_mcnally — Fri, 18 Nov 2022 13:11:18 GMT

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

Re: Recommended Access mode for multiple users with R code functionality?

peter_mcnally — Mon, 28 Nov 2022 14:39:26 GMT

The response did not help.

Re: Recommended Access mode for multiple users with R code functionality?

sccn_kcu — Mon, 03 Jul 2023 20:20:50 GMT

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.