subnet_route_table_associations

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

Overview

Name	subnet_route_table_associations
Type	Resource
Description	Associates a subnet with a route table. The subnet and route table must be in the same VPC. This association causes traffic originating from the subnet to be routed according to the routes in the route table. A route table can be associated with multiple subnets. To create a route table, see [AWS::EC2::RouteTable](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-ec2-routetable.html).
Id	aws.ec2.subnet_route_table_associations

Fields

Name	Datatype	Description
id	string
region	string	AWS region.

Methods

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

SELECT Example

SELECT
region,
id
FROM aws.ec2.subnet_route_table_associations
WHERE region = 'us-east-1';

INSERT Example

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

Required Properties

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

All Properties

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

Manifest

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

DELETE Example

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

Permissions

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

Create

ec2:AssociateRouteTable,
ec2:ReplaceRouteTableAssociation,
ec2:DescribeSubnets,
ec2:DescribeRouteTables

Delete

ec2:DisassociateRouteTable,
ec2:DescribeSubnets,
ec2:DescribeRouteTables

List

ec2:DescribeRouteTables