skills.rest
tomz
tomzCOMMUNITY
Explore all skills by this author →
Website𝕏@tomzengGitHub

azure-synapse

Configure Azure Synapse Analytics environments across SQL, Spark, and pipelines.

Updated Apr 27, 2026
Search Tags:#azure#data-analytics#spark#workloads#synapse#sql-pools
One-click install
npx skills add https://github.com/tomz/agent-skills --skill azure-synapse-tomz
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: azure-synapse
Source: https://github.com/tomz/agent-skills/tree/main/azure-synapse
Command: npx skills add https://github.com/tomz/agent-skills --skill azure-synapse-tomz

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Azure Synapse Analytics can be complex to provision, orchestrate, and monitor across dedicated SQL pools, serverless SQL pools, Spark pools, and pipelines. This skill consolidates best practices, setup steps, and reference configurations to accelerate end-to-end analytics deployments.

Core Features & Use Cases

  • Provision and configure Synapse workspaces, dedicated SQL pools, serverless SQL pools, Spark pools, and pipelines.
  • Implement security, monitoring, and Synapse Link integrations to connect Cosmos DB, SQL Server, and data sources, with governance and cost controls.
  • Optimize performance with workload management, distribution strategies, partitioning, CETAS/OPENROWSET usage, and data lake integrations for ADLS Gen2.

Quick Start

Provision a new Synapse workspace with az cli, then run a quick end-to-end data workflow to verify setup.

Frequently Asked Questions about azure-synapse

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

FAQPage Schema
How do I provision an Azure Synapse workspace end-to-end?▼

To provision an Azure Synapse workspace, use az cli commands to configure the environment, then run a quick end-to-end data workflow to verify the setup across dedicated SQL pools, serverless SQL, and Spark pools.

What is the best way to optimize Azure Synapse dedicated SQL pools?▼

Optimize Azure Synapse dedicated SQL pools by applying workload management, selecting proper distribution strategies, configuring partitioning, and integrating data lake storage with ADLS Gen2 to improve query performance.

Does Azure Synapse support Spark pool workloads for big data processing?▼

Yes, Azure Synapse supports Spark pool workloads for big data processing. You can configure Spark pools within the workspace to run large-scale data transformations and analytics alongside dedicated SQL pools.

How do I configure Synapse Link integrations with Cosmos DB?▼

Configure Synapse Link integrations by connecting Azure Synapse Analytics to Cosmos DB, SQL Server, and other data sources. This enables near real-time analytics and operational data access without impacting transactional workloads.

Can I use serverless SQL pools to query data lakes with OPENROWSET?▼

Yes, serverless SQL pools support querying data lakes using CETAS and OPENROWSET functions. This allows you to run ad-hoc queries on ADLS Gen2 data without provisioning dedicated infrastructure.

How do I implement security and monitoring for Azure Synapse pipelines?▼

Implement security and monitoring for Azure Synapse pipelines by applying governance and cost controls, configuring workspace access, and setting up monitoring workflows to track pipeline execution and data activity.

Related Skills

Explore More Data & Analytics Skills→
appliedailearnerappliedailearner

azure-synapse-analytics

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

Community
Advanced
lazygopherslazygophers
4

office-xlsx-skills

Read, write, analyze, and convert Excel, CSV, and JSON files.

Official
Advanced
InnerScopeHearingInnerScopeHearing

signal-radar

Monitor fleet telemetry data and report operational anomalies to Cosmos DB.

Official
Advanced
borgheiborghei
467

senior-data-engineer

Automate scalable data pipeline design and warehousing with Spark, Airflow, and Snowflake.

Community
Advanced