How to use DATASOURCE::POLARDB::ParameterGroups to query parameter templates in a region - Resource Orchestration Service

Syntax

{
  "Type": "DATASOURCE::POLARDB::ParameterGroups",
  "Properties": {
    "DbVersion": String,
    "DbType": String,
    "RefreshOptions": String
  }
}

Properties

Property	Type	Required	Editable	Description	Constraint
DbVersion	String	No	Yes	The type of the database engine.	Only MySQL is supported.
DbType	String	No	Yes	The version of the database engine.	Valid values: 5.6 5.7 8.0
RefreshOptions	String	No	Yes	The refresh policy for data source resources when the stack is updated.	Valid values: Never (default): Data source resources are not refreshed when the stack is updated. Always: Data source resources are refreshed when the stack is updated.

Return values

Fn::GetAtt

ParameterGroups: details of the parameter templates.
ParameterGroupIds: the IDs of the parameter templates.

Property	Type	Description	Constraint
ParameterGroupIds	List	The IDs of the parameter templates.	None.
ParameterGroups	List	Details of the parameter templates.	None.
DbType	String	The type of the database engine.	None.
ParameterGroupId	String	The ID of the parameter template.	None.
ParameterCounts	Number	The number of parameters in the parameter template.	None.
DbVersion	String	The version of the database engine.	None.
ParameterGroupDesc	String	The description of the parameter template.	None.
ParameterGroupType	String	The type of the parameter template.	Valid values: 0: default parameter template. 1: custom parameter template. 2: automatic backup parameter template. After you use the template, the system automatically backs up the original parameter settings and saves them as a template.
ForceRestart	String	Whether a cluster restart is required to apply the parameter template.	Valid values: 0: No cluster restart is required. 1: A cluster restart is required.
ParameterGroupName	String	The name of the parameter template.	None.
CreateTime	String	The time when the parameter template was created.	The time is in the ISO 8601 standard in the `YYYY-MM-ddTHH:mm:ssZ` format. The time is displayed in UTC.

Examples

YAML

ROSTemplateFormatVersion: '2015-09-01'
Parameters: {}
Resources:
  ExtensionDataSource:
    Type: DATASOURCE::POLARDB::ParameterGroups
    Properties:
      DbVersion: '5.7'
      DbType: MySQL
Outputs:
  ParameterGroups:
    Description: The list of parameter groups.
    Value:
      Fn::GetAtt:
        - ExtensionDataSource
        - ParameterGroups
  ParameterGroupIds:
    Description: The list of parameter group IDs.
    Value:
      Fn::GetAtt:
        - ExtensionDataSource
        - ParameterGroupIds

JSON

{
  "ROSTemplateFormatVersion": "2015-09-01",
  "Parameters": {
  },
  "Resources": {
    "ExtensionDataSource": {
      "Type": "DATASOURCE::POLARDB::ParameterGroups",
      "Properties": {
        "DbVersion": "5.7",
        "DbType": "MySQL"
      }
    }
  },
  "Outputs": {
    "ParameterGroups": {
      "Description": "The list of parameter groups.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionDataSource",
          "ParameterGroups"
        ]
      }
    },
    "ParameterGroupIds": {
      "Description": "The list of parameter group IDs.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionDataSource",
          "ParameterGroupIds"
        ]
      }
    }
  }
}