topic Re: terraform create multiple db user in Data Engineering

terraform create multiple db user

francly — Sat, 06 Aug 2022 14:28:32 GMT

Hi, follow the example to create one user. It's working however I want to create multiple users, I have tried many ways but still cannot get it work, please share some idea.

https://registry.terraform.io/providers/databricks/databricks/latest/docs/resources/user

data "databricks_group" "admins" {
  display_name = "admins"
}
 
resource "databricks_user" "me" {
  user_name = "me@example.com"
}
 
resource "databricks_group_member" "i-am-admin" {
  group_id  = data.databricks_group.admins.id
  member_id = databricks_user.me.id
}

Re: terraform create multiple db user

Hopkins696 — Mon, 08 Aug 2022 06:52:19 GMT

count is one of the meta-parameters available to all resources. We can specify the number of identical resources to create.

Taco Bell Survey

Re: terraform create multiple db user

Cedric — Wed, 10 Aug 2022 14:11:48 GMT

You would have to create multiple "databricks_user" resources. Using count or foreach should help you with creating multiple of the same resource.

Re: terraform create multiple db user

zcking — Thu, 11 Aug 2022 00:27:07 GMT

as @Cedric Law Hing Ping mentioned, you can use `count` or `foreach` in Terraform to do this.

Here's a simple example:

```

locals {

user_emails = toset([

"user1@example.com",

"user2@example.com",

"user3@example.com"

])

}

resource "databricks_user" "engineers" {

for_each = local.user_emails

user_name = each.value

}

data "databricks_group" "admins" {

display_name = "admins"

}

resource "databricks_group_member" "engineer-admins" {

for_each = databricks_user.engineers

group_id = data.databricks_group.admins.id

member_id = each.value.id

}

```

Re: terraform create multiple db user

francly — Thu, 11 Aug 2022 05:10:34 GMT

Thanks @Zach King this solution work for me.

Re: terraform create multiple db user

Natlab — Tue, 23 Jan 2024 07:10:10 GMT

What if I want to give User Name along with the email ID?
I used below code but its not helping(code is not failing, but not adding user name)
It seems this code line: "display_name = each.key" is not working. Pls suggest.

terraform {

required_providers {

databricks = {

source = "databricks/databricks"

}

provider "databricks" {

#alias = "workspace"

host = "https://adb-xxxx.xx.azuredatabricks.net"

token = "dapixxxxx"

}

locals {

users = {

User1 = "user1@example.com",

User2 = "user2@example.com",

User3 = "user3@example.com"

}

resource "databricks_user" "engineers" {

for_each = local.users

display_name = each.key

user_name = each.value

allow_cluster_create = false

allow_instance_pool_create = false

databricks_sql_access = true

workspace_access = true

}