AWS prescriptive-guidance documentation change
Summary
Formatting changes including whitespace adjustments, indentation fixes, and SQL code alignment. Updates to IAM policy JSON formatting and PostgreSQL function syntax corrections.
Security assessment
The changes primarily involve code formatting, indentation, and syntax corrections without introducing new security controls or addressing specific vulnerabilities. The IAM policy modifications are structural (whitespace/formatting) but maintain the same S3 permissions as before. No evidence of security vulnerability fixes or new security features added.
Diff
diff --git a/prescriptive-guidance/latest/patterns/migrate-oracle-external-tables-to-amazon-aurora-postgresql-compatible.md b/prescriptive-guidance/latest/patterns/migrate-oracle-external-tables-to-amazon-aurora-postgresql-compatible.md index 4b3ebac5f..4731dfc25 100644 --- a//prescriptive-guidance/latest/patterns/migrate-oracle-external-tables-to-amazon-aurora-postgresql-compatible.md +++ b//prescriptive-guidance/latest/patterns/migrate-oracle-external-tables-to-amazon-aurora-postgresql-compatible.md @@ -201,13 +201,13 @@ Monitor the solution.| In the Amazon CloudWatch console, monitor the Lambda func - table_name_stg character varying(100) , - table_name character varying(100) , - col_list character varying(1000) , - data_type character varying(100) , - col_order numeric, - start_pos numeric, - end_pos numeric, - no_position character varying(100) , - date_mask character varying(100) , - delimeter character(1) , - directory character varying(100) , - file_name character varying(100) , - header_exist character varying(5) + table_name_stg character varying(100) , + table_name character varying(100) , + col_list character varying(1000) , + data_type character varying(100) , + col_order numeric, + start_pos numeric, + end_pos numeric, + no_position character varying(100) , + date_mask character varying(100) , + delimeter character(1) , + directory character varying(100) , + file_name character varying(100) , + header_exist character varying(5) @@ -217 +217 @@ Monitor the solution.| In the Amazon CloudWatch console, monitor the Lambda func - col1 text + col1 text @@ -221,3 +221,3 @@ Monitor the solution.| In the Amazon CloudWatch console, monitor the Lambda func - error_details text, - file_name character varying(100), - processed_time timestamp without time zone + error_details text, + file_name character varying(100), + processed_time timestamp without time zone @@ -227,5 +227,5 @@ Monitor the solution.| In the Amazon CloudWatch console, monitor the Lambda func - file_name character varying(50) COLLATE pg_catalog."default", - processed_date timestamp without time zone, - tot_rec_count numeric, - proc_rec_count numeric, - error_rec_count numeric + file_name character varying(50) COLLATE pg_catalog."default", + processed_date timestamp without time zone, + tot_rec_count numeric, + proc_rec_count numeric, + error_rec_count numeric @@ -244,17 +244,17 @@ Monitor the solution.| In the Amazon CloudWatch console, monitor the Lambda func - --Create an IAM policy to allow, Get, and list actions on S3 bucket - { - "Version": "2012-10-17", - "Statement": [ - { - "Sid": "s3import", - "Action": [ - "s3:GetObject", - "s3:ListBucket" - ], - "Effect": "Allow", - "Resource": [ - "arn:aws:s3:::s3importtest", - "arn:aws:s3:::s3importtest/*" - ] - } - ] + --Create an IAM policy to allow, Get, and list actions on S3 bucket + { + "Version": "2012-10-17", + "Statement": [ + { + "Sid": "s3import", + "Action": [ + "s3:GetObject", + "s3:ListBucket" + ], + "Effect": "Allow", + "Resource": [ + "arn:aws:s3:::s3importtest", + "arn:aws:s3:::s3importtest/*" + ] + } + ] @@ -263 +263,4 @@ Monitor the solution.| In the Amazon CloudWatch console, monitor the Lambda func - --Create an IAM policy to allow, put, and list actions on S3 bucket + --Create an IAM policy to allow, put, and list actions on S3 bucket + { + "Version": "2012-10-17", + "Statement": [ @@ -265,14 +268,11 @@ Monitor the solution.| In the Amazon CloudWatch console, monitor the Lambda func - "Version": "2012-10-17", - "Statement": [ - { - "Sid": "s3export", - "Action": [ - "S3:PutObject", - "s3:ListBucket" - ], - "Effect": "Allow", - "Resource": [ - "arn:aws:s3:::s3importtest/*" - ] - } - ] + "Sid": "s3export", + "Action": [ + "S3:PutObject", + "s3:ListBucket" + ], + "Effect": "Allow", + "Resource": [ + "arn:aws:s3:::s3importtest/*" + ] + } + ] @@ -285,2 +285,2 @@ Monitor the solution.| In the Amazon CloudWatch console, monitor the Lambda func - RETURNS character varying - LANGUAGE plpgsql + RETURNS character varying + LANGUAGE plpgsql @@ -290,52 +290,52 @@ Monitor the solution.| In the Amazon CloudWatch console, monitor the Lambda func - v_final_sql TEXT; - pi_ext_table TEXT; - r refCURSOR; - v_sqlerrm text; - v_chunk numeric; - i integer; - v_col_list TEXT; - v_postion_list CHARACTER VARYING(1000); - v_len integer; - v_delim varchar; - v_file_name CHARACTER VARYING(1000); - v_directory CHARACTER VARYING(1000); - v_table_name_stg CHARACTER VARYING(1000); - v_sql_col TEXT; - v_sql TEXT; - v_sql1 TEXT; - v_sql2 TEXT; - v_sql3 TEXT; - v_cnt integer; - v_sql_dynamic TEXT; - v_sql_ins TEXT; - proc_rec_COUNT integer; - error_rec_COUNT integer; - tot_rec_COUNT integer; - v_rec_val integer; - rec record; - v_col_cnt integer; - kv record; - v_val text; - v_header text; - j integer; - ERCODE VARCHAR(5); - v_region text; - cr CURSOR FOR - SELECT distinct DELIMETER, - FILE_NAME, - DIRECTORY - FROM meta_EXTERNAL_TABLE - WHERE table_name = pi_ext_table - AND DELIMETER IS NOT NULL; - - - cr1 CURSOR FOR - SELECT col_list, - data_type, - start_pos, - END_pos, - concat_ws('',' ',TABLE_NAME_STG) as TABLE_NAME_STG, - no_position,date_mask - FROM meta_EXTERNAL_TABLE - WHERE table_name = pi_ext_table - order by col_order asc; + v_final_sql TEXT; + pi_ext_table TEXT; + r refCURSOR; + v_sqlerrm text; + v_chunk numeric; + i integer; + v_col_list TEXT; + v_postion_list CHARACTER VARYING(1000); + v_len integer; + v_delim varchar; + v_file_name CHARACTER VARYING(1000); + v_directory CHARACTER VARYING(1000); + v_table_name_stg CHARACTER VARYING(1000); + v_sql_col TEXT; + v_sql TEXT; + v_sql1 TEXT; + v_sql2 TEXT; + v_sql3 TEXT; + v_cnt integer; + v_sql_dynamic TEXT; + v_sql_ins TEXT; + proc_rec_COUNT integer; + error_rec_COUNT integer;