| Column Name | Column Data Type |
|---|
owner_account Input Column
The owner Amazon Web Services account for the Amazon Redshift Serverless workgroup. | VARCHAR |
vpc_id Input Column
The unique identifier of the virtual private cloud with access to Amazon Redshift Serverless. | VARCHAR |
workgroup_name Input Column
The name of the workgroup associated with the endpoint. | 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 |
address
The DNS address of the endpoint. | VARCHAR |
endpoint_arn
The Amazon Resource Name (ARN) of the VPC endpoint. | VARCHAR |
endpoint_create_time
The time that the endpoint was created. | TIMESTAMP_S |
endpoint_name
The name of the VPC endpoint. | VARCHAR |
endpoint_status
The status of the VPC endpoint. | VARCHAR |
port
The port number on which Amazon Redshift Serverless accepts incoming connections. | BIGINT |
subnet_ids
The unique identifier of subnets where Amazon Redshift Serverless choose to deploy the VPC endpoint. | VARCHAR[] |
Show child fields- subnet_ids[]
|
vpc_endpoint
The connection endpoint for connecting to Amazon Redshift Serverless. | STRUCT(
"network_interfaces" STRUCT(
"availability_zone" VARCHAR,
"ipv6_address" VARCHAR,
"network_interface_id" VARCHAR,
"private_ip_address" VARCHAR,
"subnet_id" VARCHAR
)[],
"vpc_endpoint_id" VARCHAR,
"vpc_id" VARCHAR
) |
Show child fields- vpc_endpoint.network_interfaces[]
Show child fields- vpc_endpoint.network_interfaces[].availability_zone
The availability Zone. - vpc_endpoint.network_interfaces[].ipv6_address
The IPv6 address of the network interface within the subnet. - vpc_endpoint.network_interfaces[].network_interface_id
The unique identifier of the network interface. - vpc_endpoint.network_interfaces[].private_ip_address
The IPv4 address of the network interface within the subnet. - vpc_endpoint.network_interfaces[].subnet_id
The unique identifier of the subnet.
- vpc_endpoint.vpc_endpoint_id
The connection endpoint ID for connecting to Amazon Redshift Serverless. - vpc_endpoint.vpc_id
The VPC identifier that the endpoint is associated with.
|
vpc_security_groups
The security groups associated with the endpoint. | STRUCT(
"status" VARCHAR,
"vpc_security_group_id" VARCHAR
)[] |
Show child fields- vpc_security_groups[]
Show child fields- vpc_security_groups[].status
The status of the VPC security group. - vpc_security_groups[].vpc_security_group_id
The unique identifier of the VPC security group.
|