fix: Don't reference public schema in policies (#13619)

erezrokah · web-flow · commit 163aa942db80 · 2023-09-05T08:22:25.000Z
#### Summary Reported on Discord https://discord.com/channels/872925471417962546/1148149878615187456/1148501029386735677 <!--
diff --git a/plugins/source/aws/policies/queries/lambda/functions_with_public_egress.sql b/plugins/source/aws/policies/queries/lambda/functions_with_public_egress.sql
@@ -13,7 +13,7 @@ from aws_lambda_functions,
 where sns in
     --  Find all subnets that include a route table that inclues a catchall route
     (select a->>'SubnetId'
-        from public.aws_ec2_route_tables, jsonb_array_elements(associations) a, jsonb_array_elements(routes) r
+        from aws_ec2_route_tables, jsonb_array_elements(associations) a, jsonb_array_elements(routes) r
         where r->>'DestinationCidrBlock' = '0.0.0.0/0' OR r->>'DestinationIpv6CidrBlock' = '::/0'
     )
     and sgs in
diff --git a/website/tables/aws/aws_ec2_route_tables.md b/website/tables/aws/aws_ec2_route_tables.md
@@ -100,7 +100,7 @@ WHERE
       SELECT
         a->>'SubnetId'
       FROM
-        public.aws_ec2_route_tables,
+        aws_ec2_route_tables,
         jsonb_array_elements(associations) AS a,
         jsonb_array_elements(routes) AS r
       WHERE
diff --git a/website/tables/aws/aws_lambda_functions.md b/website/tables/aws/aws_lambda_functions.md
@@ -61,7 +61,7 @@ WHERE
       SELECT
         a->>'SubnetId'
       FROM
-        public.aws_ec2_route_tables,
+        aws_ec2_route_tables,
         jsonb_array_elements(associations) AS a,
         jsonb_array_elements(routes) AS r
       WHERE

Original file line number	Diff line number	Diff line change
`@@ -13,7 +13,7 @@ from aws_lambda_functions,`
`13`	`13`	`where sns in`
`14`	`14`	`-- Find all subnets that include a route table that inclues a catchall route`
`15`	`15`	`(select a->>'SubnetId'`
`16`		`- from public.aws_ec2_route_tables, jsonb_array_elements(associations) a, jsonb_array_elements(routes) r`
	`16`	`+ from aws_ec2_route_tables, jsonb_array_elements(associations) a, jsonb_array_elements(routes) r`
`17`	`17`	`where r->>'DestinationCidrBlock' = '0.0.0.0/0' OR r->>'DestinationIpv6CidrBlock' = '::/0'`
`18`	`18`	`)`
`19`	`19`	`and sgs in`