topic Re: How to add existing recipient to existing delta share in Administration & Architecture

How to add existing recipient to existing delta share

chethankumar — Mon, 04 Nov 2024 13:56:35 GMT

I created a recipient in the Databricks console and also set up a Delta Share. Now, I’d like to link this existing recipient to the Delta Share. Is there a way to accomplish this using Terraform?

Re: How to add existing recipient to existing delta share

Naïm — Mon, 04 Nov 2024 14:26:33 GMT

Hi Chethankumar,

Yes you can use the databricks_grants resource. To read more see the documentation of our terraform provider.

Best regards,

Naïm

Re: How to add existing recipient to existing delta share

chethankumar — Fri, 08 Nov 2024 04:48:53 GMT

Hi @Naïm

Thanks for your response. It seems your answer is helping me, but I'm facing another issue. The owner of my recipient is a group, not an individual user. I'm running this Terraform script using a service principal that is a member of that group. However, I'm encountering the following issue when trying to create grants:
Error: cannot update grants: User is not an owner of Recipient 'abc'

resource "databricks_grants" "databricks_grants" {
share = "delta_sharing"
grant {
principal = "abc"
privileges = ["SELECT"]
}
}

Re: How to add existing recipient to existing delta share

Nurota — Tue, 10 Dec 2024 15:29:33 GMT

Yes, it won't allow you until you are or the service principal that runs the changes in the CI is in the owner group. You can add the SP to the owners group, and that should solve it.