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-builder below:

Class BigQueryDataSourceSpecBuilder | Apps Script

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

Builds a data source specification from the settings in this builder. Must use as...() to specify a data source type before building.

The following code sample builds a BigQuery DataSource Spec.

const bigQueryDataSourceSpec = SpreadsheetApp.newDataSourceSpec().asBigQuery();
// TODO(developer): Replace with the required dataset, project and table IDs.
bigQueryDataSourceSpec.setDatasetId('my data set id');
bigQueryDataSourceSpec.setProjectId('my project id');
bigQueryDataSourceSpec.setTableId('my table id');

bigQueryDataSourceSpec.build();

The following code sample builds a Looker DataSource Spec.

const lookerDataSourceSpecBuilder =
    SpreadsheetApp.newDataSourceSpec().asLooker();
const lookerSpec = lookerDataSourceSpecBuilder.setExploreName('my explore name')
                       .setInstanceUrl('my instance url')
                       .setModelName('my model name')
                       .build();

DataSourceSpec — The data source specification.

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.

Removes all the parameters.

const specBuilder = SpreadsheetApp.newDataSourceSpec();
specBuilder.removeAllParameters();

BigQueryDataSourceSpecBuilder — The builder, for chaining.

Removes the specified parameter.

const specBuilder = SpreadsheetApp.newDataSourceSpec();
specBuilder.removeParameter('x');

BigQueryDataSourceSpecBuilder — The builder, for chaining.

Sets the BigQuery dataset ID.

BigQueryDataSourceSpecBuilder — This builder, for chaining.

Adds a parameter, or if the parameter with the name exists, updates its source cell for data source spec builders of type DataSourceType.BIGQUERY.

This method is only available for BigQuery data sources.

const specBuilder = SpreadsheetApp.newDataSourceSpec().asBigQuery();
specBuilder.setParameterFromCell('x', 'A1');
const bigQuerySpec = specBuilder.build();

BigQueryDataSourceSpecBuilder — The builder, for chaining.

Sets the billing BigQuery project ID.

BigQueryDataSourceSpecBuilder — The builder, for chaining.

Sets the raw query string.

BigQueryDataSourceSpecBuilder — The builder, for chaining.

Sets the BigQuery table ID.

BigQueryDataSourceSpecBuilder — This builder, for chaining.

Sets the BigQuery project ID for the table.

BigQueryDataSourceSpecBuilder — The builder, for chaining.

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-03 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-03 UTC."],[[["`BigQueryDataSourceSpecBuilder` helps construct specifications for BigQuery data sources in Google Sheets."],["It offers methods to set the dataset ID, project ID, table ID, and raw query for the data source."],["Parameters can be defined and linked to specific cells within the spreadsheet."],["The builder can be used to create or copy data source specifications for use with connected sheets."],["After configuring the data source details, the `build()` method finalizes the specification."]]],["The `BigQueryDataSourceSpecBuilder` constructs data source specifications. Key actions include: building a data source spec using `build()`, copying settings via `copy()`, and managing data source parameters through `getParameters()`, `removeAllParameters()`, `removeParameter()`, and `setParameterFromCell()`. Information setting/getting methods are available such as: `set/getDatasetId()`, `set/getProjectId()`, `set/getRawQuery()`, `set/getTableId()`, `set/getTableProjectId()`, and `getType()`. These allow you to configure the BigQuery dataset, project, table, and raw query details.\n"]]

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