gateway_route_table_associations

Used to retrieve a list of gateway_route_table_associations in a region or to create or delete a gateway_route_table_associations resource, use gateway_route_table_association to read or update an individual resource.

Overview

Name	gateway_route_table_associations
Type	Resource
Description	Associates 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.
Id	aws.ec2.gateway_route_table_associations

Fields

Name	Datatype	Description
gateway_id	string	The ID of the gateway.
region	string	AWS region.

Methods

Name	Accessible by	Required Params
create_resource	INSERT	RouteTableId, GatewayId, region
delete_resource	DELETE	data__Identifier, region
list_resource	SELECT	region

SELECT Example

SELECT
region,
gateway_id
FROM aws.ec2.gateway_route_table_associations
WHERE region = 'us-east-1';

INSERT Example

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

Required Properties

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

All Properties

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

Manifest

version: 1
name: stack name
description: stack description
providers:
  - aws
globals:
  - name: region
    value: '{{ vars.AWS_REGION }}'
resources:
  - name: gateway_route_table_association
    props:
      - name: RouteTableId
        value: '{{ RouteTableId }}'
      - name: GatewayId
        value: '{{ GatewayId }}'

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

Delete

ec2:DescribeRouteTables,
ec2:DisassociateRouteTable