Azure Functions and Storage Tables
I've written previously about how Amazon's AWS Lambda feels like the future. I had a little time today to play with Azure Functions, Microsoft's new competing service.
As a preview, Azure Functions isn't quite polished yet, but the basic building blocks are in place. You create a Function App in the Azure Portal, much like you would create a Web or Mobile App, then add a few Functions in the Portal blade.
Since the service is built on the mature WebJobs product, there is already strong language support. Azure Functions can be created with specialised C#, NodeJS, PHP, Python, Powershell, Windows Batch scripts (I know), or any standard Windows executable. The Portal UI leaves a lot to be desired for now. I did't find any obvious way of using different languages or packaging up apps and dependencies, but did manage to get it working. The documentation implies that there are many more features than those exposed by the Portal blade.
For the sake of a quick test, I created a small function to connect to the Azure Storage account and create an empty Table. I had a little trouble setting up the connection string to the storage account but found a solution using magic environment variables here. This may seem normal to regular dotNet and/or Azure developers but it was new to me. The documentation implied that I needed to use a CloudConfigurationManager
from this NuGet package but I failed to figure out how to pull in the dependency and resolve the namespace. The solution is to copy a connection string from the Azure Storage account and paste it into the Functions App Service Settings blade's Application Settings under "Connection Strings". This effectively makes the string available to the Function in an environment variable at runtime. If our connection string is named StorageConnectionString
, and the type is "Custom", then the value will be available in the environment variable CUSTOMCONNSTR_StorageConnectionString
.
Here's the code I ended up with as shown in the editor in the Azure Portal.
#r "Microsoft.WindowsAzure.Storage"
using System; using Microsoft.WindowsAzure; using Microsoft.WindowsAzure.Storage; using Microsoft.WindowsAzure.Storage.Table;
public static void Run(object trigger) { var storage = CloudStorageAccount.Parse( Environment.GetEnvironmentVariable( "CUSTOMCONNSTR_StorageConnectionString")); var tableClient = storage.CreateCloudTableClient(); var membersTable = tableClient .GetTableReference("MyTable");
membersTable.CreateIfNotExists(); }
This file is a little weird because it is a csx file. There is some documentation in the Azure Functions Developer Reference but it's essentially C# with embedded assembly references (#r "Microsoft.WindowsAzure.Storage"
) and a top-level public static void Run
method. Any other classes etc. you need can be included inline in the file.
With the code in place, you have to switch to the 'integration' tab to enable a trigger so that the function can be run. I did the minimum needed to test the function and just selected a manual trigger, changed the name to "trigger", then switched back to the code view and hit the "Run" button at the bottom of the Function App blade. It took a few goes to get the code right, but with everything working, I was able to confirm that it worked by opening the storage account blade in the Azure Portal and looking at the list of Tables in the account. Sure enough, we have our shiny new table.
While creating a table programmatically is about the simplest use case I could think of for testing a Function, I must admit that it feels a bit forced to have to write code for this at all. I prefer Amazon's model of providing Console-based UIs for most of the core functionality, like creating tables and adding records. There are Storage Explorer tools for this on Azure, but it would be nice to be able to manage everything from the Portal.
There's a lot more ground to cover here: Function triggering, integration with other services, creating API endpoints and deployment automation are all considerations. I look forward to seeing how Azure Functions evolve in the future.