AWS aurora-dsql documentation change
Summary
Removed preview notice, updated system table applicability flags, standardized SQL syntax to uppercase, modified role mapping description, restructured ANALYZE command section, and changed 'Security' section title to 'Managing Aurora DSQL clusters'.
Security assessment
Changes involve documentation structure, SQL syntax formatting, and feature status updates. The role mapping description modification clarifies existing functionality but does not introduce new security considerations. The section title change from 'Security' to 'Managing Aurora DSQL clusters' does not explicitly remove security content based on visible diff context.
Diff
diff --git a/aurora-dsql/latest/userguide/working-with-systems-tables.md b/aurora-dsql/latest/userguide/working-with-systems-tables.md index f88f4eb0e..cac828c20 100644 --- a//aurora-dsql/latest/userguide/working-with-systems-tables.md +++ b//aurora-dsql/latest/userguide/working-with-systems-tables.md @@ -7,2 +6,0 @@ System tablesThe ANALYZE command -Amazon Aurora DSQL is provided as a Preview service. To learn more, see [Betas and Previews ](https://aws.amazon.com/service-terms/) in the AWS Service Terms. - @@ -75 +73 @@ Name | Applicable to Aurora DSQL -`pg_partitioned_table` | Yes +`pg_partitioned_table` | No @@ -94 +92 @@ Name | Applicable to Aurora DSQL -`pg_tablespace` | Yes +`pg_tablespace` | No @@ -196 +194 @@ Aurora DSQL supports the following system views: - select * from sys.jobs where job_id = 'example_job_uuid'; + SELECT * FROM sys.jobs WHERE job_id = 'example_job_uuid'; @@ -206 +204 @@ Aurora DSQL supports the following system views: -The view `sys.iam_pg_role_mappings` provides information about the permissions granted to IAM users. For example, suppose that `DQSLDBConnect` is an IAM role to give access of Aurora DSQL to non-admins. A user named `testuser` is granted the `DQSLDBConnect` role and corresponding permissions. You can query the `sys.iam_pg_role_mappings` view to see which users are granted which permissions. +The view `sys.iam_pg_role_mappings` provides information about the permissions granted to IAM users. For example, if `DQSLDBConnect` is an IAM role that gives Aurora DSQL access to non-admins and a user named `testuser` is granted the `DQSLDBConnect` role and corresponding permissions, you can query the `sys.iam_pg_role_mappings` view to see which users are granted which permissions. @@ -209 +207 @@ The view `sys.iam_pg_role_mappings` provides information about the permissions g - select * from sys.iam_pg_role_mappings; + SELECT * FROM sys.iam_pg_role_mappings; @@ -216 +214,4 @@ The `pg_class` table stores metadata about database objects. To get the approxim - select reltuples from pg_class where relname = 'table_name'; + SELECT reltuples FROM pg_class WHERE relname = 'table_name'; + +The command returns output similar to the following. + @@ -222,6 +223 @@ The `pg_class` table stores metadata about database objects. To get the approxim -If get the size of a table in bytes, run the following command. Note that 32768 is an internal parameter that you must include in the query. - - - select pg_size_pretty(relpages * 32768::bigint) as relbytes from pg_class where relname = '<example_table_name>'; - -## The ANALYZE command +## The `ANALYZE` command @@ -239 +235 @@ Asynchronous indexes -Security +Managing Aurora DSQL clusters