How do I get the list of tables in my BigQuery dataset in a Google AppScript

Ron Bailey 0
Viewed 21

I'm writing a Google AppsScript and am having trouble getting a list of the tables in my DataSet.

Here is my code...

function GetTablesList(){
  var tableList = BigQuery.Tables.list('crave-production','Rons_ODBC_Test')
  Logger.log('tableListItemCount:', tableList.totalItems)
}

It returns nothing after the 'tableListItemCount:' label.

What am I doing wrong?

google-bigquery google-apps-script
1 Answers

I believe this Logger.log('tableListItemCount:', tableList.totalItems) should be this Logger.log('tableListItemCount: %s', tableList.totalItems)

user30hu0
Related