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 |
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 Behavior change: The jOOQ library upgrade for Azure Synapse SQL Snap Pack, done as part of the Previously, when
If you pass |
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 |
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 |
November 2022 | 431patches19410 | Dec 29, 2022 | Latest | Fixed the Azure SQL - Execute Snap using the Azure SQL Active Directory Account that failed with |
November 2022 | 431patches19354 | Jan 2, 2023 | Latest | The Azure Synapse SQL - Bulk Load Snap no longer fails with the error |
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: |