const{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();constdataset=bigquery.dataset('my-dataset');consttable=dataset.table('my-table');

const{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();constdataset=bigquery.dataset('my-dataset');consttable=dataset.table('my-table');constyourTable=dataset.table('your-table');table.copy(yourTable,(err,apiResponse)=>{});//-// See https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#JobConfigurationTableCopy// for all available options.//-constmetadata={createDisposition:'CREATE_NEVER',writeDisposition:'WRITE_TRUNCATE'};table.copy(yourTable,metadata,(err,apiResponse)=>{});//-// If the callback is omitted, we'll return a Promise.//-table.copy(yourTable,metadata).then((data)=>{constapiResponse=data[0];});

const{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();constdataset=bigquery.dataset('my-dataset');consttable=dataset.table('my-table');constsourceTables=[dataset.table('your-table'),dataset.table('your-second-table')];table.copyFrom(sourceTables,(err,apiResponse)=>{});//-// See https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#JobConfigurationTableCopy// for all available options.//-constmetadata={createDisposition:'CREATE_NEVER',writeDisposition:'WRITE_TRUNCATE'};table.copyFrom(sourceTables,metadata,(err,apiResponse)=>{});//-// If the callback is omitted, we'll return a Promise.//-table.copyFrom(sourceTables,metadata).then((data)=>{constapiResponse=data[0];});

const{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();constdataset=bigquery.dataset('my-dataset');consttable=dataset.table('my-table');constsourceTables=[dataset.table('your-table'),dataset.table('your-second-table')];constcallback=(err,job,apiResponse)=>{// `job` is a Job object that can be used to check the status of the// request.};table.createCopyFromJob(sourceTables,callback);//-// See https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#JobConfigurationTableCopy// for all available options.//-constmetadata={createDisposition:'CREATE_NEVER',writeDisposition:'WRITE_TRUNCATE'};table.createCopyFromJob(sourceTables,metadata,callback);//-// If the callback is omitted, we'll return a Promise.//-table.createCopyFromJob(sourceTables,metadata).then((data)=>{constjob=data[0];constapiResponse=data[1];});

const{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();constdataset=bigquery.dataset('my-dataset');consttable=dataset.table('my-table');constyourTable=dataset.table('your-table');table.createCopyJob(yourTable,(err,job,apiResponse)=>{// `job` is a Job object that can be used to check the status of the// request.});//-// See https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#JobConfigurationTableCopy// for all available options.//-constmetadata={createDisposition:'CREATE_NEVER',writeDisposition:'WRITE_TRUNCATE'};table.createCopyJob(yourTable,metadata,(err,job,apiResponse)=>{});//-// If the callback is omitted, we'll return a Promise.//-table.createCopyJob(yourTable,metadata).then((data)=>{constjob=data[0];constapiResponse=data[1];});

const{Storage}=require('@google-cloud/storage');const{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();constdataset=bigquery.dataset('my-dataset');consttable=dataset.table('my-table');conststorage=newStorage({projectId:'grape-spaceship-123'});constextractedFile=storage.bucket('institutions').file('2014.csv');functioncallback(err,job,apiResponse){// `job` is a Job object that can be used to check the status of the// request.}//-// To use the default options, just pass a {@linkhttps://googleapis.dev/nodejs/storage/latest/File.html File}object.//// Note: The exported format type will be inferred by the file's extension.// If you wish to override this, or provide an array of destination files,// you must provide an `options` object.//-table.createExtractJob(extractedFile,callback);//-// If you need more customization, pass an `options` object.//-constoptions={format:'json',gzip:true};table.createExtractJob(extractedFile,options,callback);//-// You can also specify multiple destination files.//-table.createExtractJob([storage.bucket('institutions').file('2014.json'),storage.bucket('institutions-copy').file('2014.json')],options,callback);//-// If the callback is omitted, we'll return a Promise.//-table.createExtractJob(extractedFile,options).then((data)=>{constjob=data[0];constapiResponse=data[1];});

const{Storage}=require('@google-cloud/storage');const{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();constdataset=bigquery.dataset('my-dataset');consttable=dataset.table('my-table');//-// Load data from a local file.//-constcallback=(err,job,apiResponse)=>{// `job` is a Job object that can be used to check the status of the// request.};table.createLoadJob('./institutions.csv',callback);//-// You may also pass in metadata in the format of a Jobs resource. See// (https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#JobConfigurationLoad)// for a full list of supported values.//-constmetadata={encoding:'ISO-8859-1',sourceFormat:'NEWLINE_DELIMITED_JSON'};table.createLoadJob('./my-data.csv',metadata,callback);//-// Load data from a file in your Cloud Storage bucket.//-conststorage=newStorage({projectId:'grape-spaceship-123'});constdata=storage.bucket('institutions').file('data.csv');table.createLoadJob(data,callback);//-// Load data from multiple files in your Cloud Storage bucket(s).//-table.createLoadJob([storage.bucket('institutions').file('2011.csv'),storage.bucket('institutions').file('2012.csv')],callback);//-// If the callback is omitted, we'll return a Promise.//-table.createLoadJob(data).then((data)=>{constjob=data[0];constapiResponse=data[1];});

const{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();constdataset=bigquery.dataset('my-dataset');consttable=dataset.table('my-table');//-// Load data from a CSV file.//-constrequest=require('request');constcsvUrl='http://goo.gl/kSE7z6';constmetadata={allowJaggedRows:true,skipLeadingRows:1};request.get(csvUrl).pipe(table.createWriteStream(metadata)).on('job',(job)=>{// `job` is a Job object that can be used to check the status of the// request.}).on('complete',(job)=>{// The job has completed successfully.});//-// Load data from a JSON file.//-constfs=require('fs');fs.createReadStream('./test/testdata/testfile.json').pipe(table.createWriteStream('json')).on('job',(job)=>{// `job` is a Job object that can be used to check the status of the// request.}).on('complete',(job)=>{// The job has completed successfully.});

constStorage=require('@google-cloud/storage');const{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();constdataset=bigquery.dataset('my-dataset');consttable=dataset.table('my-table');conststorage=newStorage({projectId:'grape-spaceship-123'});constextractedFile=storage.bucket('institutions').file('2014.csv');//-// To use the default options, just pass a {@linkhttps://googleapis.dev/nodejs/storage/latest/File.html File}object.//// Note: The exported format type will be inferred by the file's extension.// If you wish to override this, or provide an array of destination files,// you must provide an `options` object.//-table.extract(extractedFile,(err,apiResponse)=>{});//-// If you need more customization, pass an `options` object.//-constoptions={format:'json',gzip:true};table.extract(extractedFile,options,(err,apiResponse)=>{});//-// You can also specify multiple destination files.//-table.extract([storage.bucket('institutions').file('2014.json'),storage.bucket('institutions-copy').file('2014.json')],options,(err,apiResponse)=>{});//-// If the callback is omitted, we'll return a Promise.//-table.extract(extractedFile,options).then((data)=>{constapiResponse=data[0];});

const{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();constdataset=bigquery.dataset('my-dataset');consttable=dataset.table('my-table');//-// Insert a single row.//-table.insert({INSTNM:'Motion Picture Institute of Michigan',CITY:'Troy',STABBR:'MI'},insertHandler);//-// Insert multiple rows at a time.//-constrows=[{INSTNM:'Motion Picture Institute of Michigan',CITY:'Troy',STABBR:'MI'},// ...];table.insert(rows,insertHandler);//-// Insert a row as according to thespecification.//-constrow={insertId:'1',json:{INSTNM:'Motion Picture Institute of Michigan',CITY:'Troy',STABBR:'MI'}};constoptions={raw:true};table.insert(row,options,insertHandler);//-// Handling the response. SeeTroubleshooting Errors for best practices on how to handle errors.//-functioninsertHandler(err,apiResponse){if(err){// An API error or partial failure occurred.if(err.name==='PartialFailureError'){// Some rows failed to insert, while others may have succeeded.// err.errors (object[]):// err.errors[].row (original row object passed to `insert`)// err.errors[].errors[].reason// err.errors[].errors[].message}}}//-// If the callback is omitted, we'll return a Promise.//-table.insert(rows).then((data)=>{constapiResponse=data[0];}).catch((err)=>{// An API error or partial failure occurred.if(err.name==='PartialFailureError'){// Some rows failed to insert, while others may have succeeded.// err.errors (object[]):// err.errors[].row (original row object passed to `insert`)// err.errors[].errors[].reason// err.errors[].errors[].message}});

const{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();constdataset=bigquery.dataset('my-dataset');consttable=dataset.table('my-table');//-// Load data from a local file.//-table.load('./institutions.csv',(err,apiResponse)=>{});//-// You may also pass in metadata in the format of a Jobs resource. See// (https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#JobConfigurationLoad)// for a full list of supported values.//-constmetadata={encoding:'ISO-8859-1',sourceFormat:'NEWLINE_DELIMITED_JSON'};table.load('./my-data.csv',metadata,(err,apiResponse)=>{});//-// Load data from a file in your Cloud Storage bucket.//-constgcs=require('@google-cloud/storage')({projectId:'grape-spaceship-123'});constdata=gcs.bucket('institutions').file('data.csv');table.load(data,(err,apiResponse)=>{});//-// Load data from multiple files in your Cloud Storage bucket(s).//-table.load([gcs.bucket('institutions').file('2011.csv'),gcs.bucket('institutions').file('2012.csv')],function(err,apiResponse){});//-// If the callback is omitted, we'll return a Promise.//-table.load(data).then(function(data){constapiResponse=data[0];});

const{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();constdataset=bigquery.dataset('my-dataset');consttable=dataset.table('my-table');constmetadata={name:'My recipes',description:'A table for storing my recipes.',schema:'name:string, servings:integer, cookingTime:float, quick:boolean'};table.setMetadata(metadata,(err,metadata,apiResponse)=>{});//-// If the callback is omitted, we'll return a Promise.//-table.setMetadata(metadata).then((data)=>{constmetadata=data[0];constapiResponse=data[1];});