databases

Creates, updates, deletes, gets or lists a databases resource.

Overview

Name	databases
Type	Resource
Id	aws.ssm_sap.databases

Fields

The following fields are returned by SELECT queries:

get_database

Name	Datatype	Description
database	object	The SAP HANA database of an application registered with AWS Systems Manager for SAP.
tags	object	The tags of a database.

list_databases

Name	Datatype	Description
application_id	string	The ID of the application. (pattern: <code>[\w\d.-]+</code>)
arn	string	The Amazon Resource Name (ARN) of the database. (pattern: <code>arn:(.+:){2,4}.+$|^arn:(.+:){1,3}.+/.+</code>)
component_id	string	The ID of the component. (pattern: <code>[\w\d-]+</code>)
database_id	string	The ID of the database. (pattern: <code>.*[\w\d]+</code>)
database_type	string	The type of the database. (SYSTEM, TENANT)
tags	object	The tags of the database.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_database	select	region		Gets the SAP HANA database of an application registered with AWS Systems Manager for SAP.
list_databases	select	region		Lists the SAP HANA databases of an application registered with AWS Systems Manager for SAP.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)

SELECT examples

get_database

Gets the SAP HANA database of an application registered with AWS Systems Manager for SAP.

SELECT
database,
tags
FROM aws.ssm_sap.databases
WHERE region = '{{ region }}' -- required
;

list_databases

Lists the SAP HANA databases of an application registered with AWS Systems Manager for SAP.

SELECT
application_id,
arn,
component_id,
database_id,
database_type,
tags
FROM aws.ssm_sap.databases
WHERE region = '{{ region }}' -- required
;