Pipeline: Correct one SQL database instance exceeding max age

Correct one SQL DB Instance exceeding max age

SQL DB instances can be costly to run, especially if they're rarely used, instances that have been running for a long time should be reviewed to determine if they're still required.

This control allows you to specify a threshold for how long an instance has been running and then either send a notification or attempt to perform a predefined corrective action.

Whilst it is possible to utilise this pipeline standalone, it is usually called from the correct_sql_db_instances_exceeding_max_age pipeline.

Run the pipeline

To run this pipeline from your terminal:

flowpipe pipeline run gcp_thrifty.pipeline.correct_one_sql_db_instance_exceeding_max_age \
  --arg 'name=<string>' \
  --arg 'project=<string>' \
  --arg 'title=<string>' \
  --arg 'conn=<connection.gcp>'

Use this pipeline

To call this pipeline from your pipeline, use a step:

step "pipeline" "step_name" {
  pipeline = gcp_thrifty.pipeline.correct_one_sql_db_instance_exceeding_max_age  
  args = {
    name = <string>
    project = <string>
    title = <string>
    conn = <connection.gcp>
  }
}

Params

Name	Type	Required	Description	Default
name	string	Yes	The name of the SQL database instance.	-
project	string	Yes	GCP Project ID of the resource(s).	-
title	string	Yes	Title of the resource, to be used as a display name.	-
conn	connection.gcp	Yes	Name of the GCP connection to be used for any authenticated actions.	-
notifier	notifier	Yes	The name of the notifier to use for sending notification messages.	`notifier.default`
notification_level	string `info`, `verbose`, `error`	Yes	The verbosity level of notification messages to send.	`info`
approvers	list(notifier)	Yes	List of notifiers to be used for obtaining action/approval decisions.	`notifier.default`
default_action	string `notify`, `skip`, `delete_sql_db_instance`	Yes	The default action to use for the detected item, used if no input is provided.	`notify`
enabled_actions	list(string) `skip`, `delete_sql_db_instance`	Yes	The list of enabled actions to provide to approvers for selection.	`[ "skip", "delete_sql_db_instance" ]`

Outputs