resource "google_sql_database_instance" "sql_instance_22292" {
  name                = "sql-instance-22292"
  database_version    = "SQLSERVER_2019_STANDARD"
  region              = "us-central1"
  root_password       = "something"
  deletion_protection = true

  settings {
    tier = "db-custom-2-4096"

    ip_configuration {
      authorized_networks {
        value = "34.71.242.81"
      }

      authorized_networks {
        value = "34.72.28.29"
      }

      authorized_networks {
        value = "34.67.6.157"
      }

      authorized_networks {
        value = "34.67.234.134"
      }

      authorized_networks {
        value = "34.72.239.218"
      }
    }
  }
}

resource "google_sql_user" "sql_user_22292" {
    name     = "sql-user-22292"
    instance = google_sql_database_instance.sql_instance_22292.name
    password = "something"
}

resource "google_secret_manager_secret" "sql_password_secret_22292" {
  secret_id = "sql-password-22292"

  replication {
    user_managed {
      replicas {
        location = "us-central1"
      }
    }
  }
}

resource "google_secret_manager_secret_version" "sql_password_version_22292" {
  secret      = google_secret_manager_secret.sql_password_secret_22292.name
  secret_data = google_sql_user.sql_user_22292.password
  enabled     = true
}

resource "google_secret_manager_secret" "salesforce_token_secret_22292" {
  secret_id = "salesforce-token-22292"

  replication {
    user_managed {
      replicas {
        location = "us-central1"
      }
    }
  }
}

resource "google_secret_manager_secret_version" "salesforce_token_version_22292" {
  secret      = google_secret_manager_secret.salesforce_token_secret_22292.name
  secret_data = "your-salesforce-security-token"
  enabled     = true
}

resource "google_datastream_connection_profile" "ds_conn_profile_22292" {
  display_name              = "ds-conn-profile-22292"
  location                  = "us-central1"
  connection_profile_id     = "ds-conn-profile-22292"
  create_without_validation = true
  provider                  = google-beta

  salesforce_profile {
    domain = "fake-domain.my.salesforce.com"
      
    user_credentials {
      username                              = google_sql_user.sql_user_22292.name
      secret_manager_stored_password        = google_secret_manager_secret_version.sql_password_version_22292.id
      secret_manager_stored_security_token  = google_secret_manager_secret_version.salesforce_token_version_22292.id
    }
  }
}