Control: Ensure 'log_statement' database flag for Cloud SQL PostgreSQL instance is set appropriately
Description
The value of log_statement flag determined the SQL statements that are logged. Valid values are: 'none', 'ddl', 'mod', and 'all'.
Usage
Run the control in your terminal:
powerpipe control run gcp_compliance.control.sql_instance_postgresql_log_statement_database_flag_ddl
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run gcp_compliance.control.sql_instance_postgresql_log_statement_database_flag_ddl --share
SQL
This control uses a named query:
sql_instance_postgresql_log_statement_database_flag_ddl