Google Sheets · Schema

BigQueryDataSourceSpec

The specification of a BigQuery data source that is connected to a sheet.

Google WorkspaceProductivitySpreadsheets

Properties

Name Type Description
projectId string The ID of a BigQuery enabled Google Cloud project with a billing account attached.
querySpec object A BigQueryQuerySpec.
tableSpec object A BigQueryTableSpec.
View JSON Schema on GitHub

JSON Schema

google-sheets-big-query-data-source-spec-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "BigQueryDataSourceSpec",
  "type": "object",
  "description": "The specification of a BigQuery data source that is connected to a sheet.",
  "properties": {
    "projectId": {
      "type": "string",
      "description": "The ID of a BigQuery enabled Google Cloud project with a billing account attached."
    },
    "querySpec": {
      "type": "object",
      "description": "A BigQueryQuerySpec."
    },
    "tableSpec": {
      "type": "object",
      "description": "A BigQueryTableSpec."
    }
  }
}