Skip to main content

gateway_route_table_associations

Creates, updates, deletes or gets a gateway_route_table_association resource or lists gateway_route_table_associations in a region

Overview

Namegateway_route_table_associations
TypeResource
DescriptionAssociates a gateway with a route table. The gateway and route table must be in the same VPC. This association causes the incoming traffic to the gateway to be routed according to the routes in the route table.
Idaws.ec2.gateway_route_table_associations

Fields

NameDatatypeDescription
route_table_idstringThe ID of the route table.
gateway_idstringThe ID of the gateway.
association_idstringThe route table association ID.
regionstringAWS region.

Methods

NameAccessible byRequired Params
create_resourceINSERTRouteTableId, GatewayId, region
delete_resourceDELETEdata__Identifier, region
update_resourceUPDATEdata__Identifier, data__PatchDocument, region
get_resourceSELECTdata__Identifier, region

SELECT examples

Gets all properties from an individual gateway_route_table_association.

SELECT
region,
route_table_id,
gateway_id,
association_id
FROM aws.ec2.gateway_route_table_associations
WHERE region = 'us-east-1' AND data__Identifier = '<GatewayId>';

INSERT example

Use the following StackQL query and manifest file to create a new gateway_route_table_association resource, using stack-deploy.

/*+ create */
INSERT INTO aws.ec2.gateway_route_table_associations (
RouteTableId,
GatewayId,
region
)
SELECT
'{{ RouteTableId }}',
'{{ GatewayId }}',
'{{ region }}';

DELETE example

/*+ delete */
DELETE FROM aws.ec2.gateway_route_table_associations
WHERE data__Identifier = '<GatewayId>'
AND region = 'us-east-1';

Permissions

To operate on the gateway_route_table_associations resource, the following permissions are required:

Create

ec2:DescribeRouteTables,
ec2:AssociateRouteTable

Read

ec2:DescribeRouteTables

Update

ec2:DescribeRouteTables,
ec2:ReplaceRouteTableAssociation

Delete

ec2:DescribeRouteTables,
ec2:DisassociateRouteTable