Back to Skills
Skill

azure-synapse-analytics

Expert knowledge for Azure Synapse Analytics development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when building, debugging, or optimizing Azure Synapse Analytics applications. Not for Azure Data Factory (use azure-data-factory), Azure Data Explorer (use azure-data-explorer), Azure Databricks (use azure-databricks), Azure Stream Analytics (use azure-stream-analytics).

From azure
Install
1
Run in your terminal
$
npx claudepluginhub atc-net/atc-agentic-toolkit
Tool Access

This skill uses the workspace's default tool permissions.

Skill Content

Azure Synapse Analytics Skill

This skill provides expert guidance for Azure Synapse Analytics. Covers troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. It combines local quick-reference content with remote documentation fetching capabilities.

How to Use This Skill

IMPORTANT for Agent: This file may be large. Use the Category Index below to locate relevant sections, then use read_file with specific line ranges (e.g., L136-L144) to read the sections needed for the user's question This skill requires network access to fetch documentation content. Use mcp_microsoftdocs:microsoft_docs_fetch to retrieve full articles.

  • Fallback: Use the built-in WebFetch tool if the Microsoft Learn MCP server is not available.

Category Index

CategoryLinesDescription
TroubleshootingL37-L62Diagnosing and fixing Synapse issues: workspace/tenant moves, Spark jobs and libraries, SQL pool performance/connectivity, Synapse Link failures, Studio/network/storage connectivity.
Best PracticesL63-L121Best practices for Synapse: Spark tuning, Delta/Hyperspace optimization, dedicated/serverless SQL design and performance, T-SQL patterns, indexing/stats, and Netezza/Oracle/Teradata migration guidance.
Decision MakingL122-L141Guidance on choosing Synapse components, planning migrations (Netezza/Oracle/Teradata/SQL pools), sizing and cost management, Spark lifecycle, table distribution, and using tools like Advisor and query history.
Architecture & Design PatternsL142-L162Architecture and design guidance for Synapse workspaces, SQL/serverless/Spark pools, data warehouse migrations, table design, ELT/PolyBase loading, and workload management.
Limits & QuotasL163-L173Synapse SQL pool limits: maintenance windows, memory/concurrency by performance level, capacity caps, temp table behavior, serverless Delta Lake v1 querying, and Synapse Link feature limits/issues.
SecurityL174-L232Securing Synapse workspaces end-to-end: auth and RBAC, network isolation, private endpoints, encryption, data exfiltration, policies, and secure access to storage, SQL, Spark, and migration scenarios.
ConfigurationL233-L283Configuring Synapse workspaces, Spark pools, and SQL pools: integrations (Purview, AML), libraries, autoscale, monitoring/metrics, backups/restore, workload management, and pipeline activities.
Integrations & Coding PatternsL284-L320Patterns and code to integrate Synapse (Spark, serverless, dedicated SQL) with ADLS, Cosmos DB, Azure SQL, AML, monitoring (Log Analytics, Prometheus), and external tools via connectors, REST, and T-SQL.
DeploymentL321-L333Deploying and managing Synapse workspaces and dedicated SQL pools with ARM/Bicep, CI/CD, source control, restore points, and automated SQL compute operations.

Troubleshooting

TopicURL
Recover Synapse workspaces after Entra tenant movehttps://learn.microsoft.com/en-us/azure/synapse-analytics/how-to-recover-workspace-after-tenant-move
Known issues and workarounds for Azure Synapse Analyticshttps://learn.microsoft.com/en-us/azure/synapse-analytics/known-issues
Resolve compatibility issues between SQL Server apps and Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/partner/compatibility-issues
Interpret and handle Livy job errors in Synapse Sparkhttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-handle-livy-error
Debug Synapse Spark apps with extended history serverhttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-history-server
Troubleshoot Synapse Spark library installation failureshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-troubleshoot-library-errors
Identify Synapse queries exceeding execution timeoutshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-find-queries-running-beyond-wlm-elapsed-timeout
Troubleshoot and optimize Gen2 cache performancehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-monitor-cache
Troubleshoot misclassified workloads in Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-troubleshoot-missed-classification
Use dedicated SQL pool FAQ for common issues and behaviorshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-faq
Troubleshoot Azure Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-troubleshoot
Diagnose and fix Synapse dedicated SQL pool connectivityhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-troubleshoot-connectivity
Troubleshoot common serverless SQL pool issueshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand
Troubleshoot Synapse Link Entra user impersonation issueshttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-azure-active-directory
Troubleshoot Synapse Link for Azure SQL after database failoverhttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-database-failover
Troubleshoot creation of Synapse Link for Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-link-creation
Troubleshoot Synapse Link initial snapshot issues for SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-snapshot-issues
Fix UTF-8 text reading issues in Synapse serverless SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/reading-utf8-text
Troubleshoot Synapse Studio network connectivity issueshttps://learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/troubleshoot-synapse-studio
Fix connectivity issues between Synapse Studio and storagehttps://learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/troubleshoot-synapse-studio-and-storage-connectivity
Troubleshoot Synapse Studio connectivity using PowerShellhttps://learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/troubleshoot-synapse-studio-powershell
Resolve SDK-created Synapse workspaces failing to launch Studiohttps://learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/workspaces-created-by-sdk

Best Practices

TopicURL
Configure Git source control for Synapse Studiohttps://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/source-control
Apply design and performance best practices for Netezza to Synapse migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/1-design-performance-migration
Plan ETL and data load for Netezza to Synapse migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/2-etl-load-migration-considerations
Implement visualization and reporting after Netezza to Synapse migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/4-visualization-reporting
Minimize SQL compatibility issues in Netezza to Synapse migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/5-minimize-sql-issues
Apply design and performance best practices for Oracle to Synapse migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/1-design-performance-migration
Plan ETL and data load for Oracle to Synapse migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/2-etl-load-migration-considerations
Implement visualization and reporting after Oracle to Synapse migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/4-visualization-reporting
Minimize SQL compatibility issues in Oracle to Synapse migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/5-minimize-sql-issues
Apply modern data warehouse best practices after Oracle migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/7-beyond-data-warehouse-migration
Apply design and performance best practices for Teradata to Synapse migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/1-design-performance-migration
Plan ETL and data load for Teradata to Synapse migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/2-etl-load-migration-considerations
Implement visualization and reporting after Teradata to Synapse migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/4-visualization-reporting
Minimize SQL compatibility issues in Teradata to Synapse migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/5-minimize-sql-issues
Use Apache Spark Advisor recommendations in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/monitoring/apache-spark-advisor
Optimize Azure Synapse Spark jobs for performancehttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-performance
Use Hyperspace indexes to accelerate Synapse Sparkhttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-performance-hyperspace
Improve Delta MERGE performance with Low Shuffle Mergehttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/low-shuffle-merge-for-apache-spark
Optimize Spark Delta Lake writes with Optimize Writehttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/optimize-write-for-apache-spark
Apply dedicated SQL pool design and performance best practiceshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/cheat-sheet
Optimize Synapse materialized views for performancehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-materialized-views
Optimize ordered clustered columnstore indexes in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-ordered-cci
Optimize transactional performance in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-best-practices-transactions
Use dynamic SQL safely in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-dynamic-sql
Implement GROUP BY options in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-group-by-options
Instrument Synapse queries with labelshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-label
Implement T-SQL loops in Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-loops
Design stored procedures for Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-stored-procedures
Use transactions correctly in Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-transactions
Apply user-defined schemas in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-user-defined-schemas
Assign T-SQL variables in Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-variable-assignment
Optimize columnstore index memory and compression in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-memory-optimizations-for-columnstore-compression
Apply design and coding recommendations for Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-develop
Choose data types for Synapse SQL tableshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-data-types
Use IDENTITY surrogate keys in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-identity
Indexing strategies for Synapse dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-index
Create and maintain statistics in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-statistics
Use temporary tables effectively in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-temporary
Apply performance best practices for Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-dedicated-sql-pool
Implement performance and cost best practices for serverless SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-serverless-sql-pool
Optimize columnstore compression and performance in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/data-load-columnstore-compression
Apply data loading best practices for Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/data-loading-best-practices
Use dynamic SQL safely in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-dynamic-sql
Apply GROUP BY options in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-group-by-options
Use query labels in Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-label
Implement T-SQL loops efficiently in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-loops
Tune Synapse dedicated SQL pool with materialized viewshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-materialized-view-performance-tuning
Develop stored procedures in Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-stored-procedures
Choose table data types for Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-data-types
Create and maintain statistics in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-statistics
Optimize transactional code in Synapse SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-transaction-best-practices
Use transactions in Synapse dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-transactions
Use user-defined schemas in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-user-defined-schemas
Assign T-SQL variables in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-variable-assignment
Design and use views in Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-views

Decision Making

TopicURL
Compare Synapse data integration with Azure Data Factoryhttps://learn.microsoft.com/en-us/azure/synapse-analytics/data-integration/concepts-data-factory-differences
Assess environment to choose Synapse technologieshttps://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-assess-environment
Review Synapse project plan for implementation successhttps://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-project-plan
Plan migration to Azure Synapse dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/migrate-to-synapse-analytics-guide
Select tools for Netezza data warehouse migration to Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/6-microsoft-third-party-migration-tools
Select tools for Oracle data warehouse migration to Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/6-microsoft-third-party-migration-tools
Choose Microsoft and third-party tools for Teradata to Synapse migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/6-microsoft-third-party-migration-tools
Plan and manage Azure Synapse Analytics costshttps://learn.microsoft.com/en-us/azure/synapse-analytics/plan-manage-costs
Plan Synapse Spark runtime lifecycle and supporthttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/runtime-for-apache-spark-lifecycle-and-supportability
Plan and execute migration of dedicated SQL pool to Gen2https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/gen2-migration-schedule
Use Azure Advisor recommendations for Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-recommendations
Plan upgrade to latest Synapse SQL pool generationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/upgrade-to-latest-generation
Choose appropriate DWUs for Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/what-is-a-data-warehouse-unit-dwu-cdwu
Plan and manage serverless SQL pool query costshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/data-processed
Use Synapse Distribution Advisor to choose table distribution strategieshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/distribution-advisor
Choose methods for Synapse query history analysishttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-history-storage-analysis

Architecture & Design Patterns

TopicURL
Evaluate Synapse data integration architecture designhttps://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-data-integration-design
Evaluate dedicated SQL pool data warehouse designhttps://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-dedicated-sql-pool-design
Evaluate serverless SQL pool architecture and designhttps://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-serverless-sql-pool-design
Evaluate Apache Spark pool design in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-spark-pool-design
Evaluate Azure Synapse workspace architecture designhttps://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-workspace-design
Success by Design architecture guidance for Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/success-by-design-introduction
Design a modern Azure data warehouse after Netezza migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/7-beyond-data-warehouse-migration
Design a modern data warehouse after Teradata migration to Azurehttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/7-beyond-data-warehouse-migration
Design ELT-based data loading patterns for Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/design-elt-data-loading
Design replicated tables in Synapse SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/design-guidance-for-replicated-tables
Design hash and round-robin distributed tableshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-distribute
Partition tables in Synapse dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-partition
Configure workload isolation with workload groupshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-isolation
Design workload management for Synapse SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-management
Use external tables with Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables
Design tables for Synapse dedicated and serverless SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-overview
Design PolyBase ELT data loading strategies for Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/load-data-overview

Limits & Quotas

TopicURL
Configure maintenance windows for Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/maintenance-scheduling
Memory and concurrency limits by Synapse performance levelhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/memory-concurrency-limits
Review capacity limits for Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-service-capacity-limits
Use temporary tables in Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-temporary
Query Delta Lake v1 with Synapse serverless SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-delta-lake-format
Supported features and limitations of Synapse Link for Cosmos DBhttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/concept-synapse-link-cosmos-db-support
Limitations and known issues for Synapse Link for SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/synapse-link-for-sql-known-issues

Security

TopicURL
Access firewall-protected Purview from Synapse securelyhttps://learn.microsoft.com/en-us/azure/synapse-analytics/catalog-and-governance/how-to-access-secured-purview-account
Secure Synapse linked services with managed VNethttps://learn.microsoft.com/en-us/azure/synapse-analytics/data-integration/linked-service
Design and implement access control in Azure Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-access-control
Implement authentication options for Azure Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-authentication
Configure data protection features in Azure Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-data-protection
Configure network security for Azure Synapse workspaceshttps://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-network-security
Use threat detection and auditing in Azure Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-threat-protection
Browse ADLS Gen2 with ACLs in Synapse securelyhttps://learn.microsoft.com/en-us/azure/synapse-analytics/how-to-access-container-with-access-control-lists
Configure secure prerequisites for Foundry Tools in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/tutorial-configure-cognitive-services-synapse
Configure security, access, and operations for Netezza to Synapse migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/3-security-access-operations
Configure security, access, and operations for Oracle to Synapse migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/3-security-access-operations
Configure security, access, and operations for Teradata to Synapse migrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/3-security-access-operations
Apply built-in Azure Policy definitions for Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/policy-reference
Apply Azure Policy compliance controls to Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/security-controls-policy
Connect Synapse workspace to secure storage accountshttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/connect-to-a-secure-storage-account
Manage connectivity settings for Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/connectivity-settings
Use Synapse gateway IP addresses for network ruleshttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/gateway-ip-addresses
Connect to Synapse Studio from restricted networkshttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-connect-to-workspace-from-restricted-network
Connect to Synapse workspaces using private endpointshttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-connect-to-workspace-with-private-links
Create Synapse workspaces with data exfiltration protectionhttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-create-a-workspace-with-data-exfiltration-protection
Create managed private endpoints from Synapse workspaceshttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-create-managed-private-endpoints
Grant workspace managed identity permissions in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-grant-workspace-managed-identity-permissions
Manage Synapse RBAC role assignments in Synapse Studiohttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-manage-synapse-rbac-role-assignments
Review Synapse RBAC role assignments in Synapse Studiohttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-review-synapse-rbac-role-assignments
Set up access control for Synapse workspaceshttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-set-up-access-control
Secure Synapse Studio access with private link hubshttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-private-link-hubs
Understand access control mechanisms in Synapse workspaceshttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-access-control-overview
Configure IP firewall rules for Synapse workspaceshttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-ip-firewall
Configure Synapse managed private endpoints securelyhttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-managed-private-endpoints
Use managed virtual networks with Synapse workspaceshttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-managed-vnet
Use Synapse RBAC to secure workspace resourceshttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac
Reference for built-in Synapse RBAC roles and permissionshttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac-roles
Map Synapse and Azure roles to common workspace taskshttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-understand-what-role-you-need
Apply conditional access policies to Synapse workspaceshttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/workspace-conditional-access
Enable data exfiltration protection in Synapse workspaceshttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/workspace-data-exfiltration-protection
Configure encryption and key management for Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/workspaces-encryption
Secure Synapse Spark credentials with Linked Serviceshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-secure-credentials-with-tokenlibrary
Secure Synapse Spark log emission with certificate-based service principalhttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/how-to-use-certificate-with-service-principalp-emit-log-event-hubs
Implement column-level security in Synapse SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/column-level-security
Configure secure authentication for Synapse COPY data loadshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bulk-load-copy-tsql-examples
Configure single-region data residency in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/single-region-residency
Configure authentication methods for Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-authentication
Configure TDE in Synapse SQL via Azure portalhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-encryption-tde
Manage Synapse Transparent Data Encryption with T-SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-encryption-tde-tsql
Secure Azure Synapse dedicated SQL pools with access and monitoringhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-manage-security
Configure Microsoft Entra authentication for Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/active-directory-authentication
Configure storage access control for serverless SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-storage-access-control
Use multifactor Entra authentication with Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/mfa-authentication
Set access control on shared Spark databaseshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/shared-databases-access-control
Configure SQL authentication options in Synapse Analyticshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/sql-authentication
Use managed identity to load external data securelyhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/tutorial-external-tables-using-managed-identity
Secure external data access using Entra ID passthroughhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/tutorial-load-data-using-entra-id
Secure Synapse Link for Azure SQL Database with network controlshttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-database-vnet
Configure secure networking for Synapse Link SQL Server 2022https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-server-2022-vnet
Use managed identities with Azure Synapse Analyticshttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-service-identity

Configuration

TopicURL
Connect Synapse workspace to Microsoft Purviewhttps://learn.microsoft.com/en-us/azure/synapse-analytics/catalog-and-governance/quickstart-connect-azure-purview
Configure SQL pool stored procedure activity in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/data-integration/sql-pool-stored-procedure-activity
Design Synapse development, test, and production environmentshttps://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-solution-development-environment-design
Configure and review monitoring for Azure Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-perform-monitoring-review
Link Synapse workspace to Azure Machine Learninghttps://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/quickstart-integrate-azure-machine-learning
Set up SynapseML environment for Foundry Toolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/setup-environment-cognitive-services
Reference monitoring metrics and logs for Synapse Analyticshttps://learn.microsoft.com/en-us/azure/synapse-analytics/monitor-synapse-analytics-reference
Monitor Apache Spark applications in Synapse Studiohttps://learn.microsoft.com/en-us/azure/synapse-analytics/monitoring/how-to-monitor-spark-applications
Runtime components for Synapse Spark 3.3https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-33-runtime
Runtime components for Synapse Spark 3.4https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-34-runtime
Runtime components for Synapse Spark 3.5https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-35-runtime
Configure autoscale for Apache Spark poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-autoscale
Manage Apache Spark configuration in Synapse Studiohttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-azure-create-spark-configuration
Manage Apache Spark libraries in Synapse poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-azure-portal-add-libraries
Create custom Conda channels in Synapse Sparkhttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-custom-conda-channel
Configure external Hive Metastore for Synapse Spark poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-external-metastore
Configure and use GPU-accelerated Spark poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-gpu-concept
Use Intelligent Cache for Synapse Spark performancehttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-intelligent-cache-concept
Configure Spark pool libraries in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-manage-pool-packages
Use session-scoped libraries in Synapse notebookshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-manage-session-packages
Manage workspace-level libraries for Synapse Sparkhttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-manage-workspace-packages
Configure Apache Spark pool sizes and behaviorhttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-pool-configurations
Select supported Apache Spark runtimes in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-version-support
Configure backup, restore points, and geo-backups for Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/backup-and-restore
Disable geo-backups for Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/disable-geo-backup
Configure monitoring for Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/monitor-sql-pool-synapse-analytics
Configure and use result set caching in Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-result-set-caching
Use resource classes for Synapse workload managementhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/resource-classes-for-workload-management
Monitor query activity and resources in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-resource-utilization-query-activity
Configure connections to Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-connect-overview
Configure workload groups and query timeouts in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-convert-resource-classes-workload-groups
Configure and manage Synapse SQL pool computehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-overview
Restore existing Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-active-paused-dw
Restore deleted Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-deleted-dw
Recover Synapse SQL pools from deleted servershttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-from-deleted-server
Restore Synapse SQL pools from geo-backupshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-from-geo-backup
Create user-defined restore points in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-points
Configure table constraints in Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-table-constraints
Configure workload classification in Synapse SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-classification
Set workload importance in Synapse SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-importance
Monitor workload groups in Synapse portalhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-management-portal-monitor
Enable Synapse workspace features for SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/workspace-connected-create
Enable Synapse workspace experience for existing SQL DWhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/workspace-connected-experience
Configure Synapse SQL connection strings for multiple clientshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/connection-strings
Configure collation types for Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/reference-collation-types
Monitor Synapse Link for Azure SQL Database with Studio and Azure Monitorhttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-monitor-synapse-link-sql-database
Configure Synapse notebook activity in pipelineshttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-notebook-activity

Integrations & Coding Patterns

TopicURL
Access Synapse ADLS Gen2 data from Azure Machine Learninghttps://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/access-data-from-aml
Score ML models with PREDICT in Synapse Sparkhttps://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/tutorial-score-model-predict-spark-pool
Send Synapse Spark logs and metrics to Log Analyticshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-azure-log-analytics
Use Delta Lake tables with Synapse Sparkhttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-delta-lake-overview
Manage Synapse Spark packages via PowerShell and RESThttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-manage-packages-outside-ui
Emit Synapse Spark logs and metrics to Event Hubshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/azure-synapse-diagnostic-emitters-azure-eventhub
Emit Synapse Spark logs and metrics to Azure Storagehttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/azure-synapse-diagnostic-emitters-azure-storage
Collect Synapse Spark metrics via Prometheus APIshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/connect-monitor-azure-synapse-spark-application-level-metrics
Use Spark CDM connector to read/write Common Data Modelhttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/data-sources/apache-spark-cdm-connector
Use Kusto connector with Synapse serverless Sparkhttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/data-sources/apache-spark-kusto-connector
Use Synapse Spark connector for SQL databaseshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/data-sources/apache-spark-sql-connector
Develop and submit Spark apps from IntelliJ to Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/intellij-tool-synapse
Use MSSparkUtils utilities in Synapse Spark notebookshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/microsoft-spark-utilities
Mount external storage using Synapse Spark file APIshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/synapse-file-mount-api
Move data between Synapse Spark and Dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/synapse-spark-sql-pool-import-export
Monitor Synapse Spark metrics with Prometheus and Grafanahttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/use-prometheus-grafana-to-monitor-apache-spark-application-level-metrics
Set up Fivetran with Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/fivetran-quickstart
Build Synapse SQL pool connection stringshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-connection-strings
Create tables with CTAS in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-ctas
Integrate Azure Stream Analytics with Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-integrate-azure-stream-analytics
Manage Synapse dedicated SQL pool compute via REST APIshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-rest-api
Score ONNX machine learning models with T-SQL PREDICT in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-predict
Automate Synapse dedicated SQL pool with PowerShell and RESThttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-powershell-cmdlets
Deploy and configure Striim for Synapse integrationhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/striim-quickstart
Query Azure Storage files with OPENROWSEThttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset
Access Azure Storage files via serverless SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-overview
Query Spark tables from serverless SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-spark-tables
Use CETAS to export data in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-cetas
Query Cosmos DB analytical store using Synapse serverless SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-cosmos-db-analytical-store
Connect Azure SQL Database to Synapse via Synapse Linkhttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-database
Copy Synapse Link Cosmos DB data to Dedicated SQL via Sparkhttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-copy-to-sql-pool
Query Cosmos DB via Synapse Spark 2 analytical storehttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark
Query Cosmos DB via Synapse Spark 3 analytical storehttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark-3

Deployment

TopicURL
Restore dedicated SQL pools in Synapse Analyticshttps://learn.microsoft.com/en-us/azure/synapse-analytics/backuprestore/restore-sql-pool
Create user-defined restore points in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/backuprestore/sqlpool-create-restore-point
Implement CI/CD for Azure Synapse workspaceshttps://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery
Perform operational readiness review for Synapse deploymenthttps://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-perform-operational-readiness-review
Deploy Synapse workspaces using ARM templateshttps://learn.microsoft.com/en-us/azure/synapse-analytics/quickstart-deployment-template-workspaces
Automate Synapse SQL compute management with Functionshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/manage-compute-with-azure-functions
Deploy Synapse dedicated SQL pool using ARM templateshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-arm-template
Deploy Synapse dedicated SQL pool using Bicep templateshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bicep
Set up CI/CD for Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-continuous-integration-and-deployment
Integrate Synapse SQL pools with source controlhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-source-control-integration
Similar Skills
ui-ux-pro-max

UI/UX design intelligence for web and mobile. Includes 50+ styles, 161 color palettes, 57 font pairings, 161 product types, 99 UX guidelines, and 25 chart types across 10 stacks (React, Next.js, Vue, Svelte, SwiftUI, React Native, Flutter, Tailwind, shadcn/ui, and HTML/CSS). Actions: plan, build, create, design, implement, review, fix, improve, optimize, enhance, refactor, and check UI/UX code. Projects: website, landing page, dashboard, admin panel, e-commerce, SaaS, portfolio, blog, and mobile app. Elements: button, modal, navbar, sidebar, card, table, form, and chart. Styles: glassmorphism, claymorphism, minimalism, brutalism, neumorphism, bento grid, dark mode, responsive, skeuomorphism, and flat design. Topics: color systems, accessibility, animation, layout, typography, font pairing, spacing, interaction states, shadow, and gradient. Integrations: shadcn/ui MCP for component search and examples.

49.4k
Stats
Parent Repo Stars0
Parent Repo Forks1
Last CommitMar 9, 2026
Actions
View SourceView PluginView on GitHubView README