“How to move files to different location using file transfer”
https://documentation.matillion.com/docs/2953509
Hello,
My question was about MOVING files, but not only COPY.
Could you please advise?
[cid:image001.png@01D8F818.1092F680]
Ronnie Shahrabani
Sr. Data Engineer \ UDP Team
ALTERRA MOUNTAIN COMPANY
P 303.749.8333 \ C 720.840.3713
rshahrabani@alterramtnco.commailto:rshahrabani@alterramtnco.com</mailto:rshahrabani@alterramtnco.com>
Moving files is not possible. Please support my idea for enhancing the product with this feature: https://metlcommunity.matillion.com/s/idea/0874G000000kAtjQAE/detail
Thank you for your response, but my takeaway is that it is not supported and it is not going to be.
Unfortunately, I already saw that post, and therefore I have asked you if you have any alternative component through the tool.
Ronnie Shahrabani
Sr. Data Engineer \ UDP Team
ALTERRA MOUNTAIN COMPANY
P 303.749.8333 \ C 720.840.3713
rshahrabani@alterramtnco.commailto:rshahrabani@alterramtnco.com</mailto:rshahrabani@alterramtnco.com>
Yes, I think there will be no official solution in the near future.
You could use a Bash or Python Script to trigger operations on your remote file locations. For example, if you are on AWS S3, you could use the CLI or the boto3 package to delete a file in your source after the COPY command was successfull. However, I have no template for this.
Did you check the Matillion job Exchange, which is part of this Community Website? Maybe somebody else has shared a solution there.