Hello everyone, I'm trying to perform a bulk insert of records to a BigQuery resource. The source of the data is the result of a MySQL query, I have made sure the schemas match. The bulk insert even works when there are no null values on the selected data from MySQL. My BigQuery block looks like so…

Hey @DiegoMorales - welcome to the community! :wave: This is definitely something that has come up before, as you can see here . The solution is relatively straightforward for simple queries but will be kind of a pain for bulk inserts. Essentially, you'll need to iterate through query1.data and rep…

Workflows - Handling null values on bulk insert, BigQuery Resource GUI mode

💬 Workflows

Darren Split this topic September 30, 2024, 9:12pm 5

A post was split to a new topic: Clarifying use case for transformers

Topic		Replies	Views
Workflow Query - SQL GUI - Bulk Insert: insert command field list 💬 Workflows resource-connection , bug , sql , table	2	970	December 19, 2023
Query Table to rename fields and use in GUI Bulk Insert 💬 Queries and Resources sql , table	5	68	November 15, 2024
Parameter Limit on Bulk Insert 💬 Queries and Resources	7	2422	August 30, 2023
Parameter types must be provided for null values via the 'types' field in query options 💬 Queries and Resources javascript , sql , bigquery , table , query-builder	30	9384	May 20, 2024
(BigQuery) endless bulk insert 💬 Queries and Resources resource-connection , bug , bigquery	3	928	November 6, 2023

Workflows - Handling null values on bulk insert, BigQuery Resource GUI mode

Related topics