Recently, I have had to automate a process to generate csv files and upload them to a certain folder in Azure blob storage. Here is the powershell code that does just that. After some research online, I have put together couple of solutions into one that worked well for me.
In order for this to work, you will need to install Azure powershell module on your machine. This solution assumes you are authenticating using account name and storage account key
#Upload csv files to Azure Blob Storage
$ErrorActionPreference = "Stop"
$acct = "storage-account-name" #Storage Account Name
$key = "storage-account-key" #Storage Account Key
$ContainerName = "container-name" #Container Name
$containerdirectory = "subfolder path within the container"
$localfilepath = "local-file-directory"
#create a context for communicating with azure storage
$ctx = New-AzStorageContext -StorageAccountName $acct -StorageAccountKey $key -Protocol Https
$container = Get-AzStorageContainer -Name $ContainerName -Context $ctx
$container.CloudBlobContainer.Uri.AbsoluteUri
if ($container) {
#use Set-AzStorageBlobContent to upload file
$filesToUpload = Get-Childitem -Path $localfilepath -Filter "*.csv"
ForEach ($x in $filesToUpload) {
$targetPath = $containerdirectory+($x.fullname.Substring($localfilepath.Length)).Replace("\", "/")
Write-Verbose "Uploading $("\" + $x.fullname.Substring($localfilepath.Length)) to $($container.CloudBlobContainer.Uri.AbsoluteUri + "/" + $targetPath)"
Set-AzStorageBlobContent -File $x.fullname -Container $container.Name -Blob $targetPath -Context $ctx -Force:$Force | Out-Null
}
}
Database Blog 