transit_gateway_route_table_associations
Creates, updates, deletes or gets a transit_gateway_route_table_association
resource or lists transit_gateway_route_table_associations
in a region
Overview
Name | transit_gateway_route_table_associations |
Type | Resource |
Description | Resource Type definition for AWS::EC2::TransitGatewayRouteTableAssociation |
Id | aws.ec2.transit_gateway_route_table_associations |
Fields
Name | Datatype | Description |
---|---|---|
transit_gateway_route_table_id | string | The ID of transit gateway route table. |
transit_gateway_attachment_id | string | The ID of transit gateway attachment. |
region | string | AWS region. |
Methods
Name | Accessible by | Required Params |
---|---|---|
create_resource | INSERT | TransitGatewayRouteTableId, TransitGatewayAttachmentId, region |
delete_resource | DELETE | data__Identifier, region |
list_resources | SELECT | region |
get_resource | SELECT | data__Identifier, region |
SELECT
examples
Gets all transit_gateway_route_table_associations
in a region.
SELECT
region,
transit_gateway_route_table_id,
transit_gateway_attachment_id
FROM aws.ec2.transit_gateway_route_table_associations
WHERE region = 'us-east-1';
Gets all properties from an individual transit_gateway_route_table_association
.
SELECT
region,
transit_gateway_route_table_id,
transit_gateway_attachment_id
FROM aws.ec2.transit_gateway_route_table_associations
WHERE region = 'us-east-1' AND data__Identifier = '<TransitGatewayRouteTableId>|<TransitGatewayAttachmentId>';
INSERT
example
Use the following StackQL query and manifest file to create a new transit_gateway_route_table_association
resource, using stack-deploy
.
- Required Properties
- All Properties
- Manifest
/*+ create */
INSERT INTO aws.ec2.transit_gateway_route_table_associations (
TransitGatewayRouteTableId,
TransitGatewayAttachmentId,
region
)
SELECT
'{{ TransitGatewayRouteTableId }}',
'{{ TransitGatewayAttachmentId }}',
'{{ region }}';
/*+ create */
INSERT INTO aws.ec2.transit_gateway_route_table_associations (
TransitGatewayRouteTableId,
TransitGatewayAttachmentId,
region
)
SELECT
'{{ TransitGatewayRouteTableId }}',
'{{ TransitGatewayAttachmentId }}',
'{{ region }}';
version: 1
name: stack name
description: stack description
providers:
- aws
globals:
- name: region
value: '{{ vars.AWS_REGION }}'
resources:
- name: transit_gateway_route_table_association
props:
- name: TransitGatewayRouteTableId
value: '{{ TransitGatewayRouteTableId }}'
- name: TransitGatewayAttachmentId
value: '{{ TransitGatewayAttachmentId }}'
DELETE
example
/*+ delete */
DELETE FROM aws.ec2.transit_gateway_route_table_associations
WHERE data__Identifier = '<TransitGatewayRouteTableId|TransitGatewayAttachmentId>'
AND region = 'us-east-1';
Permissions
To operate on the transit_gateway_route_table_associations
resource, the following permissions are required:
Create
ec2:AssociateTransitGatewayRouteTable,
ec2:GetTransitGatewayRouteTableAssociations
Read
ec2:GetTransitGatewayRouteTableAssociations
Delete
ec2:GetTransitGatewayRouteTableAssociations,
ec2:DisassociateTransitGatewayRouteTable
List
ec2:GetTransitGatewayRouteTableAssociations