11-17-2022 11:34 AM
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
11-17-2022 05:05 PM
@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
11-18-2022 05:11 AM
So, if there were 100 users, they would all need their own cluster to use R?
11-18-2022 12:40 AM
Hi @Peter McNally, We haven’t heard from you on the last response from @karthik p, and I was checking back to see if his suggestions helped you.
Or else, If you have any solution, please do share that with the community as it can be helpful to others.
Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.
11-28-2022 06:39 AM
The response did not help.
07-03-2023 01:20 PM
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.
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.
If there isn’t a group near you, start one and help create a community that brings people together.
Request a New Group