Skip to content
AWS for Query.Farm

aws.billingconductor.list_pricing_rules

Example SQL Queries

SELECT * FROM
aws.billingconductor.list_pricing_rules;

Description

Describes a pricing rule that can be associated to a pricing plan, or set of pricing plans.

Table Definition

Column NameColumn Data Type
billing_period Input Column

The billing period for which the described pricing rules are applicable. 

VARCHAR
filters Input Column

A DescribePricingRuleFilter that specifies the Amazon Resource Name (ARNs) of pricing rules to retrieve pricing rules information. 

STRUCT(
    "arns" VARCHAR[]
)
Show child fields
filters.arns[]
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

pricing_rules

A list containing the described pricing rules. 

STRUCT(
    "name" VARCHAR,
    "arn" VARCHAR,
    "description" VARCHAR,
    "scope" VARCHAR,
    "type" VARCHAR,
    "modifier_percentage" DOUBLE,
    "service" VARCHAR,
    "associated_pricing_plan_count" BIGINT,
    "creation_time" BIGINT,
    "last_modified_time" BIGINT,
    "billing_entity" VARCHAR,
    "tiering" STRUCT(
        "free_tier" STRUCT(
            "activated" BOOLEAN
        )
    ),
    "usage_type" VARCHAR,
    "operation" VARCHAR
)[]
Show child fields
pricing_rules[]
Show child fields
pricing_rules[].arn

The Amazon Resource Name (ARN) used to uniquely identify a pricing rule.

pricing_rules[].associated_pricing_plan_count

The pricing plans count that this pricing rule is associated with.

pricing_rules[].billing_entity

The seller of services provided by Amazon Web Services, their affiliates, or third-party providers selling services via Amazon Web Services Marketplace.

pricing_rules[].creation_time

The time when the pricing rule was created.

pricing_rules[].description

The pricing rule description.

pricing_rules[].last_modified_time

The most recent time when the pricing rule was modified.

pricing_rules[].modifier_percentage

A percentage modifier applied on the public pricing rates.

pricing_rules[].name

The name of a pricing rule.

pricing_rules[].operation

Operation is the specific Amazon Web Services action covered by this line item. This describes the specific usage of the line item.

If the Scope attribute is set to SKU, this attribute indicates which operation the PricingRule is modifying. For example, a value of RunInstances:0202 indicates the operation of running an Amazon EC2 instance.

pricing_rules[].scope

The scope of pricing rule that indicates if it is globally applicable, or if it is service-specific.

pricing_rules[].service

If the Scope attribute is SERVICE, this attribute indicates which service the PricingRule is applicable for.

pricing_rules[].tiering

The set of tiering configurations for the pricing rule.

Show child fields
pricing_rules[].tiering.free_tier

The possible Amazon Web Services Free Tier configurations.

Show child fields
pricing_rules[].tiering.free_tier.activated

Activate or deactivate Amazon Web Services Free Tier application.

pricing_rules[].type

The type of pricing rule.

pricing_rules[].usage_type

Usage type is the unit that each service uses to measure the usage of a specific type of resource.

If the Scope attribute is set to SKU, this attribute indicates which usage type the PricingRule is modifying. For example, USW2-BoxUsage:m2.2xlarge describes an M2 High Memory Double Extra Large instance in the US West (Oregon) Region. 

</p>