Connector Improvement: Need to have Schema Changes supported for Magic Folder connectors
Answered
Currently, the Fivetran connector doesn't allow for the selection of specific files in a Magic folder. If there are multiple files in the Magic folder, it is impossible to select just one. We do not choose Merge mode because the file is regularly replaced with a new one.
-
Official comment
Hi Ling, thanks for submitting this request! If the file name remains the same, you are able to use Merge Mode for this by choosing Primary Key as "Upsert file using file name and line number". Please let me know if that does not solve the problem. Thank you!
Please sign in to leave a comment.
Comments
1 comment