Connector Improvement: S3 Connector REST API enhancement - Support for upsert file using custom primary key
Completed
Hi team,
It would be awesome if you could enhance S3 connector exposed REST API to allow us to configure Field: Modified File Merge -> Upsert file using custom primary key via Terraform provider. So that would mean that new release of Fivetran provider should be created with added support for above mentioned feature. We can do that via Fivetran console ( GUI ), but there is no available API for that option ( doc link ) so that we can do it via terraform. We can only configure Modified File Merge -> Upsert file using file name and line number. Or to use append file option.
Many thanks in advance.
-
Official comment
Hi Nikola,
Thank you for reaching out! We are looking into this and will let you know when it's done.
Thank you,
Parmeet -
Hi,
Do we have any update on this request ?
We are planning to use the REST API feature to create an S3 connector. However, the feature to select primary keys is not available through the REST API. As a result, we are forced to use the UI to select primary keys after creating the connector via the REST API. This defeats the purpose of using the REST API.
-
Would be great to see this same functionality extended to the SFTP connector setup.
-
Hi everyone, Upsert file using custom primary key is now available via the API for S3 - https://fivetran.com/docs/rest-api/interactive-api-reference/api-configuration/connector-configuration#upsertwithcustomprimarykey Other File connectors to follow soon.
Thank you,
Parmeet
Please sign in to leave a comment.
Comments
4 comments