gcloud formatting output

GCP : output in table format using gcloud sdk tool

The Google Cloud Platform(GCP) provides a handy CLI tool to interact with its service – gcp cloud sdk or gcloud command. Here are some tips to format the output of this command in a tabular format.

Let us list the zones in GCP and by default this is what the output looks like –

$ gcloud compute zones list
NAME                       REGION                   STATUS  NEXT_MAINTENANCE  TURNDOWN_DATE
us-east1-b                 us-east1                 UP
us-east1-c                 us-east1                 UP
us-east1-d                 us-east1                 UP
us-east4-c                 us-east4                 UP
us-east4-b                 us-east4                 UP
us-east4-a                 us-east4                 UP
us-central1-c              us-central1              UP
us-central1-a              us-central1              UP
us-central1-f              us-central1              UP
us-central1-b              us-central1              UP
us-west1-b                 us-west1                 UP
us-west1-c                 us-west1                 UP
us-west1-a                 us-west1                 UP
europe-west4-a             europe-west4             UP
europe-west4-b             europe-west4             UP
europe-west4-c             europe-west4             UP
europe-west1-b             europe-west1             UP
europe-west1-d             europe-west1             UP
europe-west1-c             europe-west1             UP
europe-west3-c             europe-west3             UP
europe-west3-a             europe-west3             UP
europe-west3-b             europe-west3             UP
europe-west2-c             europe-west2             UP
europe-west2-b             europe-west2             UP
europe-west2-a             europe-west2             UP
asia-east1-b               asia-east1               UP
asia-east1-a               asia-east1               UP
asia-east1-c               asia-east1               UP
asia-southeast1-b          asia-southeast1          UP
asia-southeast1-a          asia-southeast1          UP
asia-southeast1-c          asia-southeast1          UP
asia-northeast1-b          asia-northeast1          UP
asia-northeast1-c          asia-northeast1          UP
asia-northeast1-a          asia-northeast1          UP
asia-south1-c              asia-south1              UP
asia-south1-b              asia-south1              UP
asia-south1-a              asia-south1              UP
australia-southeast1-b     australia-southeast1     UP
australia-southeast1-c     australia-southeast1     UP
australia-southeast1-a     australia-southeast1     UP
southamerica-east1-b       southamerica-east1       UP
southamerica-east1-c       southamerica-east1       UP
southamerica-east1-a       southamerica-east1       UP
asia-east2-a               asia-east2               UP
asia-east2-b               asia-east2               UP
asia-east2-c               asia-east2               UP
asia-northeast2-a          asia-northeast2          UP
asia-northeast2-b          asia-northeast2          UP
asia-northeast2-c          asia-northeast2          UP
asia-northeast3-a          asia-northeast3          UP
asia-northeast3-b          asia-northeast3          UP
asia-northeast3-c          asia-northeast3          UP
europe-north1-a            europe-north1            UP
europe-north1-b            europe-north1            UP
europe-north1-c            europe-north1            UP
europe-west6-a             europe-west6             UP
europe-west6-b             europe-west6             UP
europe-west6-c             europe-west6             UP
northamerica-northeast1-a  northamerica-northeast1  UP
northamerica-northeast1-b  northamerica-northeast1  UP
northamerica-northeast1-c  northamerica-northeast1  UP
us-west2-a                 us-west2                 UP
us-west2-b                 us-west2                 UP
us-west2-c                 us-west2                 UP

Now let us output this in tabular format and only print the GCP zones we are interested in –

$ gcloud compute zones  list --format="table[box,title=GCP-REGIONS](name,region,status)" --filter='name~europe'
┌──────────────────────────────────────────┐
│               GCP-REGIONS                │
├─────────────────┬───────────────┬────────┤
│       NAME      │     REGION    │ STATUS │
├─────────────────┼───────────────┼────────┤
│ europe-west4-a  │ europe-west4  │ UP     │
│ europe-west4-b  │ europe-west4  │ UP     │
│ europe-west4-c  │ europe-west4  │ UP     │
│ europe-west1-b  │ europe-west1  │ UP     │
│ europe-west1-d  │ europe-west1  │ UP     │
│ europe-west1-c  │ europe-west1  │ UP     │
│ europe-west3-c  │ europe-west3  │ UP     │
│ europe-west3-a  │ europe-west3  │ UP     │
│ europe-west3-b  │ europe-west3  │ UP     │
│ europe-west2-c  │ europe-west2  │ UP     │
│ europe-west2-b  │ europe-west2  │ UP     │
│ europe-west2-a  │ europe-west2  │ UP     │
│ europe-north1-a │ europe-north1 │ UP     │
│ europe-north1-b │ europe-north1 │ UP     │
│ europe-north1-c │ europe-north1 │ UP     │
│ europe-west6-a  │ europe-west6  │ UP     │
│ europe-west6-b  │ europe-west6  │ UP     │
│ europe-west6-c  │ europe-west6  │ UP     │
└─────────────────┴───────────────┴────────┘

You can get more details on formatting your output with –

gcloud topic formats --help

References –

https://cloud.google.com/sdk

https://cloud.google.com/sdk/gcloud/reference/topic/formats