Azure SQL Database pricing api

Question

I am looking for any pricing api which can give us the pricing of a given database family.

For ex: I have the currentSKU details as below, so if I pass the family and tier of a database then it will return all the databases with price of that family and tier.

 "currentSku": {
        "name": "GP_Gen5",
        "tier": "GeneralPurpose",
        "family": "Gen5",
        "capacity": 2
  }

So in above example, it should return all the GeneralPurpose Gen5 Azure SQL databases with all vCore capacity.. 2, 4, and so on... with pricing.

Answer 1

Hi @Vikas Neekhra , welcome to Microsoft Q&A forum.

Using REST APIs, I think we don't have the way to list the databases using SKU as filter but we can use PowerShell commandlet like below to get the list of databases by providing the filters:

Get-AzSqlDatabase -ServerName <Name of Server> -ResourceGroupName <Name of Resource groups> | Where-Object {$_.SkuName -like 'GP_Gen5' -and $_.Edition -like 'GeneralPurpose'}    

Please let me know if this is helpful or else we can discuss further.