Is there api call to set "Table access control" workspace config ?

[GNarain]

Is there api call to set "Table access control" workspace config ?

[karthik_p]

@Govind Narain​ can you try below api

curl --location --request PATCH 'https://test.cloud.databricks.com/api/2.0/workspace-conf' \

--header 'Authorization: Bearer REPLACE_TOKEN' \

--header 'Content-Type: application/json' \

--data-raw '{

  "enableTableAccessControl": "true"

}'

for reference go through below one of the discussions posted previously Can Terraform be used to set configurations in Admin / workspace settings? (databricks.com)

[GNarain]

Hi Karthik,

It did not work. The error I am getting is that it is an invalid key.

[DiogoPinto]

Hi @karthik p​ I am facing the same issue as @Govind Narain​. Do you have any reference to the different keys that are supported by this API? Thanks!

[karthik_p]

@Diogo Pinto​ did you cheked workspace id that u added in patch url is correct and also any spaces to generated token @Govind Narain​ 

[SvenPeeters]

Faciing the same issue, tried to fetch the current value via /api/2.0/workspace-conf?keys=enableTableAccessControl
Unfortunately this is returning a 400

{

    "error_code": "BAD_REQUEST",

    "message": "Invalid keys: [\"enableTableAccessControl\"]"

}

[SvenPeeters]

Hi Kaniz,

I tried this on our Databricks hosted on Azure

Call : https://adb-xxxxxxxxxxxxxxx.18.azuredatabricks.net/api/2.0/workspace-conf?keys=workspaceAccessContro...

Result

{
"error_code": "BAD_REQUEST",
"message": "Invalid keys: [\"workspaceAccessControlEnabled\"]"
}

[SvenPeeters · Accepted solution]

Hi Kaniz,

Unfortunately the databricks is deployed and configured via DevOps (BICEP & Powershell scripts), so the UI is not an option. That's something the Databricks team should address

We would like to use table acl to be able to share different views to different teams.
They will be using an SQL Warehouse and PowerBI to connect to the data.
Unfortunately I can't find an option where we can change the spark config for an SQL Warehouse.

We are considering moving to the Unity Catalog where table ACL on the workspace isn't an issue.
But having some issues with the Infra team to get them convinced 😉

Regards,

Sven