Last November, we announced the public preview of SQL as a storage provider for Azure Logic Apps (Standard). Using SQL as a storage provider provides customers with more options when it comes to running their workloads in the public cloud or on-premises. For additional guidance on when you may want to use SQL as a storage provider, please refer to our documentation.
During the public preview of this feature, we had the opportunity to work with customers to validate our architecture and feature set. Through these engagements, we discovered opportunities to improve our database schema and subsequently, performance improvements for workflow triggers and webhooks.
As a result of these schema changes, we will be releasing a refresh of SQL as a storage provider in the near future. To prepare for this refresh, we have some actions to be performed by customers. The SQL as a storage provider feature continues to be in preview and customers are required to take the following action to avoid unplanned disruptions.
Update AzureFunctionsJobHost__extensionBundle__version
Azure Logic Apps (Standard) uses an auto-update process to ensure customers are using the latest components. To prepare for the upcoming refresh, update your Logic Apps configuration to lock to a specific extension bundle version.
To lock into a specific extension bundle in the Azure Portal, modify extensionBundle setting from the Azure Portal by navigating to your Logic App instance and clicking on Configuration from the left pane. From there, locate the AzureFunctionsJobHost__extensionBundle__version attribute and click on it. Set the Value to be [1.1.35] and Save your changes.
After changing this value, restart your Logic App instance from the Overview settings page.
Alternatively, you can also update the extensionBundle from Visual Studio Code. Open host.json from your Logic Apps (Standard) project and update the version attribute to [1.1.35]. Subsequently save your configuration, deploy your project and restart your Logic App instance.
Note: By locking to the specific version of the extensionBundle [1.1.35], you will not receive updates to this Logic Apps (Standard) instance. This includes new built-in connectors and other features that have been released.
Please stay tuned to this blog for updates related to the SQL as a storage provider and other Azure Logic Apps features. We will update this post once the SQL as a storage provider (Preview) refresh has been released.