subnet_route_table_associations

Creates, updates, deletes or gets a subnet_route_table_association resource or lists subnet_route_table_associations in a region

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
route_table_id	string	The ID of the route table. The physical ID changes when the route table ID is changed.
subnet_id	string	The ID of the subnet.
region	string	AWS region.

Methods

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

SELECT examples

Gets all subnet_route_table_associations in a region.

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

Gets all properties from an individual subnet_route_table_association.

SELECT
region,
id,
route_table_id,
subnet_id
FROM aws.ec2.subnet_route_table_associations
WHERE region = 'us-east-1' AND data__Identifier = '<Id>';

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

Read

ec2:DescribeRouteTables

Delete

ec2:DisassociateRouteTable,
ec2:DescribeSubnets,
ec2:DescribeRouteTables

List

ec2:DescribeRouteTables