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
- Open your pipeline in the Studio.
- Click on Source/Target in the canvas.
- Select Source from the dropdown.
- 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
| Parameter | Description |
|---|---|
| Format type | Table format for the source. For MSSQL tables on Azure Synapse, set to mssql. |
| Select or create connection | Existing or new Azure Synapse connection in the Prophecy fabric. |
| Database | Database matching the database defined in the connection. |
| Schema | Schema within the database where the table is located. |
| Name | Name of the table to read data from. |