Skip to main content
This gem runs in Prophecy Automate.

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.