# Insert rows into BigQuery table

**URL:** <https://forums.losant.com/t/insert-rows-into-bigquery-table/5327>\
**Category:** Help\
**Tags:** workflow\
**Created:** [November 13, 2023, 1:17pm UTC](https://forums.losant.com/t/insert-rows-into-bigquery-table/5327 "2023-11-13T13:17:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paolo\_Proxy](https://avatars.discourse-cdn.com/v4/letter/p/b5ac83/32.png) [@Paolo\_Proxy](https://forums.losant.com/u/Paolo_Proxy)\
**Post date:** [November 13, 2023, 1:17pm UTC](https://forums.losant.com/t/insert-rows-into-bigquery-table/5327/1 "2023-11-13T13:17:35Z")

</div>

Hi there,  
I want to do an insert into one of my big tables but I am sure what the template is expected to be.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/9/9bffe520e77a27deed9279cf5f7ef79419346f38.png)

Do I just pass the rows as an array type?

---

<div class="post-metadata">

**Author:** ![Dylan\_Schuster](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/dylan_schuster/32/2850_2.png) [@Dylan\_Schuster](https://forums.losant.com/u/Dylan_Schuster)\
**Post date:** [November 13, 2023, 1:56pm UTC](https://forums.losant.com/t/insert-rows-into-bigquery-table/5327/2 "2023-11-13T13:56:56Z")

</div>

It depends on the operation you are doing on the table. Based on your screenshot it looks like you are trying to do `Tabledata: Insert All`, and what you have pasted in the JSON Template body is a schema copied from [Google’s documentation](https://cloud.google.com/bigquery/docs/reference/rest/v2/tabledata/insertAll).

You can find the expected syntax for the node, which matches Google’s, in [Losant’s documentation for the node and operation](https://docs.losant.com/workflows/data/google-big-query/#tabledata-insert-all).