Skip to content

haohanyang/dynamodb-datasource

Repository files navigation

Grafana DynamoDB data source

Query your Amazon DynamoDB using PartiQL and visualize the results in your Grafana dashboards.

screenshot

Get started

Data source Configuration

The plugin uses grafana-aws-sdk-react in the configuration page, a common package used for all AWS-related plugins(including plugins made by Grafana Lab). In addition, to test the connection, the plugin requires a "test table", to which the plugin makes a DescribeTable request.

Query data

The plugin currently supports query via PartiQL. The plugin performs ExecuteStatement on the PartiQL statement that user enters.

Datetime attribute

To parse datetime attributes in Grafana, user needs to provide attribute names and format. The format can be unix timestamp (for integers) or day.js format (for strings)

Datetime Format
1731017392 Unix timestamp(s)
1731017406839 Unix timestamp(ms)
2024-10-31T22:04:29+01:00 YYYY-MM-DDTHH:mm:ssZ
2024-10-31T21:04:29Z YYYY-MM-DDTHH:mm:ss[Z]
Thu, 31 Oct 2024 21:04:29 GMT ddd, DD MMM YYYY HH:mm:ss z

Variables

  • $__from and $__to (built-in): start and end in Unix timestamp(ms)
  • $from and $to: start and end in Unix timestamp(s)

You can filter data within the current time range:

SELECT * FROM MyTable WHERE TimeStamp BETWEEN $from AND $to