Pipeline: Correct one SQL database exceeding max age

Correct one SQL Databases exceeding max age

Overview

SQL Databases can be quite costly to retain, it is also likely that after a certain point in time they're no longer required and should be cleaned up to prevent further costs.

This pipeline allows you to specify a collection of SQL Databases and then either send notifications or attempt to perform a predefined corrective action upon the collection.

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

Run the pipeline

To run this pipeline from your terminal:

flowpipe pipeline run azure_thrifty.pipeline.correct_one_sql_database_exceeding_max_age \
  --arg 'title=<string>' \
  --arg 'name=<string>' \
  --arg 'resource_group=<string>' \
  --arg 'server_name=<string>' \
  --arg 'subscription_id=<string>' \
  --arg 'conn=<connection.azure>'

Use this pipeline

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

step "pipeline" "step_name" {
  pipeline = azure_thrifty.pipeline.correct_one_sql_database_exceeding_max_age  
  args = {
    title = <string>
    name = <string>
    resource_group = <string>
    server_name = <string>
    subscription_id = <string>
    conn = <connection.azure>
  }
}

Params

Name	Type	Required	Description	Default
title	string	Yes	Title of the resource, to be used as a display name.	-
name	string	Yes	The name of the SQL Database.	-
resource_group	string	Yes	Azure Resource Group of the resource(s).	-
server_name	string	Yes	The name of the server.	-
subscription_id	string	Yes	Azure Subscription ID of the resource(s).	-
conn	connection.azure	Yes	Name of the Azure 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_database`	Yes	The default action to use for the detected item, used if no input is provided.	`notify`
enabled_actions	list(string) `skip`, `delete_sql_database`	Yes	The list of enabled actions to provide to approvers for selection.	`[ "skip", "delete_sql_database" ]`

Outputs

This pipeline has no outputs.