Skip to content
AWS for Query.Farm

aws.datazone.get_asset_filter

Example SQL Queries

SELECT * FROM
aws.datazone.get_asset_filter
WHERE
"asset_identifier" = 'VALUE'
AND "domain_identifier" = 'VALUE'
AND "identifier" = 'VALUE';

Description

Gets an asset filter.

Table Definition

Column NameColumn Data Type
asset_identifier Required Input Column

The ID of the data asset.

VARCHAR
domain_identifier Required Input Column

The ID of the domain where you want to get an asset filter.

VARCHAR
identifier Required Input Column

The ID of the asset filter.

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
asset_id

The ID of the data asset.

VARCHAR
configuration

The configuration of the asset filter.

STRUCT(
    "column_configuration" STRUCT(
        "included_column_names" VARCHAR[]
    ),
    "row_configuration" STRUCT(
        "row_filter" STRUCT(
            "expression" STRUCT(
                "equal_to" STRUCT(
                    "column_name" VARCHAR,
                    "value" VARCHAR
                ),
                "greater_than" STRUCT(
                    "column_name" VARCHAR,
                    "value" VARCHAR
                ),
                "greater_than_or_equal_to" STRUCT(
                    "column_name" VARCHAR,
                    "value" VARCHAR
                ),
                "in" STRUCT(
                    "column_name" VARCHAR,
                    "values" VARCHAR[]
                ),
                "is_not_null" STRUCT(
                    "column_name" VARCHAR
                ),
                "is_null" STRUCT(
                    "column_name" VARCHAR
                ),
                "less_than" STRUCT(
                    "column_name" VARCHAR,
                    "value" VARCHAR
                ),
                "less_than_or_equal_to" STRUCT(
                    "column_name" VARCHAR,
                    "value" VARCHAR
                ),
                "like" STRUCT(
                    "column_name" VARCHAR,
                    "value" VARCHAR
                ),
                "not_equal_to" STRUCT(
                    "column_name" VARCHAR,
                    "value" VARCHAR
                ),
                "not_in" STRUCT(
                    "column_name" VARCHAR,
                    "values" VARCHAR[]
                ),
                "not_like" STRUCT(
                    "column_name" VARCHAR,
                    "value" VARCHAR
                )
            )
        ),
        "sensitive" BOOLEAN
    )
)
Show child fields
configuration.column_configuration

The column configuration of the asset filter.

Show child fields
configuration.column_configuration.included_column_names[]
configuration.row_configuration

The row configuration of the asset filter.

Show child fields
configuration.row_configuration.row_filter

The row filter.

Show child fields
configuration.row_configuration.row_filter.expression

The expression of the row filter.

Show child fields
configuration.row_configuration.row_filter.expression.equal_to

The 'equal to' clause of the row filter expression.

Show child fields
configuration.row_configuration.row_filter.expression.equal_to.column_name

The name of the column.

configuration.row_configuration.row_filter.expression.equal_to.value

The value that might be equal to an expression.

configuration.row_configuration.row_filter.expression.greater_than

The 'greater than' clause of the row filter expression.

Show child fields
configuration.row_configuration.row_filter.expression.greater_than.column_name

The name of the column.

configuration.row_configuration.row_filter.expression.greater_than.value

The value that might be greater than an expression.

configuration.row_configuration.row_filter.expression.greater_than_or_equal_to

The 'greater than or equal to' clause of the filter expression.

Show child fields
configuration.row_configuration.row_filter.expression.greater_than_or_equal_to.column_name

The name of the column.

configuration.row_configuration.row_filter.expression.greater_than_or_equal_to.value

The value that might be greater than or equal to an expression.

configuration.row_configuration.row_filter.expression.in

The 'in' clause of the row filter expression.

Show child fields
configuration.row_configuration.row_filter.expression.in.column_name

The name of the column.

configuration.row_configuration.row_filter.expression.in.values[]
configuration.row_configuration.row_filter.expression.is_not_null

The 'is not null' clause of the row filter expression.

Show child fields
configuration.row_configuration.row_filter.expression.is_not_null.column_name

The name of the column.

configuration.row_configuration.row_filter.expression.is_null

The 'is null' clause of the row filter expression.

Show child fields
configuration.row_configuration.row_filter.expression.is_null.column_name

The name of the column.

configuration.row_configuration.row_filter.expression.less_than

The 'less than' clause of the row filter expression.

Show child fields
configuration.row_configuration.row_filter.expression.less_than.column_name

The name of the column.

configuration.row_configuration.row_filter.expression.less_than.value

The value that might be less than the expression.

configuration.row_configuration.row_filter.expression.less_than_or_equal_to

The 'less than or equal to' clause of the row filter expression.

Show child fields
configuration.row_configuration.row_filter.expression.less_than_or_equal_to.column_name

The name of the column.

configuration.row_configuration.row_filter.expression.less_than_or_equal_to.value

The value that might be less than or equal to an expression.

configuration.row_configuration.row_filter.expression.like

The 'like' clause of the row filter expression.

Show child fields
configuration.row_configuration.row_filter.expression.like.column_name

The name of the column.

configuration.row_configuration.row_filter.expression.like.value

The value that might be like the expression.

configuration.row_configuration.row_filter.expression.not_equal_to

The 'no equal to' clause of the row filter expression.

Show child fields
configuration.row_configuration.row_filter.expression.not_equal_to.column_name

The name of the column.

configuration.row_configuration.row_filter.expression.not_equal_to.value

The value that might not be equal to the expression.

configuration.row_configuration.row_filter.expression.not_in

The 'not in' clause of the row filter expression.

Show child fields
configuration.row_configuration.row_filter.expression.not_in.column_name

The name of the column.

configuration.row_configuration.row_filter.expression.not_in.values[]
configuration.row_configuration.row_filter.expression.not_like

The 'not like' clause of the row filter expression.

Show child fields
configuration.row_configuration.row_filter.expression.not_like.column_name

The name of the column.

configuration.row_configuration.row_filter.expression.not_like.value

The value that might not be like the expression.

configuration.row_configuration.sensitive

Specifies whether the row filter is sensitive.

created_at

The timestamp at which the asset filter was created.

TIMESTAMP_S
description

The description of the asset filter.

VARCHAR
domain_id

The ID of the domain where you want to get an asset filter.

VARCHAR
effective_column_names

The column names of the asset filter.

VARCHAR[]
Show child fields
effective_column_names[]
effective_row_filter

The row filter of the asset filter.

VARCHAR
error_message

The error message that is displayed if the action does not complete successfully.

VARCHAR
id

The ID of the asset filter.

VARCHAR
name

The name of the asset filter.

VARCHAR
status

The status of the asset filter.

VARCHAR