SSIS Components for Azure Data Management

Build 20.0.7587

RateCards

Query the resource/meter metadata and related prices used in a given subscription.

Table Specific Information

The component will use the Azure Data Management APIs to process the following filters and will process other filters client-side within itself.
  • Offer ID
  • ResourceCurrency
  • ResourceLocale
  • RegionInfo
For example, the following query is processed server side:
SELECT * FROM RateCards WHERE OfferId='MS-AZR-0003P' AND ResourceCurrency='USD' AND ResourceLocale='en-US' AND RegionInfo='US'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Columns

Name Type Description
OfferId String Set OfferId to a valid Offer ID code (e.g., MS-AZR-0026P). The default value is 'MS-AZR-0003P'.
ResourceCurrency String The currency in which the resource rates need to be provided. The default value is 'USD'.
ResourceLocale String The culture in which the resource metadata needs to be localized. The default value is 'en-US'.
RegionInfo String The 2 letter ISO code where the offer was purchased. The default value is 'US'.
SubscriptionId String The subscription ID.
OfferTerms String Azure offer terms for the specified SubscriptionId.
MeterId String The unique identifier of the resource.
MeterName String The name of the meter, within the given meter category.
MeterCategory String The category of the meter, e.g., 'Cloud services', 'Networking', etc..
MeterSubCategory String The subcategory of the meter, e.g., 'A6 Cloud services', 'ExpressRoute (IXP)', etc..
MeterUnit String The unit in which the meter consumption is charged, e.g., 'Hours', 'GB', etc.
MeterRateKey Integer The meter quantity.
MeterRateValue Decimal The corresponding price for the specified MeterRateKey
MeterEffectiveDate String Indicates the date from which the meter rate is effective.
MeterIncludedQuantity String The resource quantity that is included in the offer at no cost. Consumption beyond this quantity will be charged.
MeterStatus String Indicates whether the MeterId is 'Active' or 'Deprecated'.
Currency String The currency in which the rates are provided.
Locale String The culture in which the resource information is localized.
IsTaxIncluded Boolean All rates are pretax, so this will always be returned as False.
MeterRegion String The region in which the Azure service is available.
Tags String Provides additional meter data. Third Party indicates a meter with no discount. Blanks indicate First Party.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587