Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://developers.google.com/apps-script/reference/spreadsheet/big-query-data-source-spec below:

Class BigQueryDataSourceSpec | Apps Script

Stay organized with collections Save and categorize content based on your preferences.

Creates a DataSourceSpecBuilder based on this data source's settings.

// TODO(developer): Replace the URL with your own.
const ss = SpreadsheetApp.openByUrl(
    'https://docs.google.com/spreadsheets/d/abc123456/edit',
);
const spec = ss.getDataSources()[0].getSpec();

const newSpec = spec.copy();

DataSourceSpecBuilder — The builder.

Gets the BigQuery dataset ID.

String — The dataset ID, or an empty string if the data source spec is defined by a raw query.

Gets the parameters of the data source.

// TODO(developer): Replace the URL with your own.
const ss = SpreadsheetApp.openByUrl(
    'https://docs.google.com/spreadsheets/d/abc123456/edit',
);
const spec = ss.getDataSources()[0].getSpec();
const parameters = spec.getParameters();

This method is only available for BigQuery data sources.

DataSourceParameter[] — The parameter list.

Gets the billing project ID.

String — The project ID.

Gets the raw query string.

String — The raw query string.

Gets the BigQuery table ID.

String — The table ID, or an empty string if the data source spec is defined by a raw query.

Gets the BigQuery project ID for the table.

String — The table project ID, or an empty string if the data source spec is defined by a raw query.

Gets the type of the data source.

// TODO(developer): Replace the URL with your own.
const ss = SpreadsheetApp.openByUrl(
    'https://docs.google.com/spreadsheets/d/abc123456/edit',
);
const spec = ss.getDataSources()[0].getSpec();
const type = spec.getType();

DataSourceType — The data source type.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2024-12-02 UTC.

[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-02 UTC."],[[["`BigQueryDataSourceSpec` allows access to existing BigQuery data source specifications within a spreadsheet."],["You can create a new data source specification using `SpreadsheetApp.newDataSourceSpec()`."],["This class provides methods to get various details about the data source, such as dataset ID, project ID, raw query, parameters, and table information."],["The `copy()` method enables the creation of a `DataSourceSpecBuilder` to modify existing specifications."],["Utilize methods like `getDatasetId()`, `getRawQuery()`, `getTableId()`, and others to retrieve specific attributes of the BigQuery data source."]]],[]]

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4