'How to load data to bigquery quickly Apps Scripts

I have tables in bigquery and im using Apps Scripts to run code connected with this tables.(BigQueryAPI) The problem is that it takes to long to load data to bigQuery.

Im loading data in that way

for(let word of generatedWords)
{
   var job_data = 
  {
  rows: [{json:{FullWord: word.word,
                GenerationType: word.generationType}}]
  }
  BigQuery.Tabledata.insertAll(job_data,projectID,datasetID,"Words");
}

.insertAll is too slow,and my code ends up after 6 min limit from Apps Scripts. Also i ve tried to do it with SQL,but its also slow.

So my question,is there a way to load up this data faster?

google-apps-script google-bigquery

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'How to load data to bigquery quickly Apps Scripts

Sources

Related Questions