22-25 April 2026
Video unavailable
SQLBits 2022

Managing Stored Access Policies for Azure Service Principals

When using SAS Keys to access Azure Storage Containers, there is a problem with managing the expiry date; in that it is an immutable property.However, this is an alternative, by assigning a Stored Access Policy to a SAS Key we can manage the expiry date in our pipelines. We will disucss how to do this, and the challenges and other benefits when using Stored Access Policies.
When using SAS Keys to access Azure Storage Containers, there is a problem with managing the expiry date; in that it is an immutable property. This means that SAS Keys need to be re-created and the value refreshed, which can be time consuming and problematic. However, this is an alternative, by assigning a Stored Access Policy to a SAS Key we can manage the expiry date in our pipelines. We will disucss how to do this, and the challenges and other benefits when using Stored Access Policies.