Azure Synapse SQL Snap Pack

In this article

Overview

Azure Synapse SQL is a big data analytic service that enables you to query and analyze your data using the T-SQL language. You can use the standard ANSI-compliant dialect of SQL language used on SQL Server and Azure SQL Database for data analysis.

Use Snaps in this Snap Pack to:

  • Execute SQL statements to create, delete, update, merge, or insert data within a specified table.

  • Fetch data from a database.

  • Get a list of tables from a database.

  • Execute stored procedures.

Articles in this section

 

Prerequisites

A valid Azure Synapse SQL Account or Azure Synapse SQL Active Directory Account.

Snap Pack History

Release

Snap Pack Version

Date

Type

Updates

November 2024

main29029

Nov 13, 2024

Stable

Updated and certified against the current SnapLogic Platform release.

August 2024

main27765

Aug 21, 2024

Stable

Upgraded the org.json.json library from v20090211 to v20240303, which is fully backward compatible.

May 2024

437patches26597

Jun 3, 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

May 8, 2024

Stable

February 2024

436patches25597

Mar 27, 2024

-

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

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.

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”))

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

Feb 14, 2024

Stable

Updated and certified against the current SnapLogic Platform release.

November 2023

main23721

Nov 8, 2023

Stable

Updated and certified against the current SnapLogic Platform release.

August 2023

main22460

Aug 16, 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

Jul 3, 2023

Latest

Fixed an issue with the Azure Synapse SQL Bulkload 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

May 10, 2023

Stable

Upgraded with the latest SnapLogic Platform release.

February 2023

432patches20389

Apr 12, 2023

Latest

The Azure Synapse SQL Account and Azure Synapse SQL Active Directory 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

Feb 9, 2023  

Stable

Upgraded with the latest SnapLogic Platform release.

November 2022

431patches19493

Jan 12, 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

Jan 6, 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

Dec 29, 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

Jan 2, 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

Dec 19, 2022

Latest

The Azure Synapse SQL Insert Snap no longer supports the Preserve Case Sensitivity checkbox.

November 2022

main18944

Nov 10, 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: