steampipe plugin install aws

Table: aws_redshiftserverless_namespace - Query AWS Redshift Serverless Namespace using SQL

The AWS Redshift Serverless Namespace is a component of Amazon Redshift, a fully managed, petabyte-scale data warehouse service in the cloud. It allows for the use of SQL, a standard querying language, to interact with and manage the data within the Redshift environment. This serverless feature provides on-demand, scalable capacity, making it easier to set up, operate, and scale a relational database.

Table Usage Guide

The aws_redshiftserverless_namespace table in Steampipe provides you with information about each namespace within an AWS Redshift Serverless cluster. This table allows you, as a DevOps engineer, to query namespace-specific details, including the namespace ARN, creation date, and associated metadata. You can utilize this table to gather insights on namespaces, such as the associated database, the owner of the namespace, and more. The schema outlines the various attributes of the Redshift Serverless Namespace for you, including the namespace ARN, creation date, and associated tags.

Examples

Basic info

Explore the basic information of your AWS Redshift Serverless namespaces such as their creation dates, regions, and statuses. This can help you understand the distribution and status of your resources for better resource management.

select
namespace_name,
namespace_arn,
namespace_id,
creation_date,
db_name,
region,
status
from
aws_redshiftserverless_namespace;
select
namespace_name,
namespace_arn,
namespace_id,
creation_date,
db_name,
region,
status
from
aws_redshiftserverless_namespace;

List all unavailable namespaces

Determine the areas in which AWS Redshift Serverless namespaces are not currently available. This can aid in troubleshooting or planning resource allocation.

select
namespace_name,
namespace_arn,
namespace_id,
creation_date,
db_name,
region,
status
from
aws_redshiftserverless_namespace
where
status <> 'AVAILABLE';
select
namespace_name,
namespace_arn,
namespace_id,
creation_date,
db_name,
region,
status
from
aws_redshiftserverless_namespace
where
status != 'AVAILABLE';

List all unencrypted namespaces

Identify instances where namespaces are not encrypted in order to enhance security measures and protect sensitive data. This can help in preventing unauthorized access and potential data breaches.

select
namespace_name,
namespace_arn,
namespace_id,
creation_date,
db_name,
region,
status
from
aws_redshiftserverless_namespace
where
kms_key_id is null;
select
namespace_name,
namespace_arn,
namespace_id,
creation_date,
db_name,
region,
status
from
aws_redshiftserverless_namespace
where
kms_key_id is null;

Get default IAM role ARN associated with each namespace

Explore which default IAM roles are associated with each namespace to better understand your AWS Redshift serverless configurations. This can be useful in identifying potential security risks or misconfigurations in your AWS environment.

select
namespace_name,
namespace_arn,
namespace_id,
creation_date,
default_iam_role_arn
from
aws_redshiftserverless_namespace;
select
namespace_name,
namespace_arn,
namespace_id,
creation_date,
default_iam_role_arn
from
aws_redshiftserverless_namespace;

Schema for aws_redshiftserverless_namespace

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
admin_password_secret_arntextThe Amazon Resource Name (ARN) for the namespace's admin user credentials secret.
admin_password_secret_kms_key_idtextThe ID of the Key Management Service (KMS) key used to encrypt and store the namespace's admin credentials secret.
admin_usernametextThe username of the administrator for the first database created in the namespace.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
creation_datetimestamp with time zoneThe creation date of the namespace.
db_nametextThe name of the first database created in the namespace.
default_iam_role_arntextThe Amazon Resource Name (ARN) of the IAM role to set as a default in the namespace.
iam_rolesjsonbA list of IAM roles to associate with the namespace.
kms_key_idtextThe ID of the Amazon Web Services Key Management Service key used to encrypt your data.
log_exportsjsonbThe types of logs the namespace can export. Available export types are User log, Connection log, and User activity log.
namespace_arntextThe Amazon Resource Name (ARN) that links to the namespace.
namespace_idtextThe unique identifier of the namespace.
namespace_nametext=The name of the namespace.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statustextThe status of the namespace.
tagsjsonbA map of tags for the resource.
tags_srcjsonbThe list of tags for the namespace.
titletextTitle of the resource.

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)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_redshiftserverless_namespace