Salesforce BigQuery Transfer | Parameter Issue

[RomeoAva]

Community Note

• 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.5.7
on MacOS

• provider registry.terraform.io/hashicorp/google v5.34.0

Affected Resource(s)

google_bigquery_data_transfer_config

Terraform Configuration

terraform {
  backend "gcs" {
    bucket = ""
    prefix = "terraform/state"
  }

  required_providers {
    google = {
      source  = "hashicorp/google"
      version = "5.34.0"
    }
    random = {
      source = "hashicorp/random"
    }
  }
}

Debug Output

No response

Expected Behavior

Hello, I am trying to create a Salesforce Transfer for BQ using Terraform. Here is my current config to create that ressource:

resource "google_bigquery_data_transfer_config" "query_config" {
  display_name           = "import_salesforce"
  location               = "US"
  data_source_id         = "salesforce"
  destination_dataset_id = "analysis"
  params = {
    "connector.authentication.oauth.clientId"     = ""
    "connector.authentication.oauth.clientSecret" = ""
    "connector.authentication.username"           = ""
    "connector.authentication.password"           = ""
    "connector.authentication.securityToken"      = ""
    "assets"                                      = ["Project_ABC"]
  }
}

Actual Behavior

When specifying a list in the assets parameter, terraform tells me:

 Inappropriate value for attribute "params": element "assets": string required.

When I try to convert it to a String, the transfer is created but on BigQuery I get the following error:

Incorrect assets set in transfer config : string_value: "Project_ABC" , assets should be a non-empty list of strings.

I also tried to json_encode the list, but same result on BQ side:

Incorrect assets set in transfer config : string_value: "[\"Project_ABC\"]" , assets should be a non-empty list of strings.

Steps to reproduce

1. terraform apply

Important Factoids

No response

References

No response

b/348691952

[ggtisc]

Confirmed issue!

According to Google Cloud documentation in the bq section describes the next format for the assets param:

params='{"assets":["Account"]

But after running a terraform apply it returns the next error:

Inappropriate value for attribute "params": element "assets": string required.