topic Re: Is there api call to set "Table access control" workspace config ? in Data Engineering

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

GNarain — Tue, 15 Nov 2022 15:51:28 GMT

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

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

karthik_p — Wed, 16 Nov 2022 00:06:56 GMT

@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)

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

GNarain — Mon, 21 Nov 2022 21:36:57 GMT

Hi Karthik,

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

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

DiogoPinto — Tue, 23 May 2023 10:31:31 GMT

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!

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

karthik_p — Tue, 30 May 2023 16:25:55 GMT

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

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

SvenPeeters — Tue, 01 Aug 2023 07:59:57 GMT

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\"]"

}

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

SvenPeeters — Wed, 16 Aug 2023 12:14:24 GMT

Hi Kaniz,

I tried this on our Databricks hosted on Azure

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

Result

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

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

SvenPeeters — Thu, 17 Aug 2023 05:23:38 GMT

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