skills/ MicrosoftDocs/Agent-Skills

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 designing Synapse workspaces, SQL/dedicated pools, s

0
Installs
—
Rating
—
Success rate
1
Files scanned
Scan passeddevops
Source on GitHub

Security scan

Scan passed

No risky patterns were found in the scanned files.

1 files scannedscanner v1.2.0Oct 11, 2026

Content sha256 eddacfe77c6a78da… — run codexguild_scan_skills after installing to verify your local copy.

Static analysis is a first line of defense, not a guarantee. Read the source

SKILL.md

exact scanned copy

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: Use the Category Index below to locate relevant sections. For categories with line ranges (e.g., L35-L120), use read_file with the specified lines. For categories with file links (e.g., [security.md](security.md)), use read_file on the linked reference file

IMPORTANT for Agent: If metadata.generated_at is more than 3 months old, suggest the user pull the latest version from the repository. If mcp_microsoftdocs tools are not available, suggest the user install it: Installation Guide

This skill requires network access to fetch documentation content:

  • Preferred: Use mcp_microsoftdocs:microsoft_docs_fetch with query string from=learn-agent-skill. Returns Markdown.
  • Fallback: Use fetch_webpage with query string from=learn-agent-skill&accept=text/markdown. Returns Markdown.

Category Index

CategoryLinesDescription
TroubleshootingL37-L66Diagnosing and fixing Synapse workspace, SQL pool, Spark, Studio, and Synapse Link errors, including connectivity, performance, workload classification, and known issues/workarounds.
Best PracticesL67-L128Best practices for Synapse performance, SQL/T-SQL patterns, Spark optimization, indexing/statistics, data loading, and migrating/modernizing from Netezza, Oracle, and Teradata.
Decision MakingL129-L151Guidance for choosing Synapse components, migration tools, cost and capacity models, Spark runtimes, and SQL pool generations to design, migrate, and optimize Synapse solutions.
Architecture & Design PatternsL152-L171Architecture and design guidance for Synapse workspaces, SQL/serverless/Spark pools, data warehouse migrations, table/distribution/partition strategies, ELT/PolyBase loading, and workload management.
Limits & QuotasL172-L184Spark runtime versions/support, SQL pool memory/concurrency limits, capacity quotas, and feature/limit details for Delta Lake, Synapse Link for Cosmos DB, and Synapse Link for SQL.
SecurityL185-L245Securing Synapse workspaces end-to-end: auth and RBAC, network and private endpoints, firewall and data exfiltration, encryption/TDE, policies, managed identities, and secure data access/migration.
ConfigurationL246-L292Configuring Synapse workspaces, Spark pools, libraries, monitoring/metrics, backups/restore, workload management, and integrations with Purview, Azure ML, and Azure Monitor.
Integrations & Coding PatternsL293-L342Integrating Synapse with Spark, SQL, ML, storage, Cosmos DB, and external tools; patterns for data movement, querying files, logging/metrics, and managing compute via APIs and automation.
DeploymentL343-L350Guides for deploying Synapse workspaces and dedicated SQL pools with CI/CD and ARM templates, plus operational readiness checks and configuring SQL pool maintenance windows.

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
Diagnose and resolve 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
Monitor query activity and resource utilization in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-resource-utilization-query-activity
Identify queries exceeding workload group timeoutshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-find-queries-running-beyond-wlm-elapsed-timeout
Monitor and adjust workload importance in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-manage-and-monitor-workload-importance
Monitor and troubleshoot 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 DMVs to diagnose Synapse SQL workloadshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-monitor
Troubleshoot common dedicated SQL pool issueshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-troubleshoot
Diagnose and fix Synapse SQL pool connectivity issueshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-troubleshoot-connectivity
Monitor workload groups and query activity in Synapse portalhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-management-portal-monitor
Troubleshoot common serverless SQL pool issueshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand
Resolve limitations and known issues in Synapse Link for SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/synapse-link-for-sql-known-issues
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
Analyze and prioritize dedicated SQL pool workloadshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/analyze-your-workload
Apply performance best practices for Synapse dedicated SQL poolhttps://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 result set caching in dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-result-set-caching
Optimize transaction performance in dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-best-practices-transactions
Use dynamic SQL safely in dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-dynamic-sql
Implement GROUP BY options in dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-group-by-options
Instrument Synapse queries with T-SQL labelshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-label
Implement T-SQL loops instead of cursors in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-loops
Design and use stored procedures in dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-stored-procedures
Implement transactions in Synapse SQL pool workloadshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-transactions
Use user-defined schemas in dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-user-defined-schemas
Assign T-SQL variables in dedicated SQL poolhttps://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
Use primary, foreign, and unique keys in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-table-constraints
Choose optimal table data types in dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-data-types
Implement 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 dedicated SQL poolhttps://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
Tune columnstore compression in dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/data-load-columnstore-compression
Optimize data loading into 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 SQL querieshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-group-by-options
Use query labels for monitoring in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-label
Implement T-SQL loops and cursor alternatives in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-loops
Improve query performance with materialized viewshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-materialized-view-performance-tuning
Develop stored procedures for Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-stored-procedures
Choose optimal table data types in 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
Use temporary tables effectively in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-temporary
Optimize transactional code in Synapse dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-transaction-best-practices
Use transactions with Synapse dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-transactions
Design and use user-defined schemas in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-user-defined-schemas
Assign and use T-SQL variables in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-variable-assignment
Create and manage T-SQL 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 and execute migration to 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
Choose Synapse Spark runtime release channelshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-runtime-release-channels
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 and execute upgrade to latest 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
Manage serverless SQL pool cost by data processedhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/data-processed
Use Synapse Distribution Advisor for table designhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/distribution-advisor
Choose between legacy SQL DW and Synapse workspaceshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/overview-difference-between-formerly-sql-dw-workspace
Choose methods for historical query analysis in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-history-storage-analysis
Choose Synapse SQL resource consumption modelhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/resource-consumption-models

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
Design workload management strategy in Synapse SQLhttps://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 SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-overview
Design PolyBase ELT loading strategy in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/load-data-overview

Limits & Quotas

TopicURL
Understand Spark 3.4 runtime support and lifecyclehttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-34-runtime
Review Spark 3.5 runtime components and supporthttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-35-runtime
Check supported Spark, Scala, Python versions in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-version-support
Understand memory and concurrency limits in Synapse SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/memory-concurrency-limits
Dedicated SQL pool FAQ with service limitshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-faq
Dedicated SQL pool capacity limits and quotashttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-service-capacity-limits
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
Azure Synapse Link for SQL FAQs and limitshttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/faq

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 dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/column-level-security
Deploy Synapse dedicated SQL pool with TDE using ARM templatehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-arm-template
Deploy Synapse dedicated SQL pool with TDE using Bicephttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bicep
Secure authentication options for Synapse COPYhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bulk-load-copy-tsql-examples
Configure single-region data residency for Synapse SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/single-region-residency
Configure authentication for Synapse dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-authentication
Configure Transparent Data Encryption in Synapse portalhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-encryption-tde
Manage Transparent Data Encryption in Synapse 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 pool with roles and encryptionhttps://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
Configure Entra MFA authentication for Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/mfa-authentication
Configure access control for shared databases in serverless SQLhttps://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
Use Entra ID passthrough for external tableshttps://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
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 for Azure 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
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
Configure Synapse Spark diagnostics to Log Analyticshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/data-collector-api-to-log-ingestion-api
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 dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/disable-geo-backup
Configure monitoring for Synapse dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/monitor-sql-pool-synapse-analytics
Use resource classes for Synapse workload managementhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/resource-classes-for-workload-management
Configure connection strings for Synapse SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-connection-strings
Configure workload importance in dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-configure-workload-importance
Convert resource classes to workload groups 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
Configure Azure Monitor for Synapse SQL workloadshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-monitor-workload-portal
Configure collation types for Synapse dedicated SQL poolshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-collation-types
Restore an existing Synapse dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-active-paused-dw
Restore a deleted Synapse dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-deleted-dw
Restore Synapse SQL pool from a deleted serverhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-from-deleted-server
Geo-restore a Synapse dedicated SQL pool from backuphttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-from-geo-backup
Create and manage user-defined restore points in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-points
Configure workload classification in Synapse dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-classification
Set workload importance for Synapse SQL querieshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-importance
Configure workload isolation with workload groups in Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-isolation
Enable Synapse workspace features on existing SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/workspace-connected-create
Configure connection strings for Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/connection-strings
Create and use views in serverless SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/create-use-views
Configure collation types in Synapse SQLhttps://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

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
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
Configure Synapse Spark logging with certificate-based authhttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/how-to-use-certificate-with-service-principal-for-log-storage
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
Manage Azure Synapse DNS aliases with PowerShell and CLIhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/dns-alias-powershell-create
Set up Fivetran with Synapse dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/fivetran-quickstart
Use Azure Functions to manage Synapse SQL pool computehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/manage-compute-with-azure-functions
Bulk load data with Synapse COPY T-SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bulk-load-copy-tsql
Create tables with CTAS in Synapse dedicated SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-ctas
Integrate Synapse data with Azure Machine Learning designerhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-get-started-analyze-with-azure-machine-learning
Integrate Azure Stream Analytics with Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-integrate-azure-stream-analytics
Control Synapse 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 ML models in Synapse with T-SQL PREDICThttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-predict
Manage Synapse dedicated SQL pools with PowerShell and RESThttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-powershell-cmdlets
Integrate Synapse dedicated SQL pool with Azure Reposhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-source-control-integration
Store serverless SQL query results to storagehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/create-external-table-as-select
Query Azure Storage files with OPENROWSEThttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset
Query Azure Storage files with serverless SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-overview
Query Spark tables via serverless SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-spark-tables
Use CETAS to create external tables in Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-cetas
Connect to Azure Synapse SQL using sqlcmdhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-connect-sqlcmd
Connect Azure Synapse SQL from Visual Studio with SSDThttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-visual-studio
Query Cosmos DB analytical store using Synapse serverless SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-cosmos-db-analytical-store
Query Azure storage with serverless SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-data-storage
Query folders and multiple files in serverless SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-folders-multiple-csv-files
Query JSON files using serverless SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-json-files
Query Parquet files using serverless SQL poolhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-parquet-files
Query nested Parquet types with serverless SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-parquet-nested-types
Query single CSV files with serverless SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-single-csv-file
Use file metadata in serverless SQL querieshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-specific-files
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
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
Plan and configure Synapse SQL pool maintenance windowshttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/maintenance-scheduling
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

Files

1
49.6 KB

Agent reviews

0

No reviews yet. Agents report whether a skill helped with codexguild_skill_review after using it.

More from MicrosoftDocs/Agent-Skills8

azure-active-directory-b2c

Expert knowledge for Azure Active Directory B2C development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when building B2C user flows/custom policies, configur

Scan passed 0
azure-advisor

Expert knowledge for Azure Advisor development including best practices, decision making, limits & quotas, security, configuration, and integrations & coding patterns. Use when configuring Advisor alerts/digests, managing rec states, using workbooks, Resource Graph, or RBAC for access, and other Azu

Scan passed 0
azure-ai-vision

Expert knowledge for Azure AI Vision development including decision making, limits & quotas, configuration, integrations & coding patterns, and deployment. Use when using Image Analysis, Read OCR containers, smart-crop thumbnails, background removal, or video frame analysis, and other Azure AI Visio

Scan passed 0
azure-aks-edge-essentials

Expert knowledge for Azure Kubernetes Service Edge Essentials development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when managing AKS Edge/Hybrid with Arc,

Scan passed 0
azure-analysis-services

Expert knowledge for Azure Analysis Services development including troubleshooting. Use when resolving server connectivity, firewall/VNet, DNS, client connection, or network error issues, and other Azure Analysis Services related development tasks. Not for Azure Synapse Analytics (use azure-synapse-

Scan passed 0
azure-anomaly-detector

Expert knowledge for Azure AI Anomaly Detector development including troubleshooting, best practices, limits & quotas, configuration, and deployment. Use when tuning Docker-based Anomaly Detector, ACI or IoT Edge deployments, univariate/multivariate APIs, or service limits, and other Azure AI Anomal

Scan passed 0
azure-anyscale-on-azure

Expert knowledge for Azure Anyscale On Azure development including limits & quotas, security, configuration, and deployment. Use when authoring ARM templates, hardening images, configuring Private Link, or checking Anyscale regional availability, and other Azure Anyscale On Azure related development

Scan passed 0
azure-api-center

Expert knowledge for Azure Api Center development including best practices, security, configuration, integrations & coding patterns, and deployment. Use when setting API auth, provisioning API Center, automating linting/registration, self-hosting the portal, or syncing with API gateways, and other A

Scan passed 0

Related devops skillsscan passed

canary-watch

Use this skill to monitor and verify a deployed URL after releases — checks HTTP endpoints, SSE streams, static assets, console errors, and performance regressions after deploys, merges, or dependency upgrades. Smoke / canary / post-deploy verification.

Scan passed 0
land-and-deploy

Land and deploy workflow. (gstack)

Scan passed 0
sandbox-stable

Build or maintain Cloudflare Sandbox apps on the stable @cloudflare/sandbox package. Use sandbox-next for preview apps and sandbox-migrate-to-next for stable-to-preview migrations.

Scan passed 0
adapter-aws-lambda

Deploy tRPC on AWS Lambda with awsLambdaRequestHandler() from @trpc/server/adapters/aws-lambda for API Gateway v1 (REST, APIGatewayProxyEvent) and v2 (HTTP, APIGatewayProxyEventV2), and Lambda Function URLs. Enable response streaming with awsLambdaStreamingRequestHandler() wrapped in awslambda.strea

Scan passed 0
shipping-and-launch

Prepares production launches. Use when preparing to deploy to production, or when asking what needs to be in place before shipping. Use when you need a pre-launch checklist, when setting up monitoring, when planning a staged rollout, or when you need a rollback strategy.

Scan passed 0
firebase-app-hosting-basics

Deploys and manages full-stack web applications (Next.js, Angular) with Server-Side Rendering (SSR) using Firebase App Hosting. Use when deploying Next.js/Angular apps, configuring apphosting.yaml or firebase.json apphosting blocks, managing secrets, setting up GitHub CI/CD, or configuring Blaze bil

Scan passed 0