turbot/gcp

steampipe plugin install gcpsteampipe plugin install gcp
On This Page
Get Involved

Table: gcp_sql_database

Cloud SQL is a fully-managed database service that helps to set up, maintain, manage, and administer relational databases on Google Cloud Platform.

Examples

Basic info

select
name,
instance_name,
charset,
collation
from
gcp_sql_database;

Get the SQL Server version with which the database is to be made compatible

select
name,
sql_server_database_compatibility_level
from
gcp_sql_database;

Count of databases per instance

select
instance_name,
count(*) as database_count
from
gcp_sql_database
group by
instance_name;

.inspect gcp_sql_database

GCP SQL Database

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
charsettextSpecifies the MySQL charset value.
collationtextSpecifies the MySQL collation value.
instance_nametextThe name of the Cloud SQL instance.
kindtextThe type of the resource.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
nametextA friendly name that identifies the resource.
projecttextThe GCP Project in which the resource is located.
self_linktextThe server-defined URL for the resource.
sql_server_database_compatibility_levelbigintThe version of SQL Server with which the database is to be made compatible.
sql_server_database_recovery_modeltextThe recovery model of a SQL Server database.
titletextTitle of the resource.