Hi, Do we have any option available in Matillion for Azure to schedule / trigger the job from outside. Such as trigger the job using file arrived in S3 (Matillion installation in AWS). Thanks Ganesh

Matillion ETL
1

Hi,

Do we have any option available in Matillion for Azure to schedule / trigger the job from outside. Such as trigger the job using file arrived in S3 (Matillion installation in AWS).
Thanks
Ganesh

2

Hello @GArun​

Thank you for your question, this was a really good conversation for our team internally!

It does look possible to achieve you would need to use Azure Functions as an equivalent of AWS Lambda:

  1. Create a new function
  2. When executed makes a call to the Matillion REST API or posts to the Azure Queue
  3. Set a trigger on the function to run when a file lands in the bucket.

There is some further details on this here: https://docs.microsoft.com/en-us/azure/azure-functions/functions-create-storage-blob-triggered-function

But thanks to your question we are going to ensure this is also added to our own documentation for other users, so thank you for raising this as it will help more people out that wish to achieve this and similar.

Kind regards, Joe