How to retrieve SQL Database price with SQL Licence, using the azure retail prices

Pedro Zuzi 21 Reputation points
2024-04-19T17:46:24.72+00:00

Hello,
I'm trying to retrive the SQL Database prices using the Azure Retail Prices API, but I'm not finding the SQL license price, i'm finding only the "hardware" price

Example using powershell:

$url = "https://prices.azure.com/api/retail/prices?currencyCode='BRL'&`$filter=serviceName eq 'SQL Database' and armRegionName eq 'eastus2' and meterName eq 'vCore'"

Anyone knows how to retrieve, in Azure SQL Database, the SQL Licence price in API?

In Azure Calculator we can find the SQL LicenceUser's image

Thanks in advance

Azure SQL Database
Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,142 questions
0 comments No comments
{count} votes

Accepted answer
  1. TP 79,156 Reputation points
    2024-04-20T13:31:31.5533333+00:00

    Hi Pedro,

    Please try using below URL:

    https://prices.azure.com/api/retail/prices?currencyCode='BRL'&$filter=serviceName eq 'SQL Database' and armRegionName eq 'Global' and meterName eq 'vCore' and priceType eq 'Consumption'
    

    Output from above:

    {
        "BillingCurrency": "BRL",
        "CustomerEntityId": "Default",
        "CustomerEntityType": "Retail",
        "Items": [
            {
                "currencyCode": "BRL",
                "tierMinimumUnits": 0.0,
                "retailPrice": 0.4989,
                "unitPrice": 0.4989,
                "armRegionName": "Global",
                "location": "Global",
                "effectiveStartDate": "2019-07-01T00:00:00Z",
                "meterId": "5fb02b75-1418-4fd0-8c07-dd5949d007dd",
                "meterName": "vCore",
                "productId": "DZH318Z0BXVM",
                "skuId": "DZH318Z0BXVM/001B",
                "productName": "SQL Database SingleDB/Elastic Pool Hyperscale - SQL License",
                "skuName": "vCore",
                "serviceName": "SQL Database",
                "serviceId": "DZH3180HX10K",
                "serviceFamily": "Databases",
                "unitOfMeasure": "1 Hour",
                "type": "Consumption",
                "isPrimaryMeterRegion": true,
                "armSkuName": ""
            },
            {
                "currencyCode": "BRL",
                "tierMinimumUnits": 0.0,
                "retailPrice": 0.4989,
                "unitPrice": 0.4989,
                "armRegionName": "Global",
                "location": "Global",
                "effectiveStartDate": "2018-07-15T00:00:00Z",
                "meterId": "6f344f4b-7c91-4026-915a-a1b597793be1",
                "meterName": "vCore",
                "productId": "DZH318Z0BQDL",
                "skuId": "DZH318Z0BQDL/001H",
                "productName": "SQL Database Single/Elastic Pool General Purpose - SQL License",
                "skuName": "vCore",
                "serviceName": "SQL Database",
                "serviceId": "DZH3180HX10K",
                "serviceFamily": "Databases",
                "unitOfMeasure": "1 Hour",
                "type": "Consumption",
                "isPrimaryMeterRegion": true,
                "armSkuName": ""
            },
            {
                "currencyCode": "BRL",
                "tierMinimumUnits": 0.0,
                "retailPrice": 1.8714,
                "unitPrice": 1.8714,
                "armRegionName": "Global",
                "location": "Global",
                "effectiveStartDate": "2018-07-15T00:00:00Z",
                "meterId": "e9889554-fb00-4e00-bb08-21788c9d0dc8",
                "meterName": "vCore",
                "productId": "DZH318Z0BQDK",
                "skuId": "DZH318Z0BQDK/001K",
                "productName": "SQL Database Single/Elastic Pool Business Critical - SQL License",
                "skuName": "vCore",
                "serviceName": "SQL Database",
                "serviceId": "DZH3180HX10K",
                "serviceFamily": "Databases",
                "unitOfMeasure": "1 Hour",
                "type": "Consumption",
                "isPrimaryMeterRegion": true,
                "armSkuName": ""
            }
        ],
        "NextPageLink": null,
        "Count": 3
    }
    
    

    Please click Accept Answer and upvote if the above was helpful.

    Thanks.

    -TP


0 additional answers

Sort by: Most helpful