Table: aiven_project_user - Query Aiven Project Users using SQL

An Aiven Project User is a user that has been granted access to a specific project within the Aiven platform. This user has certain permissions and roles within the project, which can include managing services, viewing billing information, and modifying project settings. Each user is associated with an email address, which is used as their unique identifier within the project.

Table Usage Guide

The aiven_project_user table provides insights into users within Aiven Projects. As a project manager or system administrator, explore user-specific details through this table, such as their email, access control rights, and associated metadata. Utilize it to uncover information about users, such as their permissions within a project, to ensure proper access control and security measures are in place.

Examples

Basic info

Explore which team members are associated with different projects in your organization. This can help in understanding the distribution of resources and roles within your projects.

select
  email,
  real_name,
  billing_contact,
  member_type,
  project_name,
  create_time,
  team_name
from
  aiven_project_user;

select
  email,
  real_name,
  billing_contact,
  member_type,
  project_name,
  create_time,
  team_name
from
  aiven_project_user;

List users of the turbot project

Explore which team members are part of the 'turbot' project. This can help in understanding the composition of the project team, including their roles and whether they are a billing contact.

select
  email,
  real_name,
  billing_contact,
  member_type,
  project_name,
  create_time,
  team_name
from
  aiven_project_user
where
  project_name = 'turbot';

select
  email,
  real_name,
  billing_contact,
  member_type,
  project_name,
  create_time,
  team_name
from
  aiven_project_user
where
  project_name = 'turbot';

List users with admin access in projects

Discover the segments that have users with administrative access in various projects. This is beneficial for understanding project control distribution and identifying potential security risks.

select
  email,
  real_name,
  billing_contact,
  member_type,
  project_name,
  create_time,
  team_name
from
  aiven_project_user
where
  member_type = 'admin';

select
  email,
  real_name,
  billing_contact,
  member_type,
  project_name,
  create_time,
  team_name
from
  aiven_project_user
where
  member_type = 'admin';

List users with no billing contact

Gain insights into the accounts where no billing contact has been assigned to the user. This is beneficial for identifying potential gaps in account management and ensuring all users have appropriate billing contacts.

select
  email,
  real_name,
  billing_contact,
  member_type,
  project_name,
  create_time,
  team_name
from
  aiven_project_user
where
  not billing_contact;

select
  email,
  real_name,
  billing_contact,
  member_type,
  project_name,
  create_time,
  team_name
from
  aiven_project_user
where
  billing_contact = 0;

List users who are not part of any team

Explore which users are not associated with any team, enabling you to identify potential areas of resource reallocation or team restructuring. This is particularly useful in assessing the overall distribution of users within your project.

select
  email,
  real_name,
  billing_contact,
  member_type,
  project_name,
  create_time
from
  aiven_project_user
where
  team_name = '';

select
  email,
  real_name,
  billing_contact,
  member_type,
  project_name,
  create_time
from
  aiven_project_user
where
  team_name = '';

Schema for aiven_project_user

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
auth_methods	jsonb		List of user's required authentication methods.
billing_contact	boolean		Set for project's billing contacts.
create_time	timestamp with time zone		Timestamp in ISO 8601 format, always in UTC.
email	text	=	User email address.
member_type	text		Project member type.
project_name	text	=	The project name.
real_name	text		User real name.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
team_id	text		The team ID.
team_name	text		The team name.

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_user