local_gateway_route_tables

Creates, updates, deletes or gets a local_gateway_route_table resource or lists local_gateway_route_tables in a region

Overview

Name	local_gateway_route_tables
Type	Resource
Description	Describes a route table for a local gateway.
Id	aws.ec2.local_gateway_route_tables

Fields

Name	Datatype	Description
local_gateway_route_table_id	string	The ID of the local gateway route table.
local_gateway_route_table_arn	string	The ARN of the local gateway route table.
local_gateway_id	string	The ID of the local gateway.
outpost_arn	string	The ARN of the outpost.
owner_id	string	The owner of the local gateway route table.
state	string	The state of the local gateway route table.
mode	string	The mode of the local gateway route table.
tags	array	The tags for the local gateway route table.
region	string	AWS region.

Methods

Name	Accessible by	Required Params
create_resource	INSERT	LocalGatewayId, region
delete_resource	DELETE	data__Identifier, region
update_resource	UPDATE	data__Identifier, data__PatchDocument, region
list_resources	SELECT	region
get_resource	SELECT	data__Identifier, region

SELECT examples

Gets all local_gateway_route_tables in a region.

SELECT
region,
local_gateway_route_table_id,
local_gateway_route_table_arn,
local_gateway_id,
outpost_arn,
owner_id,
state,
mode,
tags
FROM aws.ec2.local_gateway_route_tables
WHERE region = 'us-east-1';

Gets all properties from an individual local_gateway_route_table.

SELECT
region,
local_gateway_route_table_id,
local_gateway_route_table_arn,
local_gateway_id,
outpost_arn,
owner_id,
state,
mode,
tags
FROM aws.ec2.local_gateway_route_tables
WHERE region = 'us-east-1' AND data__Identifier = '<LocalGatewayRouteTableId>';

INSERT example

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

Required Properties

/*+ create */
INSERT INTO aws.ec2.local_gateway_route_tables (
 LocalGatewayId,
 region
)
SELECT 
'{{ LocalGatewayId }}',
'{{ region }}';

All Properties

/*+ create */
INSERT INTO aws.ec2.local_gateway_route_tables (
 LocalGatewayId,
 Mode,
 Tags,
 region
)
SELECT 
 '{{ LocalGatewayId }}',
 '{{ Mode }}',
 '{{ Tags }}',
 '{{ region }}';

Manifest

version: 1
name: stack name
description: stack description
providers:
  - aws
globals:
  - name: region
    value: '{{ vars.AWS_REGION }}'
resources:
  - name: local_gateway_route_table
    props:
      - name: LocalGatewayId
        value: '{{ LocalGatewayId }}'
      - name: Mode
        value: '{{ Mode }}'
      - name: Tags
        value:
          - Key: '{{ Key }}'
            Value: '{{ Value }}'

DELETE example

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

Permissions

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

Create

ec2:CreateLocalGatewayRouteTable,
ec2:DescribeLocalGatewayRouteTables,
ec2:CreateTags

Read

ec2:DescribeLocalGatewayRouteTables

Update

ec2:DescribeLocalGatewayRouteTables,
ec2:CreateTags,
ec2:DeleteTags

Delete

ec2:DeleteLocalGatewayRouteTable,
ec2:DescribeLocalGatewayRouteTables,
ec2:DeleteTags

List

ec2:DescribeLocalGatewayRouteTables