Working with Azure Storage Tables from PowerShell

  • Article

Hello, AzureRmStorageTable got a major update, now it is v2.0 and you can find a newer version of this post at my new blog: https://paulomarquesc.github.io/working-with-azure-storage-tables-from-powershell

Comments

  • Anonymous
    January 26, 2017
    Thanks, this is excellent and desperately needed. Any plans to add this to the Azure PowerShell module?
    • Anonymous
      January 31, 2017
      Hi Felix,I'm talking to the product group but no plans so far.RegardsPaulo
  • Anonymous
    February 01, 2017
    The comment has been removed
    • Anonymous
      February 02, 2017
      The comment has been removed
      • Anonymous
        February 07, 2017
        Thanks Paulo, I have everything working now!!One thing I am still a bit confused about is the fact that you reference the SDK path vs the default PSGet\Install-Module target folder (C:\Program Files\WindowsPowershell). Since there are two "correct ways" of acquire these modules\dll's, do you think you might be able to check both the SDK and PSGet paths for the proper dll's during your validation checks? I had a few discussions with our PFE and people in the Powershell product group to try to better understand these two acquisition methods, so I think this might be the way to go. Let me know what you think and thanks again for this great module. :)
        • Anonymous
          February 10, 2017
          Yep, I completely forgot about the module installed via Install-Module, I always use the web platform installer. I'll add support for those folders as well.
          • Anonymous
            February 11, 2017
            Thank you sir. :D
  • Anonymous
    March 01, 2017
    Excellent. Thanks Paulo. Tao Yang also wrote a module to do pretty much the same. Thanks a lot guys.http://blog.tyang.org/2016/11/30/powershell-module-for-managing-azure-table-storage-entities/
  • Anonymous
    March 28, 2017
    Thanks for the article, I was just wondering is there a way to modify an existing row such that you can add an attribute to it. Currently when i try to modify a row with an attribute that does not exist, I get an exception saying The property 'something' cannot be found on this object.
  • Anonymous
    April 04, 2017
    A guy much wiser then myself showed me how to upload the .zip without the .dlls in azure automation ... and without all the load .dllsAt the top of the psm1 put this:#Requires -Modules AzureRM.Profile, AzureRM.Storage, AzureRM.Resources, Azure.StorageAzure will load the modules that you already installed, just make sure the modules are installed in azure automation module list.Also place all the files in a folder with the same name as the psm1 then zip the folder.
  • Anonymous
    May 06, 2017
    Hi!Very cool module, it looks like a very nice, but missing part, of Azure PS Module from azure.com website. It is so cool, that I even want to add my contribution to it. I have added a support for using empty string values for partition keys and row keys. You can find my pull request here https://github.com/paulomarquesc/AzureRmStorageTable/pull/3.
    • Anonymous
      May 08, 2017
      Hi Anton,Thank you for the great contribution, I just approved the merge and published a new version in the PowerShell Gallery.RegardsPaulo
  • Anonymous
    May 24, 2017
    The comment has been removed
    • Anonymous
      May 24, 2017
      this error went away after i installed azure storage explorer, there might be a dependency there
      • Anonymous
        May 25, 2017
        Hi Peter, please see my last comment, bug was fixed last night with a new version of the module.
    • Anonymous
      May 25, 2017
      Hi Peter,I had a issue with 1.0.0.10 version, a bug in the Add-StorageTableRow that I fixed yesterday on 1.0.0.11 version. The storage explorer may have been a workaround but I officially fixed yesterday :-).BTW, after you build your automation, if you can share your use-case for that, it will be cool.RegardsPaulo
  • Anonymous
    September 19, 2017
    The comment has been removed
    • Anonymous
      September 21, 2017
      Hi Gene,Thanks, I just updated it.RegardsPaulo
  • Anonymous
    October 05, 2017
    Any plans to support PowerShell Core?
    • Anonymous
      October 09, 2017
      Hi Adam,Not yet, but will investigate the dependencies to check if it is feasible at this time.RegardsPaulo
  • Anonymous
    November 16, 2017
    Hey, When running Add-StorageTableRow, i get the below error:New-Object : Cannot find type [Microsoft.WindowsAzure.Storage.Table.DynamicTableEntity, Microsoft.WindowsAzure.Storage, Version=1.0.0.0, Culture=neutral, PublicKeyToken=#############]: verify that the assembly containing this type is loaded.I have PS 5.1, Azure Powershell Module and Storage Explorer installed.Any help would be appreciated,Thanks Matt
    • Anonymous
      November 19, 2017
      Hi Matt,I could not reproduce your issue, in order to make this better to troubleshoot, can you please open an issue at https://github.com/paulomarquesc/AzureRmStorageTable/issues ? That's where the project is hosted and it is better suited for tracking issues that here.This module does not have the requirement for Azure Storage Explorer, of course it can be installed for visualizing your data better but it is not a requirement. If working with Azure Storage Tables (not Cosmos DB because there are other requirements there) the following modules are the required ones (version 4 and up):AzureRM.ProfileAzureRM.StorageAzureRM.ResourcesAzure.StorageThose are the only requirements.When opening the issue can you please provide the following information:1) Output of $psversiontable from Powershell2) Output from "get-module -name azure -listavailable"3) Exact reproduction stepsRegardsPaulo
  • Anonymous
    December 29, 2017
    The comment has been removed
    • Anonymous
      January 08, 2018
      The comment has been removed