Resource Type: GCP > BigQuery

The Google Cloud Platform's BigQuery service offers scalable, serverless data warehousing in the GCP cloud. It enables users to analyze and manage large datasets, known as big data, using SQL queries. It supports the running of analytics and data-driven applications efficiently and cost-effectively.

Resource Types

The BigQuery service includes these resource types:

Controls

The primary controls for GCP > BigQuery are:

In Your Workspace

Developers

Resource Type URI

tmod:@turbot/gcp-bigquery#/resource/types/bigQuery

Category URI

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

GraphQL

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

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

mutation createResource(input: { … })

mutation updateResource(input: { … })

CLI

Get Resource

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

Steampipe Query

Get Resource

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

Get Policy Settings (By Resource ID)

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

Get Resource Notification

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