Table: aiven_billing_group - Query Aiven Billing Groups using SQL
Aiven Billing Groups are a feature that allows users to manage their Aiven services' billing under a single entity. It enables users to group their services together for easier invoicing and cost allocation. Billing Groups can be utilized across multiple projects, providing flexibility in managing costs and resources.
Table Usage Guide
The aiven_billing_group
table provides insights into Billing Groups within Aiven. As a financial analyst or a DevOps engineer, explore details of each billing group through this table, including their configurations, associated services, and usage. Utilize it to uncover information about billing groups, such as their costs, associated projects, and the allocation of resources.
Examples
Basic info
Explore which billing groups are associated with specific accounts and cards. This can be useful for understanding the financial structure of your organization and managing costs effectively.
select id, billing_group_name, account_id, card_id, billing_currency, cityfrom aiven_billing_group;
select id, billing_group_name, account_id, card_id, billing_currency, cityfrom aiven_billing_group;
Get billing group information for each project
Explore which billing groups are associated with each project to better manage and understand your organization's financial landscape. This is useful for financial planning, cost allocation, and understanding the overall billing structure of your projects.
select g.id as billing_group_id, g.billing_group_name, p.name as project_name, state, card_id, companyfrom aiven_billing_group as g, aiven_project as pwhere g.id = p.billing_group_id;
select g.id as billing_group_id, g.billing_group_name, p.name as project_name, state, card_id, companyfrom aiven_billing_group as g, aiven_project as pwhere g.id = p.billing_group_id;
Get billing group information for a specific company
Analyze the billing group details for a specific company to gain insights into the billing currency and location. This can be useful for financial planning and geographical analysis.
select id, billing_group_name, account_id, card_id, billing_currency, cityfrom aiven_billing_groupwhere company = 'Dunder Mifflin';
select id, billing_group_name, account_id, card_id, billing_currency, cityfrom aiven_billing_groupwhere company = 'Dunder Mifflin';
Schema for aiven_billing_group
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
account_id | text | The account ID. | |
billing_currency | text | The billing currency. | |
billing_emails | jsonb | List of project billing email addresses. | |
billing_extra_text | text | Extra text to be included in all project invoices, e.g. purchase order or cost center number. | |
billing_group_name | text | The billing group name. | |
card_id | text | Credit card assigned to the project. | |
city | text | The address city. | |
company | text | The name of a company. | |
country_code | text | Two letter ISO country code. | |
id | text | = | The billing group ID. |
state | text | The address state. | |
vat_id | text | EU VAT Identification Number. | |
zip_code | text | The address zip code. |
Export
This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.
You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh
script:
/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aiven
You can pass the configuration to the command with the --config
argument:
steampipe_export_aiven --config '<your_config>' aiven_billing_group