azure-synapse-analytics
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChineseAzure Synapse Analytics Skill
Azure Synapse Analytics Skill
This skill provides expert guidance for Azure Synapse Analytics. Covers troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. It combines local quick-reference content with remote documentation fetching capabilities.
本Skill为Azure Synapse Analytics提供专业指导，涵盖故障排查、最佳实践、决策制定、架构与设计模式、限制与配额、安全、配置、集成与编码模式以及部署。它结合了本地快速参考内容与远程文档获取功能。
How to Use This Skill
如何使用本Skill
IMPORTANT for Agent: This file may be large. Use the Category Index below to locate relevant sections, then usewith specific line ranges (e.g.,read_file) to read the sections needed for the user's questionL136-L144
IMPORTANT for Agent: Ifis more than 3 months old, suggest the user pull the latest version from the repository. Ifmetadata.generated_attools are not available, suggest the user install it: Installation Guidemcp_microsoftdocs
This skill requires network access to fetch documentation content:
- Preferred: Use with query string
mcp_microsoftdocs:microsoft_docs_fetch. Returns Markdown.from=learn-agent-skill - Fallback: Use with query string
fetch_webpage. Returns Markdown.from=learn-agent-skill&accept=text/markdown
Agent 重要提示：本文件可能较大。请使用下方的分类索引定位相关章节，然后使用命令并指定具体行范围（例如read_file）来读取用户问题所需的章节L136-L144
本Skill需要网络访问权限以获取文档内容：
- 首选方式：使用，并携带查询字符串
mcp_microsoftdocs:microsoft_docs_fetch，返回Markdown格式内容。from=learn-agent-skill - 备用方式：使用，并携带查询字符串
fetch_webpage，返回Markdown格式内容。from=learn-agent-skill&accept=text/markdown
Category Index
分类索引
| Category | Lines | Description |
|---|---|---|
| Troubleshooting | L37-L62 | Diagnosing and fixing Synapse issues: workspace/tenant moves, Spark jobs and libraries, SQL pool performance/connectivity, Synapse Link failures, Studio/network/storage connectivity. |
| Best Practices | L63-L121 | Best practices for Synapse: Spark tuning, Delta/Hyperspace optimization, dedicated/serverless SQL design and performance, T-SQL patterns, indexing/stats, and Netezza/Oracle/Teradata migration guidance. |
| Decision Making | L122-L141 | Guidance on choosing Synapse components, planning migrations (Netezza/Oracle/Teradata/SQL pools), sizing and cost management, Spark lifecycle, table distribution, and using tools like Advisor and query history. |
| Architecture & Design Patterns | L142-L162 | Architecture and design guidance for Synapse workspaces, SQL/serverless/Spark pools, data warehouse migrations, table design, ELT/PolyBase loading, and workload management. |
| Limits & Quotas | L163-L173 | Synapse SQL pool limits: maintenance windows, memory/concurrency by performance level, capacity caps, temp table behavior, serverless Delta Lake v1 querying, and Synapse Link feature limits/issues. |
| Security | L174-L232 | Securing Synapse workspaces end-to-end: auth and RBAC, network isolation, private endpoints, encryption, data exfiltration, policies, and secure access to storage, SQL, Spark, and migration scenarios. |
| Configuration | L233-L283 | Configuring Synapse workspaces, Spark pools, and SQL pools: integrations (Purview, AML), libraries, autoscale, monitoring/metrics, backups/restore, workload management, and pipeline activities. |
| Integrations & Coding Patterns | L284-L320 | Patterns and code to integrate Synapse (Spark, serverless, dedicated SQL) with ADLS, Cosmos DB, Azure SQL, AML, monitoring (Log Analytics, Prometheus), and external tools via connectors, REST, and T-SQL. |
| Deployment | L321-L333 | Deploying and managing Synapse workspaces and dedicated SQL pools with ARM/Bicep, CI/CD, source control, restore points, and automated SQL compute operations. |
| 分类 | 行号 | 描述 |
|---|---|---|
| 故障排查 | L37-L62 | 诊断并修复Synapse问题：工作区/租户迁移、Spark作业与库、SQL池性能/连接性、Synapse Link故障、Studio/网络/存储连接问题。 |
| 最佳实践 | L63-L121 | Synapse最佳实践：Spark调优、Delta/Hyperspace优化、专用/无服务器SQL设计与性能、T-SQL模式、索引/统计信息，以及Netezza/Oracle/Teradata迁移指南。 |
| 决策制定 | L122-L141 | 选择Synapse组件的指导、迁移规划（Netezza/Oracle/Teradata/SQL池）、规模与成本管理、Spark生命周期、表分布策略，以及使用Advisor和查询历史等工具的方法。 |
| 架构与设计模式 | L142-L162 | Synapse工作区、SQL/无服务器/Spark池、数据仓库迁移、表设计、ELT/PolyBase加载以及工作负载管理的架构与设计指导。 |
| 限制与配额 | L163-L173 | Synapse SQL池限制：维护窗口、不同性能级别的内存/并发限制、容量上限、临时表行为、无服务器Delta Lake v1查询限制，以及Synapse Link功能限制与问题。 |
| 安全 | L174-L232 | 端到端保护Synapse工作区：身份验证与RBAC、网络隔离、专用终结点、加密、数据外泄防护、策略，以及存储、SQL、Spark和迁移场景的安全访问。 |
| 配置 | L233-L283 | 配置Synapse工作区、Spark池和SQL池：与Purview、AML的集成、库管理、自动缩放、监控/指标、备份/恢复、工作负载管理以及管道活动。 |
| 集成与编码模式 | L284-L320 | 将Synapse（Spark、无服务器、专用SQL）与ADLS、Cosmos DB、Azure SQL、AML、监控（Log Analytics、Prometheus）集成的模式与代码，以及通过连接器、REST和T-SQL与外部工具集成的方法。 |
| 部署 | L321-L333 | 使用ARM/Bicep、CI/CD、源代码控制、恢复点以及自动化SQL计算操作来部署和管理Synapse工作区与专用SQL池。 |
Troubleshooting
故障排查
Best Practices
最佳实践
Decision Making
决策制定
Architecture & Design Patterns
架构与设计模式
Limits & Quotas
限制与配额
| 主题 | 链接 |
|---|---|
| 为Synapse SQL池配置维护窗口 | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/maintenance-scheduling |
| 不同Synapse性能级别的内存与并发限制 | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/memory-concurrency-limits |
| 查看Synapse专用SQL池的容量限制 | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-service-capacity-limits |
| 在Synapse SQL池中使用临时表 | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-temporary |
| 使用Synapse无服务器SQL查询Delta Lake v1 | https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-delta-lake-format |
| Synapse Link for Cosmos DB的支持功能与限制 | https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/concept-synapse-link-cosmos-db-support |
| Synapse Link for SQL的限制与已知问题 | https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/synapse-link-for-sql-known-issues |