![]() The following example shows how to add a BigQuery data source, create a data It addsĪ drive OAuth scope in addition to the minimum required spreadsheet andĮxample: Create and refresh a data source object The following sample shows the oauthScopes portion of a manifest file. If you need additional scopes to access certainīigQuery data, you can set explicit scopes.įor example, to query BigQuery data hosted within Google Drive, you must add a Drive OAuth scope to your manifest Most OAuth scopes are automatically added to the manifest file based on theįunctions used in your code. ![]() Var spreadsheet = SpreadsheetApp.getActive() Īdd additional OAuth scopes to the manifest file SpreadsheetApp.enableBigQueryExecution() The following sample shows the SpreadsheetApp.enableBigQueryExecution() method This method adds the required bigquery.readonly To access BigQuery data, you must include the enableBigQueryExecution() method Spreadsheet.insertDataSourceSheet().getDataSource() The table below lists the most common DataSource actions and how to create them in Apps Script: Action ![]() Use the DataSource classes and objects to connect to BigQuery and analyze data. You can access Connected Sheets programmatically with the Spreadsheet service. Is a Google Sheets feature that lets you analyze BigQuery data directly within Sheets. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |