Changed

• Use Entra ID automatically for NoSQL accounts with local auth disabled. #2290
• Don't fetch NoSQL account keys when using Entra ID. #2290

Added

• Added RBAC permission error handling for NoSQL accounts. If RBAC permission is missing, show a notification with an option to assign a contributor role for the current account and a link to RBAC documentation. #2289

Added

• Added support to authenticate with CosmosDB NoSQL database accounts using MS Entra ID. #2205

Changed

• Updated the supported Mongo version when creating a MongoDB database server. #2223
• Fixed a bug which blocks creating a Postgres database. #2250

Added

• Added support to execute a SQL style NoSQL query in a NoSQL query editor. #2217
• Added support to execute a NoSQL stored procedure. #2235
• Added support to view, create or delete NoSQL triggers. #2236
• Added support to view the offer information of a NoSQL collection. #2252

Changed

• Fixed a bug where the azure user session cannot be auto detected for Postgres Flexible server. #2209

This release adds the initial Azure AD authentication support for PostgreSQL flexible database servers and fixed various bugs. See 0.20.0 for all closed issues.

Breaking change

• The extension is migrated to use vscode secretStorage module for storing user credentials #2137. If you have local attachments that are broken due to this change, please re-attach them.
• The CosmosDB Graph extension has been removed from the marketplace. Attempting to open the graph explorer will open a documentation suggesting alternative tools for viewing graphs #2086.

Added

• The extension now supports connecting to PostgreSQL flexible database server as Azure AD users. Read this wiki to learn more.

Added

• Add commands to focus view and prep for release by @alexweininger in https://github.com/microsoft/vscode-cosmosdb/pull/2130

Dependencies

• Bump version after release by @github-actions in https://github.com/microsoft/vscode-cosmosdb/pull/2099
• Bump webpack from 5.28.0 to 5.76.0 by @dependabot in https://github.com/microsoft/vscode-cosmosdb/pull/2111
• Bump xml2js and @azure/ms-rest-js by @dependabot in https://github.com/microsoft/vscode-cosmosdb/pull/2125

Added

• Forward compatibility with Azure Resources API v2 @alexweininger in https://github.com/microsoft/vscode-cosmosdb/pull/2095

Changed

• Remove Preview label for Postgres Flexible by @tonybaloney in https://github.com/microsoft/vscode-cosmosdb/pull/2058
• Fix revealing attached database by @alexweininger in https://github.com/microsoft/vscode-cosmosdb/pull/2092

Engineering

• Remove version checker action by @alexweininger in https://github.com/microsoft/vscode-cosmosdb/pull/2046
• Replace public-ip with our own util to fix CVE-2022-33987 by @alexweininger in https://github.com/microsoft/vscode-cosmosdb/pull/2048
• Migrate to vscode-azext-dev by @alexweininger in https://github.com/microsoft/vscode-cosmosdb/pull/2050
• Update AppInsights key by @bwateratmsft in https://github.com/microsoft/vscode-cosmosdb/pull/2052
• Add post release version bumper by @alexweininger in https://github.com/microsoft/vscode-cosmosdb/pull/2053
• Use shared Azure Id parsing utils by @alexweininger in https://github.com/microsoft/vscode-cosmosdb/pull/2054
• Rename info-needed-closer by @bwateratmsft in https://github.com/microsoft/vscode-cosmosdb/pull/2056
• Move workflow from root to workflows folder by @alexweininger in https://github.com/microsoft/vscode-cosmosdb/pull/2057
• Change filter for treeItemPicker by @nturinski in https://github.com/microsoft/vscode-cosmosdb/pull/2063
• Finalize CodeQL settings by @bwateratmsft in https://github.com/microsoft/vscode-cosmosdb/pull/2068
• Fix readme badges by @bwateratmsft in https://github.com/microsoft/vscode-cosmosdb/pull/2070
• Skip test suite to enable CodeQL build by @nturinski in https://github.com/microsoft/vscode-cosmosdb/pull/2081
• Add .nvmrc file by @alexweininger in https://github.com/microsoft/vscode-cosmosdb/pull/2085
• Use updated AzExtTreeFileSystem by @alexweininger in https://github.com/microsoft/vscode-cosmosdb/pull/2094

Dependencies

• Bump extension version post release by @alexweininger in https://github.com/microsoft/vscode-cosmosdb/pull/2045
• Bump moment from 2.29.2 to 2.29.4 by @dependabot in https://github.com/microsoft/vscode-cosmosdb/pull/2049
• Bump loader-utils from 1.4.0 to 1.4.2 by @dependabot in https://github.com/microsoft/vscode-cosmosdb/pull/2077
• Bump yargs-parser and yargs by @dependabot in https://github.com/microsoft/vscode-cosmosdb/pull/2078
• Bump decode-uri-component from 0.2.0 to 0.2.2 by @dependabot in https://github.com/microsoft/vscode-cosmosdb/pull/2083
• Bump qs from 6.10.1 to 6.11.0 by @dependabot in https://github.com/microsoft/vscode-cosmosdb/pull/2084
• Bump @xmldom/xmldom from 0.7.5 to 0.7.8 by @dependabot in https://github.com/microsoft/vscode-cosmosdb/pull/2074
• Bump flat and mocha by @dependabot in https://github.com/microsoft/vscode-cosmosdb/pull/2088
• Bump json5 from 1.0.1 to 1.0.2 by @dependabot in https://github.com/microsoft/vscode-cosmosdb/pull/2089

Changed

• Update @vscode/extension-telemetry to 0.6.2 #2042

Changed

• Update @vscode/extension-telemetry to 0.5.2 #2032

We've made some large design changes to the Azure extensions for VS Code. View App Centric release notes

Changed

• Minimum version of VS Code is now 1.57.0

Fixed

• Fixed the ETIMEDOUT issue when signing into a PostgreSQL Flexible server on multiple machines

Added

• Postgres Flexible Servers (Preview) includes support for Databases, Functions and Stored Procedures

Changed

• Postgres Single Server defaults to version "11"

Fixed

• Bugs Fixed

Added

• SKU type option is now available while creating PostgreSQL servers
• Option to select either "Provisioned throughput" or "Serverless" model while creating CosmosDB accounts

Changed

• Icons updated to match VS Code's theme. Install new product icon themes here

Fixed

• Bugs Fixed

Added

• Now depends on the "Azure Resources" extension, which provides a "Resource Groups" and "Help and Feedback" view
• Grouped items in all context menus to improve access and readability
• "Attached Emulator..." option added to Attach Database Accounts context menu

Changed

• "Report an Issue" button was removed from errors. Use the "Help and Feedback" view or command palette instead

Fixed

• Bugs Fixed

Added

• Newly created Azure CosmosDB - MongoDB servers default to version “3.6”

Changed

• Minimum version of VS Code is now 1.48.0
• Improved extension activation time (by switching to the azure-sdk-for-js)

Fixed

• Bugs Fixed

Added

• Attach PostgreSQL servers by connection string
• PostgreSQL support for integration with App Service extension

Changed

• PostgreSQL server defaults to version "10"

Fixed

• Bugs fixed

Added

• Use the setting "azureDatabases.batchSize" to configure the Mongo "DBQuery.shellBatchSize" attribute and the batch size when loading children in the tree view.
• Create and edit stored procedures in PostgreSQL. NOTE: only applies to PostgreSQL server versions 11 and above.

Fixed

• Bugs fixed

Changed

• Results from executing most Mongo commands open in a single read-only editor.

0.13.0 - 2020-05-28

In this release, we're rebranding the Cosmos DB Extension to Azure Databases to expand our database support beyond just Cosmos DB. This release also marks the first new database engine: PostgreSQL with other database engines coming later this year.

Added

• PostgreSQL support
  • Create and view PostgreSQL servers, databases, and functions.
  • Create, edit, and execute PostgreSQL queries

Fixed

• Bugs fixed

Changed

• Viewing and querying Azure Cosmos DB graphs has been moved to a separate graph-specific extension, vscode-cosmosdbgraph

Fixed

• Language client is not ready yet #1334

Fixed

• When updating a Mongo document, the operation would fail with the following error: update operation document must contain atomic operators. #1298
• When importing a .json document into a Mongo collection, it would throw the following error: Error: r.insertedIds is not iterable #1307