[ISSUE] Issue with databricks_catalog resource when providing a database key for foreign catalog generation

[tucker-anderson]

Configuration

I'm having an issue since the 1.165.0 provider version (this code seems to work up to 1.164.1 in my testing):

resource "databricks_catalog" "catalogs" {
  name                    = "**SOME-CATALOG-NAME-HERE**"
  connection_name = "**SOME-CONNECTION-NAME-REFERENCE-HERE**"
  options                 = { database = "**SOME-DB-NAME-HERE**" }
}

Yields this on apply:

Error: cannot create catalog: UpdateCatalog options can not be provided.

Seems similar to issue #2686.

Expected Behavior

Foreign catalog should be created upon terraform apply

Actual Behavior

Catalog cannot be created with a database option key as defined here in the provider docs

Steps to Reproduce

Terraform and provider versions

Tested on providers 1.165.0 through current and all versions yielded error.

Is it a regression?

1.164.1 and 1.164.0 applies successfully

[alexott]

just to confirm - does this happen on creation?

Most probably it's caused by #4476 (Cc: @mgyucht)

[tucker-anderson]

Yes during creation of a new catalog during terraform apply. Deletions of existing catalogs with these options works with the newest providers. I did not test modifications.