terraform {
  backend "s3" {
    bucket  = "orcd-terraform-state"
    key     = "qa/fivetran/ows-product-staging/terraform.tfstate"
    region  = "us-east-1"
    encrypt = "true"
  }
}

data "fivetran_group" "qa_warehouse" {
  id = "gentry_invitro"
}

data "aws_rds_cluster" "qa_ows_product_staging" {
  cluster_identifier = "${var.environment}-ows-product-staging"
}

resource "fivetran_connector" "qa_ows_product_staging_connector" {
  group_id = data.fivetran_group.qa_warehouse.id
  service  = "aurora"

  destination_schema {
    prefix = "${var.environment}_ows_product_staging"
  }

  config {
    host             = data.aws_rds_cluster.qa_ows_product_staging.endpoint
    port             = data.aws_rds_cluster.qa_ows_product_staging.port
    user             = "fivetran"
    database         = "ows_product_staging"
    tunnel_host      = "fivetran.theorchard.io"
    tunnel_port      = "2222"
    tunnel_user      = "fivetran"
  }
}

resource "fivetran_connector_schedule" "prod_nr_ownwership_delivery_schedule" {
  connector_id      = fivetran_connector.qa_ows_product_staging_connector.id
  sync_frequency    = 5
  pause_after_trial = false
}