{"id":"9ae18663-6cac-4cc8-b325-9cb8933977ce","shortId":"YRxCVL","kind":"skill","title":"azure-synapse-analytics","tagline":"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 SQL pools, Spa","description":"# Azure Synapse Analytics Skill\n\nThis 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.\n\n## How to Use This Skill\n\n> **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\n\n> **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](https://github.com/MicrosoftDocs/mcp/blob/main/README.md)\n\nThis skill requires **network access** to fetch documentation content:\n- **Preferred**: Use `mcp_microsoftdocs:microsoft_docs_fetch` with query string `from=learn-agent-skill`. Returns Markdown.\n- **Fallback**: Use `fetch_webpage` with query string `from=learn-agent-skill&accept=text/markdown`. Returns Markdown.\n\n## Category Index\n\n| Category | Lines | Description |\n|----------|-------|-------------|\n| Troubleshooting | L37-L66 | Diagnosing and fixing Synapse workspace, SQL pool, Spark, Studio, and Synapse Link issues, including connectivity, performance, job failures, tenant moves, and workload misclassification. |\n| Best Practices | L67-L128 | Best practices for Synapse performance, SQL/T-SQL patterns, Spark optimization, indexing/statistics, data loading, and migrating/modernizing from Netezza, Oracle, and Teradata. |\n| Decision Making | L129-L149 | Guidance for choosing Synapse components, sizing and cost models, planning/assessing environments, and tools/steps to migrate or upgrade data warehouses to Synapse SQL. |\n| Architecture & Design Patterns | L150-L169 | Architecture and design guidance for Synapse workspaces, SQL/serverless/Spark pools, data warehouse migrations, table/distribution/partition strategies, ELT/PolyBase loading, and workload management. |\n| Limits & Quotas | L170-L178 | SQL and Synapse Link limits: memory/concurrency caps, dedicated pool capacity/quotas, serverless SQL constraints for Delta Lake v1, and feature/known issues for Synapse Link (Cosmos DB, SQL). |\n| Security | L179-L239 | Securing 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. |\n| Configuration | L240-L288 | Configuring Synapse workspaces, Spark pools, and SQL pools: runtimes, scaling, libraries, monitoring/metrics, backups/restore, workload management, and integrations (Purview, AML). |\n| Integrations & Coding Patterns | L289-L338 | Patterns and code to integrate Synapse (Spark, serverless, dedicated SQL) with storage, ML, monitoring, external tools, and other Azure services, plus querying external data formats. |\n| Deployment | L339-L346 | Guides for deploying Synapse workspaces and dedicated SQL pools with CI/CD and ARM templates, plus operational readiness checks and configuring SQL pool maintenance windows. |\n\n### Troubleshooting\n| Topic | URL |\n|-------|-----|\n| Recover Synapse workspaces after Entra tenant move | https://learn.microsoft.com/en-us/azure/synapse-analytics/how-to-recover-workspace-after-tenant-move |\n| Known issues and workarounds for Azure Synapse Analytics | https://learn.microsoft.com/en-us/azure/synapse-analytics/known-issues |\n| Resolve compatibility issues between SQL Server apps and Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/partner/compatibility-issues |\n| Diagnose and resolve Livy job errors in Synapse Spark | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-handle-livy-error |\n| Debug Synapse Spark apps with extended history server | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-history-server |\n| Troubleshoot Synapse Spark library installation failures | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-troubleshoot-library-errors |\n| Monitor query activity and resource utilization in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-resource-utilization-query-activity |\n| Identify queries exceeding workload group timeouts | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-find-queries-running-beyond-wlm-elapsed-timeout |\n| Monitor and adjust workload importance in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-manage-and-monitor-workload-importance |\n| Monitor and troubleshoot Gen2 cache performance | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-monitor-cache |\n| Troubleshoot misclassified workloads in Synapse SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-troubleshoot-missed-classification |\n| Use DMVs to diagnose Synapse SQL workloads | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-monitor |\n| Use dedicated SQL pool FAQ for common issues and behaviors | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-faq |\n| Troubleshoot common dedicated SQL pool issues | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-troubleshoot |\n| Diagnose and fix Synapse SQL pool connectivity issues | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-troubleshoot-connectivity |\n| Monitor workload groups and query activity in Synapse portal | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-management-portal-monitor |\n| Troubleshoot common serverless SQL pool issues | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand |\n| Troubleshoot Synapse Link Entra user impersonation issues | https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-azure-active-directory |\n| Troubleshoot Synapse Link for Azure SQL after database failover | https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-database-failover |\n| Troubleshoot creation of Synapse Link for Azure SQL Database | https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-link-creation |\n| Troubleshoot Synapse Link initial snapshot issues for SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-snapshot-issues |\n| Fix UTF-8 text reading issues in Synapse serverless SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/reading-utf8-text |\n| Troubleshoot Synapse Studio network connectivity issues | https://learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/troubleshoot-synapse-studio |\n| Fix connectivity issues between Synapse Studio and storage | https://learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/troubleshoot-synapse-studio-and-storage-connectivity |\n| Troubleshoot Synapse Studio connectivity using PowerShell | https://learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/troubleshoot-synapse-studio-powershell |\n| Resolve SDK-created Synapse workspaces failing to launch Studio | https://learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/workspaces-created-by-sdk |\n\n### Best Practices\n| Topic | URL |\n|-------|-----|\n| Configure Git source control for Synapse Studio | https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/source-control |\n| Apply design and performance best practices for Netezza to Synapse migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/1-design-performance-migration |\n| Plan ETL and data load for Netezza to Synapse migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/2-etl-load-migration-considerations |\n| Implement visualization and reporting after Netezza to Synapse migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/4-visualization-reporting |\n| Minimize SQL compatibility issues in Netezza to Synapse migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/5-minimize-sql-issues |\n| Apply design and performance best practices for Oracle to Synapse migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/1-design-performance-migration |\n| Plan ETL and data load for Oracle to Synapse migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/2-etl-load-migration-considerations |\n| Implement visualization and reporting after Oracle to Synapse migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/4-visualization-reporting |\n| Minimize SQL compatibility issues in Oracle to Synapse migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/5-minimize-sql-issues |\n| Apply modern data warehouse best practices after Oracle migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/7-beyond-data-warehouse-migration |\n| Apply design and performance best practices for Teradata to Synapse migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/1-design-performance-migration |\n| Plan ETL and data load for Teradata to Synapse migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/2-etl-load-migration-considerations |\n| Implement visualization and reporting after Teradata to Synapse migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/4-visualization-reporting |\n| Minimize SQL compatibility issues in Teradata to Synapse migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/5-minimize-sql-issues |\n| Use Apache Spark Advisor recommendations in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/monitoring/apache-spark-advisor |\n| Optimize Azure Synapse Spark jobs for performance | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-performance |\n| Use Hyperspace indexes to accelerate Synapse Spark | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-performance-hyperspace |\n| Improve Delta MERGE performance with Low Shuffle Merge | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/low-shuffle-merge-for-apache-spark |\n| Optimize Spark Delta Lake writes with Optimize Write | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/optimize-write-for-apache-spark |\n| Analyze and prioritize dedicated SQL pool workloads | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/analyze-your-workload |\n| Apply performance best practices for Synapse dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/cheat-sheet |\n| Optimize Synapse materialized views for performance | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-materialized-views |\n| Optimize ordered clustered columnstore indexes in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-ordered-cci |\n| Optimize result set caching in dedicated SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-result-set-caching |\n| Optimize transaction performance in dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-best-practices-transactions |\n| Use dynamic SQL safely in dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-dynamic-sql |\n| Implement GROUP BY options in dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-group-by-options |\n| Instrument Synapse queries with T-SQL labels | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-label |\n| Implement T-SQL loops instead of cursors in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-loops |\n| Design and use stored procedures in dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-stored-procedures |\n| Implement transactions in Synapse SQL pool workloads | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-transactions |\n| Use user-defined schemas in dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-user-defined-schemas |\n| Assign T-SQL variables in dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-variable-assignment |\n| Optimize columnstore index memory and compression in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-memory-optimizations-for-columnstore-compression |\n| Use primary, foreign, and unique keys in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-table-constraints |\n| Choose optimal table data types in dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-data-types |\n| Implement IDENTITY surrogate keys in Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-identity |\n| Indexing strategies for Synapse dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-index |\n| Create and maintain statistics in Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-statistics |\n| Use temporary tables effectively in dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-temporary |\n| Apply performance best practices for Synapse dedicated SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-dedicated-sql-pool |\n| Implement performance and cost best practices for serverless SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-serverless-sql-pool |\n| Tune columnstore compression in dedicated SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/data-load-columnstore-compression |\n| Optimize data loading into dedicated SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/data-loading-best-practices |\n| Use dynamic SQL safely in Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-dynamic-sql |\n| Apply GROUP BY options in Synapse SQL queries | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-group-by-options |\n| Use query labels for monitoring in Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-label |\n| Implement T-SQL loops and cursor alternatives in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-loops |\n| Improve query performance with materialized views | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-materialized-view-performance-tuning |\n| Develop stored procedures for Synapse SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-stored-procedures |\n| Choose optimal table data types in Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-data-types |\n| Create and maintain statistics in Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-statistics |\n| Use temporary tables effectively in Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-temporary |\n| Optimize transactional code in Synapse dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-transaction-best-practices |\n| Use transactions with Synapse dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-transactions |\n| Design and use user-defined schemas in Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-user-defined-schemas |\n| Assign and use T-SQL variables in Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-variable-assignment |\n| Create and manage T-SQL views in Synapse SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-views |\n\n### Decision Making\n| Topic | URL |\n|-------|-----|\n| Compare Synapse data integration with Azure Data Factory | https://learn.microsoft.com/en-us/azure/synapse-analytics/data-integration/concepts-data-factory-differences |\n| Assess environment to choose Synapse technologies | https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-assess-environment |\n| Review Synapse project plan for implementation success | https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-project-plan |\n| Plan and execute migration to Synapse dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/migrate-to-synapse-analytics-guide |\n| Select tools for Netezza data warehouse migration to Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/6-microsoft-third-party-migration-tools |\n| Select tools for Oracle data warehouse migration to Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/6-microsoft-third-party-migration-tools |\n| Choose Microsoft and third-party tools for Teradata to Synapse migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/6-microsoft-third-party-migration-tools |\n| Plan and manage Azure Synapse Analytics costs | https://learn.microsoft.com/en-us/azure/synapse-analytics/plan-manage-costs |\n| Plan Synapse Spark runtime lifecycle and support | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/runtime-for-apache-spark-lifecycle-and-supportability |\n| Plan and execute migration of dedicated SQL pool to Gen2 | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/gen2-migration-schedule |\n| Use Azure Advisor recommendations for Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-recommendations |\n| Plan and execute upgrade to latest SQL pool generation | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/upgrade-to-latest-generation |\n| Choose appropriate DWUs for Synapse dedicated SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/what-is-a-data-warehouse-unit-dwu-cdwu |\n| Manage serverless SQL pool cost by data processed | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/data-processed |\n| Use Synapse Distribution Advisor for table design | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/distribution-advisor |\n| Choose methods for historical query analysis in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-history-storage-analysis |\n| Choose Synapse SQL resource consumption model | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/resource-consumption-models |\n\n### Architecture & Design Patterns\n| Topic | URL |\n|-------|-----|\n| Evaluate Synapse data integration architecture design | https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-data-integration-design |\n| Evaluate dedicated SQL pool data warehouse design | https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-dedicated-sql-pool-design |\n| Evaluate serverless SQL pool architecture and design | https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-serverless-sql-pool-design |\n| Evaluate Apache Spark pool design in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-spark-pool-design |\n| Evaluate Azure Synapse workspace architecture design | https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-workspace-design |\n| Success by Design architecture guidance for Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/success-by-design-introduction |\n| Design a modern Azure data warehouse after Netezza migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/7-beyond-data-warehouse-migration |\n| Design a modern data warehouse after Teradata migration to Azure | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/7-beyond-data-warehouse-migration |\n| Design ELT-based data loading patterns for Synapse dedicated SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/design-elt-data-loading |\n| Design replicated tables in Synapse SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/design-guidance-for-replicated-tables |\n| Design hash and round-robin distributed tables | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-distribute |\n| Partition tables in Synapse dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-partition |\n| Design workload management strategy in Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-management |\n| Use external tables with Synapse SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables |\n| Design tables for Synapse dedicated and serverless SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-overview |\n| Design PolyBase ELT loading strategy in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/load-data-overview |\n\n### Limits & Quotas\n| Topic | URL |\n|-------|-----|\n| Understand memory and concurrency limits in Synapse SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/memory-concurrency-limits |\n| Dedicated SQL pool capacity limits and quotas | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-service-capacity-limits |\n| Query Delta Lake v1 with Synapse serverless SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-delta-lake-format |\n| Supported features and limitations of Synapse Link for Cosmos DB | https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/concept-synapse-link-cosmos-db-support |\n| Limitations and known issues for Synapse Link for SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/synapse-link-for-sql-known-issues |\n\n### Security\n| Topic | URL |\n|-------|-----|\n| Access firewall-protected Purview from Synapse securely | https://learn.microsoft.com/en-us/azure/synapse-analytics/catalog-and-governance/how-to-access-secured-purview-account |\n| Secure Synapse linked services with managed VNet | https://learn.microsoft.com/en-us/azure/synapse-analytics/data-integration/linked-service |\n| Design and implement access control in Azure Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-access-control |\n| Implement authentication options for Azure Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-authentication |\n| Configure data protection features in Azure Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-data-protection |\n| Configure network security for Azure Synapse workspaces | https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-network-security |\n| Use threat detection and auditing in Azure Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-threat-protection |\n| Browse ADLS Gen2 with ACLs in Synapse securely | https://learn.microsoft.com/en-us/azure/synapse-analytics/how-to-access-container-with-access-control-lists |\n| Configure secure prerequisites for Foundry Tools in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/tutorial-configure-cognitive-services-synapse |\n| Configure security, access, and operations for Netezza to Synapse migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/3-security-access-operations |\n| Configure security, access, and operations for Oracle to Synapse migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/3-security-access-operations |\n| Configure security, access, and operations for Teradata to Synapse migration | https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/3-security-access-operations |\n| Apply built-in Azure Policy definitions for Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/policy-reference |\n| Apply Azure Policy compliance controls to Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/security-controls-policy |\n| Connect Synapse workspace to secure storage accounts | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/connect-to-a-secure-storage-account |\n| Manage connectivity settings for Synapse SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/connectivity-settings |\n| Use Synapse gateway IP addresses for network rules | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/gateway-ip-addresses |\n| Connect to Synapse Studio from restricted networks | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-connect-to-workspace-from-restricted-network |\n| Connect to Synapse workspaces using private endpoints | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-connect-to-workspace-with-private-links |\n| Create Synapse workspaces with data exfiltration protection | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-create-a-workspace-with-data-exfiltration-protection |\n| Create managed private endpoints from Synapse workspaces | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-create-managed-private-endpoints |\n| Grant workspace managed identity permissions in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-grant-workspace-managed-identity-permissions |\n| Manage Synapse RBAC role assignments in Synapse Studio | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-manage-synapse-rbac-role-assignments |\n| Review Synapse RBAC role assignments in Synapse Studio | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-review-synapse-rbac-role-assignments |\n| Set up access control for Synapse workspaces | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-set-up-access-control |\n| Secure Synapse Studio access with private link hubs | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-private-link-hubs |\n| Understand access control mechanisms in Synapse workspaces | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-access-control-overview |\n| Configure IP firewall rules for Synapse workspaces | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-ip-firewall |\n| Configure Synapse managed private endpoints securely | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-managed-private-endpoints |\n| Use managed virtual networks with Synapse workspaces | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-managed-vnet |\n| Use Synapse RBAC to secure workspace resources | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac |\n| Reference for built-in Synapse RBAC roles and permissions | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac-roles |\n| Map Synapse and Azure roles to common workspace tasks | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-understand-what-role-you-need |\n| Apply conditional access policies to Synapse workspaces | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/workspace-conditional-access |\n| Enable data exfiltration protection in Synapse workspaces | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/workspace-data-exfiltration-protection |\n| Configure encryption and key management for Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/security/workspaces-encryption |\n| Secure Synapse Spark credentials with Linked Services | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-secure-credentials-with-tokenlibrary |\n| Secure Synapse Spark log emission with certificate-based service principal | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/how-to-use-certificate-with-service-principalp-emit-log-event-hubs |\n| Implement column-level security in Synapse dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/column-level-security |\n| Deploy Synapse dedicated SQL pool with TDE using ARM template | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-arm-template |\n| Deploy Synapse dedicated SQL pool with TDE using Bicep | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bicep |\n| Secure authentication options for Synapse COPY | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bulk-load-copy-tsql-examples |\n| Configure single-region data residency for Synapse SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/single-region-residency |\n| Configure authentication for Synapse dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-authentication |\n| Configure Transparent Data Encryption in Synapse portal | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-encryption-tde |\n| Manage Transparent Data Encryption in Synapse with T-SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-encryption-tde-tsql |\n| Secure Azure Synapse dedicated SQL pool with roles and encryption | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-manage-security |\n| Configure Microsoft Entra authentication for Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/active-directory-authentication |\n| Configure storage access control for serverless SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-storage-access-control |\n| Configure Entra MFA authentication for Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/mfa-authentication |\n| Configure access control for shared databases in serverless SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/shared-databases-access-control |\n| Configure SQL authentication options in Synapse Analytics | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/sql-authentication |\n| Use managed identity to load external data securely | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/tutorial-external-tables-using-managed-identity |\n| Use Entra ID passthrough for external tables | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/tutorial-load-data-using-entra-id |\n| Secure Synapse Link for Azure SQL Database with network controls | https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-database-vnet |\n| Configure secure networking for Synapse Link SQL Server 2022 | https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-server-2022-vnet |\n| Use managed identities with Azure Synapse Analytics | https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-service-identity |\n\n### Configuration\n| Topic | URL |\n|-------|-----|\n| Connect Synapse workspace to Microsoft Purview | https://learn.microsoft.com/en-us/azure/synapse-analytics/catalog-and-governance/quickstart-connect-azure-purview |\n| Design Synapse development, test, and production environments | https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-solution-development-environment-design |\n| Configure and review monitoring for Azure Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-perform-monitoring-review |\n| Link Synapse workspace to Azure Machine Learning | https://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/quickstart-integrate-azure-machine-learning |\n| Set up SynapseML environment for Foundry Tools | https://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/setup-environment-cognitive-services |\n| Reference monitoring metrics and logs for Synapse Analytics | https://learn.microsoft.com/en-us/azure/synapse-analytics/monitor-synapse-analytics-reference |\n| Monitor Apache Spark applications in Synapse Studio | https://learn.microsoft.com/en-us/azure/synapse-analytics/monitoring/how-to-monitor-spark-applications |\n| Runtime components for Synapse Spark 3.3 | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-33-runtime |\n| Review component versions in Synapse Spark 3.4 runtime | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-34-runtime |\n| Runtime components for Synapse Spark 3.5 | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-35-runtime |\n| Configure autoscale for Apache Spark pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-autoscale |\n| Manage Apache Spark configuration in Synapse Studio | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-azure-create-spark-configuration |\n| Manage Apache Spark libraries in Synapse pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-azure-portal-add-libraries |\n| Create custom Conda channels in Synapse Spark | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-custom-conda-channel |\n| Configure external Hive Metastore for Synapse Spark pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-external-metastore |\n| Configure and use GPU-accelerated Spark pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-gpu-concept |\n| Use Intelligent Cache for Synapse Spark performance | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-intelligent-cache-concept |\n| Configure Spark pool libraries in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-manage-pool-packages |\n| Use session-scoped libraries in Synapse notebooks | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-manage-session-packages |\n| Manage workspace-level libraries for Synapse Spark | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-manage-workspace-packages |\n| Configure Apache Spark pool sizes and behavior | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-pool-configurations |\n| Select supported Apache Spark runtimes in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-version-support |\n| Configure backup, restore points, and geo-backups for Synapse dedicated SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/backup-and-restore |\n| Disable geo-backups for Synapse dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/disable-geo-backup |\n| Configure monitoring for Synapse dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/monitor-sql-pool-synapse-analytics |\n| Use resource classes for Synapse workload management | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/resource-classes-for-workload-management |\n| Configure connection strings for Synapse SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-connection-strings |\n| Configure workload importance in dedicated SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-configure-workload-importance |\n| Convert resource classes to workload groups in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-convert-resource-classes-workload-groups |\n| Configure and manage Synapse SQL pool compute | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-overview |\n| Configure Azure Monitor for Synapse SQL workloads | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-monitor-workload-portal |\n| Configure collation types for Synapse dedicated SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-collation-types |\n| Restore an existing Synapse dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-active-paused-dw |\n| Restore a deleted Synapse dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-deleted-dw |\n| Restore Synapse SQL pool from a deleted server | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-from-deleted-server |\n| Geo-restore a Synapse dedicated SQL pool from backup | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-from-geo-backup |\n| Create and manage user-defined restore points in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-points |\n| Configure workload classification in Synapse dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-classification |\n| Set workload importance for Synapse SQL queries | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-importance |\n| Configure workload isolation with workload groups in Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-isolation |\n| Enable Synapse workspace features on existing SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/workspace-connected-create |\n| Configure connection strings for Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/connection-strings |\n| Create and use views in serverless SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/create-use-views |\n| Configure collation types in Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/reference-collation-types |\n| Monitor Synapse Link for Azure SQL Database with Studio and Azure Monitor | https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-monitor-synapse-link-sql-database |\n\n### Integrations & Coding Patterns\n| Topic | URL |\n|-------|-----|\n| Access Synapse ADLS Gen2 data from Azure Machine Learning | https://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/access-data-from-aml |\n| Score ML models with PREDICT in Synapse Spark | https://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/tutorial-score-model-predict-spark-pool |\n| Send Synapse Spark logs and metrics to Log Analytics | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-azure-log-analytics |\n| Use Delta Lake tables with Synapse Spark | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-delta-lake-overview |\n| Manage Synapse Spark packages via PowerShell and REST | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-manage-packages-outside-ui |\n| Emit Synapse Spark logs and metrics to Event Hubs | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/azure-synapse-diagnostic-emitters-azure-eventhub |\n| Emit Synapse Spark logs and metrics to Azure Storage | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/azure-synapse-diagnostic-emitters-azure-storage |\n| Collect Synapse Spark metrics via Prometheus APIs | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/connect-monitor-azure-synapse-spark-application-level-metrics |\n| Use Spark CDM connector to read/write Common Data Model | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/data-sources/apache-spark-cdm-connector |\n| Use Kusto connector with Synapse serverless Spark | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/data-sources/apache-spark-kusto-connector |\n| Use Synapse Spark connector for SQL databases | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/data-sources/apache-spark-sql-connector |\n| Configure Synapse Spark logging with certificate-based auth | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/how-to-use-certificate-with-service-principal-for-log-storage |\n| Develop and submit Spark apps from IntelliJ to Synapse | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/intellij-tool-synapse |\n| Use MSSparkUtils utilities in Synapse Spark notebooks | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/microsoft-spark-utilities |\n| Mount external storage using Synapse Spark file APIs | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/synapse-file-mount-api |\n| Move data between Synapse Spark and Dedicated SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/synapse-spark-sql-pool-import-export |\n| Monitor Synapse Spark metrics with Prometheus and Grafana | https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/use-prometheus-grafana-to-monitor-apache-spark-application-level-metrics |\n| Set up Fivetran with Synapse dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/fivetran-quickstart |\n| Use Azure Functions to manage Synapse SQL pool compute | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/manage-compute-with-azure-functions |\n| Bulk load data with Synapse COPY T-SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bulk-load-copy-tsql |\n| Create tables with CTAS in Synapse dedicated SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-ctas |\n| Integrate Synapse data with Azure Machine Learning designer | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-get-started-analyze-with-azure-machine-learning |\n| Integrate Azure Stream Analytics with Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-integrate-azure-stream-analytics |\n| Control Synapse SQL pool compute via REST APIs | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-rest-api |\n| Score ML models in Synapse with T-SQL PREDICT | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-predict |\n| Manage Synapse dedicated SQL pools with PowerShell and REST | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-powershell-cmdlets |\n| Integrate Synapse dedicated SQL pool with Azure Repos | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-source-control-integration |\n| Store serverless SQL query results to storage | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/create-external-table-as-select |\n| Query Azure Storage files with OPENROWSET | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset |\n| Query Azure Storage files with serverless SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-overview |\n| Query Spark tables via serverless SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-spark-tables |\n| Use CETAS to create external tables in Synapse SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-cetas |\n| Connect to Azure Synapse SQL using sqlcmd | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-connect-sqlcmd |\n| Connect Azure Synapse SQL from Visual Studio with SSDT | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-visual-studio |\n| Query Cosmos DB analytical store using Synapse serverless SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-cosmos-db-analytical-store |\n| Query Azure storage with serverless SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-data-storage |\n| Query folders and multiple files in serverless SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-folders-multiple-csv-files |\n| Query JSON files using serverless SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-json-files |\n| Query Parquet files using serverless SQL pool | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-parquet-files |\n| Query nested Parquet types with serverless SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-parquet-nested-types |\n| Query single CSV files with serverless SQL | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-single-csv-file |\n| Use file metadata in serverless SQL queries | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-specific-files |\n| Connect Azure SQL Database to Synapse via Synapse Link | https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-database |\n| Copy Synapse Link Cosmos DB data to Dedicated SQL via Spark | https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-copy-to-sql-pool |\n| Query Cosmos DB via Synapse Spark 2 analytical store | https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark |\n| Query Cosmos DB via Synapse Spark 3 analytical store | https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark-3 |\n\n### Deployment\n| Topic | URL |\n|-------|-----|\n| Implement CI/CD for Azure Synapse workspaces | https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery |\n| Perform operational readiness review for Synapse deployment | https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-perform-operational-readiness-review |\n| Deploy Synapse workspaces using ARM templates | https://learn.microsoft.com/en-us/azure/synapse-analytics/quickstart-deployment-template-workspaces |\n| Plan and configure Synapse SQL pool maintenance windows | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/maintenance-scheduling |\n| Set up CI/CD for Synapse dedicated SQL pools | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-continuous-integration-and-deployment |","tags":["azure","synapse","analytics","agent","skills","microsoftdocs","agent-skills","agentic-skills","agentskill","ai-agents","ai-coding","azure-functions"],"capabilities":["skill","source-microsoftdocs","skill-azure-synapse-analytics","topic-agent","topic-agent-skills","topic-agentic-skills","topic-agentskill","topic-ai-agents","topic-ai-coding","topic-azure","topic-azure-functions","topic-azure-kubernetes-service","topic-azure-openai","topic-azure-sql-database","topic-azure-storage"],"categories":["Agent-Skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/MicrosoftDocs/Agent-Skills/azure-synapse-analytics","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add MicrosoftDocs/Agent-Skills","source_repo":"https://github.com/MicrosoftDocs/Agent-Skills","install_from":"skills.sh"}},"qualityScore":"0.700","qualityRationale":"deterministic score 0.70 from registry signals: · indexed on github topic:agent-skills · 549 github stars · SKILL.md body (49,336 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T18:54:00.130Z","embedding":null,"createdAt":"2026-04-18T22:00:17.516Z","updatedAt":"2026-05-18T18:54:00.130Z","lastSeenAt":"2026-05-18T18:54:00.130Z","tsv":"'-8':689 '/en-us/azure/synapse-analytics/catalog-and-governance/how-to-access-secured-purview-account':1845 '/en-us/azure/synapse-analytics/catalog-and-governance/quickstart-connect-azure-purview':2467 '/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery':3462 '/en-us/azure/synapse-analytics/cicd/source-control':755 '/en-us/azure/synapse-analytics/data-integration/concepts-data-factory-differences':1417 '/en-us/azure/synapse-analytics/data-integration/linked-service':1855 '/en-us/azure/synapse-analytics/guidance/implementation-success-assess-environment':1426 '/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-data-integration-design':1608 '/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-dedicated-sql-pool-design':1618 '/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-project-plan':1436 '/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-serverless-sql-pool-design':1628 '/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-solution-development-environment-design':2477 '/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-spark-pool-design':1638 '/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-workspace-design':1647 '/en-us/azure/synapse-analytics/guidance/implementation-success-perform-monitoring-review':2487 '/en-us/azure/synapse-analytics/guidance/implementation-success-perform-operational-readiness-review':3472 '/en-us/azure/synapse-analytics/guidance/security-white-paper-access-control':1866 '/en-us/azure/synapse-analytics/guidance/security-white-paper-authentication':1875 '/en-us/azure/synapse-analytics/guidance/security-white-paper-data-protection':1885 '/en-us/azure/synapse-analytics/guidance/security-white-paper-network-security':1895 '/en-us/azure/synapse-analytics/guidance/security-white-paper-threat-protection':1906 '/en-us/azure/synapse-analytics/guidance/success-by-design-introduction':1657 '/en-us/azure/synapse-analytics/how-to-access-container-with-access-control-lists':1917 '/en-us/azure/synapse-analytics/how-to-recover-workspace-after-tenant-move':473 '/en-us/azure/synapse-analytics/known-issues':484 '/en-us/azure/synapse-analytics/machine-learning/access-data-from-aml':2950 '/en-us/azure/synapse-analytics/machine-learning/quickstart-integrate-azure-machine-learning':2497 '/en-us/azure/synapse-analytics/machine-learning/setup-environment-cognitive-services':2507 '/en-us/azure/synapse-analytics/machine-learning/tutorial-configure-cognitive-services-synapse':1928 '/en-us/azure/synapse-analytics/machine-learning/tutorial-score-model-predict-spark-pool':2961 '/en-us/azure/synapse-analytics/migration-guides/migrate-to-synapse-analytics-guide':1448 '/en-us/azure/synapse-analytics/migration-guides/netezza/1-design-performance-migration':769 '/en-us/azure/synapse-analytics/migration-guides/netezza/2-etl-load-migration-considerations':782 '/en-us/azure/synapse-analytics/migration-guides/netezza/3-security-access-operations':1941 '/en-us/azure/synapse-analytics/migration-guides/netezza/4-visualization-reporting':794 '/en-us/azure/synapse-analytics/migration-guides/netezza/5-minimize-sql-issues':806 '/en-us/azure/synapse-analytics/migration-guides/netezza/6-microsoft-third-party-migration-tools':1460 '/en-us/azure/synapse-analytics/migration-guides/netezza/7-beyond-data-warehouse-migration':1669 '/en-us/azure/synapse-analytics/migration-guides/oracle/1-design-performance-migration':820 '/en-us/azure/synapse-analytics/migration-guides/oracle/2-etl-load-migration-considerations':833 '/en-us/azure/synapse-analytics/migration-guides/oracle/3-security-access-operations':1954 '/en-us/azure/synapse-analytics/migration-guides/oracle/4-visualization-reporting':845 '/en-us/azure/synapse-analytics/migration-guides/oracle/5-minimize-sql-issues':857 '/en-us/azure/synapse-analytics/migration-guides/oracle/6-microsoft-third-party-migration-tools':1472 '/en-us/azure/synapse-analytics/migration-guides/oracle/7-beyond-data-warehouse-migration':869 '/en-us/azure/synapse-analytics/migration-guides/teradata/1-design-performance-migration':883 '/en-us/azure/synapse-analytics/migration-guides/teradata/2-etl-load-migration-considerations':896 '/en-us/azure/synapse-analytics/migration-guides/teradata/3-security-access-operations':1967 '/en-us/azure/synapse-analytics/migration-guides/teradata/4-visualization-reporting':908 '/en-us/azure/synapse-analytics/migration-guides/teradata/5-minimize-sql-issues':920 '/en-us/azure/synapse-analytics/migration-guides/teradata/6-microsoft-third-party-migration-tools':1487 '/en-us/azure/synapse-analytics/migration-guides/teradata/7-beyond-data-warehouse-migration':1682 '/en-us/azure/synapse-analytics/monitor-synapse-analytics-reference':2518 '/en-us/azure/synapse-analytics/monitoring/apache-spark-advisor':930 '/en-us/azure/synapse-analytics/monitoring/how-to-monitor-spark-applications':2528 '/en-us/azure/synapse-analytics/partner/compatibility-issues':496 '/en-us/azure/synapse-analytics/plan-manage-costs':1497 '/en-us/azure/synapse-analytics/policy-reference':1979 '/en-us/azure/synapse-analytics/quickstart-deployment-template-workspaces':3481 '/en-us/azure/synapse-analytics/security-controls-policy':1989 '/en-us/azure/synapse-analytics/security/connect-to-a-secure-storage-account':1999 '/en-us/azure/synapse-analytics/security/connectivity-settings':2009 '/en-us/azure/synapse-analytics/security/gateway-ip-addresses':2020 '/en-us/azure/synapse-analytics/security/how-to-connect-to-workspace-from-restricted-network':2030 '/en-us/azure/synapse-analytics/security/how-to-connect-to-workspace-with-private-links':2040 '/en-us/azure/synapse-analytics/security/how-to-create-a-workspace-with-data-exfiltration-protection':2050 '/en-us/azure/synapse-analytics/security/how-to-create-managed-private-endpoints':2060 '/en-us/azure/synapse-analytics/security/how-to-grant-workspace-managed-identity-permissions':2070 '/en-us/azure/synapse-analytics/security/how-to-manage-synapse-rbac-role-assignments':2081 '/en-us/azure/synapse-analytics/security/how-to-review-synapse-rbac-role-assignments':2092 '/en-us/azure/synapse-analytics/security/how-to-set-up-access-control':2102 '/en-us/azure/synapse-analytics/security/synapse-private-link-hubs':2113 '/en-us/azure/synapse-analytics/security/synapse-workspace-access-control-overview':2123 '/en-us/azure/synapse-analytics/security/synapse-workspace-ip-firewall':2133 '/en-us/azure/synapse-analytics/security/synapse-workspace-managed-private-endpoints':2142 '/en-us/azure/synapse-analytics/security/synapse-workspace-managed-vnet':2152 '/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac':2162 '/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac-roles':2175 '/en-us/azure/synapse-analytics/security/synapse-workspace-understand-what-role-you-need':2187 '/en-us/azure/synapse-analytics/security/workspace-conditional-access':2197 '/en-us/azure/synapse-analytics/security/workspace-data-exfiltration-protection':2207 '/en-us/azure/synapse-analytics/security/workspaces-encryption':2217 '/en-us/azure/synapse-analytics/spark/apache-spark-33-runtime':2537 '/en-us/azure/synapse-analytics/spark/apache-spark-34-runtime':2548 '/en-us/azure/synapse-analytics/spark/apache-spark-35-runtime':2557 '/en-us/azure/synapse-analytics/spark/apache-spark-autoscale':2566 '/en-us/azure/synapse-analytics/spark/apache-spark-azure-create-spark-configuration':2576 '/en-us/azure/synapse-analytics/spark/apache-spark-azure-log-analytics':2973 '/en-us/azure/synapse-analytics/spark/apache-spark-azure-portal-add-libraries':2586 '/en-us/azure/synapse-analytics/spark/apache-spark-custom-conda-channel':2596 '/en-us/azure/synapse-analytics/spark/apache-spark-delta-lake-overview':2983 '/en-us/azure/synapse-analytics/spark/apache-spark-external-metastore':2607 '/en-us/azure/synapse-analytics/spark/apache-spark-gpu-concept':2618 '/en-us/azure/synapse-analytics/spark/apache-spark-handle-livy-error':508 '/en-us/azure/synapse-analytics/spark/apache-spark-history-server':519 '/en-us/azure/synapse-analytics/spark/apache-spark-intelligent-cache-concept':2628 '/en-us/azure/synapse-analytics/spark/apache-spark-manage-packages-outside-ui':2994 '/en-us/azure/synapse-analytics/spark/apache-spark-manage-pool-packages':2637 '/en-us/azure/synapse-analytics/spark/apache-spark-manage-session-packages':2648 '/en-us/azure/synapse-analytics/spark/apache-spark-manage-workspace-packages':2659 '/en-us/azure/synapse-analytics/spark/apache-spark-performance':940 '/en-us/azure/synapse-analytics/spark/apache-spark-performance-hyperspace':950 '/en-us/azure/synapse-analytics/spark/apache-spark-pool-configurations':2669 '/en-us/azure/synapse-analytics/spark/apache-spark-secure-credentials-with-tokenlibrary':2227 '/en-us/azure/synapse-analytics/spark/apache-spark-troubleshoot-library-errors':528 '/en-us/azure/synapse-analytics/spark/apache-spark-version-support':2679 '/en-us/azure/synapse-analytics/spark/azure-synapse-diagnostic-emitters-azure-eventhub':3006 '/en-us/azure/synapse-analytics/spark/azure-synapse-diagnostic-emitters-azure-storage':3018 '/en-us/azure/synapse-analytics/spark/connect-monitor-azure-synapse-spark-application-level-metrics':3028 '/en-us/azure/synapse-analytics/spark/data-sources/apache-spark-cdm-connector':3040 '/en-us/azure/synapse-analytics/spark/data-sources/apache-spark-kusto-connector':3050 '/en-us/azure/synapse-analytics/spark/data-sources/apache-spark-sql-connector':3060 '/en-us/azure/synapse-analytics/spark/how-to-use-certificate-with-service-principal-for-log-storage':3072 '/en-us/azure/synapse-analytics/spark/how-to-use-certificate-with-service-principalp-emit-log-event-hubs':2241 '/en-us/azure/synapse-analytics/spark/intellij-tool-synapse':3084 '/en-us/azure/synapse-analytics/spark/low-shuffle-merge-for-apache-spark':961 '/en-us/azure/synapse-analytics/spark/microsoft-spark-utilities':3094 '/en-us/azure/synapse-analytics/spark/optimize-write-for-apache-spark':972 '/en-us/azure/synapse-analytics/spark/runtime-for-apache-spark-lifecycle-and-supportability':1507 '/en-us/azure/synapse-analytics/spark/synapse-file-mount-api':3105 '/en-us/azure/synapse-analytics/spark/synapse-spark-sql-pool-import-export':3117 '/en-us/azure/synapse-analytics/spark/use-prometheus-grafana-to-monitor-apache-spark-application-level-metrics':3128 '/en-us/azure/synapse-analytics/sql-data-warehouse/analyze-your-workload':982 '/en-us/azure/synapse-analytics/sql-data-warehouse/backup-and-restore':2695 '/en-us/azure/synapse-analytics/sql-data-warehouse/cheat-sheet':994 '/en-us/azure/synapse-analytics/sql-data-warehouse/column-level-security':2254 '/en-us/azure/synapse-analytics/sql-data-warehouse/design-elt-data-loading':1697 '/en-us/azure/synapse-analytics/sql-data-warehouse/design-guidance-for-replicated-tables':1707 '/en-us/azure/synapse-analytics/sql-data-warehouse/disable-geo-backup':2707 '/en-us/azure/synapse-analytics/sql-data-warehouse/fivetran-quickstart':3139 '/en-us/azure/synapse-analytics/sql-data-warehouse/gen2-migration-schedule':1520 '/en-us/azure/synapse-analytics/sql-data-warehouse/maintenance-scheduling':3492 '/en-us/azure/synapse-analytics/sql-data-warehouse/manage-compute-with-azure-functions':3151 '/en-us/azure/synapse-analytics/sql-data-warehouse/memory-concurrency-limits':1785 '/en-us/azure/synapse-analytics/sql-data-warehouse/monitor-sql-pool-synapse-analytics':2717 '/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-materialized-views':1003 '/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-ordered-cci':1013 '/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-result-set-caching':1024 '/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-arm-template':2267 '/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bicep':2279 '/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bulk-load-copy-tsql':3163 '/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bulk-load-copy-tsql-examples':2288 '/en-us/azure/synapse-analytics/sql-data-warehouse/resource-classes-for-workload-management':2727 '/en-us/azure/synapse-analytics/sql-data-warehouse/single-region-residency':2301 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-authentication':2311 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-recommendations':1530 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-resource-utilization-query-activity':539 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-connection-strings':2737 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-continuous-integration-and-deployment':3503 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-best-practices-transactions':1034 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-ctas':3175 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-dynamic-sql':1045 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-group-by-options':1056 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-label':1067 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-loops':1080 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-stored-procedures':1092 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-transactions':1102 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-user-defined-schemas':1114 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-variable-assignment':1126 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-encryption-tde':2321 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-encryption-tde-tsql':2334 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-get-started-analyze-with-azure-machine-learning':3186 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-configure-workload-importance':2747 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-convert-resource-classes-workload-groups':2758 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-find-queries-running-beyond-wlm-elapsed-timeout':548 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-manage-and-monitor-workload-importance':558 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-monitor-cache':567 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-troubleshoot-missed-classification':577 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-integrate-azure-stream-analytics':3196 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-overview':2768 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-rest-api':3207 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-monitor':587 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-memory-optimizations-for-columnstore-compression':1137 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-monitor-workload-portal':2778 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-faq':600 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-manage-security':2347 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-predict':3220 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-collation-types':2789 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-powershell-cmdlets':3232 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-active-paused-dw':2799 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-deleted-dw':2809 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-from-deleted-server':2820 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-from-geo-backup':2833 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-points':2846 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-service-capacity-limits':1795 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-source-control-integration':3243 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-table-constraints':1148 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-data-types':1160 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-distribute':1718 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-identity':1170 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-index':1180 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-partition':1728 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-statistics':1190 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-temporary':1201 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-troubleshoot':609 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-troubleshoot-connectivity':620 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-classification':2857 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-importance':2867 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-isolation':2878 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-management':1738 '/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-management-portal-monitor':632 '/en-us/azure/synapse-analytics/sql-data-warehouse/upgrade-to-latest-generation':1542 '/en-us/azure/synapse-analytics/sql-data-warehouse/what-is-a-data-warehouse-unit-dwu-cdwu':1553 '/en-us/azure/synapse-analytics/sql-data-warehouse/workspace-connected-create':2889 '/en-us/azure/synapse-analytics/sql/active-directory-authentication':2357 '/en-us/azure/synapse-analytics/sql/best-practices-dedicated-sql-pool':1213 '/en-us/azure/synapse-analytics/sql/best-practices-serverless-sql-pool':1226 '/en-us/azure/synapse-analytics/sql/connection-strings':2898 '/en-us/azure/synapse-analytics/sql/create-external-table-as-select':3253 '/en-us/azure/synapse-analytics/sql/create-use-views':2909 '/en-us/azure/synapse-analytics/sql/data-load-columnstore-compression':1236 '/en-us/azure/synapse-analytics/sql/data-loading-best-practices':1246 '/en-us/azure/synapse-analytics/sql/data-processed':1564 '/en-us/azure/synapse-analytics/sql/develop-dynamic-sql':1256 '/en-us/azure/synapse-analytics/sql/develop-group-by-options':1267 '/en-us/azure/synapse-analytics/sql/develop-label':1278 '/en-us/azure/synapse-analytics/sql/develop-loops':1291 '/en-us/azure/synapse-analytics/sql/develop-materialized-view-performance-tuning':1300 '/en-us/azure/synapse-analytics/sql/develop-openrowset':3262 '/en-us/azure/synapse-analytics/sql/develop-storage-files-overview':3273 '/en-us/azure/synapse-analytics/sql/develop-storage-files-spark-tables':3283 '/en-us/azure/synapse-analytics/sql/develop-storage-files-storage-access-control':2367 '/en-us/azure/synapse-analytics/sql/develop-stored-procedures':1310 '/en-us/azure/synapse-analytics/sql/develop-tables-cetas':3295 '/en-us/azure/synapse-analytics/sql/develop-tables-data-types':1321 '/en-us/azure/synapse-analytics/sql/develop-tables-external-tables':1748 '/en-us/azure/synapse-analytics/sql/develop-tables-overview':1759 '/en-us/azure/synapse-analytics/sql/develop-tables-statistics':1331 '/en-us/azure/synapse-analytics/sql/develop-tables-temporary':1341 '/en-us/azure/synapse-analytics/sql/develop-transaction-best-practices':1352 '/en-us/azure/synapse-analytics/sql/develop-transactions':1362 '/en-us/azure/synapse-analytics/sql/develop-user-defined-schemas':1375 '/en-us/azure/synapse-analytics/sql/develop-variable-assignment':1388 '/en-us/azure/synapse-analytics/sql/develop-views':1402 '/en-us/azure/synapse-analytics/sql/distribution-advisor':1574 '/en-us/azure/synapse-analytics/sql/get-started-connect-sqlcmd':3305 '/en-us/azure/synapse-analytics/sql/get-started-visual-studio':3317 '/en-us/azure/synapse-analytics/sql/load-data-overview':1769 '/en-us/azure/synapse-analytics/sql/mfa-authentication':2377 '/en-us/azure/synapse-analytics/sql/query-cosmos-db-analytical-store':3329 '/en-us/azure/synapse-analytics/sql/query-data-storage':3339 '/en-us/azure/synapse-analytics/sql/query-delta-lake-format':1806 '/en-us/azure/synapse-analytics/sql/query-folders-multiple-csv-files':3350 '/en-us/azure/synapse-analytics/sql/query-history-storage-analysis':1585 '/en-us/azure/synapse-analytics/sql/query-json-files':3360 '/en-us/azure/synapse-analytics/sql/query-parquet-files':3370 '/en-us/azure/synapse-analytics/sql/query-parquet-nested-types':3380 '/en-us/azure/synapse-analytics/sql/query-single-csv-file':3390 '/en-us/azure/synapse-analytics/sql/query-specific-files':3400 '/en-us/azure/synapse-analytics/sql/reference-collation-types':2918 '/en-us/azure/synapse-analytics/sql/resource-consumption-models':1594 '/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand':641 '/en-us/azure/synapse-analytics/sql/shared-databases-access-control':2389 '/en-us/azure/synapse-analytics/sql/sql-authentication':2399 '/en-us/azure/synapse-analytics/sql/tutorial-external-tables-using-managed-identity':2410 '/en-us/azure/synapse-analytics/sql/tutorial-load-data-using-entra-id':2420 '/en-us/azure/synapse-analytics/synapse-link/concept-synapse-link-cosmos-db-support':1819 '/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-database':3412 '/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-database-vnet':2433 '/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-server-2022-vnet':2445 '/en-us/azure/synapse-analytics/synapse-link/how-to-copy-to-sql-pool':3426 '/en-us/azure/synapse-analytics/synapse-link/how-to-monitor-synapse-link-sql-database':2933 '/en-us/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark':3438 '/en-us/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark-3':3450 '/en-us/azure/synapse-analytics/synapse-link/synapse-link-for-sql-known-issues':1831 '/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-azure-active-directory':651 '/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-database-failover':663 '/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-link-creation':675 '/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-snapshot-issues':686 '/en-us/azure/synapse-analytics/synapse-service-identity':2455 '/en-us/azure/synapse-analytics/troubleshoot/reading-utf8-text':699 '/en-us/azure/synapse-analytics/troubleshoot/troubleshoot-synapse-studio':708 '/en-us/azure/synapse-analytics/troubleshoot/troubleshoot-synapse-studio-and-storage-connectivity':719 '/en-us/azure/synapse-analytics/troubleshoot/troubleshoot-synapse-studio-powershell':728 '/en-us/azure/synapse-analytics/troubleshoot/workspaces-created-by-sdk':741 '/microsoftdocs/mcp/blob/main/readme.md)':167 '2':3433 '2022':2442 '3':138,3445 '3.3':2534 '3.4':2544 '3.5':2554 'acceler':945,2613 'accept':206 'access':172,1835,1859,1931,1944,1957,2095,2106,2115,2190,2360,2379,2939 'access/migration':378 'account':1996 'acl':1911 'activ':531,626 'address':2014 'adjust':551 'adl':1908,2941 'advisor':924,1523,1568 'agent':87,131,190,204 'altern':1286 'aml':401 'analysi':1580 'analyt':4,10,39,49,481,1493,2396,2452,2515,2970,3190,3321,3434,3446 'analyz':973 'apach':922,1630,2520,2561,2568,2578,2661,2672 'api':3025,3102,3204 'app':491,512,3077 'appli':756,807,858,870,983,1202,1257,1968,1980,2188 'applic':2522 'appropri':1544 'architectur':18,56,293,299,1595,1604,1623,1643,1651 'arm':449,2263,3477 'assess':1418 'assign':1115,1376,2075,2086 'audit':1900 'auth':360,3069 'authent':1868,2281,2303,2351,2371,2392 'autoscal':2559 'avail':157 'azur':2,8,37,47,426,479,656,670,932,1412,1491,1522,1640,1661,1679,1862,1871,1881,1890,1902,1972,1981,2179,2336,2425,2450,2483,2492,2770,2923,2929,2945,3014,3141,3180,3188,3239,3255,3264,3298,3307,3331,3402,3457 'azure-synapse-analyt':1 'backup':2681,2687,2699,2830 'backups/restore':395 'base':1686,2236,3068 'behavior':597,2666 'best':14,52,242,247,742,760,811,862,874,985,1204,1218 'bicep':2276 'brows':1907 'built':1970,2166 'built-in':1969,2165 'bulk':3152 'cach':563,1017,2621 'cap':329 'capabl':79 'capac':1789 'capacity/quotas':332 'categori':90,98,114,210,212 'cdm':3031 'certif':2235,3067 'certificate-bas':2234,3066 'ceta':3285 'channel':2590 'check':454 'choos':273,1149,1311,1421,1473,1543,1575,1586 'ci/cd':447,3455,3495 'class':2720,2750 'classif':2849 'cluster':1006 'code':26,64,403,410,1344,2935 'collat':2780,2911 'collect':3019 'column':2244 'column-level':2243 'columnstor':1007,1128,1228 'combin':69 'common':594,602,634,2182,3035 'compar':1407 'compat':486,797,848,911 'complianc':1983 'compon':275,2530,2539,2550 'compress':1132,1229 'comput':2765,3148,3201 'concurr':1777 'conda':2589 'condit':2189 'configur':24,62,379,383,456,746,1876,1886,1918,1929,1942,1955,2124,2134,2208,2289,2302,2312,2348,2358,2368,2378,2390,2434,2456,2478,2558,2570,2597,2608,2629,2660,2680,2708,2728,2738,2759,2769,2779,2847,2868,2890,2910,3061,3484 'connect':233,616,704,710,723,1990,2001,2021,2031,2459,2729,2891,3296,3306,3401 'connector':3032,3043,3054 'constraint':335 'consumpt':1590 'content':74,176 'control':749,1860,1984,2096,2116,2361,2380,2430,3197 'convert':2748 'copi':2285,3157,3413 'cosmos':346,1815,3319,3416,3428,3440 'cost':278,1217,1494,1558 'cover':50 'creat':732,1181,1322,1389,2041,2051,2587,2834,2899,3164,3287 'creation':665 'credenti':2221 'csv':3383 'ctas':3167 'cursor':1075,1285 'custom':2588 'data':257,288,308,369,377,431,773,824,860,887,1152,1238,1314,1409,1413,1453,1465,1560,1602,1613,1662,1673,1687,1877,2045,2199,2293,2314,2324,2406,2943,3036,3107,3154,3178,3418 'databas':659,672,2383,2427,2925,3057,3404 'db':347,1816,3320,3417,3429,3441 'debug':509 'decis':16,54,266,1403 'dedic':330,416,443,589,603,976,989,1019,1029,1040,1051,1087,1109,1121,1155,1175,1196,1208,1231,1241,1347,1357,1443,1513,1548,1610,1692,1723,1753,1786,2249,2257,2270,2306,2338,2690,2702,2712,2742,2784,2794,2804,2826,2852,3112,3134,3170,3223,3235,3420,3498 'defin':1106,1368,2839 'definit':1974 'delet':2802,2816 'delta':337,952,964,1797,2975 'deploy':29,67,433,439,2255,2268,3451,3469,3473 'descript':214 'design':19,32,57,294,301,757,808,871,1081,1363,1571,1596,1605,1615,1625,1633,1644,1650,1658,1670,1683,1698,1708,1729,1749,1760,1856,2468,3183 'detect':1898 'develop':11,1301,2470,3073 'diagnos':219,497,581,610 'disabl':2696 'distribut':1567,1714 'dmvs':579 'doc':182 'document':77,175 'dwus':1545 'dynam':1036,1248 'e.g':102,118 'effect':1194,1335 'elt':1685,1762 'elt-bas':1684 'elt/polybase':313 'emiss':2232 'emit':2995,3007 'enabl':2198,2879 'encrypt':2209,2315,2325,2344 'encryption/tde':371 'end':357,359 'end-to-end':356 'endpoint':366,2037,2054,2138 'entra':468,645,2350,2369,2412 'environ':281,1419,2474,2501 'error':502 'etl':771,822,885 'evalu':1600,1609,1619,1629,1639 'event':3002 'exceed':542 'execut':1439,1510,1533 'exfiltr':370,2046,2200 'exist':2792,2884 'expert':5,44 'extend':514 'extern':422,430,1740,2405,2416,2598,3096,3288 'factori':1414 'fail':735 'failov':660 'failur':236,525 'fallback':194 'faq':592 'featur':1808,1879,2882 'feature/known':341 'fetch':78,174,183,196 'file':108,116,123,128,3101,3257,3266,3344,3353,3363,3384,3392 'firewal':367,1837,2126 'firewall-protect':1836 'fivetran':3131 'fix':221,612,687,709 'folder':3341 'foreign':1140 'format':432 'foundri':1922,2503 'function':3142 'gateway':2012 'gen2':562,1517,1909,2942 'generat':1539 'geo':2686,2698,2822 'geo-backup':2685,2697 'geo-restor':2821 'git':747 'github.com':166 'github.com/microsoftdocs/mcp/blob/main/readme.md)':165 'gpu':2612 'gpu-acceler':2611 'grafana':3125 'grant':2061 'group':544,623,1047,1258,2753,2873 'guid':164,437 'guidanc':45,271,302,1652 'hash':1709 'histor':1578 'histori':515 'hive':2599 'hub':2110,3003 'hyperspac':942 'id':2413 'ident':374,1162,2064,2402,2448 'identifi':540 'imperson':647 'implement':783,834,897,1046,1068,1093,1161,1214,1279,1432,1858,1867,2242,3454 'import':85,129,553,2740,2860 'improv':951,1292 'includ':12,232 'index':91,211,943,1008,1129,1171 'indexing/statistics':256 'initi':679 'instal':161,163,524 'instead':1073 'instrument':1057 'integr':25,63,399,402,412,1410,1603,2934,3176,3187,3233 'intellig':2620 'intellij':3079 'ip':2013,2125 'isol':2870 'issu':231,342,475,487,595,606,617,638,648,681,692,705,711,798,849,912,1823 'job':235,501,935 'json':3352 'key':1143,1164,2211 'knowledg':6 'known':474,1822 'kusto':3042 'l120':105 'l128':246 'l129':269 'l129-l149':268 'l149':270 'l150':297 'l150-l169':296 'l169':298 'l170':321 'l170-l178':320 'l178':322 'l179':351 'l179-l239':350 'l239':352 'l240':381 'l240-l288':380 'l288':382 'l289':406 'l289-l338':405 'l338':407 'l339':435 'l339-l346':434 'l346':436 'l35':104 'l35-l120':103 'l37':217 'l37-l66':216 'l66':218 'l67':245 'l67-l128':244 'label':1064,1270 'lake':338,965,1798,2976 'latest':146,1536 'launch':737 'learn':189,203,2494,2947,3182 'learn-agent-skil':188,202 'learn.microsoft.com':472,483,495,507,518,527,538,547,557,566,576,586,599,608,619,631,640,650,662,674,685,698,707,718,727,740,754,768,781,793,805,819,832,844,856,868,882,895,907,919,929,939,949,960,971,981,993,1002,1012,1023,1033,1044,1055,1066,1079,1091,1101,1113,1125,1136,1147,1159,1169,1179,1189,1200,1212,1225,1235,1245,1255,1266,1277,1290,1299,1309,1320,1330,1340,1351,1361,1374,1387,1401,1416,1425,1435,1447,1459,1471,1486,1496,1506,1519,1529,1541,1552,1563,1573,1584,1593,1607,1617,1627,1637,1646,1656,1668,1681,1696,1706,1717,1727,1737,1747,1758,1768,1784,1794,1805,1818,1830,1844,1854,1865,1874,1884,1894,1905,1916,1927,1940,1953,1966,1978,1988,1998,2008,2019,2029,2039,2049,2059,2069,2080,2091,2101,2112,2122,2132,2141,2151,2161,2174,2186,2196,2206,2216,2226,2240,2253,2266,2278,2287,2300,2310,2320,2333,2346,2356,2366,2376,2388,2398,2409,2419,2432,2444,2454,2466,2476,2486,2496,2506,2517,2527,2536,2547,2556,2565,2575,2585,2595,2606,2617,2627,2636,2647,2658,2668,2678,2694,2706,2716,2726,2736,2746,2757,2767,2777,2788,2798,2808,2819,2832,2845,2856,2866,2877,2888,2897,2908,2917,2932,2949,2960,2972,2982,2993,3005,3017,3027,3039,3049,3059,3071,3083,3093,3104,3116,3127,3138,3150,3162,3174,3185,3195,3206,3219,3231,3242,3252,3261,3272,3282 'learn.microsoft.com/en-us/azure/synapse-analytics/catalog-and-governance/how-to-access-secured-purview-account':1843 'learn.microsoft.com/en-us/azure/synapse-analytics/catalog-and-governance/quickstart-connect-azure-purview':2465 'learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery':3460 'learn.microsoft.com/en-us/azure/synapse-analytics/cicd/source-control':753 'learn.microsoft.com/en-us/azure/synapse-analytics/data-integration/concepts-data-factory-differences':1415 'learn.microsoft.com/en-us/azure/synapse-analytics/data-integration/linked-service':1853 'learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-assess-environment':1424 'learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-data-integration-design':1606 'learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-dedicated-sql-pool-design':1616 'learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-project-plan':1434 'learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-serverless-sql-pool-design':1626 'learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-solution-development-environment-design':2475 'learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-spark-pool-design':1636 'learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-workspace-design':1645 'learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-perform-monitoring-review':2485 'learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-perform-operational-readiness-review':3470 'learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-access-control':1864 'learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-authentication':1873 'learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-data-protection':1883 'learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-network-security':1893 'learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-threat-protection':1904 'learn.microsoft.com/en-us/azure/synapse-analytics/guidance/success-by-design-introduction':1655 'learn.microsoft.com/en-us/azure/synapse-analytics/how-to-access-container-with-access-control-lists':1915 'learn.microsoft.com/en-us/azure/synapse-analytics/how-to-recover-workspace-after-tenant-move':471 'learn.microsoft.com/en-us/azure/synapse-analytics/known-issues':482 'learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/access-data-from-aml':2948 'learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/quickstart-integrate-azure-machine-learning':2495 'learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/setup-environment-cognitive-services':2505 'learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/tutorial-configure-cognitive-services-synapse':1926 'learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/tutorial-score-model-predict-spark-pool':2959 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/migrate-to-synapse-analytics-guide':1446 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/1-design-performance-migration':767 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/2-etl-load-migration-considerations':780 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/3-security-access-operations':1939 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/4-visualization-reporting':792 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/5-minimize-sql-issues':804 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/6-microsoft-third-party-migration-tools':1458 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/7-beyond-data-warehouse-migration':1667 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/1-design-performance-migration':818 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/2-etl-load-migration-considerations':831 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/3-security-access-operations':1952 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/4-visualization-reporting':843 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/5-minimize-sql-issues':855 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/6-microsoft-third-party-migration-tools':1470 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/7-beyond-data-warehouse-migration':867 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/1-design-performance-migration':881 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/2-etl-load-migration-considerations':894 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/3-security-access-operations':1965 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/4-visualization-reporting':906 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/5-minimize-sql-issues':918 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/6-microsoft-third-party-migration-tools':1485 'learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/7-beyond-data-warehouse-migration':1680 'learn.microsoft.com/en-us/azure/synapse-analytics/monitor-synapse-analytics-reference':2516 'learn.microsoft.com/en-us/azure/synapse-analytics/monitoring/apache-spark-advisor':928 'learn.microsoft.com/en-us/azure/synapse-analytics/monitoring/how-to-monitor-spark-applications':2526 'learn.microsoft.com/en-us/azure/synapse-analytics/partner/compatibility-issues':494 'learn.microsoft.com/en-us/azure/synapse-analytics/plan-manage-costs':1495 'learn.microsoft.com/en-us/azure/synapse-analytics/policy-reference':1977 'learn.microsoft.com/en-us/azure/synapse-analytics/quickstart-deployment-template-workspaces':3479 'learn.microsoft.com/en-us/azure/synapse-analytics/security-controls-policy':1987 'learn.microsoft.com/en-us/azure/synapse-analytics/security/connect-to-a-secure-storage-account':1997 'learn.microsoft.com/en-us/azure/synapse-analytics/security/connectivity-settings':2007 'learn.microsoft.com/en-us/azure/synapse-analytics/security/gateway-ip-addresses':2018 'learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-connect-to-workspace-from-restricted-network':2028 'learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-connect-to-workspace-with-private-links':2038 'learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-create-a-workspace-with-data-exfiltration-protection':2048 'learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-create-managed-private-endpoints':2058 'learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-grant-workspace-managed-identity-permissions':2068 'learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-manage-synapse-rbac-role-assignments':2079 'learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-review-synapse-rbac-role-assignments':2090 'learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-set-up-access-control':2100 'learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-private-link-hubs':2111 'learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-access-control-overview':2121 'learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-ip-firewall':2131 'learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-managed-private-endpoints':2140 'learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-managed-vnet':2150 'learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac':2160 'learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac-roles':2173 'learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-understand-what-role-you-need':2185 'learn.microsoft.com/en-us/azure/synapse-analytics/security/workspace-conditional-access':2195 'learn.microsoft.com/en-us/azure/synapse-analytics/security/workspace-data-exfiltration-protection':2205 'learn.microsoft.com/en-us/azure/synapse-analytics/security/workspaces-encryption':2215 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-33-runtime':2535 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-34-runtime':2546 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-35-runtime':2555 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-autoscale':2564 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-azure-create-spark-configuration':2574 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-azure-log-analytics':2971 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-azure-portal-add-libraries':2584 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-custom-conda-channel':2594 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-delta-lake-overview':2981 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-external-metastore':2605 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-gpu-concept':2616 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-handle-livy-error':506 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-history-server':517 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-intelligent-cache-concept':2626 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-manage-packages-outside-ui':2992 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-manage-pool-packages':2635 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-manage-session-packages':2646 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-manage-workspace-packages':2657 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-performance':938 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-performance-hyperspace':948 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-pool-configurations':2667 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-secure-credentials-with-tokenlibrary':2225 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-troubleshoot-library-errors':526 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-version-support':2677 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/azure-synapse-diagnostic-emitters-azure-eventhub':3004 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/azure-synapse-diagnostic-emitters-azure-storage':3016 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/connect-monitor-azure-synapse-spark-application-level-metrics':3026 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/data-sources/apache-spark-cdm-connector':3038 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/data-sources/apache-spark-kusto-connector':3048 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/data-sources/apache-spark-sql-connector':3058 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/how-to-use-certificate-with-service-principal-for-log-storage':3070 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/how-to-use-certificate-with-service-principalp-emit-log-event-hubs':2239 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/intellij-tool-synapse':3082 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/low-shuffle-merge-for-apache-spark':959 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/microsoft-spark-utilities':3092 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/optimize-write-for-apache-spark':970 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/runtime-for-apache-spark-lifecycle-and-supportability':1505 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/synapse-file-mount-api':3103 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/synapse-spark-sql-pool-import-export':3115 'learn.microsoft.com/en-us/azure/synapse-analytics/spark/use-prometheus-grafana-to-monitor-apache-spark-application-level-metrics':3126 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/analyze-your-workload':980 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/backup-and-restore':2693 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/cheat-sheet':992 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/column-level-security':2252 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/design-elt-data-loading':1695 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/design-guidance-for-replicated-tables':1705 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/disable-geo-backup':2705 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/fivetran-quickstart':3137 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/gen2-migration-schedule':1518 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/maintenance-scheduling':3490 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/manage-compute-with-azure-functions':3149 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/memory-concurrency-limits':1783 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/monitor-sql-pool-synapse-analytics':2715 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-materialized-views':1001 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-ordered-cci':1011 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-result-set-caching':1022 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-arm-template':2265 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bicep':2277 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bulk-load-copy-tsql':3161 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bulk-load-copy-tsql-examples':2286 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/resource-classes-for-workload-management':2725 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/single-region-residency':2299 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-authentication':2309 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-recommendations':1528 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-resource-utilization-query-activity':537 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-connection-strings':2735 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-continuous-integration-and-deployment':3501 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-best-practices-transactions':1032 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-ctas':3173 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-dynamic-sql':1043 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-group-by-options':1054 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-label':1065 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-loops':1078 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-stored-procedures':1090 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-transactions':1100 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-user-defined-schemas':1112 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-variable-assignment':1124 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-encryption-tde':2319 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-encryption-tde-tsql':2332 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-get-started-analyze-with-azure-machine-learning':3184 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-configure-workload-importance':2745 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-convert-resource-classes-workload-groups':2756 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-find-queries-running-beyond-wlm-elapsed-timeout':546 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-manage-and-monitor-workload-importance':556 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-monitor-cache':565 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-troubleshoot-missed-classification':575 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-integrate-azure-stream-analytics':3194 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-overview':2766 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-rest-api':3205 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-monitor':585 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-memory-optimizations-for-columnstore-compression':1135 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-monitor-workload-portal':2776 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-faq':598 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-manage-security':2345 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-predict':3218 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-collation-types':2787 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-powershell-cmdlets':3230 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-active-paused-dw':2797 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-deleted-dw':2807 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-from-deleted-server':2818 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-from-geo-backup':2831 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-points':2844 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-service-capacity-limits':1793 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-source-control-integration':3241 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-table-constraints':1146 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-data-types':1158 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-distribute':1716 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-identity':1168 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-index':1178 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-partition':1726 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-statistics':1188 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-temporary':1199 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-troubleshoot':607 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-troubleshoot-connectivity':618 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-classification':2855 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-importance':2865 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-isolation':2876 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-management':1736 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-management-portal-monitor':630 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/upgrade-to-latest-generation':1540 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/what-is-a-data-warehouse-unit-dwu-cdwu':1551 'learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/workspace-connected-create':2887 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/active-directory-authentication':2355 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-dedicated-sql-pool':1211 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-serverless-sql-pool':1224 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/connection-strings':2896 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/create-external-table-as-select':3251 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/create-use-views':2907 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/data-load-columnstore-compression':1234 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/data-loading-best-practices':1244 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/data-processed':1562 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-dynamic-sql':1254 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-group-by-options':1265 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-label':1276 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-loops':1289 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-materialized-view-performance-tuning':1298 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset':3260 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-overview':3271 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-spark-tables':3281 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-storage-access-control':2365 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-stored-procedures':1308 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-cetas':3293 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-data-types':1319 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables':1746 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-overview':1757 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-statistics':1329 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-temporary':1339 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-transaction-best-practices':1350 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-transactions':1360 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-user-defined-schemas':1373 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-variable-assignment':1386 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-views':1400 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/distribution-advisor':1572 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-connect-sqlcmd':3303 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-visual-studio':3315 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/load-data-overview':1767 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/mfa-authentication':2375 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-cosmos-db-analytical-store':3327 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-data-storage':3337 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-delta-lake-format':1804 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-folders-multiple-csv-files':3348 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-history-storage-analysis':1583 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-json-files':3358 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-parquet-files':3368 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-parquet-nested-types':3378 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-single-csv-file':3388 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-specific-files':3398 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/reference-collation-types':2916 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/resource-consumption-models':1592 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand':639 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/shared-databases-access-control':2387 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/sql-authentication':2397 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/tutorial-external-tables-using-managed-identity':2408 'learn.microsoft.com/en-us/azure/synapse-analytics/sql/tutorial-load-data-using-entra-id':2418 'learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/concept-synapse-link-cosmos-db-support':1817 'learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-database':3410 'learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-database-vnet':2431 'learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-server-2022-vnet':2443 'learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-copy-to-sql-pool':3424 'learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-monitor-synapse-link-sql-database':2931 'learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark':3436 'learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark-3':3448 'learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/synapse-link-for-sql-known-issues':1829 'learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-azure-active-directory':649 'learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-database-failover':661 'learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-link-creation':673 'learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-snapshot-issues':684 'learn.microsoft.com/en-us/azure/synapse-analytics/synapse-service-identity':2453 'learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/reading-utf8-text':697 'learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/troubleshoot-synapse-studio':706 'learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/troubleshoot-synapse-studio-and-storage-connectivity':717 'learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/troubleshoot-synapse-studio-powershell':726 'learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/workspaces-created-by-sdk':739 'level':2245,2652 'librari':393,523,2580,2632,2642,2653 'lifecycl':1502 'limit':21,59,318,327,1770,1778,1790,1810,1820 'line':100,112,213 'link':117,126,230,326,345,644,654,668,678,1813,1826,1848,2109,2223,2423,2439,2488,2921,3409,3415 'livi':500 'load':258,314,774,825,888,1239,1688,1763,2404,3153 'local':70 'locat':94 'log':2231,2512,2965,2969,2998,3010,3064 'loop':1072,1283 'low':956 'machin':2493,2946,3181 'maintain':1183,1324 'mainten':459,3488 'make':17,55,267,1404 'manag':317,373,397,1391,1490,1554,1731,1851,2000,2052,2063,2071,2136,2144,2212,2322,2401,2447,2567,2577,2649,2724,2761,2836,2984,3144,3221 'map':2176 'markdown':193,209 'materi':997,1296 'mcp':152,179 'mechan':2117 'memori':1130,1775 'memory/concurrency':328 'merg':953,958 'metadata':3393 'metadata.generated':133 'metastor':2600 'method':1576 'metric':2510,2967,3000,3012,3022,3121 'mfa':2370 'microsoft':181,1474,2349,2463 'microsoftdoc':153,180 'migrat':285,310,766,779,791,803,817,830,842,854,866,880,893,905,917,1440,1455,1467,1484,1511,1666,1677,1938,1951,1964 'migrating/modernizing':260 'minim':795,846,909 'misclassif':241 'misclassifi':569 'ml':420,2952,3209 'model':279,1591,2953,3037,3210 'modern':859,1660,1672 'monitor':421,529,549,559,621,1272,2481,2509,2519,2709,2771,2919,2930,3118 'monitoring/metrics':394 'month':139 'mount':3095 'move':238,470,3106 'mssparkutil':3086 'multipl':3343 'nest':3372 'netezza':262,763,776,788,800,1452,1665,1935 'network':171,363,703,1887,2016,2027,2146,2429,2436 'notebook':2645,3091 'old':140 'openrowset':3259 'oper':452,1933,1946,1959,3464 'optim':255,931,962,968,995,1004,1014,1025,1127,1150,1237,1312,1342 'option':1049,1260,1869,2282,2393 'oracl':263,814,827,839,851,865,1464,1948 'order':1005 'packag':2987 'parquet':3362,3373 'parti':1478 'partit':1719 'passthrough':2414 'pattern':20,27,58,65,253,295,404,408,1597,1689,2936 'perform':234,251,564,759,810,873,937,954,984,1000,1027,1203,1215,1294,2625,3463 'permiss':2065,2172 'plan':770,821,884,1430,1437,1488,1498,1508,1531,3482 'planning/assessing':280 'plus':428,451 'point':2683,2841 'polici':372,1973,1982,2191 'polybas':1761 'pool':35,225,307,331,387,390,445,458,574,591,605,615,637,978,991,1021,1031,1042,1053,1089,1098,1111,1123,1157,1177,1198,1210,1223,1233,1243,1307,1349,1359,1399,1445,1515,1538,1550,1557,1612,1622,1632,1694,1704,1725,1745,1782,1788,2006,2251,2259,2272,2298,2308,2340,2563,2583,2604,2615,2631,2663,2692,2704,2714,2734,2744,2764,2786,2796,2806,2813,2828,2854,2886,2906,3114,3136,3147,3172,3200,3225,3237,3270,3280,3336,3357,3367,3487,3500 'portal':629,2318 'powershel':725,2989,3227 'practic':15,53,243,248,743,761,812,863,875,986,1205,1219 'predict':2955,3217 'prefer':177 'prerequisit':1920 'primari':1139 'princip':2238 'priorit':975 'privat':365,2036,2053,2108,2137 'procedur':1085,1303 'process':1561 'product':2473 'project':1429 'prometheus':3024,3123 'protect':1838,1878,2047,2201 'provid':43 'pull':144 'purview':400,1839,2464 'queri':185,199,429,530,541,625,1059,1264,1269,1293,1579,1796,2864,3247,3254,3263,3274,3318,3330,3340,3351,3361,3371,3381,3397,3427,3439 'quick':72 'quick-refer':71 'quota':22,60,319,1771,1792 'rang':101 'rbac':362,2073,2084,2155,2169 'read':107,122,691 'read/write':3034 'readi':453,3465 'recommend':925,1524 'recov':464 'refer':73,127,2163,2508 'region':2292 'relev':95 'remot':76 'replic':1699 'repo':3240 'report':786,837,900 'repositori':150 'requir':170 'resid':2294 'resolv':485,499,729 'resourc':533,1589,2159,2719,2749 'rest':2991,3203,3229 'restor':2682,2790,2800,2810,2823,2840 'restrict':2026 'result':1015,3248 'return':192,208 'review':1427,2082,2480,2538,3466 'robin':1713 'role':2074,2085,2170,2180,2342 'round':1712 'round-robin':1711 'rule':2017,2127 'runtim':391,1501,2529,2545,2549,2674 'safe':1038,1250 'scale':392 'schema':1107,1369 'scope':2641 'score':2951,3208 'sdk':731 'sdk-creat':730 'section':96 'secur':23,61,349,353,376,1832,1842,1846,1888,1914,1919,1930,1943,1956,1994,2103,2139,2157,2218,2228,2246,2280,2335,2407,2421,2435 'security.md':119,120 'select':1449,1461,2670 'send':2962 'server':490,516,2441,2817 'serverless':333,415,635,695,1221,1555,1620,1755,1802,2363,2385,2904,3046,3245,3268,3278,3325,3334,3346,3355,3365,3376,3386,3395 'servic':427,1849,2224,2237 'session':2640 'session-scop':2639 'set':1016,2002,2093,2498,2858,3129,3493 'share':2382 'shuffl':957 'singl':2291,3382 'single-region':2290 'size':276,2664 'skill':40,42,84,169,191,205 'skill-azure-synapse-analytics' 'snapshot':680 'sourc':748 'source-microsoftdocs' 'spa':36 'spark':226,254,386,414,505,511,522,923,934,947,963,1500,1631,2220,2230,2521,2533,2543,2553,2562,2569,2579,2593,2603,2614,2624,2630,2656,2662,2673,2958,2964,2980,2986,2997,3009,3021,3030,3047,3053,3063,3076,3090,3100,3110,3120,3275,3423,3432,3444 'specifi':111 'sql':34,224,292,323,334,348,389,417,444,457,489,573,583,590,604,614,636,657,671,683,696,796,847,910,977,990,1020,1030,1037,1041,1052,1063,1071,1088,1097,1110,1118,1122,1156,1167,1176,1187,1197,1209,1222,1232,1242,1249,1253,1263,1275,1282,1306,1318,1328,1338,1348,1358,1372,1381,1385,1394,1398,1444,1514,1527,1537,1549,1556,1588,1611,1621,1693,1703,1724,1735,1744,1756,1781,1787,1803,1828,2005,2250,2258,2271,2297,2307,2331,2339,2354,2364,2374,2386,2391,2426,2440,2691,2703,2713,2733,2743,2763,2774,2785,2795,2805,2812,2827,2853,2863,2885,2895,2905,2915,2924,3056,3113,3135,3146,3160,3171,3193,3199,3216,3224,3236,3246,3269,3279,3292,3300,3309,3326,3335,3347,3356,3366,3377,3387,3396,3403,3421,3486,3499 'sql/serverless/spark':306 'sql/t-sql':252 'sqlcmd':3302 'ssdt':3314 'statist':1184,1325 'storag':419,716,1995,2359,3015,3097,3250,3256,3265,3332 'store':1084,1302,3244,3322,3435,3447 'strategi':312,1172,1732,1764 'stream':3189 'string':186,200,2730,2892 'studio':227,702,714,722,738,752,2024,2078,2089,2105,2525,2573,2927,3312 'submit':3075 'success':1433,1648 'suggest':141,158 'support':1504,1807,2671 'surrog':1163 'synaps':3,9,33,38,48,222,229,250,274,291,304,325,344,354,384,413,440,465,480,493,504,510,521,536,555,572,582,613,628,643,653,667,677,694,701,713,721,733,751,765,778,790,802,816,829,841,853,879,892,904,916,927,933,946,988,996,1010,1058,1077,1096,1134,1145,1166,1174,1186,1207,1252,1262,1274,1288,1305,1317,1327,1337,1346,1356,1371,1384,1397,1408,1422,1428,1442,1457,1469,1483,1492,1499,1526,1547,1566,1582,1587,1601,1635,1641,1654,1691,1702,1722,1734,1743,1752,1766,1780,1801,1812,1825,1841,1847,1863,1872,1882,1891,1903,1913,1925,1937,1950,1963,1976,1986,1991,2004,2011,2023,2033,2042,2056,2067,2072,2077,2083,2088,2098,2104,2119,2129,2135,2148,2154,2168,2177,2193,2203,2214,2219,2229,2248,2256,2269,2284,2296,2305,2317,2327,2337,2353,2373,2395,2422,2438,2451,2460,2469,2484,2489,2514,2524,2532,2542,2552,2572,2582,2592,2602,2623,2634,2644,2655,2676,2689,2701,2711,2722,2732,2755,2762,2773,2783,2793,2803,2811,2825,2843,2851,2862,2875,2880,2894,2914,2920,2940,2957,2963,2979,2985,2996,3008,3020,3045,3052,3062,3081,3089,3099,3109,3119,3133,3145,3156,3169,3177,3192,3198,3212,3222,3234,3291,3299,3308,3324,3406,3408,3414,3431,3443,3458,3468,3474,3485,3497 'synapseml':2500 't-sql':1061,1069,1116,1280,1379,1392,2329,3158,3214 'tabl':1151,1193,1313,1334,1570,1700,1715,1720,1741,1750,2417,2977,3165,3276,3289 'table/distribution/partition':311 'task':2184 'tde':2261,2274 'technolog':1423 'templat':450,2264,3478 'temporari':1192,1333 'tenant':237,469 'teradata':265,877,890,902,914,1481,1676,1961 'test':2471 'text':690 'text/markdown':207 'third':1477 'third-parti':1476 'threat':1897 'timeout':545 'tool':154,423,1450,1462,1479,1923,2504 'tools/steps':283 'topic':462,744,1405,1598,1772,1833,2457,2937,3452 'topic-agent' 'topic-agent-skills' 'topic-agentic-skills' 'topic-agentskill' 'topic-ai-agents' 'topic-ai-coding' 'topic-azure' 'topic-azure-functions' 'topic-azure-kubernetes-service' 'topic-azure-openai' 'topic-azure-sql-database' 'topic-azure-storage' 'transact':1026,1094,1343,1354 'transpar':2313,2323 'troubleshoot':13,51,215,461,520,561,568,601,633,642,652,664,676,700,720 'tune':1227 'type':1153,1315,2781,2912,3374 'understand':1774,2114 'uniqu':1142 'upgrad':287,1534 'url':463,745,1406,1599,1773,1834,2458,2938,3453 'use':30,82,88,106,121,178,195,578,588,724,921,941,1035,1083,1103,1138,1191,1247,1268,1332,1353,1365,1378,1521,1565,1739,1896,2010,2035,2143,2153,2262,2275,2400,2411,2446,2610,2619,2638,2718,2901,2974,3029,3041,3051,3085,3098,3140,3284,3301,3323,3354,3364,3391,3476 'user':143,160,646,1105,1367,2838 'user-defin':1104,1366,2837 'utf':688 'util':534,3087 'v1':339,1799 'variabl':1119,1382 'version':147,2540 'via':2988,3023,3202,3277,3407,3422,3430,3442 'view':998,1297,1395,2902 'virtual':2145 'visual':784,835,898,3311 'vnet':1852 'warehous':289,309,861,1454,1466,1614,1663,1674 'webpag':197 'window':460,3489 'workaround':477 'workload':240,316,396,543,552,570,584,622,979,1099,1730,2723,2739,2752,2775,2848,2859,2869,2872 'workspac':223,305,355,385,441,466,734,1642,1892,1992,2034,2043,2057,2062,2099,2120,2130,2149,2158,2183,2194,2204,2461,2490,2651,2881,3459,3475 'workspace-level':2650 'write':966,969","prices":[{"id":"fc69214e-7cb4-4ff1-aafb-1ff47f16cf7d","listingId":"9ae18663-6cac-4cc8-b325-9cb8933977ce","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"MicrosoftDocs","category":"Agent-Skills","install_from":"skills.sh"},"createdAt":"2026-04-18T22:00:17.516Z"}],"sources":[{"listingId":"9ae18663-6cac-4cc8-b325-9cb8933977ce","source":"github","sourceId":"MicrosoftDocs/Agent-Skills/azure-synapse-analytics","sourceUrl":"https://github.com/MicrosoftDocs/Agent-Skills/tree/main/skills/azure-synapse-analytics","isPrimary":false,"firstSeenAt":"2026-04-18T22:00:17.516Z","lastSeenAt":"2026-05-18T18:54:00.130Z"}],"details":{"listingId":"9ae18663-6cac-4cc8-b325-9cb8933977ce","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"MicrosoftDocs","slug":"azure-synapse-analytics","github":{"repo":"MicrosoftDocs/Agent-Skills","stars":549,"topics":["agent","agent-skills","agentic-skills","agentskill","ai","ai-agents","ai-coding","azure","azure-functions","azure-kubernetes-service","azure-openai","azure-sql-database","azure-storage","azure-virtual-machine","claude-code","github-copilot","microsoft-learn","openai-codex","skills"],"license":"cc-by-4.0","html_url":"https://github.com/MicrosoftDocs/Agent-Skills","pushed_at":"2026-05-17T02:50:05Z","description":"Curated Agent Skills for Microsoft & Azure – giving AI coding assistants structured, real-time expertise from Microsoft Learn docs.","skill_md_sha":"ca36e1c7b595725eff2a4d845699b13b00dc7b24","skill_md_path":"skills/azure-synapse-analytics/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/MicrosoftDocs/Agent-Skills/tree/main/skills/azure-synapse-analytics"},"layout":"multi","source":"github","category":"Agent-Skills","frontmatter":{"name":"azure-synapse-analytics","description":"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 SQL pools, Spark pools, serverless SQL, Synapse Link, or ELT/PolyBase pipelines, and other Azure Synapse Analytics related development tasks. Not for Azure Analysis Services (use azure-analysis-services), Azure Data Explorer (use azure-data-explorer), Azure Data Factory (use azure-data-factory), Azure Databricks (use azure-databricks).","compatibility":"Requires network access. Uses mcp_microsoftdocs:microsoft_docs_fetch or fetch_webpage to retrieve documentation."},"skills_sh_url":"https://skills.sh/MicrosoftDocs/Agent-Skills/azure-synapse-analytics"},"updatedAt":"2026-05-18T18:54:00.130Z"}}