BigQuery insert records

💬 Queries and Resources
1

HI @roger ,
In reference to your case:
image
Can you please let me know how can I achieve this?
image

Background: i want to insert data to Bigquery table from the retool table table component in SQL mode.

How to push data to bigquery
2

Hey @Ali_Ashfaq! If you just want to insert records from a Retool Table component, could you try something like this?

  1. Change the query type from SQL mode -> GUI mode
  2. Select the "Bulk insert records" action type
  3. Pass in {{table1.data}} as the array of records to insert

1 Like