Connector Improvement: add new feature to control schema_change_handling setting via API
Answered
When we create the connection using the endpoint for example
curl -s --request POST --url https://api.fivetran.com/v1/connections --header 'Accept: application/json;version=2' --header 'Authorization: Basic xxxxxxx==' --header 'content-type: application/json' --data @sql_server.payload.json,
it automatically enables all schemas by default even though we tried adding “"schema_change_handling": "ALLOW_COLUMNS",” to the payload json and the setting also shows up ALLOW ALL still in the UI. It would be good to have a way to handle this differently to have it "ALLOW_COLUMNS” when we create the connection so that all schemas are not selected by default.
-
Official comment
Hi Manoj,
You should be able to accomplish this using this guide: https://fivetran.com/docs/rest-api/tutorials/schema-status
Let us know if that covers it,
Jimmy
Please sign in to leave a comment.
Comments
1 comment