Skip to content

aws.mailmanager.get_traffic_policy

Example SQL Queries

SELECT * FROM
aws.mailmanager.get_traffic_policy
WHERE
"traffic_policy_id" = 'VALUE';

Description

Fetch attributes of a traffic policy resource.

Table Definition

Column NameColumn Data Type
traffic_policy_id Required Input Column

The identifier of the traffic policy resource.

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.

created_timestamp

The timestamp of when the traffic policy was created.

TIMESTAMP_S
default_action

The default action of the traffic policy.

VARCHAR
last_updated_timestamp

The timestamp of when the traffic policy was last updated.

TIMESTAMP_S
max_message_size_bytes

The maximum message size in bytes of email which is allowed in by this traffic policy—anything larger will be blocked.

BIGINT
policy_statements

The list of conditions which are in the traffic policy resource.

STRUCT(
"action" VARCHAR,
"conditions" STRUCT(
"boolean_expression" STRUCT(
"evaluate" STRUCT(
"analysis" STRUCT(
"analyzer" VARCHAR,
"result_field" VARCHAR
)
),
"operator" VARCHAR
),
"ip_expression" STRUCT(
"evaluate" STRUCT(
"attribute" VARCHAR
),
"operator" VARCHAR,
"values" VARCHAR[]
),
"string_expression" STRUCT(
"evaluate" STRUCT(
"attribute" VARCHAR
),
"operator" VARCHAR,
"values" VARCHAR[]
),
"tls_expression" STRUCT(
"evaluate" STRUCT(
"attribute" VARCHAR
),
"operator" VARCHAR,
"value" VARCHAR
)
)[]
)[]
Show child fields
policy_statements[]
Show child fields
policy_statements[].action

The action that informs a traffic policy resource to either allow or block the email if it matches a condition in the policy statement.

policy_statements[].conditions[]
Show child fields
policy_statements[].conditions[].boolean_expression

This represents a boolean type condition matching on the incoming mail. It performs the boolean operation configured in 'Operator' and evaluates the 'Protocol' object against the 'Value'.

Show child fields
policy_statements[].conditions[].boolean_expression.evaluate

The operand on which to perform a boolean condition operation.

Show child fields
policy_statements[].conditions[].boolean_expression.evaluate.analysis

The structure type for a boolean condition stating the Add On ARN and its returned value.

Show child fields
policy_statements[].conditions[].boolean_expression.evaluate.analysis.analyzer

The Amazon Resource Name (ARN) of an Add On.

policy_statements[].conditions[].boolean_expression.evaluate.analysis.result_field

The returned value from an Add On.

policy_statements[].conditions[].boolean_expression.operator

The matching operator for a boolean condition expression.

policy_statements[].conditions[].ip_expression

This represents an IP based condition matching on the incoming mail. It performs the operation configured in 'Operator' and evaluates the 'Protocol' object against the 'Value'.

Show child fields
policy_statements[].conditions[].ip_expression.evaluate

The left hand side argument of an IP condition expression.

Show child fields
policy_statements[].conditions[].ip_expression.evaluate.attribute

An enum type representing the allowed attribute types for an IP condition.

policy_statements[].conditions[].ip_expression.operator

The matching operator for an IP condition expression.

policy_statements[].conditions[].ip_expression.values[]
policy_statements[].conditions[].string_expression

This represents a string based condition matching on the incoming mail. It performs the string operation configured in 'Operator' and evaluates the 'Protocol' object against the 'Value'.

Show child fields
policy_statements[].conditions[].string_expression.evaluate

The left hand side argument of a string condition expression.

Show child fields
policy_statements[].conditions[].string_expression.evaluate.attribute

The enum type representing the allowed attribute types for a string condition.

policy_statements[].conditions[].string_expression.operator

The matching operator for a string condition expression.

policy_statements[].conditions[].string_expression.values[]
policy_statements[].conditions[].tls_expression

This represents a TLS based condition matching on the incoming mail. It performs the operation configured in 'Operator' and evaluates the 'Protocol' object against the 'Value'.

Show child fields
policy_statements[].conditions[].tls_expression.evaluate

The left hand side argument of a TLS condition expression.

Show child fields
policy_statements[].conditions[].tls_expression.evaluate.attribute

The enum type representing the allowed attribute types for the TLS condition.

policy_statements[].conditions[].tls_expression.operator

The matching operator for a TLS condition expression.

policy_statements[].conditions[].tls_expression.value

The right hand side argument of a TLS condition expression.

traffic_policy_arn

The Amazon Resource Name (ARN) of the traffic policy resource.

VARCHAR
traffic_policy_name

A user-friendly name for the traffic policy resource.

VARCHAR