Does Matillion bigquery ETL has a component similar to Cloud Storage Put Object, but does the functionality in opposite direction moving files from cloud storage/bigquery to SFTP. Also any SMTP (mail)component to notify errors or job completions.
1 Community Answers
Ian Funnell —
Thanks for raising this: it’s in plan, but has not been released yet. Please monitor the release notes for when this functionality becomes available.
For notifications, we currently have the Cloud Pub/Sub component, which you can use to send messages to a chosen topic. There is no email component, so I’d recommend that you use a Python script with the smtplib library to do this.