Is it possible to migrate Big Query with NetSuite ...
# suitescript
h
Is it possible to migrate Big Query with NetSuite using below script /** * @NApiVersion 2.x * @NScriptType Restlet */ define(['N/https', 'N/log'], function(https, log) { function getBigQueryData() { // Replace these variables with your BigQuery credentials and query var bigQueryProjectId = 'your_project_id'; var bigQueryDatasetId = 'your_dataset_id'; var bigQueryTableId = 'your_table_id'; var bigQueryAccessToken = 'your_access_token'; var bigQueryQuery = 'SELECT * FROM
your_project_id.your_dataset_id.your_table_id
LIMIT 10'; var url = 'https://bigquery.googleapis.com/bigquery/v2/projects/' + bigQueryProjectId + '/queries'; var headers = { 'Authorization': 'Bearer ' + bigQueryAccessToken, 'Content-Type': 'application/json' }; var payload = { 'query': bigQueryQuery }; var response = https.post({ url: url, headers: headers, body: JSON.stringify(payload) }); if (response.body) { var responseBody = JSON.parse(response.body); log.debug('BigQuery Response', responseBody); return responseBody; } else { log.error('BigQuery Error', 'No response received from BigQuery.'); return { error: 'No response received from BigQuery.' }; } } return { get: function() { return getBigQueryData(); } }; });