steampipe plugin install awssteampipe plugin install aws

Table: aws_sagemaker_notebook_instance

An Amazon SageMaker notebook instance is a machine learning (ML) compute instance running the Jupyter Notebook App.

Examples

Basic info

select
  name,
  arn,
  creation_time,
  instance_type,
  notebook_instance_status
from
  aws_sagemaker_notebook_instance;

List notebook instances that do not have encryption at rest enabled

select
  name,
  kms_key_id
from
  aws_sagemaker_notebook_instance
where
  kms_key_id is null;

List publicly available notebook instances

select
  name,
  direct_internet_access
from
  aws_sagemaker_notebook_instance
where
  direct_internet_access = 'Disabled';

List notebook instances that allow root access

select
  name,
  root_access
from
  aws_sagemaker_notebook_instance
where
  root_access = 'Enabled';

Query examples

Control examples

.inspect aws_sagemaker_notebook_instance

AWS Sagemaker Notebook Instance

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
accelerator_types	jsonb	The list of the Elastic Inference (EI) instance types associated with this notebook instance.
account_id	text	The AWS Account ID in which the resource is located.
additional_code_repositories	jsonb	An array of up to three Git repositories associated with the notebook instance.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
arn	text	The Amazon Resource Name (ARN) of the notebook instance.
creation_time	timestamp with time zone	A timestamp that shows when the notebook instance was created.
default_code_repository	text	The Git repository associated with the notebook instance as its default code repository.
direct_internet_access	text	Describes whether Amazon SageMaker provides internet access to the notebook instance.
failure_reason	text	If status is Failed, the reason it failed.
instance_type	text	The type of ML compute instance that the notebook instance is running on.
kms_key_id	text	The AWS KMS key ID Amazon SageMaker uses to encrypt data when storing it on the ML storage volume attached to the instance.
last_modified_time	timestamp with time zone	A timestamp that shows when the notebook instance was last modified.
name	text	The name of the notebook instance.
network_interface_id	text	The network interface IDs that Amazon SageMaker created at the time of creating the instance.
notebook_instance_lifecycle_config_name	text	The name of a notebook instance lifecycle configuration associated with this notebook instance.
notebook_instance_status	text	The status of the notebook instance.
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.
role_arn	text	The Amazon Resource Name (ARN) of the IAM role associated with the instance.
root_access	text	Whether root access is enabled or disabled for users of the notebook instance.Lifecycle configurations need root access to be able to set up a notebook instance
security_groups	jsonb	The IDs of the VPC security groups.
subnet_id	text	The ID of the VPC subnet.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	The list of tags for the notebook instance.
title	text	Title of the resource.
url	text	The URL that you use to connect to the Jupyter notebook that is running in your notebook instance.
volume_size_in_gb	bigint	The size, in GB, of the ML storage volume attached to the notebook instance.

turbot/aws