This plugin for Obsidian.md allows you to perform simple AWS DynamoDB queries within your markdown documentation. It was originally designed to aid in single table design by providing a rapid prototyping and querying document during data access pattern discovery.

You create a code block with the type dynamodb and inside it write your query. You can use PartiQL or pass the parameters just as you would when using the DynamoDB client in the AWS SDK.

• PartiQL select statements for DynamoDB - Amazon DynamoDB
• Query - Amazon DynamoDB

Features:

• ✅ Basic Credentials management (Key/Secret)
• ✅ Query by PartiQL
• ✅ Query by SDK params
• ✅ Render to simple inline table
• ✅ Useful error messages
• ✅ Region selector
• ✅ Quick table info (with GSI and LSI details)
• ❌ Deals with complex nested objects
• ❌ Deals with large amounts of records (remember to limit)

Press cmd + p to bring up the command search and type...

• dynamodb-set-region to change the region your tables are in
• dynamodb-info-command to list tables in that region and get some basic info on them, such as their global indexes, or the amount of records

Note that the dynamodb-info-command can also be accessed by clickint the dynamo icon on your ribbon, usually located on the top left of Obsidian.

```dynamodb
params:
	TableName: Dynamotable
	KeyConditionExpression: pk = :v1 AND sk = :v2
	ExpressionAttributeValues:
	  ":v1":
	    S: "ORG#3t"
	  ":v2":
	    S: "ORG#3t"

```dynamodb
query: SELECT * FROM Dynamotable WHERE pk = 'ORG#Microsoft' AND begins_with("sk", 'ROLE#') 

```dynamodb
query: SELECT * FROM Dynamotable WHERE pk = 'ORG#Microsoft' AND sk = 'ORG#Microsoft'

```dynamodb
title: 🍏 PartiQL Scan in a specific region
query: SELECT * FROM Dynamotable
region: us-east-1