steampipe plugin install aws

Table: aws_efs_access_point - Query Amazon EFS Access Points using SQL

The Amazon Elastic File System (EFS) Access Points provide a customized view into an EFS file system. They enable applications to use a specific operating system user and group, and a directory in the file system as a root directory. By using EFS Access Points, you can enforce a user identity, permission strategy, and root directory for each application using the file system.

Table Usage Guide

The aws_efs_access_point table in Steampipe provides you with information about Access Points within Amazon Elastic File System (EFS). This table enables you, as a DevOps engineer, system administrator, or other technical professional, to query access point-specific details, including the file system it is associated with, its access point ID, and other related metadata. You can utilize this table to gather insights on access points, such as their operating system type, root directory creation info, and more. The schema outlines the various attributes of the access point for you, including the access point ARN, creation time, life cycle state, and associated tags.

Examples

Basic info

Analyze the settings to understand the status and ownership of various access points within Amazon Elastic File System (EFS). This can help in assessing the elements within your EFS, pinpointing specific locations where changes might be needed.

select
name,
access_point_id,
access_point_arn,
file_system_id,
life_cycle_state,
owner_id,
root_directory
from
aws_efs_access_point;
select
name,
access_point_id,
access_point_arn,
file_system_id,
life_cycle_state,
owner_id,
root_directory
from
aws_efs_access_point;

List access points for each file system

Identify the access points associated with each file system to gain insights into file ownership and root directory details. This can be useful for managing and auditing file system access within an AWS environment.

select
name,
access_point_id,
file_system_id,
owner_id,
root_directory
from
aws_efs_access_point
select
name,
access_point_id,
file_system_id,
owner_id,
root_directory
from
aws_efs_access_point

List access points in the error lifecycle state

Identify instances where access points in the AWS Elastic File System are in an error state. This could be useful in diagnosing system issues or assessing overall system health.

select
name,
access_point_id,
life_cycle_state,
file_system_id,
owner_id,
root_directory
from
aws_efs_access_point
where
life_cycle_state = 'error';
select
name,
access_point_id,
life_cycle_state,
file_system_id,
owner_id,
root_directory
from
aws_efs_access_point
where
life_cycle_state = 'error';

Schema for aws_efs_access_point

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
access_point_arntextThe unique Amazon Resource Name (ARN) associated with the access point.
access_point_idtext=The ID of the access point, assigned by Amazon EFS.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
client_tokentextThe opaque string specified in the request to ensure idempotent creation.
file_system_idtext=The ID of the EFS file system that the access point applies to.
life_cycle_statetextIdentifies the lifecycle phase of the access point.
nametextThe name of the access point. This is the value of the Name tag.
owner_idtextIdentified the AWS account that owns the access point resource.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
posix_userjsonbThe full POSIX identity, including the user ID, group ID, and secondary group IDs on the access point that is used for all file operations by NFS clients using the access point.
regiontextThe AWS Region in which the resource is located.
root_directoryjsonbThe directory on the Amazon EFS file system that the access point exposes as the root directory to NFS clients using the access point.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
tagsjsonbA map of tags for the resource.
tags_srcjsonbThe tags associated with the access point, presented as an array of Tag objects.
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_efs_access_point