A little more googling and I found the pyodbc, that looks promising. On Fri, May 13, 2016 at 10:41 AM, John Omernik <j...@omernik.com> wrote:
> "SQL Alchemy already understands Drill" I was just looking for that, is > there already some docs/blogs on that? I was going to start there as well > to determine how it worked and then look into the dialect writing and see > how big that project was. I didn't find much on the Drill + Alchemy, but I > am in an airport and I blame wifi gremlins. > > > > On Fri, May 13, 2016 at 10:25 AM, Ted Dunning <ted.dunn...@gmail.com> > wrote: > >> SQLAlchemy generates SQL queries and passes them on to Drill. Since >> SQLAlchemy already understands Drill, most of what will be needed is >> slight >> tuning for SQL dialect and providing a mechanism for SQLAlchemy to get >> meta-data from views. Tableau does the meta-data discovery using limit 0 >> queries to get column names. We would hope that similar methods would >> work. >> >> >> On Fri, May 13, 2016 at 6:13 AM, Erik Antelman <eantel...@gmail.com> >> wrote: >> >> > Isn't this a matter of Drill<->SQLAlchemy. Such a support could likely >> > enable other frameworks. >> > >> > Would one think that adaptation of SQLAlchemy to Drill is specific to >> > Caravel? What subset of features from a RDBMS ORM is meaningfull, >> feasable >> > and usefull to map to Drill. This sounds like a broad general question. >> I >> > am sure there are orms from other language camps that might want Drill >> > backends. >> > On May 13, 2016 7:33 AM, "John Omernik" <j...@omernik.com> wrote: >> > >> > > I will be looking into this as well, thanks for sharing! >> > > On May 13, 2016 2:01 AM, "Nirav Shah" <nirav.s...@games24x7.com> >> wrote: >> > > >> > > > I Hi Neeraja, >> > > > >> > > > I am interested in contributing if integration is not available. >> > > > Kindly let me know >> > > > >> > > > Regards, >> > > > Nirav >> > > > >> > > > On Thu, May 12, 2016 at 9:19 PM, Neeraja Rentachintala < >> > > > nrentachint...@maprtech.com> wrote: >> > > > >> > > > > Hi Folks >> > > > > >> > > > > Caravel is nice visualization tool recently open sourced by >> airbnb. >> > Did >> > > > > anyone try to integrate Drill and/or interested in contributing to >> > > making >> > > > > this work with Drill. >> > > > > >> > > > > https://github.com/airbnb/caravel >> > > > > >> > > > > >> > > > > -Thanks >> > > > > Neeraja >> > > > > >> > > > >> > > >> > >> > >
