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.58k stars 908 forks source link

Support for generic ODBC\JDBC Connection #7505

Open andrewkarcher opened 5 years ago

andrewkarcher commented 5 years ago

We are looking at whether or not we could use Azure Data Studio to query Delta Lake Tables. I realize that there is no native extension, but Delta Lake also provides a JDBC interface to query Delta Lake Tables.

Describe the solution or feature you'd like An extension that would allow support for a generic OBDC\JDBC connector.

Describe alternatives you've considered Right now, seems like our only option would be to use another tool like DBeaver to connect to our Delta Lake tables.

NOD507 commented 4 years ago

Im looking for suppor for Teradata but ODBC/JDBC could be the way too. Also here are other requests that would get resolved with this one.

https://github.com/microsoft/azuredatastudio/issues/5757

https://github.com/microsoft/azuredatastudio/issues/7473

flowermichael commented 3 years ago

Any progress on this request? We have a prospect who is interested in connecting a SQL interface to one of a variety of sources. Azure Data Studio doesn't have ootb connections to all of these, and more concerning, it doesn't provide an extensible method of adding other sources. The prospect might want to add a new source later, and I don't want them to be waiting for Microsoft to decide whether it's a worthwhile extension. This particular issue is "Backlog", 13+ months old with no activity since it was opened... We're recommending more open and flexible alternatives (eg DBeaver, DBVisualizer).

marijusha commented 3 years ago

Is there any update on this topic? To query Azure SQL database tables together with Azure Data Lake files data would be great. It would make our work much more agile if we could avoid extracting files from Azure Data Lake to SQL database and only then working with the data.

flowermichael commented 3 years ago

@marijusha Have you looked at Dremio? It provides a fast access layer to ADLS data. It can also connnect to SQL data sources. And there's a free Community Edition version.

mzadony commented 2 years ago

Is this even on Microsoft's radar? Seems like a pretty obvious way to expand the usefulness and user base of the product...

ghost commented 7 months ago

Support for ODBC in this product would solve a problem we're facing and would add much value to this application.