Step 1: Create the remote service (Azure function) in the Portal¶

Create the function¶

To perform the tasks described in this section, you should be in the Function App screen in the Azure Portal. The name of your Azure Functions app should be displayed, typically near the upper left corner of the screen.

To create the HTTP-triggered function:

1. In the left-hand side menu tree, look for the section titled Functions. In that section, click on the item labeled Functions to add a function.

2. Click on the + Add button.

3. Select HTTP trigger from the list of potential triggers on the right.

4. Enter the name to use for your HTTP-triggered function.

   Record this name in the HTTP-Triggered Function name field in your tracking worksheet.

5. Enter the Authorization level.

   Snowflake recommends choosing Function as the authorization level.

   For more information about possible authorization levels, see the Microsoft documentation: HTTP-triggered functions.

6. Click on the button titled Add.

   This takes you to a screen that shows the function name and, below that, the word Function.

7. In the tree menu on the left-hand side, click on Code + Test.

8. Replace the default code with your own code.

   Sample code for a JavaScript “echo” function is provided below.

   The function reads each row, then copies the row to the output (results). The row number is also included in the output. The output is returned as part of a multi-level dictionary.

   This function accepts and returns data in the same format (JSON) that Snowflake sends and reads. For more details about data formats, see Remote Service Input and Output Data Formats .

   Normally, the function returns HTTP code 200. If no rows are passed to the function (i.e. if the request body is empty), the function returns error code 400.

   module.exports = async function(context, request) {
       context.log('JavaScript HTTP trigger function processed a request.');
   
       if (request.body) {
           var rows = request.body.data;
           var results = [];
           rows.forEach(row => {
               results.push([row[0], row]);
           });
   
           results = {data: results}
           context.res = {
               status: 200,
               body: JSON.stringify(results)
           };
      }
      else {
          context.res = {
              status: 400,
              body: "Please pass data in the request body."
          };
      }
   };
   

   Copy

9. Click on the Save button above the code.

Test the function¶

To test the HTTP-triggered Azure Function you just created, paste the following sample data into the Body field and click on the Test/Run button:

{
    "data": [ [ 0, 43, "page" ], [ 1, 42, "life, the universe, and everything" ] ]
}

Copy

The content of the output should be similar to the following:

{ "data":
    [
        [ 0, [ 0, 43, "page" ] ],
        [ 1, [ 1, 42, "life, the universe, and everything" ]  ]
    ]
}

Copy

Note that the formatting might be different from what is shown above.

Enable app service authentication for the Azure functions app¶

Before you execute the steps below, you should be on the Function App screen for your Azure Functions app.

1. In the left-hand menu pane, look for the section named Settings and click on Authentication.

   If the left-hand margin shows the Developer menu (with Code + Test, Integration, etc.), if you have a scroll bar at the bottom of your screen, try sliding the scroll bar to the left to return to the Function App or App Service section, and then look for Settings.

2. Click the Add identity provider button.

3. In the Identity provider drop-down menu, select Microsoft.

4. For App registration type, select Create new app registration.

5. In the Name field, type the name of your app.

6. For Supported account types, select Current tenant - Single tenant.

7. For Restrict access, select Require authentication.

8. For Unauthenticated requests, select HTTP 401 Unauthorized.

9. Click Next: Permissions. Review the permissions.

10. Click Add. A new Azure AD application is created and the application page is displayed.

11. Click the link that shows your application’s name to go to your Azure AD application’s page.

12. Find the Application (client) ID field.

    Record this ID in the Azure Function App AD Application ID field in your tracking worksheet.

    Important

    Make sure you copy the ID, not the Azure AD application name. The ID should contain a UUID.