Skip to content
AWS for Query.Farm

aws.datazone.search

Example SQL Queries

SELECT * FROM
aws.datazone.search
WHERE
"domain_identifier" = 'VALUE'
AND "search_scope" = 'VALUE';

Description

Searches for assets in Amazon DataZone.

Table Definition

Column NameColumn Data Type
domain_identifier Required Input Column

The identifier of the Amazon DataZone domain.

VARCHAR
search_scope Required Input Column

The scope of the search.

VARCHAR
additional_attributes Input Column

Specifies additional attributes for the Search action.

VARCHAR[]
Show child fields
additional_attributes[]
filters Input Column

Specifies the search filters.

STRUCT(
    "filter" STRUCT(
        "attribute" VARCHAR,
        "value" VARCHAR
    )
)
Show child fields
filters.filter

A search filter in Amazon DataZone.

Show child fields
filters.filter.attribute

A search filter attribute in Amazon DataZone.

filters.filter.value

A search filter value in Amazon DataZone.

owning_project_identifier Input Column

The identifier of the owning project specified for the search.

VARCHAR
search_in Input Column

The details of the search.

STRUCT(
    "attribute" VARCHAR
)[]
Show child fields
search_in[]
Show child fields
search_in[].attribute

The search attribute.

search_text Input Column

Specifies the text for which to search.

VARCHAR
sort Input Column

Specifies the way in which the search results are to be sorted.

STRUCT(
    "attribute" VARCHAR,
    "order" VARCHAR
)
Show child fields
sort.attribute

The attribute detail of the way to sort search results.

sort.order

The order detail of the wya to sort search results.

_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
items

The results of the Search action.

STRUCT(
    "asset_item" STRUCT(
        "additional_attributes" STRUCT(
            "forms_output" STRUCT(
                "content" VARCHAR,
                "form_name" VARCHAR,
                "type_name" VARCHAR,
                "type_revision" VARCHAR
            )[],
            "latest_time_series_data_point_forms_output" STRUCT(
                "content_summary" VARCHAR,
                "form_name" VARCHAR,
                "id" VARCHAR,
                "timestamp" TIMESTAMP_S,
                "type_identifier" VARCHAR,
                "type_revision" VARCHAR
            )[],
            "read_only_forms_output" STRUCT(
                "content" VARCHAR,
                "form_name" VARCHAR,
                "type_name" VARCHAR,
                "type_revision" VARCHAR
            )[]
        ),
        "created_at" TIMESTAMP_S,
        "created_by" VARCHAR,
        "description" VARCHAR,
        "domain_id" VARCHAR,
        "external_identifier" VARCHAR,
        "first_revision_created_at" TIMESTAMP_S,
        "first_revision_created_by" VARCHAR,
        "glossary_terms" VARCHAR[],
        "identifier" VARCHAR,
        "name" VARCHAR,
        "owning_project_id" VARCHAR,
        "type_identifier" VARCHAR,
        "type_revision" VARCHAR
    ),
    "data_product_item" STRUCT(
        "created_at" TIMESTAMP_S,
        "created_by" VARCHAR,
        "description" VARCHAR,
        "domain_id" VARCHAR,
        "first_revision_created_at" TIMESTAMP_S,
        "first_revision_created_by" VARCHAR,
        "glossary_terms" VARCHAR[],
        "id" VARCHAR,
        "name" VARCHAR,
        "owning_project_id" VARCHAR
    ),
    "glossary_item" STRUCT(
        "created_at" TIMESTAMP_S,
        "created_by" VARCHAR,
        "description" VARCHAR,
        "domain_id" VARCHAR,
        "id" VARCHAR,
        "name" VARCHAR,
        "owning_project_id" VARCHAR,
        "status" VARCHAR,
        "updated_at" TIMESTAMP_S,
        "updated_by" VARCHAR
    ),
    "glossary_term_item" STRUCT(
        "created_at" TIMESTAMP_S,
        "created_by" VARCHAR,
        "domain_id" VARCHAR,
        "glossary_id" VARCHAR,
        "id" VARCHAR,
        "long_description" VARCHAR,
        "name" VARCHAR,
        "short_description" VARCHAR,
        "status" VARCHAR,
        "term_relations" STRUCT(
            "classifies" VARCHAR[],
            "is_a" VARCHAR[]
        ),
        "updated_at" TIMESTAMP_S,
        "updated_by" VARCHAR
    )
)[]
Show child fields
items[]
Show child fields
items[].asset_item

The asset item included in the search results.

Show child fields
items[].asset_item.additional_attributes

The additional attributes of a Amazon DataZone inventory asset.

Show child fields
items[].asset_item.additional_attributes.forms_output[]
Show child fields
items[].asset_item.additional_attributes.forms_output[].content

The content of the metadata form.

items[].asset_item.additional_attributes.forms_output[].form_name

The name of the metadata form.

items[].asset_item.additional_attributes.forms_output[].type_name

The name of the metadata form type.

items[].asset_item.additional_attributes.forms_output[].type_revision

The revision of the metadata form type.

items[].asset_item.additional_attributes.latest_time_series_data_point_forms_output[]
Show child fields
items[].asset_item.additional_attributes.latest_time_series_data_point_forms_output[].content_summary

The content of the summary of the time series data points form.

items[].asset_item.additional_attributes.latest_time_series_data_point_forms_output[].form_name

The name of the time series data points summary form.

items[].asset_item.additional_attributes.latest_time_series_data_point_forms_output[].id

The ID of the time series data points summary form.

items[].asset_item.additional_attributes.latest_time_series_data_point_forms_output[].timestamp

The timestamp of the time series data points summary form.

items[].asset_item.additional_attributes.latest_time_series_data_point_forms_output[].type_identifier

The type ID of the time series data points summary form.

items[].asset_item.additional_attributes.latest_time_series_data_point_forms_output[].type_revision

The type revision of the time series data points summary form.

items[].asset_item.additional_attributes.read_only_forms_output[]
Show child fields
items[].asset_item.additional_attributes.read_only_forms_output[].content

The content of the metadata form.

items[].asset_item.additional_attributes.read_only_forms_output[].form_name

The name of the metadata form.

items[].asset_item.additional_attributes.read_only_forms_output[].type_name

The name of the metadata form type.

items[].asset_item.additional_attributes.read_only_forms_output[].type_revision

The revision of the metadata form type.

items[].asset_item.created_at

The timestamp of when the Amazon DataZone inventory asset was created.

items[].asset_item.created_by

The Amazon DataZone user who created the inventory asset.

items[].asset_item.description

The description of an Amazon DataZone inventory asset.

items[].asset_item.domain_id

The identifier of the Amazon DataZone domain in which the inventory asset exists.

items[].asset_item.external_identifier

The external identifier of the Amazon DataZone inventory asset.

items[].asset_item.first_revision_created_at

The timestamp of when the first revision of the inventory asset was created.

items[].asset_item.first_revision_created_by

The Amazon DataZone user who created the first revision of the inventory asset.

items[].asset_item.glossary_terms[]
items[].asset_item.identifier

the identifier of the Amazon DataZone inventory asset.

items[].asset_item.name

The name of the Amazon DataZone inventory asset.

items[].asset_item.owning_project_id

The identifier of the Amazon DataZone project that owns the inventory asset.

items[].asset_item.type_identifier

The identifier of the asset type of the specified Amazon DataZone inventory asset.

items[].asset_item.type_revision

The revision of the inventory asset type.

items[].data_product_item

The data product.

Show child fields
items[].data_product_item.created_at

The timestamp at which the data product was created.

items[].data_product_item.created_by

The user who created the data product.

items[].data_product_item.description

The description of the data product.

items[].data_product_item.domain_id

The ID of the domain where the data product lives.

items[].data_product_item.first_revision_created_at

The timestamp at which first revision of the data product was created.

items[].data_product_item.first_revision_created_by

The user who created the first revision of the data product.

items[].data_product_item.glossary_terms[]
items[].data_product_item.id

The ID of the data product.

items[].data_product_item.name

The name of the data product.

items[].data_product_item.owning_project_id

The ID of the owning project of the data product.

items[].glossary_item

The glossary item included in the search results.

Show child fields
items[].glossary_item.created_at

The timestamp of when the glossary was created.

items[].glossary_item.created_by

The Amazon DataZone user who created the glossary.

items[].glossary_item.description

The business glossary description.

items[].glossary_item.domain_id

The identifier of the Amazon DataZone domain in which the business glossary exists.

items[].glossary_item.id

The identifier of the glossary.

items[].glossary_item.name

The name of the glossary.

items[].glossary_item.owning_project_id

The identifier of the project that owns the business glosary.

items[].glossary_item.status

The business glossary status.

items[].glossary_item.updated_at

The timestamp of when the business glossary was updated.

items[].glossary_item.updated_by

The Amazon DataZone user who updated the business glossary.

items[].glossary_term_item

The glossary term item included in the search results.

Show child fields
items[].glossary_term_item.created_at

The timestamp of when a business glossary term was created.

items[].glossary_term_item.created_by

The Amazon DataZone user who created the business glossary.

items[].glossary_term_item.domain_id

The identifier of the Amazon DataZone domain in which the business glossary exists.

items[].glossary_term_item.glossary_id

The identifier of the business glossary to which the term belongs.

items[].glossary_term_item.id

The identifier of the business glossary term.

items[].glossary_term_item.long_description

The long description of the business glossary term.

items[].glossary_term_item.name

The name of the business glossary term.

items[].glossary_term_item.short_description

The short description of the business glossary term.

items[].glossary_term_item.status

The status of the business glossary term.

items[].glossary_term_item.term_relations

The relations of the business glossary term.

Show child fields
items[].glossary_term_item.term_relations.classifies[]
items[].glossary_term_item.term_relations.is_a[]
items[].glossary_term_item.updated_at

The timestamp of when a business glossary term was updated.

items[].glossary_term_item.updated_by

The Amazon DataZone user who updated the business glossary term.

total_match_count

Total number of search results.

BIGINT