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

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:

Updated and certified against the current SnapLogic Platform release.