title: Remove root from avro upload to bigquery using nodejs
body: <p>Just starting out with bigquery and trying to find the best way to upload db tables to bq. We've been converting the table content to avro using the avsc library because from all the docs it seems that avro is the fastest way to load it but it adds a root element to the schema so that all the columns are root.name, root.time etc. I saw there was another <a href="https://stackoverflow.com/questions/36862511/inserting-rows-with-multiple-columns-into-bigquery-using-avro">post about this from 2016 here</a> and the solution is to use a temporary table and strip out the root like this,
  <code>bq query --external_table_definition=foo::AVRO=gs://your_bucket/path/file.avro* --destination_table your_dataset.your_table &quot;SELECT root.* FROM foo&quot;</code>
  but the nodejs library only has instructions to accomplish permanent tables, not temporary ones. Even if I wanted to create a permanent table, I can't because due to the &quot;root&quot; it places all columns in one row and the amount of data exceeds the amount allowed in a single row. How can I load the data to bigquery?</p>