I am new to Snowflake and Azure functions.
We are going to be provided a view by our Snowflake team (which will be updated daily) that consists of about 30K records.
We need to process these records and send emails to required party using Azure functions.
My questions:
- How can we use a Stored Procedure to read Snowflake data from an Azure function.
- We may have 5-6 instances of Azure functions to process the data in a timely manner. In such a case how to ensure that each Instance of the Azure function is processing a different data set.
Thanks