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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
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