sqlalchemy-teradata
sqlalchemy-teradata copied to clipboard
Teradata
A SQLAlchemy dialect for Teradata
``` engine.execute('CREATE VOLATILE TABLE test(id BIGINT) UNIQUE PRIMARY INDEX (id) ON COMMIT PRESERVE ROWS;') engine.has_table('test') False ``` Maybe check > HELP VOLATILE TABLE too?
I define the datatypes to create a table. When using string(100) it will end up in LONG VARCHAR. I do have multiple VARCHAR columns and now it always ends in...
Make username and password optional in create_engine in case the user wants to do something like: from sqlalchemy import create_engine engine = create_engine('teradata://host/?trusted_connection=yes') This is useful if Teradata is set...
I am running into an error while running `Base.prepare(engine)`. The base itself is associated with 15 tables each of which having multiple columns, so it is conceivable that there are...
Hi Team, I was trying to create SQLAlchemy engine as per below sample code. ```python from sqlalchemy import create_engine td_engine = create_engine('teradata://dbuser:[email protected]') ``` Executing this statement gave me the following...
…/schemas in the system instead of just the username. ## High level description of this Pull-request I am puzzled about the behavior of get_schema_names in dialect.py. I was expecting it...
hi I am puzzled about the behavior of get_schema_names in dialect.py. I was expecting it to retrieve all the schemas/databases in the system but instead of that only retrieves your...
I encountered the same issue mentioned in #67. I think I've pinpointed where the error's coming from. To test, I created a script that only tries to reflect **20** views....
When I call get_view_definition method using the following: from sqlalchemy import create_engine from sqlalchemy.engine import reflection td_engine = create_engine('teradata://user:pass@host/container?driver=Teradata') insp = reflection.Inspector.from_engine(td_engine) insp.get_view_definition("MyViewName") I get the error: : ('HY000', "[Teradata][ODBC...
Starting a fresh new docker image, I'm running the following commands ``` alien -i drivers/teradata/15/tdicu1510-15.10.01.00-1.noarch.rpm alien -i drivers/teradata/15/TeraGSS_linux_x64-15.10.01.01-1.noarch.rpm alien -i drivers/teradata/15/tdodbc1510-15.10.01.01-1.noarch.rpm export ODBCINI=/opt/teradata/client/15.10/odbc_64/odbc.ini export ODBCINST=/opt/teradata/client/15.10/odbc_64/odbcinst.ini export LD_LIBRARY_PATH=/opt/teradata/client/15.10/lib64/:$LD_LIBRARY_PATH ``` Trying to...
