microsoft / microsoft/vscode-mssql

Create a Star Schema for Fabric with the Schema Designer

Open
#22,143 0 comments 0 reactions 0 assignees View on GitHub
Area - Schema Designer Enhancement User-filed
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

### Feature Description

I am a MS Fabric Architect. The Schema Designer is awesome. If it can create a Star Schema for Fabric it would save many hours vs doing it manually. It appears the Schema Designer Agent is for relational DBs like would be used in the Fabric Warehouses....

### Problem and Motivation

I am a MS Fabric Architect. The Schema Designer is awesome. If it can create a Star Schema for Fabric it would save many hours vs doing it manually. It appears the Schema Designer Agent is for relational DBs like would be used in the Fabric Warehouses....

### Related Area

- [ ] Connection dialog (SQL Server | Azure browse/Fabric browse)
- [ ] Query editor
- [ ] Query results panel
- [ ] Object Explorer
- [ ] GitHub Copilot integration
- [ ] Preview/Edit data
- [ ] Table Designer
- [x] Schema Designer
- [ ] Schema Compare
- [ ] Local SQL Server Container provisioning
- [x] SQL database in Fabric provisioning
- [x] DACPAC/BACPAC export/import
- [ ] SQL Database projects
- [ ] Query Plan Visualizer
- [ ] Other (please describe below)

### If you selected "Other", please describe the area

_No response_

### Confirmation

- [x] I have searched existing feature requests and couldn't find a match
- [ ] I want to help implement this feature

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reviewing the Schema Designer area and the SQL database in Fabric provisioning context described in the issue. No files, tests, or entry points are named; the feature would be complete when the Schema Designer can create a Star Schema for Fabric rather than requiring manual creation.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql, typescript
Domain
data-engineering, database
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Quiet
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.