Optimizing Azure Table Storage: Automated Data Clean-up using a PowerShell script with Azure Automat

Connect-AzAccount-ID

$SubscriptionID = “xxxxxxxxxxxxxxxxxx”
$AzureContext = Set-AzContext –Subscription ID $Subscription ID
Update-AzConfig -DisplaySecretsWarning $false

$StorageAccount = “xxxxxxxxxxxxxxxxxx”
$StorageAccountKey = “xxxxxxxxxxxxxxxxxx”

$ctx = New-AzStorageContext -StorageAccountName $StorageAccount -StorageAccountKey $StorageAccountKey

$alltablename = (Get-AzStorageTable –Context $ctx).cloudtable

foreach ($table in $alltablename)

{
$tabledata = Get-AzTableRow -Table $table -CustomFilter “Timestamp gt DateTime ‘YYYY-MM-DDThh:mm:ssZ’ ” |
Remove-AzTableRow -Table $table
}

#disclaimer
# The sample scripts are not supported under any Microsoft standard support program or service. The sample scripts are provided AS IS, WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK ARISING OUT OF THE USE OR PERFORMANCE OF THE SAMPLE Scripts AND THE DOCUMENTATION REMAINS WITH YOU. IN NO EVENT SHALL MICROSOFT, ITS AUTHORS, THE OWNER OF THIS REPOSITORY, OR ANY OTHER PERSON INVOLVED IN THE CREATION, PRODUCTION, OR DELIVERING OF THE SAMPLE Scripts BE LIABLE FOR ANY DAMAGES WHATSOEVER (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF DATA,
#Without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss arising out of the use of or inability to use the sample script or documentation (except for damages for such damages), even if Microsoft has been advised of the possibility of such damages.