2回答
- 新しい順
- 投票が多い順
- コメントが多い順
1
Hi, The Scan command you are looking for looks like this:
aws dynamodb scan --table-name cust --query 'Items[*].stateHistory.L[*].M.state'
aws dynamodb scan --table-name cust --query 'Items[*].stateHistory.L[*].M.state'
[
[
{
"S": "confirmed"
},
{
"S": "active"
},
{
"S": "finished"
},
{
"S": "archived"
}
]
]
Or you can narrow it down further with:
aws dynamodb scan --table-name cust --query 'Items[*].stateHistory.L[*].M.state.S' --output text
aws dynamodb scan --table-name cust --query 'Items[*].stateHistory.L[*].M.state.S' --output text
confirmed active finished archived
0
Thank you! Exactly what I needed! 👍 I modified it slightly, so that the output in the text is easy to process via Excel:
...,(stateHistory.L[0].M.state.S),(stateHistory.L[1].M.state.S),(stateHistory.L[2].M.state.S),(stateHistory.L[3].M.state.S),(stateHistory.L[4].M.state.S)]" --output text> data.txt
Follow-up question: How do I add headlines to each data field of the data.txt automatically so that I can use them as column names in Excel afterwards? 🤔
回答済み 2年前
関連するコンテンツ
- AWS公式更新しました 1年前
- AWS公式更新しました 1年前
- AWS公式更新しました 9ヶ月前
- AWS公式更新しました 2年前