---
title: "Azure Synapse Data Source Template"
slug: "azure-synapse-data-source-template"
updated: 2026-04-08T18:49:15Z
published: 2026-04-08T18:49:15Z
canonical: "docs.validatar.com/azure-synapse-data-source-template"
---

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

# Azure Synapse Data Source Template

## Overview

The Azure Synapse Analytics data source template provides metadata ingestion, data type mappings, and profiling definitions for Synapse dedicated and serverless SQL pool connections.

**Platform:** Azure Synapse Analytics **Connection Category:** Database **Template Category:** Marketplace

## What's Included

### Connection Configuration

- Supports Synapse SQL connections (dedicated and serverless pools)
- Identifier delimiters: `[` / `]` (T-SQL compatible)

### Data Type Mappings

Follows SQL Server data type conventions with Synapse-specific additions. See the [SQL Server Data Source Template](/docs/sql-server-data-source-template) for the base type mappings.

## Metadata Ingestion

Queries Synapse's system catalog views (`sys.schemas`, `sys.tables`, `sys.columns`) similar to SQL Server, with adjustments for Synapse-specific object types and external tables.

## Installation

## Customization

Common customizations:

- **Pool type** — Adjust for dedicated vs. serverless SQL pool differences
- **External tables** — Include or exclude external tables backed by Data Lake Storage
- **Distribution** — Add custom ingestion for Synapse distribution and indexing metadata

## Related Articles

- [What Is a Data Source Template?](/docs/what-is-a-data-source-template-overview)
- [SQL Server Data Source Template](/docs/sql-server-data-source-template)
- [Metadata Ingestion Scripts — SQL Templates](/docs/metadata-ingestion-scripts-sql-templates)