{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"warning","localId":"bce9208a4e52"},"content":[{"type":"paragraph","attrs":{"localId":"fdbb47f58773"},"content":[{"text":"This page is no longer maintained (May 13, 2026). For the most current information, go to ","type":"text"},{"text":"Google BigQuery Snap Pack","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.snaplogic.com/snaps/sp-google-bigquery/sp-bigquery-about.html"}}]},{"text":".","type":"text"}]}]},{"type":"layoutSection","attrs":{"localId":"2afacb1cc669"},"marks":[{"type":"breakout","attrs":{"mode":"wide","width":1800}}],"content":[{"type":"layoutColumn","attrs":{"width":50.0,"localId":"89a3c2175cad"},"content":[{"type":"paragraph","attrs":{"localId":"85c735e32c72"},"content":[{"text":"In this article","type":"text","marks":[{"type":"strong"}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"maxLevel":{"value":"3"}},"macroMetadata":{"macroId":{"value":"9ef964b8-3bf3-4be6-ae29-7846f9d0561c"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"d80797aa-d66a-4be1-aa76-59770186d284"}},{"type":"heading","attrs":{"level":1,"localId":"b3aca145fc7b"},"content":[{"text":"Overview","type":"text"}]},{"type":"paragraph","attrs":{"localId":"788fa4ca797e"},"content":[{"text":"Google BigQuery is Google's Cloud Platform for handling big data. Use Snaps in this Snap Pack to ","type":"text"},{"text":"read from","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438698"}}]},{"text":" and ","type":"text"},{"text":"write to","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438700"}}]},{"text":" BigQuery. ","type":"text"}]},{"type":"heading","attrs":{"level":2,"localId":"63ccf3a1982c"},"content":[{"text":"Supported Version","type":"text"}]},{"type":"paragraph","attrs":{"localId":"f7b982a1fb46"},"content":[{"text":"This Snap Pack is tested against Google BigQuery version 2.0.","type":"text"}]}]},{"type":"layoutColumn","attrs":{"width":50.0,"localId":"7b1f99e17e73"},"content":[{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"bgColor":{"value":"#ebf7e1"},"borderStyle":{"value":"solid"}},"macroMetadata":{"macroId":{"value":"d32ca552-5c92-4f7f-a230-caabb6f73ce9"},"schemaVersion":{"value":"1"},"title":"Panel"}},"localId":"a2df6ec0-8958-4741-9fc8-8799ea24f203"},"content":[{"type":"paragraph","attrs":{"localId":"c9361ea365c8"},"content":[{"text":"In this section","type":"text","marks":[{"type":"strong"}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"children","parameters":{"macroParams":{"all":{"value":"true"},"depth":{"value":"2"}},"macroMetadata":{"macroId":{"value":"6126b64b-4aa4-4d8d-8014-8a2e6851ed75"},"schemaVersion":{"value":"2"},"title":"Child pages"}},"localId":"7cbb9617-1584-4a4e-b367-6a1cbec89308"}}]}]}]},{"type":"layoutSection","attrs":{"localId":"00fc087837c0"},"marks":[{"type":"breakout","attrs":{"mode":"wide","width":1800}}],"content":[{"type":"layoutColumn","attrs":{"width":100.0,"localId":"3304839b5a52"},"content":[{"type":"rule","attrs":{"localId":"dee25e17c712"}},{"type":"heading","attrs":{"level":4,"localId":"25817580f5cf"},"content":[{"text":"Related links","type":"text"}]},{"type":"bulletList","attrs":{"localId":"aa774f6406bb"},"content":[{"type":"listItem","attrs":{"localId":"1fd8b31d558d"},"content":[{"type":"paragraph","attrs":{"localId":"89bfaf851fc7"},"content":[{"text":"Google Cloud Platform: What is BigQuery?","type":"text","marks":[{"type":"link","attrs":{"href":"https://cloud.google.com/bigquery/what-is-bigquery"}}]}]}]},{"type":"listItem","attrs":{"localId":"ec9ae58d9465"},"content":[{"type":"paragraph","attrs":{"localId":"f11fe91452bc"},"content":[{"text":"Quota Policy","type":"text","marks":[{"type":"link","attrs":{"href":"https://cloud.google.com/bigquery/quota-policy"}}]}]}]}]}]}]},{"type":"layoutSection","attrs":{"localId":"7b659313a57e"},"marks":[{"type":"breakout","attrs":{"mode":"wide","width":1800}}],"content":[{"type":"layoutColumn","attrs":{"width":100.0,"localId":"9e57f579a2fd"},"content":[{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt","parameters":{"macroParams":{"name":{"value":"Google BigQuery SPH"},"atlassian-macro-output-type":{"value":"INLINE"}},"macroMetadata":{"macroId":{"value":"6c1e3ef6-9473-4b94-b4ab-525044bd1338"},"schemaVersion":{"value":"1"},"title":"Excerpt"}},"localId":"97e5dfee-b90d-4664-ac15-16ac51eafb10"},"content":[{"type":"heading","attrs":{"level":1,"localId":"00790b8eae73"},"content":[{"text":"Snap Pack History","type":"text"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"legacy-content","text":"","parameters":{"cxhtml":"Click to view/expand

Release	Snap Pack Version	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 ta