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"
}