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

The following code sample builds a BigQuery DataSource Spec.

constbigQueryDataSourceSpec=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.

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

Return

DataSourceSpec — The data source specification.

Creates aDataSourceSpecBuilder based on this data source's settings.

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

Return

DataSourceSpecBuilder — The builder.

Gets the BigQuery dataset ID.

Return

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.constss=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123456/edit',);constspec=ss.getDataSources()[0].getSpec();constparameters=spec.getParameters();

This method is only available for BigQuery data sources.

Return

DataSourceParameter[] — The parameter list.

Gets the billing project ID.

Return

String — The project ID.

Gets the raw query string.

Return

String — The raw query string.

Gets the BigQuery table ID.

Return

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.

Return

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.constss=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123456/edit',);constspec=ss.getDataSources()[0].getSpec();consttype=spec.getType();

Return

DataSourceType — The data source type.

Removes all the parameters.

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

Return

BigQueryDataSourceSpecBuilder — The builder, for chaining.

Removes the specified parameter.

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

Parameters

Return

BigQueryDataSourceSpecBuilder — The builder, for chaining.

Sets the BigQuery dataset ID.

Parameters

Return

BigQueryDataSourceSpecBuilder — This builder, for chaining.

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

This method is only available for BigQuery data sources.

constspecBuilder=SpreadsheetApp.newDataSourceSpec().asBigQuery();specBuilder.setParameterFromCell('x','A1');constbigQuerySpec=specBuilder.build();

Parameters

Return

BigQueryDataSourceSpecBuilder — The builder, for chaining.

Sets the billing BigQuery project ID.

Parameters

Return

BigQueryDataSourceSpecBuilder — The builder, for chaining.

Sets the raw query string.

Parameters

Return

BigQueryDataSourceSpecBuilder — The builder, for chaining.

Sets the BigQuery table ID.

Parameters

Return

BigQueryDataSourceSpecBuilder — This builder, for chaining.

Sets the BigQuery project ID for the table.

Parameters

Return

BigQueryDataSourceSpecBuilder — The builder, for chaining.