Salesforce connector, can't create connection with stored passwords

[johnhoran]

Describe the bug We are storing our passwords in AWS SSM so we have a single place where all these are managed. However it looks like fivetran only supports creating the connection though an oauth flow now. To Reproduce

resource "fivetran_connector" "salesforce" {
  group_id = var.destination_group.id
  service  = "salesforce"

  destination_schema {
    name = "salesforce"
  }

  config {
    username = yamldecode(data.aws_ssm_parameter.credentials.value).username
    password = yamldecode(data.aws_ssm_parameter.credentials.value).password
    base_url = yamldecode(data.aws_ssm_parameter.credentials.value).instance
  }
}

Expected behavior We should be able to create the connection though terraform. Ideally we would be setting username, password and security token.

Logs & Output

╷
│ Error: create error
│ 
│   with module.salesforce.fivetran_connector.salesforce,
│   on ../../modules/salesforce/main.tf line 25, in resource "fivetran_connector" "salesforce":
│   25: resource "fivetran_connector" "salesforce" {
│ 
│ status code: 400; expected: 201; code: InvalidInput; message: Can't create connector `config`: field `password` could not be set because it is in sunset period. You can only manage this field for connectors created before 2023-07-28T00:00:00Z
╵

Plugin version: 1.1.0

[beevital]

This issue is not related with Terraform itself, please file a ticket for our product support.