Loading Google BigQuery from Talend: GCS Staging, Load Jobs, and MERGE That Prunes Partitions
September 17, 2026 · Matt Irvin
BigQuery offers four write paths and Talend can use all of them — only one belongs in a nightly batch. Choosing load jobs over GCS, authenticating without a stray JSON key, pinning NUMERIC and timestamp types, and writing a MERGE that prunes partitions instead of scanning the whole table.
Read more