Resource Type: GCP > SQL

The Google Cloud SQL service offers flexible and scalable database storage in the GCP cloud. It enables users to create and manage relational databases, known as instances, that can store and manage data for applications and services.

Resource Types

The SQL service includes these resource types:

Controls

The primary controls for GCP > SQL are:

In Your Workspace

Developers

Resource Type URI

tmod:@turbot/gcp-sql#/resource/types/sql

Category URI

tmod:@turbot/turbot#/resource/categories/cloudService

GraphQL

query resource(id: "tmod:@turbot/gcp-sql#/resource/types/sql") { … }

query resourceActivities(filter: "resourceId:'tmod:@turbot/gcp-sql#/resource/types/sql'") { … }

mutation createResource(input: { … })

mutation updateResource(input: { … })

CLI

Get Resource

turbot graphql resource --id "tmod:@turbot/gcp-sql#/resource/types/sql"

Steampipe Query

Get Resource

select * from guardrails_resource where resource_type_uri = 'tmod:@turbot/gcp-sql#/resource/types/sql';

Get Policy Settings (By Resource ID)

select * from guardrails_policy_setting where filter = 'resourceTypeId:"tmod:@turbot/gcp-sql#/resource/types/sql"';

Get Resource Notification

select * from guardrails_notification where resource_type_uri = 'tmod:@turbot/gcp-sql#/resource/types/sql' and notification_type in ('resource_updated', 'resource_created');