Total Page Preview:   000000000441

How to get cloud SQL instance list using cloudshell in gcp?

In this article I am going to explain how to get cloud sql instance list in google cloud(gcp) cloudshell command.

 

Syntax 

gcloud sql instances list [--filter=EXPRESSION] [--limit=LIMIT] [--page-size=PAGE_SIZE] [--sort-by=[FIELD,…]] [--uri] [GCLOUD_WIDE_FLAG …]

 

Example

 gcloud sql instances list

gcloud sql instances list --format="json"

 

 

OUTPUT

NAME             DATABASE_VERSION        LOCATION        TIER              PRIMARY_ADDRESS  PRIVATE_ADDRESS  STATUS
instance1        MYSQL_5_7               europe-west2-a  db-n1-standard-2  00.000.00.104    -                RUNNABLE
prod-instanceas  SQLSERVER_2017_EXPRESS  us-central1-a   db-custom-2-3840  000.000.000.160  -                RUNNABLE
prod-instances   POSTGRES_9_6            us-central1-a   db-custom-2-8192  000.00.00.229    -                RUNNABLE

 

 

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com



Comments