Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

schema_change_handling required for sap_hana_db service but not supported #349

Open
fivetran-justinbeausoleil opened this issue Aug 27, 2024 · 0 comments
Assignees
Labels
bug Something isn't working

Comments

@fivetran-justinbeausoleil

Describe the bug
With version 1.2.8, the resource fivetran_conector_schema_config requires schema_change_handling. However, the service sap_hana_db does not support schema_change_handling, and fails during apply.

To Reproduce

resource "fivetran_connector_schema_config" "sap_hana_db_schema_config" {
  count = local.dev_only # only create a dev environment

  connector_id           = fivetran_connector.sap_hana_db[count.index].id
  schema_change_handling = "ALLOW_ALL"
  schemas = {
    "SAPABAP1" = {
      "enabled" : true,
      "tables" : {
        "BSEG" : {
          "enabled" : true
        }
      }
    }
  }
  validation_level = "NONE"
}

Expected behavior
Because sap_hana_db does not support schema_change_handling, the key/value pair should not be required for the indicated service.

Logs & Output
Running terraform apply results in:

│ Error: Unable to Create Connector Schema Resource.
│ 
│   with fivetran_connector_schema_config.sap_hana_db_schema_config[0],
│   on connector-schema-config.tf line 32, in resource "fivetran_connector_schema_config" "sap_hana_db_schema_config":
│   32: resource "fivetran_connector_schema_config" "sap_hana_db_schema_config" {
│ 
│ Error while applying schema config patch. status code: 400; expected: 200; code: InvalidInput; message: Service `sap_hana_db` doesn't support `schema_change_handling`.

Plugin version:

    fivetran = {
      source  = "fivetran/fivetran"
      version = "1.2.8"
    }

Additional context
If I put an empty string, I receive the error:
Attribute schema_change_handling value must be one of: ["ALLOW_ALL" "ALLOW_COLUMNS" "BLOCK_ALL"], got: ""

@fivetran-justinbeausoleil fivetran-justinbeausoleil added the bug Something isn't working label Aug 27, 2024
@beevital beevital self-assigned this Aug 28, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants