turbot/gcp

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

Table: gcp_bigquery_dataset

Datasets are top-level containers that are used to organize and control access to your tables and views.

Examples

Basic info

select
dataset_id,
self_link,
creation_time,
location
from
gcp_bigquery_dataset;

List datasets which are not encrypted using CMK

select
dataset_id,
location,
kms_key_name
from
gcp_bigquery_dataset
where
kms_key_name is null;

List publicly accessible datasets

select
dataset_id,
location,
ls as access_policy
from
gcp_bigquery_dataset,
jsonb_array_elements(access) as ls
where
ls ->> 'specialGroup' = 'allAuthenticatedUsers'
or ls ->> 'iamMember' = 'allUsers';

List datasets which do not have owner tag key

select
dataset_id,
location
from
gcp_bigquery_dataset
where
tags -> 'owner' is null;

.inspect gcp_bigquery_dataset

GCP BigQuery Dataset

NameTypeDescription
accessjsonbAn array of objects that define dataset access for one or more entities.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
creation_timetimestamp without time zoneThe time when this dataset was created.
dataset_idtextThe ID of the dataset resource.
default_partition_expiration_msbigintThe default partition expiration for all partitioned tables in the dataset, in milliseconds.
default_table_expiration_msbigintThe default lifetime of all tables in the dataset, in milliseconds.
descriptiontextA user-friendly description of the dataset.
etagtextA hash of the resource.
idtextThe fully-qualified, unique, opaque ID of the dataset.
kindtextThe type of the resource. This property always returns the value 'bigquery#dataset'.
kms_key_nametextDescribes the Cloud KMS encryption key that will be used to protect destination BigQuery table.
labelsjsonbA set of labels associated with this dataset.
last_modified_timetimestamp without time zoneThe date when this dataset or any of its tables was last modified.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
nametextA descriptive name for the dataset, if one exists.
projecttextThe GCP Project in which the resource is located.
self_linktextAn URL that can be used to access the resource again.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.