Koleksiyonlar ile düzeninizi koruyun İçeriği tercihlerinize göre kaydedin ve kategorilere ayırın.
BigQueryDataSourceSpec
Mevcut BigQuery veri kaynağı spesifikasyonuna erişin. Yeni bir veri kaynağı spesifikasyonu oluşturmak için SpreadsheetApp.newDataSourceSpec() öğesini kullanın.
// 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();
String: Veri kümesi kimliği veya veri kaynağı spesifikasyonu ham bir sorgu ile tanımlanmışsa boş bir dize.
getParameters()
Veri kaynağının parametrelerini alır.
// 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();
Bu yöntem yalnızca BigQuery veri kaynakları için kullanılabilir.
String: Tablo kimliği veya veri kaynağı spesifikasyonu ham bir sorgu ile tanımlanmışsa boş bir dize.
getTableProjectId()
Tablonun BigQuery proje kimliğini alır.
Return
String: Tablo proje kimliği veya veri kaynağı spesifikasyonu ham sorguyla tanımlanmışsa boş bir dize.
getType()
Veri kaynağının türünü alır.
// 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();
[[["Anlaması kolay","easyToUnderstand","thumb-up"],["Sorunumu çözdü","solvedMyProblem","thumb-up"],["Diğer","otherUp","thumb-up"]],[["İhtiyacım olan bilgiler yok","missingTheInformationINeed","thumb-down"],["Çok karmaşık / çok fazla adım var","tooComplicatedTooManySteps","thumb-down"],["Güncel değil","outOfDate","thumb-down"],["Çeviri sorunu","translationIssue","thumb-down"],["Örnek veya kod sorunu","samplesCodeIssue","thumb-down"],["Diğer","otherDown","thumb-down"]],["Son güncelleme tarihi: 2025-07-26 UTC."],[[["\u003cp\u003e\u003ccode\u003eBigQueryDataSourceSpec\u003c/code\u003e allows access to existing BigQuery data source specifications within a spreadsheet.\u003c/p\u003e\n"],["\u003cp\u003eYou can create a new data source specification using \u003ccode\u003eSpreadsheetApp.newDataSourceSpec()\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eThis class provides methods to get various details about the data source, such as dataset ID, project ID, raw query, parameters, and table information.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003ecopy()\u003c/code\u003e method enables the creation of a \u003ccode\u003eDataSourceSpecBuilder\u003c/code\u003e to modify existing specifications.\u003c/p\u003e\n"],["\u003cp\u003eUtilize methods like \u003ccode\u003egetDatasetId()\u003c/code\u003e, \u003ccode\u003egetRawQuery()\u003c/code\u003e, \u003ccode\u003egetTableId()\u003c/code\u003e, and others to retrieve specific attributes of the BigQuery data source.\u003c/p\u003e\n"]]],[],null,["BigQueryDataSourceSpec\n\nAccess the existing BigQuery data source specification. To create a new data source\nspecification, use [SpreadsheetApp.newDataSourceSpec()](/apps-script/reference/spreadsheet/spreadsheet-app#newDataSourceSpec()). \n\nMethods\n\n| Method | Return type | Brief description |\n|---------------------------------------------|--------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------|\n| [copy()](#copy()) | [DataSourceSpecBuilder](/apps-script/reference/spreadsheet/data-source-spec-builder) | Creates a [DataSourceSpecBuilder](/apps-script/reference/spreadsheet/data-source-spec-builder) based on this data source's settings. |\n| [getDatasetId()](#getDatasetId()) | `String` | Gets the BigQuery dataset ID. |\n| [getParameters()](#getParameters()) | [DataSourceParameter[]](/apps-script/reference/spreadsheet/data-source-parameter) | Gets the parameters of the data source. |\n| [getProjectId()](#getProjectId()) | `String` | Gets the billing project ID. |\n| [getRawQuery()](#getRawQuery()) | `String` | Gets the raw query string. |\n| [getTableId()](#getTableId()) | `String` | Gets the BigQuery table ID. |\n| [getTableProjectId()](#getTableProjectId()) | `String` | Gets the BigQuery project ID for the table. |\n| [getType()](#getType()) | [DataSourceType](/apps-script/reference/spreadsheet/data-source-type) | Gets the type of the data source. |\n\nDetailed documentation \n\n`copy()` \nCreates a [DataSourceSpecBuilder](/apps-script/reference/spreadsheet/data-source-spec-builder) based on this data source's settings.\n\n```javascript\n// TODO(developer): Replace the URL with your own.\nconst ss = SpreadsheetApp.openByUrl(\n 'https://docs.google.com/spreadsheets/d/abc123456/edit',\n);\nconst spec = ss.getDataSources()[0].getSpec();\n\nconst newSpec = spec.copy();\n```\n\nReturn\n\n\n[DataSourceSpecBuilder](/apps-script/reference/spreadsheet/data-source-spec-builder) --- The builder.\n\n*** ** * ** ***\n\n`get``Dataset``Id()` \nGets the BigQuery dataset ID.\n\nReturn\n\n\n`String` --- The dataset ID, or an empty string if the data source spec is defined by a raw query.\n\n*** ** * ** ***\n\n`get``Parameters()` \nGets the parameters of the data source.\n\n```javascript\n// TODO(developer): Replace the URL with your own.\nconst ss = SpreadsheetApp.openByUrl(\n 'https://docs.google.com/spreadsheets/d/abc123456/edit',\n);\nconst spec = ss.getDataSources()[0].getSpec();\nconst parameters = spec.getParameters();\n```\n\nThis method is only available for BigQuery data sources.\n\nReturn\n\n\n[DataSourceParameter[]](/apps-script/reference/spreadsheet/data-source-parameter) --- The parameter list.\n\n*** ** * ** ***\n\n`get``Project``Id()` \nGets the billing project ID.\n\nReturn\n\n\n`String` --- The project ID.\n\n*** ** * ** ***\n\n`get``Raw``Query()` \nGets the raw query string.\n\nReturn\n\n\n`String` --- The raw query string.\n\n*** ** * ** ***\n\n`get``Table``Id()` \nGets the BigQuery table ID.\n\nReturn\n\n\n`String` --- The table ID, or an empty string if the data source spec is defined by a raw query.\n\n*** ** * ** ***\n\n`get``Table``Project``Id()` \nGets the BigQuery project ID for the table.\n\nReturn\n\n\n`String` --- The table project ID, or an empty string if the data source spec is defined by a raw\nquery.\n\n*** ** * ** ***\n\n`get``Type()` \nGets the type of the data source.\n\n```javascript\n// TODO(developer): Replace the URL with your own.\nconst ss = SpreadsheetApp.openByUrl(\n 'https://docs.google.com/spreadsheets/d/abc123456/edit',\n);\nconst spec = ss.getDataSources()[0].getSpec();\nconst type = spec.getType();\n```\n\nReturn\n\n\n[DataSourceType](/apps-script/reference/spreadsheet/data-source-type) --- The data source type."]]
