For private containers, create an AUTHORIZATION object with your storage account credentials:
CREATE AUTHORIZATION MyAzureAuth
AS DEFINER TRUSTED
USER 'mystorageaccount' -- Storage Account Name
PASSWORD '*****************'; -- Access Key or SAS Token