azure-synapse-analytics

Guide Azure Synapse Analytics development across workspaces, pools, and integrations.

Updated Dec 19, 2025
One-click install
npx skills add https://github.com/appliedailearner/upendra_kumar_portfolio --skill azure-synapse-analytics-appliedailearner
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: azure-synapse-analytics
Source: https://github.com/appliedailearner/upendra_kumar_portfolio/tree/main/.agent/skills/azure-synapse-analytics
Command: npx skills add https://github.com/appliedailearner/upendra_kumar_portfolio --skill azure-synapse-analytics-appliedailearner

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Azure Synapse Analytics development is complex and error-prone; this skill provides expert guidance to troubleshoot, design, and deploy effective Synapse solutions.

Core Features & Use Cases

  • Troubleshooting across Synapse workspaces, Spark pools, and dedicated/serverless SQL pools.
  • Architecture & design patterns, performance best practices, and security hardening for Synapse deployments.
  • Integrations guidance with ADLS, Cosmos DB, and other data sources, plus deployment & governance recommendations.

Quick Start

Use this skill to obtain a ready-to-apply Azure Synapse development blueprint and implementation plan.

Frequently Asked Questions about azure-synapse-analytics

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I troubleshoot Azure Synapse dedicated SQL pool performance issues?

To troubleshoot Azure Synapse dedicated SQL pool performance, this skill applies architecture design patterns and performance best practices fetched from official Microsoft Docs to identify bottlenecks and optimize query execution.

What is the best way to design Azure Synapse workspaces for security and governance?

Designing Azure Synapse workspaces for security involves implementing network isolation, managed identities, and role-based access control, guided by official security hardening best practices for Synapse deployments.

How do I configure Azure Synapse Link to integrate Cosmos DB data?

Configure Azure Synapse Link for Cosmos DB by enabling the analytical store and connecting the Synapse workspace to the Cosmos DB account, allowing no-code ETL and near real-time analytics directly over operational data.

Does Azure Synapse serverless SQL pool support querying ADLS data directly?

Yes, Azure Synapse serverless SQL pools support querying ADLS data directly using T-SQL and the OPENROWSET function, enabling schema-on-read exploration of data lake files without provisioning dedicated infrastructure.

Why does my Azure Synapse Spark pool deployment fail during configuration?

Azure Synapse Spark pool deployment failures often stem from virtual network integration misconfigurations, quota limits, or role assignment issues, which can be resolved by verifying network security group rules and managed identity permissions.