Google Cloud (GCP) BigQuery table

gcp.project.bigqueryService.table MQL resource for querying Google Cloud infrastructure with cnquery and cnspec.

Google CloudPrivate Resource

Min version: latestDefaults: id

Relationships

Google Cloud

4 resources · 7 relationships·Click to select, expand fields to see properties.

Field	Type	Description
`clusteringFields`required	dict	Data clustering configuration
`created`required	time	Creation timestamp
`datasetId`required	string	Dataset ID
`description`required	string	User-friendly description of the table
`expirationTime`required	time	Time when this table expires
`externalDataConfig`required	dict	Information about table stored outside of BigQuery.
`id`required	string	Table ID
`kmsName`required	string	Cloud KMS encryption key that is used to protect BigQuery table
`labels`required	map[string]string	User-provided labels
`location`required	string	Location of the table
`materializedView`required	dict	Information for materialized views
`modified`required	time	Modified timestamp
`name`required	string	The user-friendly name for the table
`numBytes`required	int	Size of the table in bytes
`numLongTermBytes`required	int	Number of bytes in the table considered "long-term storage" for reduced billing purposes
`numRows`required	int	Number of rows of data in this table
`projectId`required	string	Project ID
`rangePartitioning`required	dict	Integer-range-based partitioning on a table
`requirePartitionFilter`required	int	Whether queries that reference this table must specify a partition filter
`schema`required	[]dict	Table schema
`snapshotTime`required	time	Snapshot creation time
`timePartitioning`required	dict	Time-based date partitioning on a table
`type`required	string	Table Type
`useLegacySQL`required	int	Whether the view query uses Legacy SQL
`viewQuery`required	string	Query to use for a logical view