| Column Name | Column Data Type |
|---|
asset_id Required Input Column
The unique identifier for an asset. | VARCHAR |
data_set_id Required Input Column
The unique identifier for the data set associated with this asset. | VARCHAR |
revision_id Required Input Column
The unique identifier for the revision associated with this asset. | 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 |
arn
The ARN for the asset. | VARCHAR |
asset_details
Details about the asset. | STRUCT(
"s3_snapshot_asset" STRUCT(
"size" DOUBLE
),
"redshift_data_share_asset" STRUCT(
"arn" VARCHAR
),
"api_gateway_api_asset" STRUCT(
"api_description" VARCHAR,
"api_endpoint" VARCHAR,
"api_id" VARCHAR,
"api_key" VARCHAR,
"api_name" VARCHAR,
"api_specification_download_url" VARCHAR,
"api_specification_download_url_expires_at" TIMESTAMP_S,
"protocol_type" VARCHAR,
"stage" VARCHAR
),
"s3_data_access_asset" STRUCT(
"bucket" VARCHAR,
"key_prefixes" VARCHAR[],
"keys" VARCHAR[],
"s3_access_point_alias" VARCHAR,
"s3_access_point_arn" VARCHAR,
"kms_keys_to_grant" STRUCT(
"kms_key_arn" VARCHAR
)[]
),
"lake_formation_data_permission_asset" STRUCT(
"lake_formation_data_permission_details" STRUCT(
"lf_tag_policy" STRUCT(
"catalog_id" VARCHAR,
"resource_type" VARCHAR,
"resource_details" STRUCT(
"database" STRUCT(
"expression" STRUCT(
"tag_key" VARCHAR,
"tag_values" VARCHAR[]
)[]
),
"table" STRUCT(
"expression" STRUCT(
"tag_key" VARCHAR,
"tag_values" VARCHAR[]
)[]
)
)
)
),
"lake_formation_data_permission_type" VARCHAR,
"permissions" VARCHAR[],
"role_arn" VARCHAR
)
) |
Show child fields- asset_details.api_gateway_api_asset
Information about the API Gateway API asset. Show child fields- asset_details.api_gateway_api_asset.api_description
The API description of the API asset. - asset_details.api_gateway_api_asset.api_endpoint
The API endpoint of the API asset. - asset_details.api_gateway_api_asset.api_id
The unique identifier of the API asset. - asset_details.api_gateway_api_asset.api_key
The API key of the API asset. - asset_details.api_gateway_api_asset.api_name
The API name of the API asset. - asset_details.api_gateway_api_asset.api_specification_download_url
The download URL of the API specification of the API asset. - asset_details.api_gateway_api_asset.api_specification_download_url_expires_at
The date and time that the upload URL expires, in ISO 8601 format. - asset_details.api_gateway_api_asset.protocol_type
The protocol type of the API asset. - asset_details.api_gateway_api_asset.stage
The stage of the API asset.
- asset_details.lake_formation_data_permission_asset
The AWS Lake Formation data permission that is the asset. Show child fields- asset_details.lake_formation_data_permission_asset.lake_formation_data_permission_details
Details about the AWS Lake Formation data permission. Show child fields- asset_details.lake_formation_data_permission_asset.lake_formation_data_permission_details.lf_tag_policy
Details about the LF-tag policy. Show child fields- asset_details.lake_formation_data_permission_asset.lake_formation_data_permission_details.lf_tag_policy.catalog_id
The identifier for the AWS Glue Data Catalog. - asset_details.lake_formation_data_permission_asset.lake_formation_data_permission_details.lf_tag_policy.resource_details
Details for the Lake Formation Resources included in the LF-tag policy. Show child fields- asset_details.lake_formation_data_permission_asset.lake_formation_data_permission_details.lf_tag_policy.resource_details.database
Details about the database resource included in the AWS Lake Formation data permission. Show child fields- asset_details.lake_formation_data_permission_asset.lake_formation_data_permission_details.lf_tag_policy.resource_details.database.expression[]
Show child fields- asset_details.lake_formation_data_permission_asset.lake_formation_data_permission_details.lf_tag_policy.resource_details.database.expression[].tag_key
The key name for the LF-tag. - asset_details.lake_formation_data_permission_asset.lake_formation_data_permission_details.lf_tag_policy.resource_details.database.expression[].tag_values[]
- asset_details.lake_formation_data_permission_asset.lake_formation_data_permission_details.lf_tag_policy.resource_details.table
Details about the table resource included in the AWS Lake Formation data permission. Show child fields- asset_details.lake_formation_data_permission_asset.lake_formation_data_permission_details.lf_tag_policy.resource_details.table.expression[]
Show child fields- asset_details.lake_formation_data_permission_asset.lake_formation_data_permission_details.lf_tag_policy.resource_details.table.expression[].tag_key
The key name for the LF-tag. - asset_details.lake_formation_data_permission_asset.lake_formation_data_permission_details.lf_tag_policy.resource_details.table.expression[].tag_values[]
- asset_details.lake_formation_data_permission_asset.lake_formation_data_permission_details.lf_tag_policy.resource_type
The resource type for which the LF-tag policy applies.
- asset_details.lake_formation_data_permission_asset.lake_formation_data_permission_type
The data permission type. - asset_details.lake_formation_data_permission_asset.permissions[]
- asset_details.lake_formation_data_permission_asset.role_arn
The IAM role's ARN that allows AWS Data Exchange to assume the role and grant and revoke permissions to AWS Lake Formation data permissions.
- asset_details.redshift_data_share_asset
The Amazon Redshift datashare that is the asset. Show child fields- asset_details.redshift_data_share_asset.arn
The Amazon Resource Name (ARN) of the datashare asset.
- asset_details.s3_data_access_asset
The Amazon S3 data access that is the asset. Show child fields- asset_details.s3_data_access_asset.bucket
The Amazon S3 bucket hosting data to be shared in the S3 data access. - asset_details.s3_data_access_asset.key_prefixes[]
- asset_details.s3_data_access_asset.keys[]
- asset_details.s3_data_access_asset.kms_keys_to_grant[]
Show child fields- asset_details.s3_data_access_asset.kms_keys_to_grant[].kms_key_arn
The AWS KMS CMK (Key Management System Customer Managed Key) used to encrypt S3 objects in the shared S3 Bucket. AWS Data exchange will create a KMS grant for each subscriber to allow them to access and decrypt their entitled data that is encrypted using this KMS key specified.
- asset_details.s3_data_access_asset.s3_access_point_alias
The automatically-generated bucket-style alias for your Amazon S3 Access Point. Customers can access their entitled data using the S3 Access Point alias. - asset_details.s3_data_access_asset.s3_access_point_arn
The ARN for your Amazon S3 Access Point. Customers can also access their entitled data using the S3 Access Point ARN.
- asset_details.s3_snapshot_asset
The Amazon S3 object that is the asset. Show child fields- asset_details.s3_snapshot_asset.size
The size of the Amazon S3 object that is the object.
|
asset_type
The type of asset that is added to a data set. | VARCHAR |
created_at
The date and time that the asset was created, in ISO 8601 format. | TIMESTAMP_S |
id
The unique identifier for the asset. | VARCHAR |
name
The name of the asset. When importing from Amazon S3, the Amazon S3 object key is used as the asset name. When exporting to Amazon S3, the asset name is used as default target Amazon S3 object key. When importing from Amazon API Gateway API, the API name is used as the asset name. When importing from Amazon Redshift, the datashare name is used as the asset name. When importing from AWS Lake Formation, the static values of "Database(s) included in the LF-tag policy" or "Table(s) included in the LF-tag policy" are used as the asset name. | VARCHAR |
source_id
The asset ID of the owned asset corresponding to the entitled asset being viewed. This parameter is returned when an asset owner is viewing the entitled copy of its owned asset. | VARCHAR |
updated_at
The date and time that the asset was last updated, in ISO 8601 format. | TIMESTAMP_S |