Hello, I want to create an app where I get data from an API and push the same data to a bigquery table. I cant figure out how to send the data to bigquery. My data is json type. Example data: "rows": [ { "id": "d38c92bd-6477-4a60-acfe-b4dfa43d92a3", "ticker": "link", "ve…

Hi @roger , welcome to the retool community! If you are using SQL mode, you want to make sure your syntax fits how BigQuery wants it, i.e.: INSERT dataset.Inventory (product, quantity) VALUES('top load washer', 10), ('front load washer', 20), ('dryer', 30), ('refrigerator', 10), …

How to push data to bigquery

💬 Queries and Resources

victoria Split this topic November 16, 2023, 12:11am 8

2 posts were split to a new topic: GUI mode greyed out when using service account

Topic		Replies	Views
Need help using GUI mode in BIG Query and update tables dynamically 💬 App Building javascript , sql , bigquery , table , component	8	103	February 6, 2025
(BigQuery) endless bulk insert 💬 Queries and Resources resource-connection , bug , bigquery	3	912	November 6, 2023
How can I enable editing of BigQuery table data from within my Retool app? 💬 App Building bigquery , table	2	1107	November 20, 2023
Use Database Query to Populate Dropdown List 💬 Queries and Resources javascript , sql	4	4735	August 1, 2023
How do I insert data to MySQL from array in Retool? 💬 Queries and Resources sql , mysql	7	7644	August 2, 2023

How to push data to bigquery

Related topics