How To Modify a Column in a Core Table?

Question

How do I modify a column in a core table?

Environment

Fivetran REST API

Answer

Use one of the following endpoints:

Update a Connection Column Config
Update a Connection Table Config - the table parameters must be omitted in the request paylod

Example of payload with omitted table parameters

If you choose to use the Update a Connection Table Config endpoint, you must omit table parameters, such as enabled and sync_mode, in the payload and only specify the column parameters' values, as shown in the following example.

{
  "columns": {
    "column": {
      "enabled": true,
      "hashed": false,
      "is_primary_key": true,
      "masking_algorithm": "PLAINTEXT"
    }
  }
}

Otherwise, you will get the following 409 error:

{
  "code": "IllegalState",
  "message": "Cannot modify read-only table <schema_name>.<table_name> config"
}