Snap Pack History: Azure Synapse SQL

  • Release Name
  • Date
  • Snap Pack Version
  • Type
Updates
  • May 2026
  • main34730
  • 13 May 2026
  • Stable
  • May 2026
  • main34730
  • 13 May 2026
  • Stable
  • May 2026
  • main34730
  • 13 May 2026
  • Stable
Updated and certified against the current SnapLogic Platform release.
  • November 2025
  • main33142
  • 12 Nov 2025
  • Stable
  • November 2025
  • main33142
  • 12 Nov 2025
  • Stable
  • November 2025
  • main33142
  • 12 Nov 2025
  • Stable
Updated and certified against the current SnapLogic Platform release.
  • August 2025
  • main32088
  • 13 Aug 2025
  • Stable
  • August 2025
  • main32088
  • 13 Aug 2025
  • Stable
  • August 2025
  • main32088
  • 13 Aug 2025
  • Stable
Updated and certified against the current SnapLogic Platform release.
  • May 2025
  • main31019
  • 14 May 2025
  • Stable
  • May 2025
  • main31019
  • 14 May 2025
  • Stable
  • May 2025
  • main31019
  • 14 May 2025
  • Stable
Updated and certified against the current SnapLogic Platform release.
  • February 2025
  • 440patches29963
  • 31 March 2025
  • Latest
  • February 2025
  • 440patches29963
  • 31 March 2025
  • Latest
  • February 2025
  • 440patches29963
  • 31 March 2025
  • Latest
Enhanced the Azure Synapse SQL Bulk Load Snap to support the default ROWTERMINATOR parameter for COPY INTO when Data Source is set to Input view.
  • February 2025
  • main29887
  • 12 Feb 2025
  • Stable
  • February 2025
  • main29887
  • 12 Feb 2025
  • Stable
  • February 2025
  • main29887
  • 12 Feb 2025
  • Stable
Updated and certified against the current SnapLogic Platform release.
  • November 2024
  • main29029
  • 13 Nov 2024
  • Stable
  • November 2024
  • main29029
  • 13 Nov 2024
  • Stable
  • November 2024
  • main29029
  • 13 Nov 2024
  • Stable
Updated and certified against the current SnapLogic Platform release.
  • August 2024
  • main27765
  • 21 Aug 2024
  • Stable
  • August 2024
  • main27765
  • 21 Aug 2024
  • Stable
  • August 2024
  • main27765
  • 21 Aug 2024
  • Stable
Upgraded the org.json.json library from v20090211 to v20240303, which is fully backward compatible.
  • May 2024
  • 437patches26597
  • 03 June 2024
  • Latest
  • May 2024
  • 437patches26597
  • 03 June 2024
  • Latest
  • May 2024
  • 437patches26597
  • 03 June 2024
  • Latest
Fixed an issue with the Azure Synapse SQL Select Snap that displayed an error and did not retry the connection when the serverless SQL pool was warming up.
  • May 2024
  • main26341
  • 08 May 2024
  • Stable
  • May 2024
  • main26341
  • 08 May 2024
  • Stable
  • May 2024
  • main26341
  • 08 May 2024
  • Stable
  • February 2024
  • 436patches25597
  • 27 March 2024
  • -
  • February 2024
  • 436patches25597
  • 27 March 2024
  • -
  • February 2024
  • 436patches25597
  • 27 March 2024
  • -

Upgraded the jOOQ library of the Azure Synapse SQL Snap Pack from v3.9.1 to v3.17.x.

Note: This upgrade is currently NOT available with the latest distribution. However, you can still consume this patch through 436patches25597. This update is scheduled to be included in the latest distribution release on April 10, 2024, and will be a part of the stable distribution with the GA release on May 8, 2024.
Important:

Behavior change:

The jOOQ library upgrade for Azure Synapse SQL Snap Pack, done as part of the 436patches25597, resulted in the following behavior change:

Previously, when "null"(string) was passed from the upstream Mapper Snap for the Bigint datatype, the Azure Synapse SQL Update Snap updated it as null without displaying any error. It displayed the status as 0 and the output message as Success. Now, the Snap displays the following error in this scenario:

Error converting value(expecting a number but you are sending String("null"))

Note: If you pass null from Mapper Snap with the expression enabled, the Snap updates the null value for the BigInt datatype correctly, as earlier.
  • February 2024
  • main25112
  • 14 Feb 2024
  • Stable
  • February 2024
  • main25112
  • 14 Feb 2024
  • Stable
  • February 2024
  • main25112
  • 14 Feb 2024
  • Stable
Updated and certified against the current SnapLogic Platform release.
  • November 2023
  • main23721
  • 08 Nov 2023
  • Stable
  • November 2023
  • main23721
  • 08 Nov 2023
  • Stable
  • November 2023
  • main23721
  • 08 Nov 2023
  • Stable
Updated and certified against the current SnapLogic Platform release.
  • August 2023
  • main22460
  • 16 Aug 2023
  • Stable
  • August 2023
  • main22460
  • 16 Aug 2023
  • Stable
  • August 2023
  • main22460
  • 16 Aug 2023
  • Stable
The Azure Synapse SQL Execute Snap now includes a new Query type field. When Auto is selected, the Snap tries to determine the query type automatically.
  • May 2023
  • 433patches21718
  • 03 July 2023
  • Latest
  • May 2023
  • 433patches21718
  • 03 July 2023
  • Latest
  • May 2023
  • 433patches21718
  • 03 July 2023
  • Latest
Fixed an issue with the Azure Synapse SQL Bulk Load Snap that caused a 404 error when the External Location was set to ADLS Gen2 and the Azure Folder field was not specified in the account settings.
  • May 2023
  • main21015
  • 10 May 2023
  • Stable
  • May 2023
  • main21015
  • 10 May 2023
  • Stable
  • May 2023
  • main21015
  • 10 May 2023
  • Stable
Upgraded with the latest SnapLogic Platform release.
  • February 2023
  • 432patches20389
  • 12 April 2023
  • Latest
  • February 2023
  • 432patches20389
  • 12 April 2023
  • Latest
  • February 2023
  • 432patches20389
  • 12 April 2023
  • Latest
The Azure Synapse SQL Account and Azure Synapse SQL Entra Account now support the latest JDBC Driver 12.2.0.jre11 by default. You do not have to upload the JAR file in the JDBC Driver field manually.
  • February 2023
  • main19844
  • 09 Feb 2023
  • Stable
  • February 2023
  • main19844
  • 09 Feb 2023
  • Stable
  • February 2023
  • main19844
  • 09 Feb 2023
  • Stable
Upgraded with the latest SnapLogic Platform release.
  • November 2022
  • 431patches19493
  • 12 January 2023
  • Latest
  • November 2022
  • 431patches19493
  • 12 January 2023
  • Latest
  • November 2022
  • 431patches19493
  • 12 January 2023
  • Latest
The Azure Synapse SQL Bulk Load Snap no longer fails when loading the JDBC driver from SLDB as it now uses the uploaded JAR driver when performing all bulk load operations.
  • November 2022
  • 431patches19410
  • 06 January 2023
  • Stable
  • November 2022
  • 431patches19410
  • 06 January 2023
  • Stable
  • November 2022
  • 431patches19410
  • 06 January 2023
  • Stable
Fixed the Azure SQL - Execute Snap using the Azure SQL Active Directory Account that failed with SQL operation failed errors in environments using federated authentication.
  • November 2022
  • 431patches19410
  • 29 December 2022
  • Latest
  • November 2022
  • 431patches19410
  • 29 December 2022
  • Latest
  • November 2022
  • 431patches19410
  • 29 December 2022
  • Latest
Fixed the Azure SQL - Execute Snap using the Azure SQL Active Directory Account that failed with SQL operation failed errors in environments using federated authentication.
  • November 2022
  • 431patches19354
  • 02 January 2023
  • Latest
  • November 2022
  • 431patches19354
  • 02 January 2023
  • Latest
  • November 2022
  • 431patches19354
  • 02 January 2023
  • Latest
The Azure Synapse SQL Bulk Load Snap no longer fails with the error Invalid column value in CSV data file when the data contains the field quote character (").
  • November 2022
  • 431patches19263
  • 19 December 2022
  • Latest
  • November 2022
  • 431patches19263
  • 19 December 2022
  • Latest
  • November 2022
  • 431patches19263
  • 19 December 2022
  • Latest
The Azure Synapse SQL Insert Snap no longer supports the Preserve Case Sensitivity checkbox.
  • November 2022
  • main18944
  • 10 Nov 2022
  • Stable
  • November 2022
  • main18944
  • 10 Nov 2022
  • Stable
  • November 2022
  • main18944
  • 10 Nov 2022
  • Stable

Introduced the Azure Synapse SQL Snap Pack. The Azure Synapse Analytics is service from Microsoft that helps you query data to create, update, insert, or delete data in the Azure Synapse SQL. This Snap Pack contains the following Snaps: