Azure Synapse SQL - Select

Owned by Kalpana Malladi, created
Last updated: Aug 30, 2024
7 min read

In this article

Overview

You can use this Snap to fetch data from an Azure Synapse SQL Server database by providing a table name and configuring the connection.

You can use JSON paths in a query and have values from an incoming document substituted into the query. However, documents with missing values for a specific JSON path are written to Snap's error view. After a query is executed, the query's results are merged into the incoming document, overwriting any existing keys' values. The original document is displayed as output if there are no results from the query.

 

Snap Type

The Azure Synapse SQL Select Snap is a READ-type Snap that reads or fetches data from an Azure Synapse SQL Server database.

Prerequisites

A valid database account with the required permissions.

Support for Ultra Pipelines

Works in Ultra Pipelines. 

Limitations

When the table name contains single quote characters, the No table found error is displayed. This is because of the JDBC driver limitation.