terraform {
  backend "s3" {
    bucket  = "orcd-terraform-state"
    key     = "prod/neighbouring-rights/fivetran/terraform.tfstate"
    region  = "us-east-1"
    encrypt = "true"
  }
}

data "aws_rds_cluster" "database" {
  cluster_identifier = "${var.environment}-neighbouring-rights-delivery"
}

resource "fivetran_group" "group" {
  name = var.destination_name
}

resource "fivetran_destination" "destination" {
  group_id         = fivetran_group.group.id
  region           = "GCP_US_EAST4"
  service          = "aurora_warehouse"
  time_zone_offset = "0"
  run_setup_tests  = false

  config {
    connection_type = "SshTunnel"
    database        = "neighbouring_rights_delivery"
    host            = data.aws_rds_cluster.database.endpoint
    password        = "dummy"
    port            = 3306
    tunnel_host     = "fivetran.theorchard.io"
    tunnel_port     = "2222"
    tunnel_user     = "fivetran"
    user            = "fivetran_dest"
  }
}