Table: openstack_project

A project (tenant) is a container for cloud resources. OpenStack software components split their resources into multiple projects. A project can be part of only one domain.

Examples

Basic project info

select
  name,
  description,
  is_domain,
  domain_id,
  enabled,
  id
from
  openstack_project;

Project by ID

select
  name,
  description,
  is_domain,
  domain_id,
  enabled,
  id
from
  openstack_project
where
  id = '460f07e045ba4f5fbe35573739073c39';

All active projects

select
  name,
  description,
  is_domain,
  domain_id,
  enabled,
  id
from
  openstack_project
where
  enabled = true;

All projects that are a domain

select
  name,
  description,
  is_domain,
  domain_id,
  enabled,
  id
from
  openstack_project
where
  is_domain = true;

All projects of the default domain

select
  name,
  description,
  is_domain,
  domain_id,
  enabled,
  id
from
  openstack_project
where
  domain_id = 'default';

Schema for openstack_project

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
description	text		Description is the description of the project.
domain_id	text		DomainID is the domain ID the project belongs to.
enabled	boolean		Enabled is whether or not the project is enabled.
id	text	=	ID is the unique ID of the project.
is_domain	boolean		IsDomain indicates whether the project is a domain.
name	text		Name is the name of the project.
options	text		Options are defined options in the API to enable certain features.
parent_id	text		ParentID is the parent_id of the project.
tags	text		Tags is the list of tags associated with the project.