Skip to content
AWS for Query.Farm

aws.databrew.describe_recipe

Example SQL Queries

SELECT * FROM
aws.databrew.describe_recipe
WHERE
"name" = 'VALUE';

Description

Returns the definition of a specific DataBrew recipe corresponding to a particular version.

Table Definition

Column NameColumn Data Type
name Required Input Column

The name of the recipe.

VARCHAR
recipe_version Input Column

The recipe version identifier.

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
create_date

The date and time that the recipe was created.

TIMESTAMP_S
created_by

The identifier (user name) of the user who created the recipe.

VARCHAR
description

The description of the recipe.

VARCHAR
last_modified_by

The identifier (user name) of the user who last modified the recipe.

VARCHAR
last_modified_date

The date and time that the recipe was last modified.

TIMESTAMP_S
project_name

The name of the project associated with this recipe.

VARCHAR
published_by

The identifier (user name) of the user who last published the recipe.

VARCHAR
published_date

The date and time when the recipe was last published.

TIMESTAMP_S
resource_arn

The ARN of the recipe.

VARCHAR
steps

One or more steps to be performed by the recipe. Each step consists of an action, and the conditions under which the action should succeed.

STRUCT(
    "action" STRUCT(
        "operation" VARCHAR,
        "parameters" MAP(VARCHAR, VARCHAR)
    ),
    "condition_expressions" STRUCT(
        "condition" VARCHAR,
        "value" VARCHAR,
        "target_column" VARCHAR
    )[]
)[]
Show child fields
steps[]
Show child fields
steps[].action

The particular action to be performed in the recipe step.

Show child fields
steps[].action.operation

The name of a valid DataBrew transformation to be performed on the data.

steps[].action.parameters

Contextual parameters for the transformation.

steps[].condition_expressions[]
Show child fields
steps[].condition_expressions[].condition

A specific condition to apply to a recipe action. For more information, see Recipe structure in the Glue DataBrew Developer Guide.

steps[].condition_expressions[].target_column

A column to apply this condition to.

steps[].condition_expressions[].value

A value that the condition must evaluate to for the condition to succeed.

tags

Metadata tags associated with this project.

MAP(VARCHAR, VARCHAR)