Table: aiven_service - Query Aiven Cloud Services using SQL

Aiven Cloud Services is a comprehensive platform that offers managed open-source data technologies, including databases, message queues, and search engines. It allows users to deploy and manage these technologies on a variety of cloud platforms, providing flexibility and scalability. Aiven Cloud Services is designed to handle the complexity of managing and maintaining these technologies, enabling users to focus on their core business.

Table Usage Guide

The aiven_service table provides insights into the services offered within Aiven Cloud Services. As a DevOps engineer or a cloud architect, explore service-specific details through this table, including service configurations, plan details, and current status. Utilize it to manage and monitor your Aiven services, ensuring optimal configuration and performance.

Examples

Basic info

Analyze the settings to understand the status and type of each project within your Aiven service. This can help you assess the overall health of your projects and plan accordingly.

select
  name,
  project_name,
  state,
  plan,
  type,
  create_time
from
  aiven_service;

select
  name,
  project_name,
  state,
  plan,
  type,
  create_time
from
  aiven_service;

List premium services

Explore which services are categorized as premium in your project. This can help prioritize resource allocation and understand the cost structure better.

select
  name,
  project_name,
  state,
  plan,
  type,
  create_time
from
  aiven_service
where
  plan like 'Premium%';

select
  name,
  project_name,
  state,
  plan,
  type,
  create_time
from
  aiven_service
where
  plan like 'Premium%';

List services which are not running

Identify instances where certain services are not currently operational. This is useful in pinpointing areas for troubleshooting or optimizing system performance.

select
  name,
  project_name,
  state,
  plan,
  type,
  create_time
from
  aiven_service
where
  state <> 'RUNNING';

select
  name,
  project_name,
  state,
  plan,
  type,
  create_time
from
  aiven_service
where
  state <> 'RUNNING';

List services with termination protection disabled

Determine the areas in which services have termination protection disabled. This is useful in identifying potential vulnerabilities and ensuring all services are adequately protected.

select
  name,
  project_name,
  state,
  plan,
  type,
  create_time
from
  aiven_service
where
  not termination_protection;

select
  name,
  project_name,
  state,
  plan,
  type,
  create_time
from
  aiven_service
where
  termination_protection = 0;

List services with target cloud provider aws

Explore services hosted on AWS by examining their names, project affiliations, states, plans, types, and creation times. This helps in managing and monitoring services specific to AWS, aiding in efficient resource allocation and project planning.

select
  name,
  project_name,
  state,
  plan,
  type,
  create_time
from
  aiven_service
where
  cloud_name like 'aws%';

select
  name,
  project_name,
  state,
  plan,
  type,
  create_time
from
  aiven_service
where
  cloud_name like 'aws%';

Schema for aiven_service

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
acl	jsonb		List of Kafka ACL entries.
backups	jsonb		List of backups for the service.
cloud_name	text		The target cloud.
components	jsonb		Service component information objects.
connection_info	jsonb		Service-specific connection information properties.
connection_pools	jsonb		PostgreSQL PGBouncer connection pools.
create_time	timestamp with time zone		Service creation timestamp (ISO 8601).
integrations	jsonb		Integrations with other services.
maintenance_window	jsonb		Automatic maintenance settings.
metadata	jsonb		Service type specific metadata.
name	text	=	The service name.
node_count	bigint		Number of service nodes in the active plan.
node_states	jsonb		State of individual service nodes.
plan	text		The subscription plan.
powered	boolean		Power-on the service (true) or power-off (false).
project_name	text	=	The project name.
project_vpc_id	text		The Project VPC ID.
state	text		The state of the service.
termination_protection	boolean		Service is protected against termination and powering off.
type	text		Service type code.
update_time	timestamp with time zone		Service last update timestamp (ISO 8601).
uri	text		URI for connecting to the service (may be null).
uri_params	jsonb		Service URI parameterized into key-value pairs.
user_config	jsonb		Service type-specific settings.
users	jsonb		List of service users.

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_service