Git Product home page Git Product logo

sqlalchemy-vertica's Introduction

sqlalchemy-vertica

Vertica dialect for sqlalchemy.

Forked from the Vertica dialect for sqlalchemy using vertica-python.

import sqlalchemy as sa
import urllib
# for pyodbc connection
sa.create_engine('vertica+pyodbc:///?odbc_connect=%s' % (urllib.quote('DSN=dsn'),))

# for turbodbc connection
sa.create_engine('vertica+turbodbc:///?DSN=dsn')

# for vertica-python connection
sa.create_engine('vertica+vertica_python://user:pwd@host:port/database')

Installation

From PyPI:

pip install sqlalchemy-vertica[pyodbc,turbodbc,vertica-python]  # choose the relevant engines

From git:

git clone https://github.com/startappdev/sqlalchemy-vertica
cd sqlalchemy-vertica
pip install pyodbc turbodbc vertica-python  # choose the relevant engines
python setup.py install

sqlalchemy-vertica's People

Contributors

isaac-councill avatar jamescasbon avatar lemeryfertitta avatar

Stargazers

avatar avatar avatar avatar avatar

Watchers

avatar avatar avatar avatar avatar

Forkers

bradleyhurley telyukov lv10 martenlindblad taboola

sqlalchemy-vertica's Issues

The output of the query is only the fields name

Hi there,

I have installed sqlalchemy-vertica vertica_python, and I am using it in the JupyterNotebook with sql magic function %sql.

The connection is successfully made and the query runs but the result is empty, I see only the column names.

%sql vertica+vertica_python://victorc:****@host/dbname
result = %sql SELECT * FROM table_name LIMIT 10

The result is only the fields name.

I am wondering if it is due to ipython-sql or sqlalchemy_vertica libraries ?
Any thoughts will be appreciated.

Python version: 3.7

Thanks,
Victor

Access a particular namespace

Hi!

I'm not sure this is the best contact medium for this, but here it goes:

I'm connecting to a vertica database using sqlalchemy and your module. Everything seems fine but I only get access to the default schema ('public'), and I want to access another one. How would I do that? That is, how do I specify that I want to work in schema XX, rather than in public? My user has access to schema XX, and I see the tables fine from the command line.

Code here: https://gist.github.com/danimateos/a99d277fda6dcd4c469cf5f36b57282c

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.