azure-synapse

What problem does it solve?

This Skill simplifies the setup and configuration of Azure Synapse Analytics workspaces, enabling users to quickly establish robust data warehousing, big data processing, and analytics pipelines.

Core Features & Use Cases

• Workspace Deployment: Automates the creation of Synapse workspaces with integrated data lake storage and security configurations using Bicep or Terraform.
• Component Configuration: Guides the setup of dedicated SQL pools, serverless SQL pools, Spark pools, and Synapse Pipelines.
• Performance & Security: Provides best practices and configurations for optimizing performance, security, and cost.
• Use Case: A data engineer needs to set up a new Azure Synapse workspace for a big data project, including a Spark pool for data transformation and a dedicated SQL pool for reporting.

Quick Start

Use the azure-synapse skill to generate a Bicep configuration for a new Synapse workspace named 'my-synapse-workspace' with a data lake account 'mydatalakeaccount' and file system 'myfilesystem'.