So, without running this, but having it build successfully, this seems like a good place to start, it has caravel, and pyodbc all installed here. I will be playing more this weekend....
FROM ubuntu RUN apt-get update && apt-get install -y build-essential libssl-dev libffi-dev python-dev python-pip RUN apt-get install -y unixodbc-dev unixodbc-bin RUN pip install pyodbc RUN pip install caravel CMD ["python -v"] On Fri, May 13, 2016 at 10:44 AM, John Omernik <j...@omernik.com> wrote: > 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 >>> > > > > >>> > > > >>> > > >>> > >>> >> >> >