AWS CLI output table as multi columns

- 개요

AWS CLI output을 table로 할 때 depth가 많은 경우 column이 하나로 겹쳐서 나오는 경우가 있다.

 

- 해결 방법

마지막에 "|[0]" 붙혀서 query 한다.

 

- 예제 (Single Column)

aws ec2 describe-network-interfaces --query 'NetworkInterfaces[*].{PublicIP:PrivateIpAddresses[].Association.PublicIp}' --output table

---------------------------
|DescribeNetworkInterfaces|
|DescribeNetworkInterfaces|
|DescribeNetworkInterfaces|
|DescribeNetworkInterfaces|
|DescribeNetworkInterfaces|
|DescribeNetworkInterfaces|
|DescribeNetworkInterfaces|
||       PublicIP        ||
|+-----------------------+|
||  11.111.1.11          ||
|+-----------------------+|
|DescribeNetworkInterfaces|
||       PublicIP        ||
|+-----------------------+|

 

- 예제 (Multi Column)

aws ec2 describe-network-interfaces --query 'NetworkInterfaces[*].{PublicIP:PrivateIpAddresses[].Association.PublicIp|[0]}' --output table

---------------------------
|DescribeNetworkInterfaces|
+-------------------------+
|        PublicIP         |
+-------------------------+
|  None                   |
|  None                   |
|  11.111.1.1             |
|  None                   |
|  None                   |
|  None                   |
|  None                   |
|  None                   |
|  None                   |
+-------------------------+

 

- 참고

https://stackoverflow.com/questions/73236117/aws-cli-output-table-as-single-columns