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

ParameterDescription
Format typeTable format for the source. For MSSQL tables on Azure Synapse, set to mssql.
Select or create connectionExisting or new Azure Synapse connection in the Prophecy fabric.
DatabaseDatabase matching the database defined in the connection.
SchemaSchema within the database where the table is located.
NameName of the table to read data from.

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