Skip to content

[Application QuickStart] [Backend] Restricting DAB local container deployment to Sql Auth#21554

Merged
manujoseph85 merged 5 commits into
mainfrom
dev/majoseph/dab-local-db-restriction
Mar 11, 2026
Merged

[Application QuickStart] [Backend] Restricting DAB local container deployment to Sql Auth#21554
manujoseph85 merged 5 commits into
mainfrom
dev/majoseph/dab-local-db-restriction

Conversation

@manujoseph85

@manujoseph85 manujoseph85 commented Mar 11, 2026

Copy link
Copy Markdown
Contributor

Description

We found an issue where DAB local container deployment does not work for Fabric connections because Fabric only supports Token based auth. Currently, there is no easy way to enable that for local containers.

This pull request introduces a new restriction for local container deployment of the Data API Builder (DAB) feature, ensuring it is only available for SQL Authentication connections.

We will add Azure based container deployments next, and other auth types can be easily supported then with Azure Managed Identity.

image

Code Changes Checklist

  • New or updated unit tests added
  • All existing tests pass (npm run test)
  • Code follows contributing guidelines
  • Telemetry/logging updated if relevant
  • No regressions or UX breakage

Reviewers: Please read our reviewer guidelines

@github-actions

github-actions Bot commented Mar 11, 2026

Copy link
Copy Markdown

PR Changes

Category Target Branch PR Branch Difference
vscode-mssql VSIX 6410 KB 6410 KB ⚪ 0 KB ( 0% )
sql-database-projects VSIX 7061 KB 7061 KB ⚪ 0 KB ( 0% )
data-workspace VSIX 535 KB 535 KB ⚪ 0 KB ( 0% )

@codecov-commenter

codecov-commenter commented Mar 11, 2026

Copy link
Copy Markdown

Codecov Report

✅ All modified and coverable lines are covered by tests.
✅ Project coverage is 72.69%. Comparing base (bef06cd) to head (66518e1).

Additional details and impacted files

Impacted file tree graph

@@            Coverage Diff             @@
##             main   #21554      +/-   ##
==========================================
+ Coverage   72.68%   72.69%   +0.01%     
==========================================
  Files         331      331              
  Lines       98504    98546      +42     
  Branches     5465     5470       +5     
==========================================
+ Hits        71595    71637      +42     
  Misses      26909    26909              
Files with missing lines Coverage Δ
extensions/mssql/src/constants/locConstants.ts 75.95% <100.00%> (+0.02%) ⬆️
...nsions/mssql/src/reactviews/common/locConstants.ts 25.29% <100.00%> (+0.08%) ⬆️
.../schemaDesigner/schemaDesignerWebviewController.ts 86.20% <100.00%> (+0.80%) ⬆️
...sions/mssql/src/sharedInterfaces/schemaDesigner.ts 100.00% <100.00%> (ø)
🚀 New features to boost your workflow:
  • ❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.
  • 📦 JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.

Copilot AI left a comment

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Pull request overview

Restricts Schema Designer’s Data API Builder (DAB) local container deployment workflow to SQL Authentication (SqlLogin) connections, since local Docker-based deployment can’t complete interactive/token-based authentication (e.g., Fabric/Azure MFA).

Changes:

  • Adds isDabDeploymentSupported to Schema Designer webview state and computes it from the connection authentication type.
  • Disables the Deploy button in the DAB toolbar (with tooltip text) and adds a backend guard in the deployment RPC handler.
  • Adds unit tests covering supported/unsupported auth types and the deployment guard behavior, plus new localized string entries.

Reviewed changes

Copilot reviewed 9 out of 9 changed files in this pull request and generated 2 comments.

Show a summary per file
File Description
localization/xliff/vscode-mssql.xlf Adds new user-facing string for the “SQL Auth only” restriction.
extensions/mssql/test/unit/schemaDesignerWebviewController.test.ts Adds unit tests for deployment support detection and guard behavior.
extensions/mssql/src/sharedInterfaces/schemaDesigner.ts Extends Schema Designer state with isDabDeploymentSupported.
extensions/mssql/src/schemaDesigner/schemaDesignerWebviewController.ts Computes support flag and blocks deployment RPC requests when unsupported.
extensions/mssql/src/reactviews/pages/SchemaDesigner/dab/dabToolbar.tsx Disables Deploy button and shows tooltip messaging based on support flag.
extensions/mssql/src/reactviews/pages/SchemaDesigner/dab/dabContext.tsx Plumbs isDabDeploymentSupported from Schema Designer state into DAB context.
extensions/mssql/src/reactviews/common/locConstants.ts Adds webview localization entry for the restriction message.
extensions/mssql/src/constants/locConstants.ts Adds extension-side localization entry for the restriction message (used by controller).
extensions/mssql/l10n/bundle.l10n.json Adds bundle entry for the new localized string.

💡 Add Copilot custom instructions for smarter, more guided reviews. Learn how to get started.

You can also share your feedback on Copilot code review. Take the survey.

Comment thread localization/xliff/vscode-mssql.xlf
Comment thread extensions/mssql/test/unit/schemaDesignerWebviewController.test.ts
@manujoseph85 manujoseph85 merged commit ef4b2f0 into main Mar 11, 2026
3 checks passed
@manujoseph85 manujoseph85 deleted the dev/majoseph/dab-local-db-restriction branch March 11, 2026 16:53
manujoseph85 added a commit that referenced this pull request Mar 11, 2026
…ployment to Sql Auth (#21554)

* Restricting DAB deployment to Sql Auth connections
Benjin pushed a commit that referenced this pull request Mar 11, 2026
…ployment to Sql Auth (#21554) (#21571)

* Restricting DAB deployment to Sql Auth connections
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Projects

None yet

Development

Successfully merging this pull request may close these issues.

[Bug]: DAB container deployment error while connected to SQL database in Fabric

5 participants