Skip to main content
This gem runs in .

​
Overview

This page describes how to configure Source gems to read from Microsoft SQL Server hosted on Azure Synapse dedicated SQL pools.

​
Prerequisites

  • Run Prophecy version 4.1.3 or higher.

​
Create a Synapse gem

To create a Synapse Source gem in your pipeline:
1

Add a Source gem to the pipeline

  1. Open your pipeline in the Studio.
  2. Click on Source/Target in the canvas.
  3. Select Source from the dropdown.
  4. Click on the gem to open the configuration.
2

Select Synapse format

In the Type tab, select Synapse. Then, click Next.
3

Set location details

In the Location tab, set your connection details and table location. To learn more, jump to Source location.
4

Set table properties

In the Properties tab, set the table properties. To learn more, jump to Source properties.
5

Preview data

In the Preview tab, load a sample of the data and verify that it looks correct.

​
Source configuration

Use these settings to configure a Source gem for reading data from Azure Synapse.

​
Source location

​
Source properties

Infer or manually configure the schema of the table. Optionally, add a description for your table. Additional properties are not supported at this time.