MSSQL on Azure Synapse dedicated SQL pool
This page describes how to configure Source gems to read from Microsoft SQL Server hosted on Azure Synapse dedicated SQL pools.
Configuration tabs
When you create a new external Source gem, the gem dialog contains the following tabs.
- Type: Select the Synapse table option.
- Source location: Choose the connection and define the location where you will read tables from.
- Properties: Infer or manually specify the schema of the table.
- Preview: Load a preview of the dataset reflecting your configurations.
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. |
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.