steampipe plugin install aiven

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,
city
from
aiven_billing_group;
select
id,
billing_group_name,
account_id,
card_id,
billing_currency,
city
from
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,
company
from
aiven_billing_group as g,
aiven_project as p
where
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,
company
from
aiven_billing_group as g,
aiven_project as p
where
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,
city
from
aiven_billing_group
where
company = 'Dunder Mifflin';
select
id,
billing_group_name,
account_id,
card_id,
billing_currency,
city
from
aiven_billing_group
where
company = 'Dunder Mifflin';

Schema for aiven_billing_group

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextThe account ID.
billing_currencytextThe billing currency.
billing_emailsjsonbList of project billing email addresses.
billing_extra_texttextExtra text to be included in all project invoices, e.g. purchase order or cost center number.
billing_group_nametextThe billing group name.
card_idtextCredit card assigned to the project.
citytextThe address city.
companytextThe name of a company.
country_codetextTwo letter ISO country code.
idtext=The billing group ID.
statetextThe address state.
vat_idtextEU VAT Identification Number.
zip_codetextThe 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