> ## Documentation Index
> Fetch the complete documentation index at: https://docs.prophecy.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# MSSQL on Azure Synapse dedicated SQL pool

> Read and write from an Azure Synapse dedicated SQL pool

export const execution_engine_0 = "Prophecy Automate"

<Info>This gem runs in {execution_engine_0}.</Info>

## 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:

<Steps>
  <Step title="Add a Source gem to the pipeline">
    1. Open your pipeline in the [Studio](/data-analysis/development/studio/studio).
    2. Click on **Source/Target** in the canvas.
    3. Select **Source** from the dropdown.
    4. Click on the gem to open the configuration.
  </Step>

  <Step title="Select Synapse format">
    In the **Type** tab, select **Synapse**. Then, click **Next**.
  </Step>

  <Step title="Set location details">
    In the **Location** tab, set your connection details and table location. To learn more, jump to [Source location](#source-location).
  </Step>

  <Step title="Set table properties">
    In the **Properties** tab, set the table properties. To learn more, jump to [Source
    properties](#source-properties).
  </Step>

  <Step title="Preview data">
    In the **Preview** tab, load a sample of the data and verify that it looks correct.
  </Step>
</Steps>

## 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](/data-analysis/environment/connections/synapse) in the Prophecy fabric. |
| Database                    | Database matching the database defined in the [connection](/data-analysis/environment/connections/synapse).        |
| Schema                      | Schema within the database where the table is located.                                                             |
| Name                        | Name 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.