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