mcpField
A
azure-synapse-analytics

azure-synapse-analytics

github.com/microsoftdocs数据与数据库796184 次安装3 天前更新
代码仓库

关于 azure-synapse-analytics

面向使用 Azure Synapse Analytics 的 Agent，提供故障排查、架构设计、安全、配置和部署等指导。内容结合本地速查索引与远程文档获取，涵盖 SQL、Spark 和 Synapse Link 等主题。

主要功能

  1. 01Synapse 故障排查指导
  2. 02性能与架构最佳实践
  3. 03安全及配置参考
  4. 04集成、编码与部署指导
  5. 05本地索引与远程文档获取

适用场景

  1. 01排查 SQL 池或 Spark 问题
  2. 02规划 Synapse 架构与迁移
  3. 03配置工作区安全和网络
  4. 04查阅部署及自动化模式

MCP 相关

该技能可通过 mcp_microsoftdocs 的 microsoft_docs_fetch 获取远程文档；也可使用 fetch_webpage 作为备用方式。

安装

复制下面的命令，在终端中运行。

$npx skills add https://github.com/microsoftdocs/agent-skills --skill azure-synapse-analytics

安装后在 Claude Code 中输入/azure-synapse-analytics确认已加载。

详细介绍

Azure Synapse Analytics 技能

此技能提供 Azure Synapse Analytics 专业指导，涵盖故障排除、最佳实践、决策、架构与设计模式、限制与配额、安全性、配置、集成与编码模式以及部署。它结合了本地快速参考内容和远程文档获取功能。

如何使用此技能

重要提示（Agent）： 使用下方的类别索引查找相关章节。对于标有行号范围（例如 L35-L120）的类别，请使用 read_file 读取指定行。对于带有文件链接（例如 [security.md](security.md)）的类别，请使用 read_file 读取链接的参考文件

重要提示（Agent）： 如果 metadata.generated_at 距今超过 3 个月，请建议用户从存储库拉取最新版本。如果无法使用 mcp_microsoftdocs 工具，请建议用户安装该工具：安装指南

此技能需要网络访问权限才能获取文档内容：

  • 首选：使用 mcp_microsoftdocs:microsoft_docs_fetch，并将查询字符串设为 from=learn-agent-skill。返回 Markdown。
  • 备用：使用 fetch_webpage，并将查询字符串设为 from=learn-agent-skill&accept=text/markdown。返回 Markdown。

类别索引

类别行描述
故障排除L37-L67诊断和修复 Synapse 工作区、SQL 池、Spark、Link 和 Studio 问题，包括连接、性能、工作负载分类以及已知问题和兼容性问题。
最佳实践L68-L130Synapse 性能和设计最佳实践：迁移（Netezza/Oracle/Teradata）、Spark 调优、Delta/Hyperspace、专用/无服务器 SQL 优化、索引、统计信息、T-SQL 模式和治理。
决策L131-L153关于选择 Synapse 架构、成本和容量规划、Spark 运行时，以及从其他数据仓库和 SQL 池迁移/升级的指导。
架构与设计模式L154-L173关于 Synapse 工作区、SQL/无服务器/Spark 池、数据仓库迁移、表/分布/分区策略、ELT/PolyBase 加载和工作负载管理的架构与设计指导。
限制与配额L174-L186Spark 运行时版本/支持、SQL 池内存/并发限制、容量配额，以及 Delta Lake、Synapse Link for Cosmos DB 和 Synapse Link for SQL 的功能/限制详情。
安全性L187-L271保护 Synapse 工作区和 SQL 安全：身份验证（Entra、MFA、托管标识）、RBAC、网络（虚拟网络、专用终结点、防火墙）、加密/TDE、审核、Defender 和数据保护。
配置L272-L321配置 Synapse 工作区、Spark 池和 SQL 池：环境设置、自动缩放、库、监视/指标、备份/还原、工作负载管理、审核和集成（Purview、AML）。
集成与编码模式L322-L371将 Synapse 与 Spark、SQL、ML、存储、Cosmos DB 和外部工具集成；数据移动、查询文件、日志记录/指标以及通过 API 和自动化管理计算资源的模式。
部署L372-L379使用 CI/CD 和 ARM 模板部署 Synapse 工作区和专用 SQL 池的指南，以及运行准备情况检查和配置 SQL 池维护时段。
故障排除
主题URL
Entra 租户迁移后恢复 Synapse 工作区https://learn.microsoft.com/en-us/azure/synapse-analytics/how-to-recover-workspace-after-tenant-move
Azure Synapse Analytics 的已知问题和解决方法https://learn.microsoft.com/en-us/azure/synapse-analytics/known-issues
解决 Azure Synapse Analytics 常见 FAQ 问题https://learn.microsoft.com/en-us/azure/synapse-analytics/overview-faq
解决 SQL Server 应用与 Synapse 之间的兼容性问题https://learn.microsoft.com/en-us/azure/synapse-analytics/partner/compatibility-issues
诊断并解决 Synapse Spark 中的 Livy 作业错误https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-handle-livy-error
使用扩展历史记录服务器调试 Synapse Spark 应用https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-history-server
排查 Synapse Spark 库安装失败问题https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-troubleshoot-library-errors
监视 Synapse 中的查询活动和资源使用情况https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-resource-utilization-query-activity
找出超出工作负载组超时限制的查询https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-find-queries-running-beyond-wlm-elapsed-timeout
监视并调整 Synapse 中的工作负载重要性https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-manage-and-monitor-workload-importance
监视并排查 Gen2 缓存性能问题https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-monitor-cache
排查 Synapse SQL 池中工作负载分类错误的问题https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-troubleshoot-missed-classification
使用 DMV 诊断 Synapse SQL 工作负载https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-monitor
排查常见的专用 SQL 池问题https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-troubleshoot
诊断并修复 Synapse SQL 池连接问题https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-troubleshoot-connectivity
在 Synapse 门户中监视工作负载组和查询活动https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-management-portal-monitor
排查常见的无服务器 SQL 池问题https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand
解决 Synapse Link for SQL 的限制和已知问题https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/synapse-link-for-sql-known-issues
排查 Synapse Link Entra 用户模拟问题https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-azure-active-directory
排查 Azure SQL 的数据库故障转移后 Synapse Link 问题https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-database-failover
排查 Azure SQL Database 的 Synapse Link 创建问题https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-link-creation
排查 Synapse Link for SQL 初始快照问题https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/troubleshoot/troubleshoot-sql-snapshot-issues
修复 Synapse 无服务器 SQL 中的 UTF-8 文本读取问题https://learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/reading-utf8-text
排查 Synapse Studio 网络连接问题https://learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/troubleshoot-synapse-studio
修复 Synapse Studio 与存储之间的连接问题https://learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/troubleshoot-synapse-studio-and-storage-connectivity
使用 PowerShell 排查 Synapse Studio 连接问题https://learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/troubleshoot-synapse-studio-powershell
解决使用 SDK 创建的 Synapse 工作区无法启动 Studio 的问题https://learn.microsoft.com/en-us/azure/synapse-analytics/troubleshoot/workspaces-created-by-sdk
最佳实践
主题URL
为 Synapse Studio 配置 Git 源代码管理https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/source-control
应用 Netezza 到 Synapse 迁移的设计和性能最佳实践https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/1-design-performance-migration
规划 Netezza 到 Synapse 迁移的 ETL 和数据加载https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/2-etl-load-migration-considerations
在 Netezza 到 Synapse 迁移后实现可视化和报告https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/4-visualization-reporting
最大限度减少 Netezza 到 Synapse 迁移中的 SQL 兼容性问题https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/5-minimize-sql-issues
应用 Oracle 到 Synapse 迁移的设计和性能最佳实践https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/1-design-performance-migration
规划 Oracle 到 Synapse 迁移的 ETL 和数据加载https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/2-etl-load-migration-considerations
在 Oracle 到 Synapse 迁移后实现可视化和报告https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/4-visualization-reporting
最大限度减少 Oracle 到 Synapse 迁移中的 SQL 兼容性问题https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/5-minimize-sql-issues
Oracle 迁移后应用现代数据仓库最佳实践https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/7-beyond-data-warehouse-migration
应用 Teradata 到 Synapse 迁移的设计和性能最佳实践https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/1-design-performance-migration
规划 Teradata 到 Synapse 迁移的 ETL 和数据加载https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/2-etl-load-migration-considerations
在 Teradata 到 Synapse 迁移后实现可视化和报告https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/4-visualization-reporting
最大限度减少 Teradata 到 Synapse 迁移中的 SQL 兼容性问题https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/5-minimize-sql-issues
在 Synapse 中使用 Apache Spark Advisor 建议https://learn.microsoft.com/en-us/azure/synapse-analytics/monitoring/apache-spark-advisor
优化 Azure Synapse Spark 作业性能https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-performance
使用 Hyperspace 索引加速 Synapse Sparkhttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-performance-hyperspace
使用 Low Shuffle Merge 提升 Delta MERGE 性能https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/low-shuffle-merge-for-apache-spark
使用 Optimize Write 优化 Spark Delta Lake 写入https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/optimize-write-for-apache-spark
分析并确定专用 SQL 池工作负载的优先级https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/analyze-your-workload
应用 Synapse 专用 SQL 池性能最佳实践https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/cheat-sheet
优化 Synapse 物化视图以提升性能https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-materialized-views
优化 Synapse 中有序聚集列存储索引https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-ordered-cci
优化专用 SQL 池中的结果集缓存https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-result-set-caching
优化专用 SQL 池中的事务性能https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-best-practices-transactions
在专用 SQL 池中安全使用动态 SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-dynamic-sql
在专用 SQL 池中实现 GROUP BY 选项https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-group-by-options
使用 T-SQL 标签为 Synapse 查询添加检测信息https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-label
在 Synapse 中使用 T-SQL 循环代替游标https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-loops
在专用 SQL 池中设计和使用存储过程https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-stored-procedures
在 Synapse SQL 池工作负载中实现事务https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-transactions
在专用 SQL 池中使用用户定义的架构https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-user-defined-schemas
在专用 SQL 池中赋值 T-SQL 变量https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-variable-assignment
优化 Synapse 中列存储索引的内存和压缩https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-memory-optimizations-for-columnstore-compression
在 Synapse 中使用主键、外键和唯一键https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-table-constraints
在专用 SQL 池中选择最佳表数据类型https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-data-types
在 Synapse SQL 中实现 IDENTITY 代理键https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-identity
Synapse 专用 SQL 池的索引策略https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-index
在 Synapse SQL 中创建和维护统计信息https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-statistics
在专用 SQL 池中有效使用临时表https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-temporary
在 Synapse SQL 中应用生产审计最佳实践https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/auditing-best-practices
应用 Synapse 专用 SQL 池的性能最佳实践https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-dedicated-sql-pool
为无服务器 SQL 池应用性能和成本最佳实践https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-serverless-sql-pool
调整专用 SQL 池中的列存储压缩https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/data-load-columnstore-compression
优化向专用 SQL 池加载数据https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/data-loading-best-practices
在 Synapse SQL 中安全使用动态 SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-dynamic-sql
在 Synapse SQL 查询中应用 GROUP BY 选项https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-group-by-options
在 Synapse SQL 中使用查询标签进行监视https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-label
在 Synapse 中实现 T-SQL 循环和游标替代方案https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-loops
使用物化视图提升查询性能https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-materialized-view-performance-tuning
为 Synapse SQL 池开发存储过程https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-stored-procedures
在 Synapse SQL 中选择最佳表数据类型https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-data-types
在 Synapse SQL 中创建和维护统计信息https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-statistics
在 Synapse SQL 中有效使用临时表https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-temporary
优化 Synapse 专用 SQL 池中的事务代码https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-transaction-best-practices
在 Synapse 专用 SQL 池中使用事务https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-transactions
在 Synapse SQL 中设计和使用用户定义的架构https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-user-defined-schemas
在 Synapse SQL 中赋值和使用 T-SQL 变量https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-variable-assignment
在 Synapse SQL 池中创建和管理 T-SQL 视图https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-views
决策
主题URL
比较 Synapse 数据集成与 Azure Data Factoryhttps://learn.microsoft.com/en-us/azure/synapse-analytics/data-integration/concepts-data-factory-differences
评估环境以选择 Synapse 技术https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-assess-environment
审查 Synapse 项目计划，确保成功实施https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-project-plan
规划并执行迁移到 Synapse 专用 SQL 池https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/migrate-to-synapse-analytics-guide
选择将 Netezza 数据仓库迁移到 Synapse 的工具https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/6-microsoft-third-party-migration-tools
选择将 Oracle 数据仓库迁移到 Synapse 的工具https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/6-microsoft-third-party-migration-tools
选择将 Teradata 迁移到 Synapse 的 Microsoft 和第三方工具https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/6-microsoft-third-party-migration-tools
规划和管理 Azure Synapse Analytics 成本https://learn.microsoft.com/en-us/azure/synapse-analytics/plan-manage-costs
选择 Synapse Spark 运行时发布渠道https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-runtime-release-channels
规划 Synapse Spark 运行时生命周期和支持https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/runtime-for-apache-spark-lifecycle-and-supportability
规划并执行专用 SQL 池迁移到 Gen2https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/gen2-migration-schedule
使用 Azure Advisor 的 Synapse SQL 建议https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-recommendations
规划并执行升级到最新 SQL 池代际https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/upgrade-to-latest-generation
为 Synapse 专用 SQL 池选择合适的 DWUhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/what-is-a-data-warehouse-unit-dwu-cdwu
按处理的数据量管理无服务器 SQL 池成本https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/data-processed
使用 Synapse Distribution Advisor 进行表设计https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/distribution-advisor
在旧版 SQL DW 与 Synapse 工作区之间进行选择https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/overview-difference-between-formerly-sql-dw-workspace
选择 Synapse 历史查询分析方法https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-history-storage-analysis
选择 Synapse SQL 资源消耗模型https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/resource-consumption-models
架构与设计模式
主题URL
评估 Synapse 数据集成架构设计https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-data-integration-design
评估专用 SQL 池数据仓库设计https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-dedicated-sql-pool-design
评估无服务器 SQL 池架构与设计https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-serverless-sql-pool-design
评估 Synapse 中的 Apache Spark 池设计https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-spark-pool-design
评估 Azure Synapse 工作区架构设计https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-workspace-design
Synapse 的 Success by Design 架构指南https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/success-by-design-introduction
从 Netezza 迁移后设计现代 Azure 数据仓库https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/7-beyond-data-warehouse-migration
从 Teradata 迁移到 Azure 后设计现代数据仓库https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/7-beyond-data-warehouse-migration
为 Synapse 专用 SQL 池设计基于 ELT 的数据加载模式https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/design-elt-data-loading
在 Synapse SQL 池中设计复制表https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/design-guidance-for-replicated-tables
设计哈希和轮循分布表https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-distribute
在 Synapse 专用 SQL 池中对表进行分区https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-partition
在 Synapse SQL 中设计工作负载管理策略https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-management
在 Synapse SQL 池中使用外部表https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables
为 Synapse 专用和无服务器 SQL 设计表https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-overview
在 Synapse 中设计基于 PolyBase 的 ELT 加载策略https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/load-data-overview
限制与配额
主题URL
了解 Spark 3.4 运行时支持和生命周期https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-34-runtime
查看 Spark 3.5 运行时组件和支持https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-35-runtime
查看 Synapse 中支持的 Spark、Scala、Python 版本https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-version-support
了解 Synapse SQL 池中的内存和并发限制https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/memory-concurrency-limits
专用 SQL 池常见问题及服务限制https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-faq
专用 SQL 池容量限制和配额https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-service-capacity-limits
使用 Synapse 无服务器 SQL 查询 Delta Lake v1https://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
Azure Synapse Link for SQL 常见问题和限制https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/faq
安全性
主题URL
从 Synapse 安全访问受防火墙保护的 Purviewhttps://learn.microsoft.com/en-us/azure/synapse-analytics/catalog-and-governance/how-to-access-secured-purview-account
使用托管 VNet 保护 Synapse 链接服务https://learn.microsoft.com/en-us/azure/synapse-analytics/data-integration/linked-service
在 Azure Synapse 中设计和实施访问控制https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-access-control
为 Azure Synapse 实施身份验证选项https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-authentication
配置 Azure Synapse 中的数据保护功能https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-data-protection
配置 Azure Synapse 工作区的网络安全https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-network-security
在 Azure Synapse 中使用威胁检测和审核https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/security-white-paper-threat-protection
在 Synapse 中安全浏览带有 ACL 的 ADLS Gen2https://learn.microsoft.com/en-us/azure/synapse-analytics/how-to-access-container-with-access-control-lists
为 Synapse 中的 Foundry Tools 配置安全的先决条件https://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/tutorial-configure-cognitive-services-synapse
配置 Netezza 到 Synapse 迁移的安全性、访问权限和操作https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/netezza/3-security-access-operations
配置 Oracle 到 Synapse 迁移的安全性、访问权限和操作https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/3-security-access-operations
配置 Teradata 到 Synapse 迁移的安全性、访问权限和操作https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/teradata/3-security-access-operations
应用 Synapse 的内置 Azure Policy 定义https://learn.microsoft.com/en-us/azure/synapse-analytics/policy-reference
将 Azure Policy 合规性控制应用于 Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/security-controls-policy
将 Synapse 工作区连接到安全存储帐户https://learn.microsoft.com/en-us/azure/synapse-analytics/security/connect-to-a-secure-storage-account
配置 Azure Synapse 中的安全连接设置https://learn.microsoft.com/en-us/azure/synapse-analytics/security/connectivity-settings
将 Synapse 网关 IP 地址用于网络规则https://learn.microsoft.com/en-us/azure/synapse-analytics/security/gateway-ip-addresses
从受限网络连接到 Synapse Studiohttps://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-connect-to-workspace-from-restricted-network
使用专用终结点连接到 Synapse 工作区https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-connect-to-workspace-with-private-links
创建启用了数据外泄保护的 Synapse 工作区https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-create-a-workspace-with-data-exfiltration-protection
从 Synapse 工作区创建托管专用终结点https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-create-managed-private-endpoints
在 Synapse 中授予工作区托管标识权限https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-grant-workspace-managed-identity-permissions
在 Synapse Studio 中管理 Synapse RBAC 角色分配https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-manage-synapse-rbac-role-assignments
在 Synapse Studio 中查看 Synapse RBAC 角色分配https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-review-synapse-rbac-role-assignments
在 Azure Synapse 中配置基于角色的访问控制https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-set-up-access-control
使用专用链接中心保护对 Synapse Studio 的访问https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-private-link-hubs
了解 Synapse 工作区中的访问控制机制https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-access-control-overview
配置 Synapse 工作区的 IP 防火墙规则https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-ip-firewall
安全配置 Synapse 托管专用终结点https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-managed-private-endpoints
在 Synapse 工作区中使用托管虚拟网络https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-managed-vnet
使用 Synapse RBAC 保护工作区资源https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac
Synapse RBAC 内置角色和权限参考https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac-roles
将 Synapse 和 Azure 角色映射到常见工作区任务https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-understand-what-role-you-need
将条件访问策略应用于 Synapse 工作区https://learn.microsoft.com/en-us/azure/synapse-analytics/security/workspace-conditional-access
在 Synapse 工作区中启用数据外泄保护https://learn.microsoft.com/en-us/azure/synapse-analytics/security/workspace-data-exfiltration-protection
配置 Synapse 的加密和密钥管理https://learn.microsoft.com/en-us/azure/synapse-analytics/security/workspaces-encryption
使用链接服务保护 Synapse Spark 凭据https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-secure-credentials-with-tokenlibrary
使用基于证书的服务主体安全发送 Synapse Spark 日志https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/how-to-use-certificate-with-service-principalp-emit-log-event-hubs
在 Synapse 专用 SQL 池中实施列级安全性https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/column-level-security
使用 ARM 模板部署启用了 TDE 的 Synapse 专用 SQL 池https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-arm-template
使用 Bicep 部署启用了 TDE 的 Synapse 专用 SQL 池https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bicep
为 Synapse COPY 配置安全的身份验证选项https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bulk-load-copy-tsql-examples
为 Synapse SQL 池配置单区域数据驻留https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/single-region-residency
为 Synapse 专用 SQL 池配置身份验证https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-authentication
在 Synapse 门户中配置透明数据加密https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-encryption-tde
使用 T-SQL 管理 Synapse 中的透明数据加密https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-encryption-tde-tsql
保护 Azure Synapse 专用 SQL 池https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-manage-security
为 Synapse SQL 配置 Microsoft Entra 身份验证https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/active-directory-authentication
将 Synapse SQL 审核到 VNet 和防火墙后方的存储https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/audit-write-storage-account-behind-vnet-firewall
使用托管标识配置 Synapse SQL 审核https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/auditing-managed-identity
审核 Microsoft 支持人员对 Synapse SQL 的操作https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/auditing-microsoft-support-operations
配置并了解 Synapse SQL 审核https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/auditing-overview
配置服务器级和数据库级审核策略https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/auditing-server-level-database-level
设置 Azure Synapse SQL 审核目标https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/auditing-setup
为 Synapse SQL 配置 Microsoft Entra 身份验证https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/authentication-aad-configure
为 Synapse 托管标识分配 Directory Readers 角色https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/authentication-aad-directory-readers-role-tutorial
在 Synapse SQL 中使用 Microsoft Entra 服务器主体https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/authentication-azure-ad-logins
在 Synapse 中创建和管理 Microsoft Entra 登录名https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/authentication-azure-ad-logins-tutorial
为 Synapse SQL 配置仅限 Microsoft Entra 的身份验证https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/authentication-azure-ad-only-authentication
使用托管标识配置 Synapse SQL 身份验证https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/authentication-azure-ad-user-assigned-managed-identity
使用 Microsoft Entra 身份验证连接到 Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/authentication-microsoft-entra-connect-to-azure-sql
启用和管理 Synapse SQL 的 Microsoft Defenderhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/azure-defender-for-sql
对 Synapse SQL 中的敏感数据进行分类和标记https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/data-discovery-and-classification-overview
为无服务器 SQL 配置存储访问控制https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-storage-access-control
配置 Synapse SQL 中的登录名、用户和角色https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/logins-create-manage
为 Synapse SQL 配置 Entra MFA 身份验证https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/mfa-authentication
为 Synapse SQL 池配置网络访问控制https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/network-access-controls-overview
将 Azure Private Link 与 Synapse SQL 终结点配合使用https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/private-endpoint-overview
为无服务器 SQL 中的共享数据库配置访问控制https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/shared-databases-access-control
配置 Synapse Analytics 中的 SQL 身份验证选项https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/sql-authentication
使用 PowerShell 和 CLI 通过 Key Vault 启用 Synapse TDEhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/transparent-data-encryption-byok-configure
轮换 Synapse SQL 的客户管理 TDE 保护程序https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/transparent-data-encryption-byok-key-rotation
使用 Azure Key Vault 配置客户管理的 TDEhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/transparent-data-encryption-byok-overview
移除 Synapse SQL 池中已泄露的 TDE 保护程序https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/transparent-data-encryption-byok-remove-tde-protector
为 Synapse SQL 池启用透明数据加密https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/transparent-data-encryption-tde-overview
使用托管标识安全加载外部数据https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/tutorial-external-tables-using-managed-identity
对外部表使用 Entra ID 直通身份验证https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/tutorial-load-data-using-entra-id
配置 Synapse SQL 虚拟网络服务终结点https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/vnet-service-endpoint-rule-overview
使用网络控制保护 Azure SQL Database 的 Synapse Linkhttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-database-vnet
为 Synapse Link SQL Server 2022 配置安全网络https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-server-2022-vnet
在 Azure Synapse Analytics 中使用托管标识https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-service-identity
配置
主题URL
将 Synapse 工作区连接到 Microsoft Purviewhttps://learn.microsoft.com/en-us/azure/synapse-analytics/catalog-and-governance/quickstart-connect-azure-purview
设计 Synapse 开发、测试和生产环境https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-evaluate-solution-development-environment-design
配置并查看 Azure Synapse 监视https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-perform-monitoring-review
将 Synapse 工作区链接到 Azure Machine Learninghttps://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/quickstart-integrate-azure-machine-learning
为 Foundry Tools 设置 SynapseML 环境https://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/setup-environment-cognitive-services
Azure Synapse Analytics 监视指标参考https://learn.microsoft.com/en-us/azure/synapse-analytics/monitor-synapse-analytics-reference
在 Synapse Studio 中监视 Apache Spark 应用程序https://learn.microsoft.com/en-us/azure/synapse-analytics/monitoring/how-to-monitor-spark-applications
Synapse Spark 3.3 的运行时组件https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-33-runtime
配置 Apache Spark 池的自动缩放https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-autoscale
在 Synapse Studio 中管理 Apache Spark 配置https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-azure-create-spark-configuration
管理 Synapse 池中的 Apache Spark 库https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-azure-portal-add-libraries
在 Synapse Spark 中创建自定义 Conda 通道https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-custom-conda-channel
为 Synapse Spark 池配置外部 Hive Metastorehttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-external-metastore
配置和使用 GPU 加速的 Spark 池https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-gpu-concept
使用智能缓存提升 Synapse Spark 性能https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-intelligent-cache-concept
在 Synapse 中配置 Spark 池库https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-manage-pool-packages
在 Synapse 笔记本中使用会话范围库https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-manage-session-packages
管理 Synapse Spark 工作区级库https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-manage-workspace-packages
配置 Apache Spark 池大小和行为https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-pool-configurations
将 Synapse Spark 诊断信息配置到 Log Analyticshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/data-collector-api-to-log-ingestion-api
为 Synapse 专用 SQL 池配置备份、还原点和异地备份https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/backup-and-restore
禁用 Synapse 专用 SQL 池的异地备份https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/disable-geo-backup
为 Synapse 专用 SQL 池配置监视https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/monitor-sql-pool-synapse-analytics
使用资源类管理 Synapse 工作负载https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/resource-classes-for-workload-management
配置 Synapse SQL 池的连接字符串https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-connection-strings
配置专用 SQL 池中的工作负载重要性https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-configure-workload-importance
在 Synapse 中将资源类转换为工作负载组https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-convert-resource-classes-workload-groups
配置和管理 Synapse SQL 池计算资源https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-overview
为 Synapse SQL 工作负载配置 Azure Monitorhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-monitor-workload-portal
配置 Synapse 专用 SQL 池的排序规则类型https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-collation-types
还原现有 Synapse 专用 SQL 池https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-active-paused-dw
还原已删除的 Synapse 专用 SQL 池https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-deleted-dw
从已删除的服务器还原 Synapse SQL 池https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-from-deleted-server
从备份异地还原 Synapse 专用 SQL 池https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-from-geo-backup
在 Synapse 中创建和管理用户定义的还原点https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-points
配置 Synapse 专用 SQL 池中的工作负载分类https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-classification
设置 Synapse SQL 查询的工作负载重要性https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-importance
在 Synapse 中使用工作负载组配置工作负载隔离https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-isolation
在现有 SQL 池上启用 Synapse 工作区功能https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/workspace-connected-create
解读 Azure Synapse SQL 审核日志格式https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/audit-log-format
在监视工具中分析 Synapse SQL 审核日志https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/auditing-analyze-audit-logs
通过 PowerShell、CLI 和 REST 管理 Synapse SQL 审核https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/auditing-manage-using-api
配置 Synapse SQL 的连接字符串https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/connection-strings
在无服务器 SQL 池中创建和使用视图https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/create-use-views
在 Synapse SQL 中配置排序规则类型https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/reference-collation-types
使用 Studio 和 Azure Monitor 监视 Azure SQL Database 的 Synapse Linkhttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-monitor-synapse-link-sql-database
集成与编码模式
主题URL
从 Azure Machine Learning 访问 Synapse ADLS Gen2 数据https://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/access-data-from-aml
在 Synapse Spark 中使用 PREDICT 对 ML 模型进行评分https://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/tutorial-score-model-predict-spark-pool
在 Synapse Spark 中使用 Delta Lake 表https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-delta-lake-overview
通过 PowerShell 和 REST 管理 Synapse Spark 包https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-manage-packages-outside-ui
将 Synapse Spark 日志和指标发送到 Event Hubshttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/azure-synapse-diagnostic-emitters-azure-eventhub
将 Synapse Spark 日志和指标发送到 Azure Storagehttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/azure-synapse-diagnostic-emitters-azure-storage
通过 Prometheus API 收集 Synapse Spark 指标https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/connect-monitor-azure-synapse-spark-application-level-metrics
使用 Spark CDM 连接器读写 Common Data Modelhttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/data-sources/apache-spark-cdm-connector
在 Synapse 无服务器 Spark 中使用 Kusto 连接器https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/data-sources/apache-spark-kusto-connector
将 Synapse Spark 连接器用于 SQL 数据库https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/data-sources/apache-spark-sql-connector
使用基于证书的身份验证配置 Synapse Spark 日志记录https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/how-to-use-certificate-with-service-principal-for-log-storage
从 IntelliJ 开发 Spark 应用并将其提交到 Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/spark/intellij-tool-synapse
在 Synapse Spark 笔记本中使用 MSSparkUtils 实用工具https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/microsoft-spark-utilities
使用 Synapse Spark 文件 API 挂载外部存储https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/synapse-file-mount-api
在 Synapse Spark 和专用 SQL 池之间移动数据https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/synapse-spark-sql-pool-import-export
使用 Prometheus 和 Grafana 监视 Synapse Spark 指标https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/use-prometheus-grafana-to-monitor-apache-spark-application-level-metrics
使用 PowerShell 和 CLI 管理 Azure Synapse DNS 别名https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/dns-alias-powershell-create
使用 Synapse 专用 SQL 池设置 Fivetranhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/fivetran-quickstart
使用 Azure Functions 管理 Synapse SQL 池计算资源https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/manage-compute-with-azure-functions
使用 Synapse COPY T-SQL 批量加载数据https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bulk-load-copy-tsql
在 Synapse 专用 SQL 池中使用 CTAS 创建表https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-ctas
使用 Azure Machine Learning 设计器集成 Synapse 数据https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-get-started-analyze-with-azure-machine-learning
将 Azure Stream Analytics 与 Synapse SQL 集成https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-integrate-azure-stream-analytics
通过 REST API 控制 Synapse SQL 池计算资源https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-rest-api
在 Synapse 中使用 T-SQL PREDICT 对 ML 模型进行评分https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-predict
使用 PowerShell 和 REST 管理 Synapse 专用 SQL 池https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-powershell-cmdlets
将 Synapse 专用 SQL 池与 Azure Repos 集成https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-source-control-integration
将无服务器 SQL 查询结果存储到存储中https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/create-external-table-as-select
使用 OPENROWSET 查询 Azure Storage 文件https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset
使用无服务器 SQL 池查询 Azure Storage 文件https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-overview
通过无服务器 SQL 池查询 Spark 表https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-spark-tables
使用 CETAS 在 Synapse SQL 中创建外部表https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-cetas
使用 sqlcmd 连接到 Azure Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-connect-sqlcmd
使用 SSDT 从 Visual Studio 连接 Azure Synapse SQLhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-visual-studio
使用 Synapse 无服务器 SQL 查询 Cosmos DB 分析存储https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-cosmos-db-analytical-store
使用无服务器 SQL 池查询 Azure Storagehttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-data-storage
在无服务器 SQL 中查询文件夹和多个文件https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-folders-multiple-csv-files
使用无服务器 SQL 池查询 JSON 文件https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-json-files
使用无服务器 SQL 池查询 Parquet 文件https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-parquet-files
使用无服务器 SQL 查询嵌套 Parquet 类型https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-parquet-nested-types
使用无服务器 SQL 查询单个 CSV 文件https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-single-csv-file
在无服务器 SQL 查询中使用文件元数据https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-specific-files
通过 Synapse Link 将 Azure SQL Database 连接到 Synapsehttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-database
通过 Spark 将 Synapse Link Cosmos DB 数据复制到专用 SQL 池https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-copy-to-sql-pool
通过 Synapse Spark 2 分析存储查询 Cosmos DBhttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark
通过 Synapse Spark 3 分析存储查询 Cosmos DBhttps://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark-3
部署
主题URL
为 Azure Synapse 工作区实施 CI/CDhttps://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery
对 Synapse 部署执行运营就绪情况审查https://learn.microsoft.com/en-us/azure/synapse-analytics/guidance/implementation-success-perform-operational-readiness-review
使用 ARM 模板部署 Synapse 工作区https://learn.microsoft.com/en-us/azure/synapse-analytics/quickstart-deployment-template-workspaces
规划并配置 Synapse SQL 池维护时段https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/maintenance-scheduling
为 Synapse 专用 SQL 池设置 CI/CDhttps://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-continuous-integration-and-deployment

评论

支持 Markdown