Skip to content
AWS for Query.Farm

aws.datazone.search_types

Example SQL Queries

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

Description

Searches for types in Amazon DataZone.

Table Definition

Column NameColumn Data Type
domain_identifier Required Input Column

The identifier of the Amazon DataZone domain in which to invoke the SearchTypes action.

VARCHAR
managed Required Input Column

Specifies whether the search is managed.

BOOLEAN
search_scope Required Input Column

Specifies the scope of the search for types.

VARCHAR
filters Input Column

The filters for the SearchTypes action.

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.

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

The specifies the way to sort the SearchTypes results.

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 SearchTypes action.

STRUCT(
    "asset_type_item" STRUCT(
        "created_at" TIMESTAMP_S,
        "created_by" VARCHAR,
        "description" VARCHAR,
        "domain_id" VARCHAR,
        "forms_output" MAP(VARCHAR, STRUCT(
                "required" BOOLEAN,
                "type_name" VARCHAR,
                "type_revision" VARCHAR
            )),
        "name" VARCHAR,
        "origin_domain_id" VARCHAR,
        "origin_project_id" VARCHAR,
        "owning_project_id" VARCHAR,
        "revision" VARCHAR,
        "updated_at" TIMESTAMP_S,
        "updated_by" VARCHAR
    ),
    "form_type_item" STRUCT(
        "created_at" TIMESTAMP_S,
        "created_by" VARCHAR,
        "description" VARCHAR,
        "domain_id" VARCHAR,
        "imports" STRUCT(
            "name" VARCHAR,
            "revision" VARCHAR
        )[],
        "model" STRUCT(
            "smithy" VARCHAR
        ),
        "name" VARCHAR,
        "origin_domain_id" VARCHAR,
        "origin_project_id" VARCHAR,
        "owning_project_id" VARCHAR,
        "revision" VARCHAR,
        "status" VARCHAR
    ),
    "lineage_node_type_item" STRUCT(
        "created_at" TIMESTAMP_S,
        "created_by" VARCHAR,
        "description" VARCHAR,
        "domain_id" VARCHAR,
        "forms_output" MAP(VARCHAR, STRUCT(
                "required" BOOLEAN,
                "type_name" VARCHAR,
                "type_revision" VARCHAR
            )),
        "name" VARCHAR,
        "revision" VARCHAR,
        "updated_at" TIMESTAMP_S,
        "updated_by" VARCHAR
    )
)[]
Show child fields
items[]
Show child fields
items[].asset_type_item

The asset type included in the results of the SearchTypes action.

Show child fields
items[].asset_type_item.created_at

The timestamp of when the asset type was created.

items[].asset_type_item.created_by

The Amazon DataZone user who created the asset type.

items[].asset_type_item.description

The description of the asset type.

items[].asset_type_item.domain_id

The identifier of the Amazon DataZone domain where the asset type exists.

items[].asset_type_item.forms_output

The forms included in the details of the asset type.

items[].asset_type_item.name

The name of the asset type.

items[].asset_type_item.origin_domain_id

The identifier of the Amazon DataZone domain where the asset type was originally created.

items[].asset_type_item.origin_project_id

The identifier of the Amazon DataZone project where the asset type exists.

items[].asset_type_item.owning_project_id

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

items[].asset_type_item.revision

The revision of the asset type.

items[].asset_type_item.updated_at

The timestamp of when the asset type was updated.

items[].asset_type_item.updated_by

The Amazon DataZone user who updated the asset type.

items[].form_type_item

The form type included in the results of the SearchTypes action.

Show child fields
items[].form_type_item.created_at

The timestamp of when the metadata form type was created.

items[].form_type_item.created_by

The Amazon DataZone user who created teh metadata form type.

items[].form_type_item.description

The description of the metadata form type.

items[].form_type_item.domain_id

The identifier of the Amazon DataZone domain in which the form type exists.

items[].form_type_item.imports[]
Show child fields
items[].form_type_item.imports[].name

The name of the import.

items[].form_type_item.imports[].revision

The revision of the import.

items[].form_type_item.model

The model of the form type.

Show child fields
items[].form_type_item.model.smithy

Indicates the smithy model of the API.

items[].form_type_item.name

The name of the form type.

items[].form_type_item.origin_domain_id

The identifier of the Amazon DataZone domain in which the form type was originally created.

items[].form_type_item.origin_project_id

The identifier of the project in which the form type was originally created.

items[].form_type_item.owning_project_id

The identifier of the project that owns the form type.

items[].form_type_item.revision

The revision of the form type.

items[].form_type_item.status

The status of the form type.

items[].lineage_node_type_item

The details of a data lineage node type.

Show child fields
items[].lineage_node_type_item.created_at

The timestamp at which the data lineage node type was created.

items[].lineage_node_type_item.created_by

The user who created the data lineage node type.

items[].lineage_node_type_item.description

The description of the data lineage node type.

items[].lineage_node_type_item.domain_id

The ID of the domain where the data lineage node type lives.

items[].lineage_node_type_item.forms_output

The forms output of the data lineage node type.

items[].lineage_node_type_item.name

The name of the data lineage node type.

items[].lineage_node_type_item.revision

The revision of the data lineage node type.

items[].lineage_node_type_item.updated_at

The timestamp at which the data lineage node type was updated.

items[].lineage_node_type_item.updated_by

The user who updated the data lineage node type.

total_match_count

Total number of search results.

BIGINT