Support for generic ODBC\JDBC Connection

[andrewkarcher]

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]

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.

#5757

#7473

[flowermichael]

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]

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]

@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]

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