Skip to main content

dimension_key_details

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

Overview

Namedimension_key_details
TypeResource
Idaws.pi.dimension_key_details

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
dimensionsarrayThe details for the requested dimensions.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_dimension_key_detailsselectregionGet the attributes of the specified dimension group for a DB instance or data source. For example, if you specify a SQL ID, GetDimensionKeyDetails retrieves the full text of the dimension db.sql.statement associated with this ID. This operation is useful because GetResourceMetrics and DescribeDimensionKeys don't support retrieval of large SQL statement text, lock snapshots, and execution plans.

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.

NameDatatypeDescription
regionstringAWS region (default: us-east-1)

SELECT examples

Get the attributes of the specified dimension group for a DB instance or data source. For example, if you specify a SQL ID, GetDimensionKeyDetails retrieves the full text of the dimension db.sql.statement associated with this ID. This operation is useful because GetResourceMetrics and DescribeDimensionKeys don't support retrieval of large SQL statement text, lock snapshots, and execution plans.

SELECT
dimensions
FROM aws.pi.dimension_key_details
WHERE region = '{{ region }}' -- required
;