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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The AWS Account ID in which the resource is located.
admin_password_secret_arn	text		The Amazon Resource Name (ARN) for the namespace's admin user credentials secret.
admin_password_secret_kms_key_id	text		The ID of the Key Management Service (KMS) key used to encrypt and store the namespace's admin credentials secret.
admin_username	text		The username of the administrator for the first database created in the namespace.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
creation_date	timestamp with time zone		The creation date of the namespace.
db_name	text		The name of the first database created in the namespace.
default_iam_role_arn	text		The Amazon Resource Name (ARN) of the IAM role to set as a default in the namespace.
iam_roles	jsonb		A list of IAM roles to associate with the namespace.
kms_key_id	text		The ID of the Amazon Web Services Key Management Service key used to encrypt your data.
log_exports	jsonb		The types of logs the namespace can export. Available export types are User log, Connection log, and User activity log.
namespace_arn	text		The Amazon Resource Name (ARN) that links to the namespace.
namespace_id	text		The unique identifier of the namespace.
namespace_name	text	=	The name of the namespace.
partition	text		The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text		The AWS Region in which the resource is located.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The status of the namespace.
tags	jsonb		A map of tags for the resource.
tags_src	jsonb		The list of tags for the namespace.
title	text		Title 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