Table: aiven_project - Query Aiven Projects using SQL

Aiven Projects encapsulate a collection of services and are the main level of separation between different environments within Aiven. They provide a way to manage access controls and billing where the cost of all services under a project are combined into a single invoice. Aiven Projects are essential for managing and organizing resources in Aiven.

Table Usage Guide

The aiven_project table provides insights into projects within Aiven. As a cloud engineer, explore project-specific details through this table, including the project's ID, name, and creation time. Utilize it to manage and organize your resources effectively within Aiven.

Examples

Basic info

Explore which Aiven projects have available credits and their estimated balances. This can be useful to manage budgets, by identifying which projects are nearing their credit limit and may require additional funding or cost control measures.

select
  name,
  account_id,
  available_credits,
  default_cloud,
  estimated_balance,
  payment_method
from
  aiven_project;

select
  name,
  account_id,
  available_credits,
  default_cloud,
  estimated_balance,
  payment_method
from
  aiven_project;

List projects with estimated bill greater than 50 USD

Explore which projects have an estimated bill greater than 50 USD to monitor and manage your budget effectively. This allows you to assess your financial commitments and plan for future expenses.

select
  name,
  account_id,
  available_credits,
  default_cloud,
  estimated_balance,
  payment_method
from
  aiven_project
where
  estimated_balance :: float > 50;

select
  name,
  account_id,
  available_credits,
  default_cloud,
  estimated_balance,
  payment_method
from
  aiven_project
where
  CAST(estimated_balance AS REAL) > 50;

List projects where services are not running

Explore which projects have services that are not currently operational. This can help in identifying potential issues and ensuring all services are running as expected.

select
  p.name as project_name,
  account_id,
  available_credits,
  default_cloud,
  estimated_balance,
  payment_method
from
  aiven_project as p,
  aiven_service as s
where
  p.name = s.project_name
  and s.state <> 'RUNNING';

select
  p.name as project_name,
  account_id,
  available_credits,
  default_cloud,
  estimated_balance,
  payment_method
from
  aiven_project as p,
  aiven_service as s
where
  p.name = s.project_name
  and s.state <> 'RUNNING';

List projects where default cloud provider is aws

Discover the projects that have AWS as their default cloud provider. This can be useful to assess the distribution of your projects across different cloud platforms.

select
  name,
  account_id,
  available_credits,
  default_cloud,
  estimated_balance,
  payment_method
from
  aiven_project
where
  default_cloud like 'aws%';

select
  name,
  account_id,
  available_credits,
  default_cloud,
  estimated_balance,
  payment_method
from
  aiven_project
where
  default_cloud like 'aws%';

Schema for aiven_project

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text		The account ID.
available_credits	text		Available credits, in USD.
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_id	text		Billing group ID.
billing_group_name	text		Billing group name.
card	jsonb		Credit card assigned to the project.
copy_from_project	text		Project name from which to copy settings to the new project.
country	text		The country.
country_code	text		Two letter ISO country code.
default_cloud	text		Default cloud to use when launching services.
estimated_balance	text		Estimated balance, in USD.
name	text	=	The project name.
payment_method	text		The payment method.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
technical_emails	jsonb		List of technical email addresses.
vat_id	text		EU VAT Identification Number.

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_project