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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
access_point_arn	text		The unique Amazon Resource Name (ARN) associated with the access point.
access_point_id	text	=	The ID of the access point, assigned by Amazon EFS.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The AWS Account ID in which the resource is located.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
client_token	text		The opaque string specified in the request to ensure idempotent creation.
file_system_id	text	=	The ID of the EFS file system that the access point applies to.
life_cycle_state	text		Identifies the lifecycle phase of the access point.
name	text		The name of the access point. This is the value of the Name tag.
owner_id	text		Identified the AWS account that owns the access point resource.
partition	text		The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
posix_user	jsonb		The 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.
region	text		The AWS Region in which the resource is located.
root_directory	jsonb		The 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_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		A map of tags for the resource.
tags_src	jsonb		The tags associated with the access point, presented as an array of Tag objects.
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_efs_access_point