Google BigQuery Table

Schema representing a BigQuery table resource, including its structure, metadata, and configuration.

AnalyticsBig DataCloudData WarehouseServerlessSQL

Properties

Name	Type	Description
kind	string	The resource type, always bigquery#table
id	string	The fully-qualified unique name of the table in the format projectId:datasetId.tableId
tableReference	object	Reference describing the ID of this table
friendlyName	string	A descriptive name for this table
description	string	A user-friendly description of this table
schema	object	Describes the schema of this table
numRows	string	The number of rows of data in this table
numBytes	string	The size of this table in bytes, excluding any data in the streaming buffer
type	string	Describes the table type
location	string	The geographic location where the table resides
labels	object	The labels associated with this table
creationTime	string	The time when this table was created, in milliseconds since the epoch
expirationTime	string	The time when this table expires, in milliseconds since the epoch
lastModifiedTime	string	The time when this table was last modified, in milliseconds since the epoch

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://cloud.google.com/schemas/bigquery/table.json",
  "title": "Google BigQuery Table",
  "description": "Schema representing a BigQuery table resource, including its structure, metadata, and configuration.",
  "type": "object",
  "properties": {
    "kind": {
      "type": "string",
      "description": "The resource type, always bigquery#table",
      "const": "bigquery#table"
    },
    "id": {
      "type": "string",
      "description": "The fully-qualified unique name of the table in the format projectId:datasetId.tableId"
    },
    "tableReference": {
      "$ref": "#/$defs/TableReference",
      "description": "Reference describing the ID of this table"
    },
    "friendlyName": {
      "type": "string",
      "description": "A descriptive name for this table",
      "maxLength": 1024
    },
    "description": {
      "type": "string",
      "description": "A user-friendly description of this table"
    },
    "schema": {
      "$ref": "#/$defs/TableSchema",
      "description": "Describes the schema of this table"
    },
    "numRows": {
      "type": "string",
      "description": "The number of rows of data in this table"
    },
    "numBytes": {
      "type": "string",
      "description": "The size of this table in bytes, excluding any data in the streaming buffer"
    },
    "type": {
      "type": "string",
      "description": "Describes the table type",
      "enum": ["TABLE", "VIEW", "MATERIALIZED_VIEW", "EXTERNAL", "SNAPSHOT"]
    },
    "location": {
      "type": "string",
      "description": "The geographic location where the table resides"
    },
    "labels": {
      "type": "object",
      "description": "The labels associated with this table",
      "additionalProperties": {
        "type": "string"
      }
    },
    "creationTime": {
      "type": "string",
      "description": "The time when this table was created, in milliseconds since the epoch"
    },
    "expirationTime": {
      "type": "string",
      "description": "The time when this table expires, in milliseconds since the epoch"
    },
    "lastModifiedTime": {
      "type": "string",
      "description": "The time when this table was last modified, in milliseconds since the epoch"
    }
  },
  "$defs": {
    "TableReference": {
      "type": "object",
      "description": "A reference uniquely identifying a BigQuery table",
      "required": ["projectId", "datasetId", "tableId"],
      "properties": {
        "projectId": {
          "type": "string",
          "description": "The ID of the project containing this table"
        },
        "datasetId": {
          "type": "string",
          "description": "The ID of the dataset containing this table"
        },
        "tableId": {
          "type": "string",
          "description": "The ID of the table"
        }
      }
    },
    "TableSchema": {
      "type": "object",
      "description": "Schema of a BigQuery table",
      "properties": {
        "fields": {
          "type": "array",
          "description": "Describes the fields in a table",
          "items": {
            "$ref": "#/$defs/TableFieldSchema"
          }
        }
      }
    },
    "TableFieldSchema": {
      "type": "object",
      "description": "A field in a BigQuery table schema",
      "required": ["name", "type"],
      "properties": {
        "name": {
          "type": "string",
          "description": "The field name, must be unique within the table schema"
        },
        "type": {
          "type": "string",
          "description": "The field data type",
          "enum": ["STRING", "BYTES", "INTEGER", "INT64", "FLOAT", "FLOAT64", "NUMERIC", "BIGNUMERIC", "BOOLEAN", "BOOL", "TIMESTAMP", "DATE", "TIME", "DATETIME", "GEOGRAPHY", "RECORD", "STRUCT", "JSON", "RANGE"]
        },
        "mode": {
          "type": "string",
          "description": "The field mode",
          "enum": ["NULLABLE", "REQUIRED", "REPEATED"],
          "default": "NULLABLE"
        },
        "description": {
          "type": "string",
          "description": "The field description"
        },
        "fields": {
          "type": "array",
          "description": "Describes the nested schema fields if the type is RECORD",
          "items": {
            "$ref": "#/$defs/TableFieldSchema"
          }
        },
        "policyTags": {
          "type": "object",
          "description": "Policy tags attached to this field for column-level security",
          "properties": {
            "names": {
              "type": "array",
              "items": {
                "type": "string"
              },
              "description": "A list of policy tag resource names"
            }
          }
        }
      }
    }
  }
}