Google BigQuery Snap Pack
This page is no longer maintained (May 13, 2026). For the most current information, go to Google BigQuery Snap Pack.
In this section
- Configuring Google BigQuery Accounts
- BigQuery Bulk Load (Cloud Storage)
- BigQuery Bulk Load (Streaming)
- BigQuery Write
- BigQuery Dataset Create
- BigQuery Dataset Delete
- BigQuery Dataset List
- BigQuery Table Create
- BigQuery Table Data List
- BigQuery Table Delete
- BigQuery Table List
- BigQuery Bulk Upsert (Streaming)
- BigQuery Execute
Snap Pack History
Release Snap Pack Version Date Type Updates May 2026 main34730 Stable Updated and certified against the current SnapLogic Platform release. November 2025 main33142 Stable Updated and certified against the current SnapLogic Platform release. August 2025 442patches32588 Latest Fixed an issue with the Google BigQuery Execute Snap where it ran into an infinite loop while calling stored procedures (SP). August 2025 442patches32113 Latest Fixed an issue with the Google BigQuery Bulk Upsert (Streaming) Snap, which produced output even without any input documents. August 2025 main32088 Stable Updated and certified against the current SnapLogic Platform release. May 2025 441patches31077 Latest Fixed an issue with the Google BigQuery Bulk Upsert (Streaming) Snap, which failed when there were no input documents. May 2025 main31019 Stable Updated and certified against the current SnapLogic Platform release. February 2025 440patches30928 Latest Fixed an issue with the Ultra task for the BigQuery Write Snap. February 2025 440patches30368 Latest Fixed the thread leak issue in Google BigQuery Snaps. February 2025 440patches29960 Latest Fixed an issue with the BigQuery Upsert (Streaming) Snap where an HTTP 404 error occurred when retrieving job status for multi-regional datasets in BigQuery. This occurred because the location was not explicitly specified in the request. The job request now includes the location information, ensuring successful job polling regardless of the region (for example, the US or EU). February 2025 main29887 Stable The Google BigQuery Bulk Load (Cloud Storage) Snap now displays a lint warning when the bulk load process completes successfully but the temporary file deletion fails. Enhanced the following Google BigQuery Snaps with implicit retry functionality to improve the reliability of CRUD operations by retrying after errors: BigQuery Write BigQuery Execute BigQuery Bulk Load (Cloud Storage) November 2024 439patches29574 Latest Fixed an issue with BigQuery Upsert (Streaming) Snap that displayed a 404 Not Found error because of the region mismatch by ensuring the region is specified correctly in the dataset. November 2024 439patches29499 Latest The BigQuery Bulk Load (Cloud Storage) Snap now displays a lint warning when the bulk load process completes successfully but the temporary file deletion fails. Enhanced the following Google BigQuery Snaps with implicit retry functionality to improve the reliability of CRUD operations in BigQuery and handle all retriable BigQuery errors: BigQuery Write BigQuery Table Delete BigQuery Table Data List BigQuery Table Create BigQuery Execute BigQuery Dataset List BigQuery Dataset Delete BigQuery Dataset Create BigQuery Table List BigQuery Bulk Load (Cloud Storage) November 2024 main29029 Stable Updated and certified against the current SnapLogic Platform release. August 2024 438patches28058 Latest Fixed an issue with the BigQuery Table Data List Snap that displayed a null pointer exception when the table source schema contained a nested Array list schema. August 2024 main27765
Stable Updated and certified against the current SnapLogic Platform release. May 2024 main26341 Stable Updated and certified against the current SnapLogic Platform release. February 2024 main25112 Stable Updated and certified against the current SnapLogic Platform release. November 2023 main23721 Stable Updated and certified against the current SnapLogic Platform release. August 2023 main22460
Stable Updated and certified against the current SnapLogic Platform release. May 2023 433patches22057 Latest Introduced the Google BigQuery Upsert (Streaming) Snap, which enables you to perform bulk update/insert operations into a BigQuery table from existing tables or any input data stream. May 2023 433patches21955 Latest Fixed an issue with the GBQ-Google Service Account that caused an input stream to remain open. May 2023 main21015 Stable Updated and certified to be compatible with the August SnapLogic Platform release. February 2023 432patches20962 Latest Fixed an intermittent null pointer exception that occurred in the BigQuery Write Snap. February 2023 432patches20298 Latest Disabled retries on truncated tables for the the BigQuery Write and BigQuery Bulk Load (Streaming) Snaps. Added better error messages for error conditions in the BigQuery Table Data List Snap. Fixed an issue with the BigQuery Table Create Snap that caused an error to display when fields were separated with a comma and a space. Fixed an issue with the sorting of the Partitioning time dropdown in the BigQuery Table Create Snap. February 2023 432patches19840 Latest Fixed an issue with the Google BigQuery Bulk Load (Streaming) Snap that caused the Table not found message to display even when Create table if not present was selected. February 2023 main19844 Stable Introduced the following new Snaps: Google BigQuery Table Create Snap—enables you to create tables that support clustering and partitioning. Google BigQuery Table Data List Snap—enables you to read table data from a BigQuery dataset and lists the contents of the table in rows in the output. November 2022 431patches19301 Latest The Google BigQuery Bulk Load (Streaming) Snap works as expected, with no active Timer threads remaining when the Pipeline execution fails. November 2022 main18944 Stable Upgraded with the latest SnapLogic Platform release. August 2022 main17386 Stable The Location field in the BigQuery Execute Snap lists all the locations in the suggestions. Introduced the following Snaps and accounts to manage datasets in Google BigQuery (GBQ): BigQuery Dataset Create: Creates datasets in the GBQ. BigQuery Dataset Delete: Removes datasets from the GBQ. BigQuery Dataset List: Lists datasets from the GBQ. BigQuery Table Delete: Removes tables from the GBQ. BigQuery Table List: Lists tables that are read from the GBQ dataset. Google Service Account JSON: Accesses the resources on GBQ using a JSON Key. 4.29 main15993 Stable Upgraded with the latest SnapLogic Platform release. 4.28 Patch 428patches15459 Latest Fixed an issue with Google BigQuery Execute Snap, where the Snap displayed 404 Job not found error when calling a procedure. Fixed an issue with the Google BigQuery Bulk Load (Cloud Storage) Snap where the Snap failed, because the access token expired when it had to wait longer to execute. With this fix, the Snap is reloaded to get refreshed access token. 4.28 Patch 428patches14743 Latest Fixed an issue with the Google BigQuery Execute Snap, where the Snap displayed an error when the input data contained a table having the record type column and its value was null. Fixed an issue with the Google BigQuery Write Snap, when the input data contained complex data type columns (such as nested fields) and Create table if not present checkbox was selected. 4.28 main14627 Stable Upgraded with the latest SnapLogic Platform release. 4.27 Patch 427patches13752 Latest Upgraded Google BigQuery driver to 1.119.0 version to support time partition intervals by MONTH and YEAR. 4.27 Patch 427patches13615 Latest Fixed the table truncate 404 error with the Google BigQuery Load (Streaming) Snap by supporting the retry functionality. The Snap now waits in case of an error and retries before loading the data. 4.27 Patch 427patches12691 Latest Fixed an issue with the Google BigQuery Bulk Load (Cloud Storage) Snap, where the Snap failed with an exception for big query tables. The CreateDisposition is now set conditionally on the basis of the setting in the Create table if not present checkbox. 4.27 main12833 Stable Enhanced the Google BigQuery Bulk Load (Cloud Storage) Snap with the following batching and retry properties to process input records: Batching: Processes the input records in batches. Batch Size: The number of records batched per request. Batch Timeout (milliseconds): Time in milliseconds to elapse following which the batch, if not empty, will be processed even though it might be lesser than the given batch size. 4.26 main11181 Stable Upgraded with the latest SnapLogic Platform release. 4.25 main9554 Stable Upgraded with the latest SnapLogic Platform release. 4.24 main8556 Stable Upgraded with the latest SnapLogic Platform release. 4.23 main7430 Stable Enhanced the Google BigQuery Execute Snap and Google BigQuery accounts to enable you to choose the SQL dialect to use in the Query field. See Interpreting the SQL Query Dialect for more information. Fixed the precision loss in Google BigQuery Execute Snap output that strips millisecond values while retrieving TIMESTAMP values from Google BigQuery tables. 4.22 main6403 Stable Upgraded with the latest SnapLogic Platform release. 4.21 snapsmrc542 Stable Upgraded with the latest SnapLogic Platform release. 4.20 Patch google/bigquery8773 Latest Fixed the NPE issue with stored procedures and DROP TABLE queries in the Google BigQuery Execute Snap. 4.20 snapsmrc535 Stable Upgraded with the latest SnapLogic Platform release. 4.19 snaprsmrc528 Stable Upgraded with the latest SnapLogic Platform release. 4.18 snapsmrc523 Stable Upgraded with the latest SnapLogic Platform release. 4.17 ALL7402 Latest Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers. 4.17 snapsmrc515 Stable Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box. 4.16 snapsmrc508 Stable Upgraded with the latest SnapLogic Platform release. 4.15 snapsmrc500 Stable Upgraded with the latest SnapLogic Platform release. 4.14 snapsmrc490 Stable Upgraded with the latest SnapLogic Platform release. 4.13 snapsmrc486 Stable Upgraded with the latest SnapLogic Platform release. 4.12 snapsmrc480 Stable Added a new property Schema auto detect in the Google BigQuery Bulk Load (Cloud Storage) Snap to support CSV and JSON files where one or more columns in the source file may not contain any values. 4.11 snapsmrc465 Stable Added new Snap: Google BigQuery Bulk Load (Cloud Storage) Added new Snap: Google BigQuery Bulk Load (Streaming). Updated Google Big Query Write Snap with a new Create table if not present property. 4.10 Patch google/bigquery4046 Latest Addressed an issue when authenticating with Dynamic OAuth accounts. 4.10 snapsmrc414 Stable Upgraded with the latest SnapLogic Platform release. 4.9 snapsmrc405 Stable Upgraded with the latest SnapLogic Platform release. 4.8 Patch bigquery2952 Latest Supports refreshing OAuth access tokens during long-running pipeline executions. Fixed an issue with writing small batch sizes and when querying empty dataset tables. 4.8.0 Patch bigquery2813 Latest Reload OAuth account from Platform when the access token expires during pipeline execution. 4.8 snapsmrc398 Stable Upgraded with the latest SnapLogic Platform release. 4.7 snapsmrc382 Stable Upgraded with the latest SnapLogic Platform release. 4.6 snapsmrc362 Stable Upgraded with the latest SnapLogic Platform release. 4.5.1 snapsmrc344 Stable Upgraded with the latest SnapLogic Platform release. 4.4.1 NA Stable Upgraded with the latest SnapLogic Platform release. 4.4 NA Stable Upgraded with the latest SnapLogic Platform release. 4.3.2 NA Stable Resolved the following issues with the Google BigQuery Execute Snap: throwing binary data in stacktrace and two error messages. improve error handling for suggestions improve error handling on bad queries suggestion bubble missing for Destination table ID Resolved an issue with Auto refresh token not working in Google BigQuery account.