PATCH /v1/connections/{connectionId}/schemas/{schemaName}/tables/{tableName}/columns/{columnName}
Updates the column config within your table for an existing connection within your Fivetran account.
NOTE: The response contains all known schemas and tables. Also, it contains columns whose state has ever been set by the user. For more information, see also the Connection Schema config tutorial.
Servers
- https://api.fivetran.com
Path parameters
| Name | Type | Required | Description |
|---|---|---|---|
schemaName |
String | Yes |
The database schema name within your destination (different from the connection schema) |
tableName |
String | Yes |
The table name within your database schema |
columnName |
String | Yes |
The column name within your table |
connectionId |
String | Yes |
The unique identifier for the connection within the Fivetran system |
Request headers
| Name | Type | Required | Description |
|---|---|---|---|
Accept |
String | No |
Default value: "application/json" |
Content-Type |
String | Yes |
The media type of the request body.
Default value: "application/json" |
Request body fields
| Name | Type | Required | Description |
|---|---|---|---|
hashed |
Boolean | No |
The boolean value specifying whether a column should be hashed |
enabled |
Boolean | Yes |
The boolean value specifying whether the sync for the table into the destination is enabled. |
is_primary_key |
Boolean | No | |
masking_algorithm |
String | No |
Possible values:
|
How to start integrating
- Add HTTP Task to your workflow definition.
- Search for the API you want to integrate with and click on the name.
- This loads the API reference documentation and prepares the Http request settings.
- Click Test request to test run your request to the API and see the API's response.