Table: aiven_account - Query Aiven Accounts using SQL

Aiven Account is a resource within Aiven's cloud-native database management system that represents the account of a user or organization. It provides a centralized way to manage and monitor the usage of various Aiven services, including databases, data pipelines, and more. Aiven Account helps users stay informed about the status and performance of their Aiven resources.

Table Usage Guide

The aiven_account table provides insights into Aiven Accounts within Aiven's cloud-native database management system. As a database administrator or DevOps engineer, explore account-specific details through this table, including account ID, name, owner, and creation time. Utilize it to uncover information about accounts, such as their current status, usage of Aiven services, and the management of resources.

Examples

Basic info

Explore which Aiven accounts have billing enabled and when they were created to manage and optimize your financial resources effectively. This is useful for assessing cost efficiency and tracking the timeline of account creation.

select
  id,
  name,
  billing_enabled,
  create_time,
  tenant_id
from
  aiven_account;

select
  id,
  name,
  billing_enabled,
  create_time,
  tenant_id
from
  aiven_account;

List accounts with billing enabled

Explore which accounts have billing enabled. This can be useful for financial auditing or to identify accounts that are incurring charges.

select
  id,
  name,
  billing_enabled,
  create_time,
  tenant_id
from
  aiven_account
where
  billing_enabled;

select
  id,
  name,
  billing_enabled,
  create_time,
  tenant_id
from
  aiven_account
where
  billing_enabled = 1;

List projects of each account

Uncover the details of each account's projects, including their available credits, default cloud, estimated balance, and payment method. This information can be useful for financial management and resource allocation.

select
  a.name as account_name,
  p.name as project_name,
  available_credits,
  default_cloud,
  estimated_balance,
  payment_method
from
  aiven_account as a,
  aiven_project as p
where
  a.id = p.account_id;

select
  a.name as account_name,
  p.name as project_name,
  available_credits,
  default_cloud,
  estimated_balance,
  payment_method
from
  aiven_account as a,
  aiven_project as p
where
  a.id = p.account_id;

Schema for aiven_account

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
billing_enabled	boolean		Check if the billing is enabled for the account.
create_time	timestamp with time zone		The create time of the account.
id	text	=	The account ID.
name	text		The account name.
owner_team_id	text		The owner team ID of the account.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tenant_id	text		The tenant ID of the account.
update_time	timestamp with time zone		The update time of the account.

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_account