Support for MS Dataverse / CDS
Add support so SQL Prompt will work in SSMS when connected to MS Dataverse / CDS (Common Data Service - Dynamics really).
Right now, it fails since the (meta)data exposed probably isn't quite as complete as on a "full-scale" SQL Server database
Marc Scheuner
shared this idea
-
Jonlee Lockwood commented
I too am crying out for this. But also for Microsoft Fabric SQL endpoints.
-
patrick mccarthy
commented
we would like this too. Dynamics 365 exposes the full "sys." view around metadata as the Object Explorer shows all the column metadata on all the tables..
While some of the sql prompt features might be reduced, there is no reason it could not at least do Intellisense against the db objects (given that SSMS can show all the metadata and we know that Microsoft did not modify SSMS to conform to Dynamics, rather, Dynamics confirmed to expose a read only db to SSMS)
-
Josh Yeats commented
Yes, this would be very helpful when using the T-SQL endpoint from SSMS.
The dataverse has a huge number of tables and those tables have a huge number of columns.
Intellisense over this would be very nice.