search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.5k stars 883 forks source link

Provide a SQL Data Warehouse connectionProvider #1526

Open kevinvngo opened 6 years ago

kevinvngo commented 6 years ago

Enable a flag in the JSON file to show widgets only if the connection is to a Azure SQL DW since DW queries will fail against an Azure SQL DB

yualan commented 6 years ago

@AbbiePetcht said: "You can create your own context provider similar to isCloud (C:\Repro\sqlopsstudio\extensions\mssql\src\contextProvider.ts) It will call back on onDashboardOpen"

Once we create a context, can we make it universal to keep it consistent? Something like "isSqlDB" and "isSqlDW"?

kevcunnane commented 6 years ago

For edition and SQL version, Boolean contexts may not be as useful as string / numerical. So returning edition name (enterprise / standard / DW) will require fewer conditions for the majority of extensions. We should consider which flags should be baked in - common examples are provider (already done), isCloud, version, DB Compat Level, edition. Let’s think for instance how an extension could show support for ManagedInstance features without needing its own special flag and I think we’ll get to the best answer quickest here.