State issue with Analytics Hub subscription resource block

[jongoings]

Community Note

I have been added as a subscriber to an Analytics Hub listing. I am trying to add that listing to my project.

I'm using the 'google_bigquery_analytics_hub_listing_subscription' resource block to add to my project.

I'm noticing some interesting behavior. The listing is added to my project, but my state file is not updated, and I get the following error.

Error: Provider produced inconsistent result after apply
│
│ When applying changes to google_bigquery_analytics_hub_listing_subscription.subscription, provider "provider["registry.terraform.io/hashicorp/google"]" produced an unexpected new value: Root object was present,
│ but now absent.
│
│ This is a bug in the provider, which should be reported in the provider's own issue tracker.

So the listing gets added to my project, but when I run the terraform destroy command I get the

No changes. No objects need to be destroyed.

Here is my resource block:

resource "google_bigquery_analytics_hub_listing_subscription" "subscription" {
  project          = "dev-project"   #The project ID of the source project
  location         = "us"              #The region to deploy GCP objects
  data_exchange_id = "jdg_dev_exchange" #The data exchange ID that contains the listing
  listing_id       = "jdg_shared_ds"       #The listing ID to subscribe to
  destination_dataset {
    description   = "Test for adding a dataset via subscriptions"   #The description of the destination dataset
    friendly_name = "JDG Sub Test" #The friendly name of the destination dataset
    labels        = {"env": "sdb", "product": "testprod"}        #The labels to apply to the destination dataset
    location      = "us"
    dataset_reference {
      dataset_id = "jdg_test_add_sub" #The ID of the destination dataset
      project_id = "my-own-personal-project" #The ID of the destination project
    }
  }
}

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request.
• Please do not leave +1 or me too comments, they generate extra noise for issue followers and do not help prioritize the request.
• If you are interested in working on this issue or have submitted a pull request, please leave a comment.
• If an issue is assigned to a user, that user is claiming responsibility for the issue.
• Customers working with a Google Technical Account Manager or Customer Engineer can ask them to reach out internally to expedite investigation and resolution of this issue.

Terraform Version & Provider Version(s)

Terraform v1.11.2
on windows_386

• provider registry.terraform.io/hashicorp/google v6.25.0

Affected Resource(s)

google_bigquery_analytics_hub_listing_subscription

Terraform Configuration

resource "google_bigquery_analytics_hub_listing_subscription" "subscription" {
  project          = "dev-project"   #The project ID of the source project
  location         = "us"              #The region to deploy GCP objects
  data_exchange_id = "jdg_dev_exchange" #The data exchange ID that contains the listing
  listing_id       = "jdg_shared_ds"       #The listing ID to subscribe to
  destination_dataset {
    description   = "Test for adding a dataset via subscriptions"   #The description of the destination dataset
    friendly_name = "JDG Sub Test" #The friendly name of the destination dataset
    labels        = {"env": "sdb", "product": "testprod"}        #The labels to apply to the destination dataset
    location      = "us"
    dataset_reference {
      dataset_id = "jdg_test_add_sub" #The ID of the destination dataset
      project_id = "my-own-personal-project" #The ID of the destination project
    }
  }
}

Debug Output

Error: Provider produced inconsistent result after apply
│
│ When applying changes to google_bigquery_analytics_hub_listing_subscription.subscription, provider "provider["registry.terraform.io/hashicorp/google"]" produced an unexpected new value: Root object was present,
│ but now absent.
│
│ This is a bug in the provider, which should be reported in the provider's own issue tracker.

Expected Behavior

I would expect the dataset to be created AND added to the state file with the index I've indicated.

Actual Behavior

The object is created BUT it is not added to the state file

Steps to reproduce

1. terraform apply

Important Factoids

No response

References

https://registry.terraform.io/providers/hashicorp/google/latest/docs/resources/bigquery_analytics_hub_listing_subscription

[ggtisc]

Hi @jongoings

I tryed to reproduce this issue but everything works as expected without errors. Have you confirmed the IDs of the following resources you are using?

1. data_exchange_id = "jdg_dev_exchange"
2. listing_id = "jdg_shared_ds"
3. dataset_reference.dataset_id = "jdg_test_add_sub"

You can also look into the following documentation example to see what does each argument do and need to have (link here)

Used code to test the issue:

resource "google_bigquery_analytics_hub_data_exchange" "bq_analytics_hub_data_exchange_21914" {
  location         = "US"
  data_exchange_id = "bq_analytics_hub_data_exchange_21914"
  display_name     = "bq_analytics_hub_data_exchange_21914"
  description      = "something"
}

resource "google_bigquery_dataset" "bq_dataset_21914" {
  dataset_id                  = "bq_dataset_21914"
  friendly_name               = "bq_dataset_21914"
  description                 = "something"
  location                    = "US"
}

resource "google_bigquery_analytics_hub_listing" "bq_analytics_hub_listing_21914" {
  location         = "US"
  data_exchange_id = google_bigquery_analytics_hub_data_exchange.bq_analytics_hub_data_exchange_21914.data_exchange_id
  listing_id       = "bq_analytics_hub_listing_21914"
  display_name     = "bq_analytics_hub_listing_21914"
  description      = "something"

  bigquery_dataset {
    dataset = google_bigquery_dataset.bq_dataset_21914.id
  }
}

resource "google_bigquery_analytics_hub_listing_subscription" "bq_analytics_hub_listing_sub_21914" {
  project          = "terraform-dev-gtiscareno-org"
  location         = "us"
  data_exchange_id = google_bigquery_analytics_hub_data_exchange.bq_analytics_hub_data_exchange_21914.data_exchange_id
  listing_id       = google_bigquery_analytics_hub_listing.bq_analytics_hub_listing_21914.listing_id

  destination_dataset {
    description   = "something"
    friendly_name = "destination dataset"
    location      = "us"

    labels        = {
      "env": "foo",
      "product": "bar"
    }

    dataset_reference {
      dataset_id = "destination_dataset_21914"
      project_id = "my-project"
    }
  }
}