Skip to content
AWS for Query.Farm

aws.dynamodb.list_imports

Example SQL Queries

SELECT * FROM
aws.dynamodb.list_imports;

Description

Lists completed imports within the past 90 days.

Table Definition

Column NameColumn Data Type
next_token Input Column

If this value is returned, there are additional results to be displayed. To retrieve them, call ListImports again, with NextToken set to this value. 

VARCHAR
page_size Input Column

The number of ImportSummary objects returned in a single page. 

BIGINT
table_arn Input Column

The Amazon Resource Name (ARN) associated with the table that was imported to. 

VARCHAR
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
import_summary_list

A list of ImportSummary objects. 

STRUCT(
    "import_arn" VARCHAR,
    "import_status" VARCHAR,
    "table_arn" VARCHAR,
    "s3_bucket_source" STRUCT(
        "s3_bucket_owner" VARCHAR,
        "s3_bucket" VARCHAR,
        "s3_key_prefix" VARCHAR
    ),
    "cloud_watch_log_group_arn" VARCHAR,
    "input_format" VARCHAR,
    "start_time" TIMESTAMP_S,
    "end_time" TIMESTAMP_S
)[]
Show child fields
import_summary_list[]
Show child fields
import_summary_list[].cloud_watch_log_group_arn

The Amazon Resource Number (ARN) of the Cloudwatch Log Group associated with this import task.

import_summary_list[].end_time

The time at which this import task ended. (Does this include the successful complete creation of the table it was imported to?)

import_summary_list[].import_arn

The Amazon Resource Number (ARN) corresponding to the import request.

import_summary_list[].import_status

The status of the import operation.

import_summary_list[].input_format

The format of the source data. Valid values are CSV, DYNAMODB_JSON or ION.

import_summary_list[].s3_bucket_source

The path and S3 bucket of the source file that is being imported. This includes the S3Bucket (required), S3KeyPrefix (optional) and S3BucketOwner (optional if the bucket is owned by the requester).

Show child fields
import_summary_list[].s3_bucket_source.s3_bucket

The S3 bucket that is being imported from.

import_summary_list[].s3_bucket_source.s3_bucket_owner

The account number of the S3 bucket that is being imported from. If the bucket is owned by the requester this is optional.

import_summary_list[].s3_bucket_source.s3_key_prefix

The key prefix shared by all S3 Objects that are being imported.

import_summary_list[].start_time

The time at which this import task began.

import_summary_list[].table_arn

The Amazon Resource Number (ARN) of the table being imported into.